校验mysql报错/data/tidb/tidb-toolkit-v4.0.13-linux-amd64/bin/sync_diff_inspector --config=./config.toml

🪐 TiDB 技术问题 备份&数据迁移
1

【 TiDB 使用环境】生产环境
4013
【复现路径】做过哪些操作出现的问题
校验报错
[2023/12/26 08:30:46.581 +00:00] [ERROR] [main.go:38] [“parse cmd flags”] [error=“unknown keys in config file ./config.toml: [export-fix-sql check-struct-only data-sources data-sources.mysql1 data-sources.mysql1.host data-sources.mysql1.port data-sources.mysql1.user data-sources.mysql1.password data-sources.tidb1 data-sources.tidb1.host data-sources.tidb1.port data-sources.tidb1.user data-sources.tidb1.password task task.output-dir task.source-instances task.target-instance task.target-check-tables]”] [errorVerbose=“unknown keys in config file ./config.toml: [export-fix-sql check-struct-only data-sources data-sources.mysql1 data-sources.mysql1.host data-sources.mysql1.port data-sources.mysql1.user data-sources.mysql1.password data-sources.tidb1 data-sources.tidb1.host data-sources.tidb1.port data-sources.tidb1.user data-sources.tidb1.password task task.output-dir task.source-instances task.target-instance task.target-check-tables]\nmain.(*Config).configFromFile\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/config.go:286\nmain.(*Config).Parse\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/config.go:252\nmain.main\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:32\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:203\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1357”] [stack=“main.main\n\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:38\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:203”]

2

unknown keys in config file ./config.toml

3

都提醒的这么明显了，找找哪个配置不对啊

4

配置上有KEY错误

5

./config.toml检查下这个配置文件

6

这个错误提示你在 ./config.toml 配置文件中有一些未知的键（key）。换句话说，你的配置文件中可能包含了一些 Sync_diff_inspector 不支持的配置项。

以下是你提供的错误列表中的一部分未知键：

  • export-fix-sql
  • check-struct-only
  • data-sources
  • data-sources.mysql1
  • data-sources.mysql1.host
  • …（以及其他类似的键）
7

配置文件写的不对