lightning导入数据出错

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

[2022/08/08 22:42:21.323 +08:00] [ERROR] [local.go:733] [“failed to get StoreInfo from pd http api”] [error=“Get “http://tidb-rlfjb3nncn-pd.tidb-rlfjb3nncn-hb.jvessel2.jdcloud.com:2379/pd/api/v1/store/89”: context canceled”] [errorVerbose=“Get “http://tidb-rlfjb3nncn-pd.tidb-rlfjb3nncn-hb.jvessel2.jdcloud.com:2379/pd/api/v1/store/89”: context canceled\ngithub.com/pingcap/errors.AddStack\ \t/nfs/cache/mod/github.com/pingcap/errors@v0.11.5-0.20211224045212-9687c2b0f87c/errors.go:174\ github.com/pingcap/errors.Trace\ \t/nfs/cache/mod/github.com/pingcap/errors@v0.11.5-0.20211224045212-9687c2b0f87c/juju_adaptor.go:15\ github.com/pingcap/tidb/br/pkg/pdutil.pdRequest\ \t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/pdutil/pd.go:150\ github.com/pingcap/tidb/br/pkg/pdutil.(*PdController).getStoreInfoWith\ \t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/pdutil/pd.go:364\ngithub.com/pingcap/tidb/br/pkg/pdutil.(*PdController).GetStoreInfo\ \t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/pdutil/pd.go:354\ngithub.com/pingcap/tidb/br/pkg/lightning/backend/local.(*local).WriteToTiKV\ \t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/backend/local/local.go:717\ngithub.com/pingcap/tidb/br/pkg/lightning/backend/local.(*local).writeAndIngestPairs\ \t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/backend/local/local.go:1143\ngithub.com/pingcap/tidb/br/pkg/lightning/backend/local.(*local).writeAndIngestByRange\ \t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/backend/local/local.go:1095\ngithub.com/pingcap/tidb/br/pkg/lightning/backend/local.(*local).writeAndIngestByRanges.func1\ \t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/backend/local/local.go:1282\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1371”]
[2022/08/08 22:42:21.323 +08:00] [ERROR] [local.go:733] [“failed to get StoreInfo from pd http api”] [error=“Get “http://tidb-rlfjb3nncn-pd.tidb-rlfjb3nncn-hb.jvessel2.jdcloud.com:2379/pd/api/v1/store/66”: context canceled”] [errorVerbose=“Get “http://tidb-rlfjb3nncn-pd.tidb-rlfjb3nncn-hb.jvessel2.jdcloud.com:2379/pd/api/v1/store/66”: context canceled\ngithub.com/pingcap/errors.AddStack\ \t/nfs/cache/mod/github.com/pingcap/errors@v0.11.5-0.20211224045212-9687c2b0f87c/errors.go:174\ github.com/pingcap/errors.Trace\ \t/nfs/cache/mod/github.com/pingcap/errors@v0.11.5-0.20211224045212-9687c2b0f87c/juju_adaptor.go:15\ github.com/pingcap/tidb/br/pkg/pdutil.pdRequest\ \t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/pdutil/pd.go:150\ github.com/pingcap/tidb/br/pkg/pdutil.(*PdController).getStoreInfoWith\ \t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/pdutil/pd.go:364\ngithub.com/pingcap/tidb/br/pkg/pdutil.(*PdController).GetStoreInfo\ \t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/pdutil/pd.go:354\ngithub.com/pingcap/tidb/br/pkg/lightning/backend/local.(*local).WriteToTiKV\ \t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/backend/local/local.go:717\ngithub.com/pingcap/tidb/br/pkg/lightning/backend/local.(*local).writeAndIngestPairs\ \t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/backend/local/local.go:1143\ngithub.com/pingcap/tidb/br/pkg/lightning/backend/local.(*local).writeAndIngestByRange\ \t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/backend/local/local.go:1095\ngithub.com/pingcap/tidb/br/pkg/lightning/backend/local.(*local).writeAndIngestByRanges.func1\ \t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/backend/local/local.go:1282\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1371”]
[2022/08/08 22:42:21.327 +08:00] [ERROR] [local.go:1359] [“split & scatter ranges failed”] [uuid=620f50f3-0cb0-5c85-901d-6ba75d2009a7] [error=“context canceled”]
[2022/08/08 22:42:21.332 +08:00] [ERROR] [local.go:1359] [“split & scatter ranges failed”] [uuid=7c2574a4-2c55-500a-80ec-d6019a35fff8] [error=“context canceled”]
[2022/08/08 22:42:21.334 +08:00] [ERROR] [local.go:1359] [“split & scatter ranges failed”] [uuid=2441157e-dc47-56b6-ac4c-10309ed24723] [error=“context canceled”]
[2022/08/08 22:42:21.345 +08:00] [ERROR] [local.go:1359] [“split & scatter ranges failed”] [uuid=c80e37e2-bc47-5fdd-a6ca-e2707d7173f3] [error=“context canceled”]
[2022/08/08 22:42:21.346 +08:00] [ERROR] [local.go:1359] [“split & scatter ranges failed”] [uuid=2b982059-7849-5c41-9186-8bb429e8e571] [error=“context canceled”]
[2022/08/08 22:42:21.347 +08:00] [ERROR] [local.go:1359] [“split & scatter ranges failed”] [uuid=44f67476-1d43-5d32-adb6-7f0a1b28a43f] [error=“context canceled”]
[2022/08/08 22:42:21.348 +08:00] [ERROR] [local.go:1359] [“split & scatter ranges failed”] [uuid=2a26cb6d-e968-5c2d-845a-55cb61125ea3] [error=“context canceled”]
[2022/08/08 22:42:21.378 +08:00] [ERROR] [local.go:1359] [“split & scatter ranges failed”] [uuid=704ee858-1777-58c3-a76a-28d9619bfd84] [error=“context canceled”]
[2022/08/08 22:42:21.379 +08:00] [ERROR] [local.go:1359] [“split & scatter ranges failed”] [uuid=da29bd4d-d7aa-520b-8a3d-4dba513dcd56] [error=“context canceled”]
[root@gejb-tidb–01 lightning]#

tidb 版本5.4.0
lightning 版本5.4.0

每次用lightning导入都出这种错误。

3

看下你运行lightning的机器能否正常访问到pd的2379端口

4

同vpc内，不应该每次都出现这个情况。

5

failed to get StoreInfo from pd http api，可能是端口没开放。手动在 lightning 机器上 telnet {PD-IP:PORT} 端口吧。

  1. 要么是端口写错了 pd-ip:2379
  2. 要么是端口未对外开放
1 个赞