dm同步task配置启动报错Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist

[机智的秘密鱼尾]

【 TiDB 使用环境】生产环境
【 TiDB 版本】6.5.3
【复现路径】调整上游同步库
【遇到的问题：问题现象及影响】
“checkResult”: “[code=26005:class=dm-master:scope=internal:level=medium], Message: fail to check synchronization configuration with type: check was failed, please see detail
detail: {
“results”: [
{
“id”: 9,
“name”: “table structure compatibility check”,
“desc”: “check compatibility of table structure”,
“state”: “fail”,
“errors”: [
{
“severity”: “fail”,
“short_error”: “Error 1168 (HY000): Unable to open underlying table which is differently defined or of non-MyISAM type or doesn’t exist”
}
]
}
],
“summary”: {
“passed”: false,
“total”: 10,
“successful”: 9,
“failed”: 1,
“warning”: 0
}
}”
【资源配置】进入到 TiDB Dashboard -集群信息 (Cluster Info) -主机(Hosts) 截图此页面
【附件：截图/日志/监控】

[饭光小团]

上下游表机构不一致，看下 对应binlog是同步到哪个表

[机智的秘密鱼尾]

看了下，调整block-allow-list，精准匹配要同步的数据，发现ok了，可是库里面还有别的表结构不满足要求

[Jellybean (李文杰)]

看报错信息，是上下游的表结构scheme没有对齐导致的，应该是因为下游表结构和上游的有差异。

可以试试手动去下游创建表，或者手动去对齐表结构情况