DM reports an error due to unsupported upstream database statement syntax

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: dm因为上游数据库语句语法不支持报错

| username: Jjjjayson_zeng

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issue: Issue Phenomenon and Impact]
[Resource Configuration]
[Attachment: Screenshot/Log/Monitoring]

image
image1259×658 16 KB

How should I handle errors when the upstream syntax is not supported by downstream TiDB?

2
| username: db_user | Original post link

According to the documentation, following this procedure should resolve the issue.

3
| username: Jjjjayson_zeng | Original post link

I read the documentation, and the actual situation is that, for example, if we synchronize 10 tables in the whitelist, and tables not in the whitelist also have issues, then in this case, do we have to manually execute the command binlog skip task-name for each one?

4
| username: db_user | Original post link

Do you mean that you encounter this error even with tables not on the whitelist during actual use? This is not expected; it shouldn’t normally happen. If this occurs, could you provide the logs and reproduction steps?