“Message”: “current pos (mysql-bin|000001.000111, 1073519643): 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: line 1 column 69 near "row int)" %!!(MISSING)(EXTRA string=create table t_info(date datetime,db varchar(10),name varchar(50),row int))”,
“RawCause”: "line 1 column 69 near "row int)" "
- 可以查看下binlog文件这里的DDLsql是什么？ 看起来是 tidb 不支持
- 请问tidb版本是多少？ DM 版本是多少？
- 如果确认不支持，可以尝试跳过sql
跳了 不起作用啊
sql-skip --worker=xxxxxxxxx --binlog-pos=mysql-bin|000001.000111:1073519643 task_scc
请参考文档使用 handle-error skip 试试
https://docs.pingcap.com/zh/tidb-data-migration/v2.0/handle-failed-sql-statements#命令用法