tidm增量同步，上下游表结构相同但是会报Column count doesn't match value count: (columns) vs (values)的错

🪐 TiDB 技术问题
,
2

应该是历史上有同名任务，而那个任务里的 schema 是老的schema 导致的。试下用binlog-schema命令更新下schema tracker中的缓存

Use "dmctl binlog-schema [command] --help" for more information about a command.
» binlog-schema update --help
update tables schema structure

Usage:
  dmctl binlog-schema update <task-name> <database> <table> [schema-file] [flags]

Flags:
      --flush         flush the table info and checkpoint immediately (default true)
      --from-source   use the schema from upstream database as the schema of the specified tables
      --from-target   use the schema from downstream database as the schema of the specified tables
  -h, --help          help for update
      --sync          sync the table info to master to resolve shard ddl lock, only for optimistic mode now (default true)

Global Flags:
  -s, --source strings   MySQL Source ID.
»
2 个赞