为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:DM V1.0.6
- 【问题描述】:DM同步过程中,binlog有条DDL的sql:ALTER TABLE
broker_member_level_log
ADD UNIQUE (id_old
),通过手工跳过该DDL,但看日志还是一直报错,导致同步一直卡在binlog同一个pos位置,请帮忙看看需要如何解决,谢谢。
手工跳过该DDL,后resume-take task
sql-skip -w xxx:8262 --sql-pattern=~(?i)ALTER\s+TABLE\s+hdb_broker2
.broker_member_level_log
\s+ADD --sharding hdb_broker2
日志报错
[2020/07/23 15:19:03.227 +08:00] [ERROR] [subtask.go:285] [“unit process error”] [subtask=hdb_broker2] [unit=Sync] [“error information”=“{"msg":"current pos (mysql-bin|000001.000662, 441193554): fail to handle ddl job for ALTER TABLE broker_member_level_log
ADD UNIQUE (id_old
)","error":{"ErrCode":36061,"ErrClass":11,"ErrScope":3,"ErrLevel":3,"Message":"current pos (mysql-bin|000001.000662, 441193554): fail to handle ddl job for ALTER TABLE broker_member_level_log
ADD UNIQUE (id_old
)"}}”]
查看状态syncerBinlog 无变化: