用tidb-lightning导数据报错：error="rpc error: code = Canceled desc = context canceled"

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

这个看起来还是异常退出了啊:joy:
运行lightning的机器是什么配置的

23

8C32G

24

你把table-concurrency 搞小一点试试

26

从8调成4了，看会不会再退出。

28

调成4，也一样退出了，数据没导完。
[2021/12/27 19:53:51.948 +08:00] [INFO] [restore.go:2232] [“restore file completed”] [table=pagoda_customer5.store_goodsorder_goods_rel] [engineNumber=0] [fileIndex=1280] [path=pagoda_customer5.store_goodsorder_goods_rel.0000012800000.sql:0] [readDur=419.189198ms] [encodeDur=164.925292ms] [deliverDur=20.836898181s] [checksum="{cksum=0,size=23620066,kvs=123119}"] [takeTime=20.897447543s] []
[2021/12/27 19:53:51.948 +08:00] [INFO] [restore.go:2222] [“restore file start”] [table=pagoda_customer5.store_goodsorder_goods_rel] [engineNumber=0] [fileIndex=1288] [path=pagoda_customer5.store_goodsorder_goods_rel.0000012880000.sql:0]
[2021/12/27 19:53:53.152 +08:00] [INFO] [main.go:45] [“got signal to exit”] [signal=hangup]
[2021/12/27 19:53:53.152 +08:00] [WARN] [restore.go:1069] [“stopping periodic actions”] [error=“context canceled”]
[2021/12/27 19:53:53.152 +08:00] [INFO] [restore.go:1173] [“cancel periodic actions”] [do=false]
[2021/12/27 19:53:53.152 +08:00] [INFO] [restore.go:416] [“task canceled”] [step=3] [error=“restore table pagoda_customer5.store_goodsorder_goods_rel failed: context canceled”]
[2021/12/27 19:53:53.152 +08:00] [INFO] [restore.go:2222] [“restore file start”] [table=pagoda_customer5.store_goodsorder_goods_rel] [engineNumber=0] [fileIndex=1289] [path=pagoda_customer5.store_goodsorder_goods_rel.0000012890000.sql:0]
[2021/12/27 19:53:53.152 +08:00] [INFO] [restore.go:431] [“the whole procedure completed”] [takeTime=1h0m2.226788621s] []
[2021/12/27 19:53:53.152 +08:00] [INFO] [main.go:93] [“tidb lightning exit”]

29

怎样用二种方式，同时来导数呢，一种是local,另外一种是tidb的方式，现在一个执行的脚本用的是local,另外一个脚本是tidb，tidb的脚本执行不成功，报错如下：
[2021/12/28 23:40:54.048 +08:00] [ERROR] [lightning.go:305] [“restore failed”] [error=“config ‘tikv-importer.backend’ value ‘tidb’ different from checkpoint value ‘local’, please delete the file ‘/tmp/tidb_lightning_checkpoint.pb’ and remove all restored tables and try again”]
[2021/12/28 23:40:54.048 +08:00] [ERROR] [main.go:89] [“tidb lightning encountered error stack info”] [error=“config ‘tikv-importer.backend’ value ‘tidb’ different from checkpoint value ‘local’, please delete the file ‘/tmp/tidb_lightning_checkpoint.pb’ and remove all restored tables and try again”] [errorVerbose=“config ‘tikv-importer.backend’ value ‘tidb’ different from checkpoint value ‘local’, please delete the file ‘/tmp/tidb_lightning_checkpoint.pb’ and remove all restored tables and try again\ngithub.com/pingcap/tidb/br/pkg/lightning/restore.verifyCheckpoint\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/br/br/pkg/lightning/restore/restore.go:777\ github.com/pingcap/tidb/br/pkg/lightning/restore.NewRestoreControllerWithPauser\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/br/br/pkg/lightning/restore/restore.go:291\ github.com/pingcap/tidb/br/pkg/lightning/restore.NewRestoreController\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/br/br/pkg/lightning/restore/restore.go:266\ github.com/pingcap/tidb/br/pkg/lightning.(*Lightning).run\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/br/br/pkg/lightning/lightning.go:303\ngithub.com/pingcap/tidb/br/pkg/lightning.(*Lightning).RunOnce\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/br/br/pkg/lightning/lightning.go:190\ main.main.func2\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/br/br/cmd/tidb-lightning/main.go:85\ main.main\ \t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/br/br/cmd/tidb-lightning/main.go:86\ runtime.main\ \t/usr/local/go/src/runtime/proc.go:225\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1371”]
[2021/12/28 23:40:54.048 +08:00] [ERROR] [main.go:90] [“tidb lightning encountered error”] [error=“config ‘tikv-importer.backend’ value ‘tidb’ different from checkpoint value ‘local’, please delete the file ‘/tmp/tidb_lightning_checkpoint.pb’ and remove all restored tables and try again”]

30

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。