tidb-lightning 导入报错

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

  • 【TiDB 版本】:4.0.7
  • 【问题描述】:
    Error: TiDB Lightning has detected tables with illegal checkpoints; please remove these checkpoints first
    tidb lightning encountered error: TiDB Lightning has detected tables with illegal checkpoints; please remove these checkpoints first

[tidb@tidb-129-224 bin]$ ./tidb-lightning-ctl -checkpoint-error-destroy=all
Get http://127.0.0.1:10080/settings: dial tcp 127.0.0.1:10080: connect: connection refused
github.com/pingcap/errors.AddStack
/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.8/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20200917111840-a15ef68f753d/errors.go:174
github.com/pingcap/errors.Trace
/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.8/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20200917111840-a15ef68f753d/juju_adaptor.go:15
github.com/pingcap/tidb-lightning/lightning/common.GetJSON
/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.8/go/src/github.com/pingcap/tidb-lightning/lightning/common/util.go:282
github.com/pingcap/tidb-lightning/lightning/common.(*TLS).GetJSON
/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.8/go/src/github.com/pingcap/tidb-lightning/lightning/common/security.go:149
github.com/pingcap/tidb-lightning/lightning/config.(*Config).Adjust
/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.8/go/src/github.com/pingcap/tidb-lightning/lightning/config/config.go:564
main.run
/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.8/go/src/github.com/pingcap/tidb-lightning/cmd/tidb-lightning-ctl/main.go:71
main.main
/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.8/go/src/github.com/pingcap/tidb-lightning/cmd/tidb-lightning-ctl/main.go:36
runtime.main
/usr/local/go/src/runtime/proc.go:203
runtime.goexit
/usr/local/go/src/runtime/asm_amd64.s:1357
cannot fetch settings from TiDB, please manually fill in tidb.port and tidb.pd-addr

[tidb@tidb-129-224 bin]$ cat tidb-lightning.toml
[lightning]
level = “info”
file = “/tmp/lightning.log”
max-size = 100
max-days = 10
max-backups = 10
index-concurrency = 2
table-concurrency = 6
io-concurrency = 5

[mydumper]
read-block-size = 65536
character-set = “auto”
data-source-dir = “/u01/bak/2020112002/”

[tidb]
host = “10.96.129.222”
port = 4000
user = “root”
password = “xiebin1204”
pd-addr = “10.96.129.222:2379”
status-port = 10080

这个报错看起来不是第一次导入的报错,可以先按照文档清空 checkpoint https://pingcap.com/docs-cn/stable/tidb-lightning/tidb-lightning-checkpoints/#断点续传的控制,然后再启动 lightning 试试。

提问前建议先在 asktug 搜索一下,已经有很多此类帖子并且有相关解决方案了,多谢。

查了,处理不了。我才提问的

现在是表结构都导入了就是数据没有导入

请问这个问题是否已经解决? 关于上面表结构导入数据未导入的问题,我看你这边是有其他帖子跟进?lightning 报错

使用 tidb-lightning-ctl 的时候也需要指定 tidb-lightning 对应的 toml 配置文件,或者对应的命令行参数。看这个报错的意思是,没有指定 toml 文件,导致使用了默认的参数