为提高效率,请提供以下信息,问题描述清晰能够更快得到解决:
【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”
}
}
]
}
]
}