报错信息如下
“result”: true,
“msg”: “”,
“workers”: [
{
“result”: true,
“worker”: “172.16:8262”,
“msg”: “”,
“subTaskStatus”: [
{
“name”: “dm_dbcenter”,
“stage”: “Paused”,
“unit”: “Sync”,
“result”: {
“isCanceled”: false,
“errors”: [
{
“Type”: “UnknownError”,
“msg”: “”,
“error”: {
“ErrCode”: 11006,
“ErrClass”: 2,
“ErrScope”: 3,
“ErrLevel”: 3,
“Message”: “current pos (master-bin|000001.003916, 49944498): encountered incompatible DDL in TiDB:
\tplease confirm your DDL statement is correct and needed.
\tfor TiDB compatible DDL, please see the docs:
\t English version: https://pingcap.com/docs/dev/reference/mysql-compatibility/#ddl\
\t Chinese version: https://pingcap.com/docs-cn/dev/reference/mysql-compatibility/#ddl\
\tif the DDL is not needed, you can use a filter rule with "*" schema-pattern to ignore it.
\t : parse statement: [parser:1115]Unknown character set: ‘utf16’%!!(MISSING)(EXTRA string=ALTER TABLE compensate_record_final CHANGE id id varchar(50) CHARACTER SET utf16 NOT NULL COMMENT ‘主键’)”,
“RawCause”: “[parser:1115]Unknown character set: ‘utf16’”
}
}
],
“detail”: null
},
“unresolvedDDLLockID”: “”,
“sync”: {
“totalEvents”: “0”,
“totalTps”: “0”,
“recentTps”: “0”,
“masterBinlog”: “(master-bin.003924, 1073127623)”,
“masterBinlogGtid”: “”,
“syncerBinlog”: “(master-bin|000001.003916, 49944316)”,
“syncerBinlogGtid”: “”,
“blockingDDLs”: [
],
“unresolvedGroups”: [
],
“synced”: false
}
}
],
“relayStatus”: {
“masterBinlog”: “(master-bin.003924, 1073127623)”,
“masterBinlogGtid”: “”,
“relaySubDir”: “878fbca6-3e23-11e9-b80d-d6bd31bc1e5f.000001”,
“relayBinlog”: “(master-bin.003924, 1073127623)”,
“relayBinlogGtid”: “”,
“relayCatchUpMaster”: true,
“stage”: “Running”,
“result”: null
},
“sourceID”: “mysql-replica-01”
}
]
}
跳过操作:
sql-skip --worker=172.16:8262 --binlog-pos=master-bin|000001.003916:49944561 dm_dbcenter
{
“result”: true,
“msg”: “”,
“workers”: [
{
“result”: true,
“worker”: “”,
“msg”: “”
}
]
}
重启
» resume-task --worker=172.16:8262 dm_dbcenter
但是为生效,请问是哪没操作对吗