【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】
【复现路径】做过哪些操作出现的问题
【遇到的问题:问题现象及影响】
【资源配置】
query结果
{
"info": {xxx
"sink-uri": "mysql://xxx:xxx@xxx:13306/?time-zone=SYSTEM",
"opts": {
"_changefeed_id": "sink-verify"
},
"create-time": "2023-08-09T08:22:26.457117975Z",
"start-ts": 443413131555766280,
"target-ts": 0,
"admin-job-type": 0,
"sort-engine": "unified",
"sort-dir": "",
"config": {
"case-sensitive": true,
"enable-old-value": true,
"force-replicate": false,
"check-gc-safe-point": true,
"filter": {
"rules": [
"pakistan.client_info"
],
"ignore-txn-start-ts": [
443412121305743403,
443413131555766280
]
},
"mounter": {
"worker-num": 16
},
"sink": {
"dispatchers": null,
"protocol": "",
"column-selectors": null
},
"cyclic-replication": {
"enable": false,
"replica-id": 0,
"filter-replica-ids": null,
"id-buckets": 0,
"sync-ddl": false
},
"scheduler": {
"type": "table-number",
"polling-time": -1
},
"consistent": {
"level": "none",
"max-log-size": 64,
"flush-interval": 1000,
"storage": ""
}
},
"state": "normal",
"error": null,
"sync-point-enabled": false,
"sync-point-interval": 600000000000,
"creator-version": "v5.4.0"
},
"status": {
"resolved-ts": 443413131555766280,
"checkpoint-ts": 443413131555766280,
"admin-job-type": 0
},
"count": 0,
"task-status": [
{
"capture-id": "1546f04f-a77f-40d4-9790-8ad7ed7ed3d9",
"status": {
"tables": {
"572": {
"start-ts": 443413131555766280,
"mark-table-id": 0
}
},
"operation": {},
"admin-job-type": 0
}
}
]
}
cdc日志里报[“execute DDL with error, retry later”] [query=“ALTER TABLE xxxx
RENAME COLUMN xxxx
TO xxx
”] [error=“[CDC:ErrMySQLTxnError]MySQL txn error: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘COLUMN xxxxx
TO xxxxx
’ at line 1”]
我在mysql里已经使用change column语法重命名了列名,解析到443413131555766280这个位置 ,我也加到了ignore-txn-start-ts,请问这如何解决