Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

upgrade v3.2409.0 to v3.2410.0 #2743

ColdWaterLW started this conversation in Upgrade
Discussion options

不兼容的变更内容

新版本的SQLE做了非兼容性变更,旧的SQLE升级到新SQLE需要额外的手动升级操作。相关issue:
#2691
#2616
#2601

版本升级方案

⚠️ 建议在升级前备份SQLE、DMS业务库

  • 假设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服务

You must be logged in to vote

Replies: 0 comments

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
1 participant

AltStyle によって変換されたページ (->オリジナル) /