mysql库20G,转换过程报错。错误日志如下:
第一段:
2026-05-06 13:23:39.621 MainProcess INFO mysql_lib.py (1034): Start to create tables.
2026-05-06 13:23:39.739 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.FORUM_THREAD.isFirstPost is ‘是否是第一次发布’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:39.745 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.FORUM_USER_LEVEL.PostTotal is ‘发帖数’;
comment on column _WEBPLUSPRO_tmp.FORUM_USER_LEVEL.user_dutyname is ‘职务’;
comment on column _WEBPLUSPRO_tmp.FORUM_USER_LEVEL.PostRank is ‘等级’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:39.803 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_AIPLUS_SYNC.host is ‘MQ配置’;
comment on column _WEBPLUSPRO_tmp.T_AIPLUS_SYNC.port is ‘MQ配置’;
comment on column _WEBPLUSPRO_tmp.T_AIPLUS_SYNC.virtualHost is ‘MQ配置’;
comment on column _WEBPLUSPRO_tmp.T_AIPLUS_SYNC.userName is ‘MQ配置’;
comment on column _WEBPLUSPRO_tmp.T_AIPLUS_SYNC.password is ‘MQ配置’;
comment on column _WEBPLUSPRO_tmp.T_AIPLUS_SYNC.queueName is ‘MQ配置队列’;
comment on column _WEBPLUSPRO_tmp.T_AIPLUS_SYNC.type is ‘ES配置类型’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:39.816 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_APPLICATION.AppId is ‘第三方应用标志’;
comment on column _WEBPLUSPRO_tmp.T_APPLICATION.PrivateKey is ‘预分配的秘钥’;
comment on column _WEBPLUSPRO_tmp.T_APPLICATION.LoginUrl is ‘登录页Url’;
comment on column _WEBPLUSPRO_tmp.T_APPLICATION.ValidMinute is ‘令牌有效时间,默认10分钟’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:39.835 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_ARTFLOW_WORDTPL.id is ‘自增id’;
comment on column _WEBPLUSPRO_tmp.T_ARTFLOW_WORDTPL.flowID is ‘流程id’;
comment on column _WEBPLUSPRO_tmp.T_ARTFLOW_WORDTPL.zipName is ‘压缩包名称’;
comment on column _WEBPLUSPRO_tmp.T_ARTFLOW_WORDTPL.savePath is ‘压缩包存放路径’;
comment on column _WEBPLUSPRO_tmp.T_ARTFLOW_WORDTPL.wordHtml is ‘word内容’;
comment on column _WEBPLUSPRO_tmp.T_ARTFLOW_WORDTPL.tplType is ‘导出类型,1表示备案导出,2表示流程导出’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:39.868 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_ARTICLE.title is ‘标题’;
第二段:
comment on column _WEBPLUSPRO_tmp.T_ARTICLE.articleCheckStatus is ‘发布是否经过校阅’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:39.907 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_ARTICLEOPERATEHISTORY.content is ‘操作内容’;
comment on column _WEBPLUSPRO_tmp.T_ARTICLEOPERATEHISTORY.articleId is ‘文章id’;
comment on column _WEBPLUSPRO_tmp.T_ARTICLEOPERATEHISTORY.operateDate is ‘操作时间’;
comment on column _WEBPLUSPRO_tmp.T_ARTICLEOPERATEHISTORY.operateIp is ‘操作ip’;
comment on column _WEBPLUSPRO_tmp.T_ARTICLEOPERATEHISTORY.operatorId is ‘操作人’;
comment on column _WEBPLUSPRO_tmp.T_ARTICLEOPERATEHISTORY.operate is ‘操作类型’;
comment on column _WEBPLUSPRO_tmp.T_ARTICLEOPERATEHISTORY.typeVal is ‘操作对象 1文字 2链接’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:39.920 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_ARTICLETYPE.initArtNewUrl is ‘初始化文章增加编辑地址’;
comment on column _WEBPLUSPRO_tmp.T_ARTICLETYPE.initArtEditUrl is ‘初始化文章修改编辑地址’;
comment on column _WEBPLUSPRO_tmp.T_ARTICLETYPE.isSearch is ‘是否参与搜索,默认参与’;
comment on column _WEBPLUSPRO_tmp.T_ARTICLETYPE.editorVersion is ‘初始化当前文章类型打开编辑器版本,2为原编辑器,3为新的编辑器’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:39.961 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_ARTICLE_CHECKIMPL.needConstructor is ‘是否需要构造方法 0不需要 1需要’;
comment on column _WEBPLUSPRO_tmp.T_ARTICLE_CHECKIMPL.isdefault is ‘是否默认构造’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:39.977 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_ARTICLE_CHECKRESULT.status is ‘0:执行中,1执行完成,2失效’;
comment on column _WEBPLUSPRO_tmp.T_ARTICLE_CHECKRESULT.uuId is ‘未保存之前的Id’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:39.992 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_ARTICLE_DELETED.artId is ‘文章id’;
comment on column _WEBPLUSPRO_tmp.T_ARTICLE_DELETED.title is ‘标题’;
comment on column _WEBPLUSPRO_tmp.T_ARTICLE_DELETED.createTime is ‘创建时间’;
comment on column _WEBPLUSPRO_tmp.T_ARTICLE_DELETED.opTime is ‘操作时间’;
comment on column _WEBPLUSPRO_tmp.T_ARTICLE_DELETED.opUserId is ‘操作人id’;
comment on column _WEBPLUSPRO_tmp.T_ARTICLE_DELETED.opUserName is ‘操作人名称’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:40.004 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_ARTICLE_RECORD.id is ‘唯一标识’;
第三段:
comment on column _WEBPLUSPRO_tmp.T_ARTICLE_RECORD.publisherId is ‘发布人员id’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:40.023 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_AUDITLOG.DOMAINID is ‘所属域’;
comment on column _WEBPLUSPRO_tmp.T_AUDITLOG.appModule is ‘所属模块’;
comment on column _WEBPLUSPRO_tmp.T_AUDITLOG.opObjectType is ‘操作对象类型’;
comment on column _WEBPLUSPRO_tmp.T_AUDITLOG.opObjectId is ‘操作对象id’;
comment on column _WEBPLUSPRO_tmp.T_AUDITLOG.LOGRESOURCE is ‘资源’;
comment on column _WEBPLUSPRO_tmp.T_AUDITLOG.opType is ‘操作类型’;
comment on column _WEBPLUSPRO_tmp.T_AUDITLOG.action is ‘操作’;
comment on column _WEBPLUSPRO_tmp.T_AUDITLOG.opContent is ‘操作内容’;
comment on column _WEBPLUSPRO_tmp.T_AUDITLOG.tag1 is ‘扩展字段’;
comment on column _WEBPLUSPRO_tmp.T_AUDITLOG.tag2 is ‘扩展字段’;
comment on column _WEBPLUSPRO_tmp.T_AUDITLOG.tag3 is ‘扩展字段’;
comment on column _WEBPLUSPRO_tmp.T_AUDITLOG.opTime is ‘操作时间’;
comment on column _WEBPLUSPRO_tmp.T_AUDITLOG.opUserId is ‘操作者id’;
comment on column _WEBPLUSPRO_tmp.T_AUDITLOG.opUserName is ‘操作姓名’;
comment on column _WEBPLUSPRO_tmp.T_AUDITLOG.opIp is ‘操作ip’;
comment on column _WEBPLUSPRO_tmp.T_AUDITLOG.CRC is ‘加密哈希值’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:40.041 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_AUTH.crc is ‘加密哈希值’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:40.048 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_AUTHGROUPMEMBER.crc is ‘加密哈希值’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:40.054 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_AUTHORGMEMBER.crc is ‘加密哈希值’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:40.060 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_AUTHROLEMEMBER.crc is ‘加密哈希值’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:40.066 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_AUTHUSERMEMBER.crc is ‘加密哈希值’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:40.105 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_BSP_INFOPUSH.siteId is ‘站点id’;
comment on column _WEBPLUSPRO_tmp.T_BSP_INFOPUSH.columnId is ‘栏目id’;
comment on column _WEBPLUSPRO_tmp.T_BSP_INFOPUSH.enabled is ‘是否启用’;
comment on column _WEBPLUSPRO_tmp.T_BSP_INFOPUSH.pushType is ‘接受者类型 1:邮件2:短信 3数据库 4微信5微博’;
comment on column _WEBPLUSPRO_tmp.T_BSP_INFOPUSH.receiverInfo is ‘接受者信息’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:40.110 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_BSP_PERSONBS.siteId is ‘站点id’;
comment on column _WEBPLUSPRO_tmp.T_BSP_PERSONBS.columnId is ‘栏目id’;
comment on column _WEBPLUSPRO_tmp.T_BSP_PERSONBS.userId is ‘人员id’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:40.115 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_BSP_POLICY.columnId is ‘栏目id’;
comment on column _WEBPLUSPRO_tmp.T_BSP_POLICY.siteId is ‘站点id’;
comment on column _WEBPLUSPRO_tmp.T_BSP_POLICY.pushMode is ‘发送模式:1:定时发送,2:循环发送,3:满足条数发送’;
comment on column _WEBPLUSPRO_tmp.T_BSP_POLICY.pushParam is ‘发送参数,根据发送模式而定。’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:40.174 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_CF_FIELDCATEGORY.Style is ‘样式’;
comment on column _WEBPLUSPRO_tmp.T_CF_FIELDCATEGORY.SortType is ‘排序方式’;
comment on column _WEBPLUSPRO_tmp.T_CF_FIELDCATEGORY.ImgUrl is ‘背景图’;
, sql code is 3F001, and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 13:23:40.204 MainProcess ERROR pg_lib.py (4113): Execute create column comment ddl failed, the error sql is comment on column _WEBPLUSPRO_tmp.T_CF_FIELDS.Id is ‘唯一标识’;
comment on column _WEBPLUSPRO_tmp.T_CF_FIELDS.Name is ‘名称’;
。。。。。
最后停住:
2026-05-06 14:01:58.734 writer-3 INFO pg_lib.py (5172): Building index idx_FK_T_VL_CO_T_VL_COLUM_1778046959530019_3956314_1521_2 on _WEBPLUSPRO_tmp.T_VL_COLUMNVISTLOG
2026-05-06 14:02:02.230 writer-4 ERROR pg_lib.py (5211): alter table adding auto_increment failed, error code is 3F001 and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 14:02:49.797 writer-3 INFO pg_lib.py (5178): Finish Building index idx_FK_T_VL_CO_T_VL_COLUM_1778046959530019_3956314_1521_2 on _WEBPLUSPRO_tmp.T_VL_COLUMNVISTLOG
2026-05-06 14:02:49.797 writer-3 INFO pg_lib.py (5183): ready to reset parallel index workers 2 for table _WEBPLUSPRO_tmp.T_VL_COLUMNVISTLOG
2026-05-06 14:02:49.799 writer-3 INFO pg_lib.py (5190): reset parallel index workers 2 for table _WEBPLUSPRO_tmp.T_VL_COLUMNVISTLOG
2026-05-06 14:10:18.813 writer-3 ERROR pg_lib.py (5211): alter table adding auto_increment failed, error code is 3F001 and error message is schema “_webpluspro_tmp” does not exist
2026-05-06 14:10:18.838 MainProcess INFO mysql_lib.py (2333): [RETRY] no need enter retry now: retry=2, tasks: empty
2026-05-06 14:10:18.848 MainProcess INFO pg_lib.py (907): Granting select on tables in schema _WEBPLUSPRO_tmp to the role(s) usr_readonly.
2026-05-06 14:10:18.881 MainProcess WARNING pg_lib.py (924): The role usr_readonly does not exist
2026-05-06 14:10:18.881 MainProcess INFO pg_lib.py (907): Granting select on tables in schema _loxodonta_africana_tmp to the role(s) usr_readonly.
2026-05-06 14:10:18.881 MainProcess DEBUG pg_lib.py (708): There is already a database connection active.
2026-05-06 14:10:18.883 MainProcess WARNING pg_lib.py (924): The role usr_readonly does not exist
2026-05-06 14:10:18.884 MainProcess INFO pg_lib.py (5228): Swapping schema WEBPLUSPRO with _WEBPLUSPRO_tmp
2026-05-06 14:10:18.884 MainProcess DEBUG pg_lib.py (5229): Renaming schema WEBPLUSPRO in _rename_WEBPLUSPRO
2026-05-06 14:10:18.896 MainProcess DEBUG pg_lib.py (5231): Renaming schema _WEBPLUSPRO_tmp in WEBPLUSPRO
2026-05-06 14:10:18.913 MainProcess DEBUG pg_lib.py (5233): Renaming schema _rename_WEBPLUSPRO in _WEBPLUSPRO_tmp
2026-05-06 14:10:18.916 MainProcess DEBUG pg_lib.py (5235): Commit the swap transaction
2026-05-06 14:10:18.917 MainProcess INFO pg_lib.py (5228): Swapping schema loxodonta_africana with _loxodonta_africana_tmp
2026-05-06 14:10:18.917 MainProcess DEBUG pg_lib.py (5229): Renaming schema loxodonta_africana in _rename_loxodonta_africana
2026-05-06 14:10:18.918 MainProcess DEBUG pg_lib.py (5231): Renaming schema _loxodonta_africana_tmp in loxodonta_africana
2026-05-06 14:10:18.919 MainProcess DEBUG pg_lib.py (5233): Renaming schema _rename_loxodonta_africana in _loxodonta_africana_tmp
2026-05-06 14:10:18.920 MainProcess DEBUG pg_lib.py (5235): Commit the swap transaction
2026-05-06 14:10:18.921 MainProcess DEBUG mysql_lib.py (860): Dropping the schema _WEBPLUSPRO_tmp.
2026-05-06 14:10:18.921 MainProcess DEBUG pg_lib.py (737): Changing the lock timeout for the session to 120s.
2026-05-06 14:10:21.613 MainProcess DEBUG mysql_lib.py (860): Dropping the schema _loxodonta_africana_tmp.
2026-05-06 14:10:21.613 MainProcess DEBUG pg_lib.py (737): Changing the lock timeout for the session to 120s.
2026-05-06 14:10:21.634 MainProcess INFO pg_lib.py (4546): Set high watermark for source: mysql
2026-05-06 14:10:21.634 MainProcess INFO mysql_lib.py (3069): init replica for source mysql is complete
2026-05-06 14:10:21.648 MainProcess INFO chameleon.py (83): init_replica finished.