DDL同步不成功
-
今天上午从2.2.5.11升级到2.2.6.9,DDL始终不能同步成功。请版主帮忙,谢谢。
以下是日志:
2022-10-30 10:47:51.679 [MultiStageCoprocessor-other-canal3793ssr59n3_INCREMENT-12-thd-0] WARN c.c.c.m.w.reader.vendor.parse.logparse.LogEventConvert - Receive DDL in LogEventConvert, DDL sql is :alter table sys_userinfo add column testCol varchar(100) null
2022-10-30 10:47:51.680 [MultiStageCoprocessor-other-canal3793ssr59n3_INCREMENT-12-thd-0] INFO c.c.c.d.c.m.r.b.schema.store.RemoteMetaHistoryService - insert meta history record to remote.DeograSYS.sys_userinfo
2022-10-30 10:47:51.714 [reactor-tcp-epoll-1] INFO c.c.cloudcanal.task.rsocket.impl.AsyncReceiverImpl - receive async result. request id:3f2fe812-57fd-11ed-ad65-afc8a93cce1a
2022-10-30 10:47:51.714 [MultiStageCoprocessor-other-canal3793ssr59n3_INCREMENT-12-thd-0] INFO rsocket - [task->sidecar] SUCCESS,route name:mysqlInsertHistoryMetadata.request id:3f2fe812-57fd-11ed-ad65-afc8a93cce1a,elapse:34 ms.
2022-10-30 10:47:52.570 [incre-fetch-from-buffer-10-thd-0] INFO c.c.c.mysql.worker.reader.incre.MySqlIncreEventBroker - getWithoutAck successfully, batch:2048, real:1,binlog file:mysql-bin.000007
2022-10-30 10:47:52.571 [incre-apply-disruptor-5-thd-2] INFO c.c.cloudcanal.task.applier.incre.DdlEventHandler - change the DDL.source dbName:DeograSYS,source tableName:sys_userinfo,source DDL:alter table sys_userinfo add column testCol varchar(100) null
2022-10-30 10:47:52.572 [incre-apply-disruptor-5-thd-2] INFO c.c.cloudcanal.task.applier.incre.DdlEventHandler - one of CHANGED DDL:ALTER TABLEDeograPLM
.sys_userinfo
ADD COLUMNtestCol
varchar(100) NULL
2022-10-30 10:47:52.578 [incre-apply-disruptor-5-thd-11] WARN c.c.c.b.service.task.applier.AbstractRdbIncreDDLExecutor - -------------origin DDL sql:alter table sys_userinfo add column testCol varchar(100) null,dbName:DeograPLM
2022-10-30 10:47:52.578 [incre-apply-disruptor-5-thd-11] INFO c.c.c.mysql.worker.writer.incre.MySqlIncreDdlExecutor - try to execute sql:/ccw/ALTER TABLEDeograPLM
.sys_userinfo
ADD COLUMNtestCol
varchar(100) NULL
2022-10-30 10:47:52.578 [incre-apply-disruptor-5-thd-11] INFO c.c.c.b.s.task.ddlprecheck.AbstractDdlExecutePredict - predict ddl begin.
2022-10-30 10:47:52.578 [incre-apply-disruptor-5-thd-11] INFO c.c.c.b.s.task.ddlprecheck.AbstractDdlExecutePredict - predict ddl mapping is: {testcol=ADD_COLUMN}
2022-10-30 10:47:52.592 [incre-apply-disruptor-5-thd-11] WARN c.c.cloudcanal.mysql.worker.meta.MySqlTableDefGenerator - DeograPLM.deograplm.sys_userinfo column metadata is empty,maybe have ddl later.
2022-10-30 10:47:52.592 [incre-apply-disruptor-5-thd-11] INFO c.c.c.b.s.task.ddlprecheck.AbstractDdlExecutePredict - table not found, predict ddl: /ccw/ALTER TABLEDeograPLM
.sys_userinfo
ADD COLUMNtestCol
varchar(100) NULL skipped.
2022-10-30 10:47:53.570 [incre-fetch-from-buffer-10-thd-0] INFO c.c.c.mysql.worker.reader.incre.MySqlIncreEventBroker - getWithoutAck successfully, batch:2048, real:0
2022-10-30 10:47:54.448 [reactor-tcp-epoll-1] INFO c.c.cloudcanal.task.rsocket.impl.AsyncReceiverImpl - receive async result. request id:40d4be73-57fd-11ed-ad65-c7761c7bfa36
2022-10-30 10:47:54.448 [heartbeat-report-4-thd-0] INFO rsocket - [task->sidecar] SUCCESS,route name:taskReceiveHeartBeat.request id:40d4be73-57fd-11ed-ad65-c7761c7bfa36,elapse:10 ms.
2022-10-30 10:47:54.570 [incre-fetch-from-buffer-10-thd-0] INFO c.c.c.mysql.worker.reader.incre.MySqlIncreEventBroker - getWithoutAck successfully, batch:2048, real:0
2022-10-30 10:47:55.570 [incre-fetch-from-buffer-10-thd-0] INFO c.c.c.mysql.worker.reader.incre.MySqlIncreEventBroker - getWithoutAck successfully, batch:2048, real:0
2022-10-30 10:47:56.571 [incre-fetch-from-buffer-10-thd-0] INFO c.c.c.mysql.worker.reader.incre.MySqlIncreEventBroker - getWithoutAck successfully, batch:2048, real:0
2022-10-30 10:47:57.571 [incre-fetch-from-buffer-10-thd-0] INFO c.c.c.mysql.worker.reader.incre.MySqlIncreEventBroker - getWithoutAck successfully, batch:2048, real:0
2022-10-30 10:47:58.571 [incre-fetch-from-buffer-10-thd-0] INFO c.c.c.mysql.worker.reader.incre.MySqlIncreEventBroker - getWithoutAck successfully, batch:2048, real:0
2022-10-30 10:47:59.163 [stats-report-3-thd-0] INFO c.c.c.base.service.task.monitor.TaskMonitorManager - report task stats(33) to sidecar. -
可以参照下这个帖子,在社区提问下先。麻烦提供下异常信息和日志信息。https://www.askcug.com/topic/142