Check MySQL Error /data/tidb/tidb-toolkit-v4.0.13-linux-amd64/bin/sync_diff_inspector --config=./config.toml

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

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

| username: 路在何chu

[TiDB Usage Environment] Production Environment
4013
[Reproduction Path] What operations were performed when the issue occurred
Validation error
[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
| username: 路在何chu | Original post link

unknown keys in config file ./config.toml

3
| username: 像风一样的男子 | Original post link

It’s been pointed out so clearly, just check which configuration is incorrect.

4
| username: dba远航 | Original post link

There is a KEY error in the configuration.

5
| username: andone | Original post link

Check the configuration file ./config.toml

6
| username: ti-tiger | Original post link

This error indicates that there are some unknown keys in your ./config.toml configuration file. In other words, your configuration file may contain some options that Sync_diff_inspector does not support.

Here are some of the unknown keys from the error list you provided:

  • export-fix-sql
  • check-struct-only
  • data-sources
  • data-sources.mysql1
  • data-sources.mysql1.host
  • … (and other similar keys)
7
| username: tidb菜鸟一只 | Original post link

The configuration file is written incorrectly.