-
Notifications
You must be signed in to change notification settings - Fork 205
upgrade v3.2409.0 to v3.2410.0 #2743
ColdWaterLW
started this conversation in
Upgrade
-
不兼容的变更内容
新版本的SQLE做了非兼容性变更,旧的SQLE升级到新SQLE需要额外的手动升级操作。相关issue:
#2691
#2616
#2601
版本升级方案
- 假设DMS元数据库为
dms
,schema的参数值与库名保持一致 - 假设SQLE元数据库为
sqle
,schema的参数值与库名保持一致
升级步骤1:停止旧的sqled和dms服务后,执行如下SQL:
UPDATE dms.dms_configs SET need_init_roles = 1 WHERE uid = 700100; ALTER TABLE sqle.sql_manage_queues DROP COLUMN end_point; ALTER TABLE sqle.sql_manage_records DROP COLUMN end_point; ALTER TABLE sqle.workflow_instance_records MODIFY COLUMN execution_assignees varchar(2000); ALTER TABLE sqle.sql_manage_record_processes MODIFY COLUMN assignees varchar(2000); ALTER TABLE sqle.sql_manages MODIFY COLUMN assignees varchar(2000); ALTER TABLE sqle.workflow_steps MODIFY COLUMN assignees varchar(2000);
升级步骤2:启动sqled、dms服务
Beta Was this translation helpful? Give feedback.
All reactions
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment