为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:v3.0.3
- 【问题描述】:dm版本为v1.0.3
dm-worker任务同步阿里云5.7版本的rds-mysql,出现以下报错,根据报错信息排查binlog位置日志为XA日志相关信息。这种binlog sql应该不属于"incompatible DD"范围吧 , 这种情况下Binlog event filter该如何进行配置予以过滤呢? 谢谢
"errors": [
{
"Type": "UnknownError",
"msg": "[code=11006:class=functional:scope=internal:level=high] current pos (mysql-bin|000001.001822, 84989524): 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 2 near \"XA START X'647264732d313032393238633565643066303030304070745f6f72646572',X'50545f4f524445525f3135363938333635313535323044555a535f503851445f30303730',1\" %!!(MISSING)(EXTRA string=XA START X'647264732d313032393238633565643066303030304070745f6f72646572',X'50545f4f524445525f3135363938333635313535323044555a535f503851445f30303730',1)\
github.com/pingcap/dm/pkg/terror.(*Error).Delegate\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/terror/terror.go:267\
github.com/pingcap/dm/pkg/parser.Parse\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/parser/common.go:42\
github.com/pingcap/dm/syncer.(*Syncer).parseDDLSQL\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/ddl.go:68\
github.com/pingcap/dm/syncer.(*Syncer).handleQueryEvent\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:1564\
github.com/pingcap/dm/syncer.(*Syncer).Run\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:1310\
github.com/pingcap/dm/syncer.(*Syncer).Process\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:598\
github.com/pingcap/dm/syncer.(*Syncer).Resume\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:2306\
runtime.goexit\
\t/usr/local/go/src/runtime/asm_amd64.s:1357",
"error": null
}
],
#200213 3:28:39 server id 1281286294 end_log_pos 84989524 CRC32 0x771d389c Query thread_id=1733961 exec_time=0 error_code=0
SET TIMESTAMP=1581535719/!/;
/!\C utf8mb4 //!/;
SET @@session.character_set_client=45,@@session.collation_connection=45,@@session.collation_server=45/!/;
XA START X’647264732d313032393238633565643066303030304070745f6f72646572’,X’50545f4f524445525f3135363938333635313535323044555a535f503851445f30303730’,1
/!/;