Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 上游mysql 执行DDL，DM同步下游到TIDB报错
|
username: LKLK
V5.4.1 cluster version, upstream MySQL executes DDL, DM synchronization to downstream TiDB reports an error, how can I solve it?
{
“result”: true,
“msg”: “”,
“sources”: [
{
“result”: true,
“msg”: “”,
“sourceStatus”: {
“source”: “xxxx”,
“worker”: “xxx”,
“result”: null,
“relayStatus”: null
},
“subTaskStatus”: [
{
“name”: “pay”,
“stage”: “Running”,
“unit”: “Sync”,
“result”: null,
“unresolvedDDLLockID”: “”,
“sync”: {
“totalEvents”: “15928709”,
“totalTps”: “49777”,
“recentTps”: “0”,
“masterBinlog”: “(mysql-bin.000021, 14947773)”,
“masterBinlogGtid”: “0-1453306-3023561378”,
“syncerBinlog”: “(mysql-bin.000019, 677578533)”,
“syncerBinlogGtid”: “0-1453306-3022111539”,
“blockingDDLs”: [
“ALTER TABLE snspaycenter.t_paymethod CHANGE COLUMN pm_show_name pm_show_name VARCHAR(60) CHARACTER SET UTF8 COLLATE utf8_general_ci NOT NULL DEFAULT _UTF8MB4’’ COMMENT ‘External Name’”
],
“unresolvedGroups”: [
{
“target”: “snspaycenter.t_paymethod”,
“DDLs”: [
“ALTER TABLE snspaycenter.t_paymethod CHANGE COLUMN pm_show_name pm_show_name VARCHAR(60) CHARACTER SET UTF8 COLLATE utf8_general_ci NOT NULL DEFAULT _UTF8MB4’’ COMMENT ‘External Name’”
],
“firstLocation”: “position: (mysql-bin.000019, 677578575), gtid-set: 0-1453306-3022111539”,
“synced”: [
“snspaycenter.t_paymethod”
],
“unsynced”: [
]
}
],
“synced”: false,
“binlogType”: “remote”,
“secondsBehindMaster”: “74983”
}
}
]
}
]
}
[Attachment]
Please provide the version information of each component, such as cdc/tikv, which can be obtained by executing cdc version/tikv-server --version.
|
username: 
|
username: 
|
username: 
|
username: 
|
username: