DM数据同步服务,全量同步已完成,增量同步出现了错误

为提高效率,请提供以下信息,问题描述清晰能够更快得到解决:

【TiDB 版本】tidb v4.0.9 dm v2.0.0

【问题描述】我们上游数据库是mysql8.0.14,下游是tidb v4.0.9数据库集群,现在已完成全量数据同步,增量同步报一个错误 startLocation: [position: (binlog.000006, 252120461), gtid-set: ], endLocation: [position: (binlog.000006, 252120623), gtid-set: ]: query UPDATE tbl_user SET username = ‘Guest’ WHERE id = ‘1525’: only support ROW format binlog, unexpected DML statement found in query event,帮忙看下是什么原因导致的,需要如何处理?谢谢

以下是详细的服务器控制台信息
[root@ip-192-168-1-206 soft]# tiup dmctl --master-addr 192.168.1.206:8261 query-status webchat
Starting component dmctl: /root/.tiup/components/dmctl/v2.0.1/dmctl/dmctl --master-addr 192.168.1.206:8261 query-status webchat
{
“result”: true,
“msg”: “”,
“sources”: [
{
“result”: true,
“msg”: “”,
“sourceStatus”: {
“source”: “mysql-replica-webchat”,
“worker”: “dm-192.168.1.206-8262”,
“result”: null,
“relayStatus”: null
},
“subTaskStatus”: [
{
“name”: “webchat”,
“stage”: “Paused”,
“unit”: “Sync”,
“result”: {
“isCanceled”: false,
“errors”: [
{
“ErrCode”: 36014,
“ErrClass”: “sync-unit”,
“ErrScope”: “internal”,
“ErrLevel”: “high”,
“Message”: “startLocation: [position: (binlog.000006, 252120461), gtid-set: ], endLocation: [position: (binlog.000006, 252120623), gtid-set: ]: query UPDATE tbl_user SET username = ‘Guest’ WHERE id = ‘1525’: only support ROW format binlog, unexpected DML statement found in query event”,
“RawCause”: “”,
“Workaround”: “”
}
],
“detail”: null
},
“unresolvedDDLLockID”: “”,
“sync”: {
“totalEvents”: “0”,
“totalTps”: “0”,
“recentTps”: “0”,
“masterBinlog”: “(binlog.000006, 252124335)”,
“masterBinlogGtid”: “”,
“syncerBinlog”: “(binlog.000006, 252120280)”,
“syncerBinlogGtid”: “”,
“blockingDDLs”: [
],
“unresolvedGroups”: [
],
“synced”: false,
“binlogType”: “remote”
}
}
]
}
]
}

DM 只支持 ROW 格式的 binlog。另外请问是否跳过了前置检查?这个问题应该会在前置检查中暴露

https://docs.pingcap.com/zh/tidb-data-migration/stable/precheck#上游-mysql-实例配置前置检查

知道原因了,是binlog日志类型的问题导致的, 我们线上有很多mysql服务器配置都是
binlog_format = mixed,这个以后是否能支持下这种日志格式呢?

暂时只支持 ROW 格式的 binlog。

以后有支持的开发计划吗?

暂时没有。

好的,了解了,感谢

:handshake::handshake: