DM 增量同步阶段sql报错,无法正常skip-sql

报错信息如下
“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
但是为生效,请问是哪没操作对吗

您好,这边提示的报错信息是 “RawCause”: “[parser:1115]Unknown character set: ‘utf16’” ,目前 TiDB 不支持 utf16 字符集,可以参考下面这个帖子解决下:

无法用sql-skip的操作解决是吗

目前无法通过 sql-skip 方式跳过,你可以尝试下在 task 任务里加 filter 方式来绕过

好的谢谢

不客气哈,有问题的话请继续反馈。