【 TiDB 使用环境】生产环境
【 TiDB 版本】V7.5.0
【复现路径】dump全量导出后,再做增量导出,用lightning全量导入后,再做增量导入报错
【遇到的问题:问题现象及影响】
[root@tidb_history_tikv1 tidb-community-server-v7.5.0-linux-amd64]# tail -f lightning.log
[2024/02/04 15:22:00.019 +08:00] [WARN] [config.go:1563] [“currently only per-task configuration can be applied, global configuration changes can only be made on startup”] [“global config changes”=“[lightning.level,lightning.file]”]
[2024/02/04 15:22:00.019 +08:00] [ERROR] [main.go:103] [“tidb lightning encountered error stack info”] [error=“[Lightning:Config:ErrInvalidConfig]conflict.strategy cannot be used with tikv-importer.parallel-import”] [errorVerbose=“[Lightning:Config:ErrInvalidConfig]conflict.strategy cannot be used with tikv-importer.parallel-import\ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20221009092201-b66cddb77c32/errors.go:174\ngithub.com/pingcap/errors.(*Error).GenWithStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20221009092201-b66cddb77c32/normalize.go:155\ngithub.com/pingcap/tidb/br/pkg/lightning/config.(*Conflict).adjust\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/config/config.go:1341\ngithub.com/pingcap/tidb/br/pkg/lightning/config.(*Config).Adjust\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/config/config.go:1594\ngithub.com/pingcap/tidb/br/pkg/lightning.(*Lightning).RunOnceWithOptions\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/lightning.go:350\nmain.main.func2\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/cmd/tidb-lightning/main.go:94\nmain.main\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/cmd/tidb-lightning/main.go:95\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:267\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1650”]
【资源配置】
[root@tidb_history_tikv1 tidb-community-server-v7.5.0-linux-amd64]# cat lightning.toml
[lightning]
level = “info”
file = “lightning.log”
table-concurrency = 8
io-concurrency = 6
[tikv-importer]
backend = “tidb”
sorted-kv-dir = “/data/lightning_data” # 指定ssd目录
incremental-import = true
[mydumper]
data-source-dir = “/data/account_db2”
filter = [‘.’,‘!mysql.‘,’!sys.’,‘!INFORMATION_SCHEMA.‘,’!PERFORMANCE_SCHEMA.’,‘!METRICS_SCHEMA.‘,’!INSPECTION_SCHEMA.’]
[checkpoint]
enable = true
[tidb]
host = “10.230.8.29”
port = 4000
user = “root”
password = “XXXXXX”
status-port = 10080
pd-addr = “10.230.6.137:2379”