this table is not eligible to replicate

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

【TiDB 版本】v4.0.7

【问题描述】通过TiCDC将TiDB的数据复制到MySQL的过程中,发现无索引的表不能被复制。参数如下:

Starting component ctl: /root/.tiup/components/ctl/v5.0.0-rc/ctl cdc changefeed query --pd=http://10.60.79.168:2379 --changefeed-id=sync-test-repl-task
{
“info”: {
“sink-uri”: “mysql://sync_data:test1234@rds-test.ct7cj9f0ldac.us-east-1.rds.amazonaws.com:3306/?max-txn-row=500\u0026time-zone=”,
“opts”: {
“_changefeed_id”: “cli-verify”
},
“create-time”: “2021-02-19T14:19:26.154014888+08:00”,
“start-ts”: 423025791230541831,
“target-ts”: 0,
“admin-job-type”: 0,
“sort-engine”: “memory”,
“sort-dir”: “.”,
“config”: {
“case-sensitive”: false,
“enable-old-value”: true,
“force-replicate”: true,
“check-gc-safe-point”: true,
“filter”: {
“rules”: [
“sync_test.*”
],
“ignore-txn-start-ts”: null,
“ddl-allow-list”: null
},
“mounter”: {
“worker-num”: 16
},
“sink”: {
“dispatchers”: null,
“protocol”: “default”
},
“cyclic-replication”: {
“enable”: false,
“replica-id”: 1,
“filter-replica-ids”: [
2,
3
],
“id-buckets”: 0,
“sync-ddl”: true
},
“scheduler”: {
“type”: “table-number”,
“polling-time”: -1
}
},
“state”: “normal”,
“history”: null,
“error”: null,
“sync-point-enabled”: false,
“sync-point-interval”: 600000000000
},
“status”: {
“resolved-ts”: 423025874303975425,
“checkpoint-ts”: 423025874251546625,
“admin-job-type”: 0
},
“count”: 0,
“task-status”: [
{
“capture-id”: “d4b8da56-f56f-485e-9949-10aab228cb16”,
“status”: {
“tables”: {
“47”: {
“start-ts”: 423025791230541831,
“mark-table-id”: 0
},
“71”: {
“start-ts”: 423025867645517835,
“mark-table-id”: 0
}
},
“operation”: null,
“admin-job-type”: 0
}
}
]
}

要同步的表结构如下:
CREATE TABLE test_no_index (
id int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

请帮忙看下原因,多谢。


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

补充下ticdc的日志,如下,请参考:

[2021/02/19 14:24:18.231 +08:00] [WARN] [schema_storage.go:468] [“this table is not eligible to replicate”] [tableName=test_no_index1] [tableID=75]
[2021/02/19 14:24:18.280 +08:00] [INFO] [changefeed.go:615] [“apply job”] [job=“ID:76, Type:create table, State:done, SchemaState:public, SchemaID:45, TableID:75, RowCount:0, ArgLen:0, start time: 2021-02-19 14:24:17.246 +0800 CST, Err:, ErrCount:0, SnapshotVersion:0”] [schema=sync_test] [query=“CREATE TABLE test_no_index1 ( id int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin”] [ts=423025929681895434]
[2021/02/19 14:24:18.281 +08:00] [WARN] [schema_storage.go:468] [“this table is not eligible to replicate”] [tableName=test_no_index1] [tableID=75]
[2021/02/19 14:24:18.281 +08:00] [INFO] [changefeed.go:645] [“ddl job ignored”] [changefeed=sync-test-repl-task] [job="{“id”:76,“type”:3,“schema_id”:45,“table_id”:75,“schema_name”:“sync_test”,“state”:4,“err”:null,“err_count”:0,“row_count”:0,“raw_args”:[{“id”:75,“name”:{“O”:“test_no_index1”,“L”:“test_no_index1”},“charset”:“utf8mb4”,“collate”:“utf8mb4_bin”,“cols”:[{“id”:1,“name”:{“O”:“id”,“L”:“id”},“offset”:0,“origin_default”:null,“default”:null,“default_bit”:null,“default_is_expr”:false,“generated_expr_string”:"",“generated_stored”:false,“dependences”:null,“type”:{“Tp”:3,“Flag”:0,“Flen”:11,“Decimal”:0,“Charset”:“binary”,“Collate”:“binary”,“Elems”:null},“state”:5,“comment”:"",“hidden”:false,“version”:2}],“index_info”:null,“fk_info”:null,“state”:5,“pk_is_handle”:false,“comment”:"",“auto_inc_id”:0,“auto_id_cache”:0,“auto_rand_id”:0,“max_col_id”:1,“max_idx_id”:0,“update_timestamp”:423025929681895432,“ShardRowIDBits”:0,“max_shard_row_id_bits”:0,“auto_random_bits”:0,“pre_split_regions”:0,“partition”:null,“compression”:"",“view”:null,“sequence”:null,“Lock”:null,“version”:3,“tiflash_replica”:null}],“schema_state”:5,“snapshot_ver”:0,“start_ts”:423025929681895432,“dependency_id”:0,“query”:“CREATE TABLE test_no_index1 ( id int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin”,“binlog”:{“SchemaVersion”:59,“DBInfo”:null,“TableInfo”:{“id”:75,“name”:{“O”:“test_no_index1”,“L”:“test_no_index1”},“charset”:“utf8mb4”,“collate”:“utf8mb4_bin”,“cols”:[{“id”:1,“name”:{“O”:“id”,“L”:“id”},“offset”:0,“origin_default”:null,“default”:null,“default_bit”:null,“default_is_expr”:false,“generated_expr_string”:"",“generated_stored”:false,“dependences”:null,“type”:{“Tp”:3,“Flag”:0,“Flen”:11,“Decimal”:0,“Charset”:“binary”,“Collate”:“binary”,“Elems”:null},“state”:5,“comment”:"",“hidden”:false,“version”:2}],“index_info”:null,“fk_info”:null,“state”:5,“pk_is_handle”:false,“comment”:"",“auto_inc_id”:0,“auto_id_cache”:0,“auto_rand_id”:0,“max_col_id”:1,“max_idx_id”:0,“update_timestamp”:423025929681895432,“ShardRowIDBits”:0,“max_shard_row_id_bits”:0,“auto_random_bits”:0,“pre_split_regions”:0,“partition”:null,“compression”:"",“view”:null,“sequence”:null,“Lock”:null,“version”:3,“tiflash_replica”:null},“FinishedTS”:423025929681895434},“version”:1,“reorg_meta”:null,“priority”:0}"]
[2021/02/19 14:24:18.481 +08:00] [INFO] [schema_storage.go:749] [“finished gc in schema storage”] [gcTs=423025929681895434]

麻烦仔细看下官网的同步限制,多谢。
https://docs.pingcap.com/zh/tidb/stable/ticdc-overview#同步限制