You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
USE job_execute;
SET NAMES utf8mb4;
DROP PROCEDURE IF EXISTS job_schema_update;
DELIMITER <JOB_UBF>
CREATE PROCEDURE job_schema_update()
BEGIN
SET AUTOCOMMIT = 0;
ALTER TABLE gse_script_agent_task MODIFY `agent_id` varchar(64);
ALTER TABLE gse_file_agent_task MODIFY `agent_id` varchar(64);
COMMIT;
END <JOB_UBF>
DELIMITER ;
COMMIT;
CALL job_schema_update();
DROP PROCEDURE IF EXISTS job_schema_update;
Version / Branch / tag
3.7.x
出了什么问题?(What Happened?)
由于gse_script_agent_task/gse_file_agent_task 数据太多,执行ALTER 操作会导致锁表并且执行会失败
如何复现?(How to reproduce?)
在数据量大的环境必现
预期结果(What you expect?)
The text was updated successfully, but these errors were encountered: