drainer 报错导致不能启动 数据不能同步

为提高效率,请提供以下信息,问题描述清晰能够更快得到解决:

【TiDB 版本】

+--------------------+--------------+------+----+------+
|    TiDB_version    | Clu_replicas | TiDB | PD | TiKV |
+--------------------+--------------+------+----+------+
| 5.7.25-TiDB-v3.0.2 |      3       |  1   | 1  |  3   |
+--------------------+--------------+------+----+------+

【问题描述】

[2021/03/19 18:17:57.287 +08:00] [ERROR] [server.go:270] ["syncer exited abnormal"] [error="handlePreviousDDLJobIfNeed failed: handle ddl job ID:243, Type:modify schema charset and collate, State:synced, SchemaState:public, SchemaID:59, TableID:0, RowCount:0, ArgLen:0, start time: 2021-02-19 10:39:35.995 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0 failed, the schema info: {\
\t\t\"hasImplicitCol\": false,\
\t\t\"schemaMetaVersion\": 0,\
\t\t\"schemaNameToID\": {\
\t\t\t\"ApolloConfigDB\": 152,\
\t\t\t\"ApolloPortalDB\": 122,\
\t\t\t\"FilterWords\": 223,\
\t\t\t\"hkuc\": 41,\
\t\t\t\"hkucc\": 59,\
\t\t\t\"mysql\": 3,\
\t\t\t\"test\": 1\
\t\t},\
\t\t\"tableIDToName\": {\
\t\t\t\"105\": {\
\t\t\t\t\"db-name\": \"hkucc\",\
\t\t\t\t\"tbl-name\": \"t_user_iphone_rela\"\
\t\t\t},\
\t\t\t\"109\": {\
\t\t\t\t\"db-name\": \"hkuc\",\
\t\t\t\t\"tbl-name\": \"t_user\"\
\t\t\t},\
\t\t\t\"11\": {\
\t\t\t\t\"db-name\": \"mysql\",\
\t\t\t\t\"tbl-name\": \"columns_priv\"\
\t\t\t},\
\t\t\t\"111\": {\
\t\t\t\t\"db-name\": \"hkuc\",\
\t\t\t\t\"tbl-name\": \"t_user_iptv\"\
\t\t\t},\
\t\t\t\"124\": {\
\t\t\t\t\"db-name\": \"ApolloPortalDB\",\
\t\t\t\t\"tbl-name\": \"App\"\
\t\t\t},\
\t\t\t\"126\": {\
\t\t\t\t\"db-name\": \"ApolloPortalDB\",\
\t\t\t\t\"tbl-name\": \"AppNamespace\"\
\t\t\t},\
\t\t\t\"128\"。。。。
---

若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。

看起来是下游不支持 DDL 操作? 可以参考下文档解决。

https://docs.pingcap.com/zh/tidb/stable/tidb-binlog-faq#同步时出现上游数据库支持但是下游数据库执行会出错的-ddl应该怎么办