tidb-lightning导入数据报“transport: Error while dialing dial tcp: missing address”

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

  • 【TiDB 版本】:v4.0.5
  • 【问题描述】:

tidb-lightning导入数据报错

$ cat tidb-lightning.toml
[mydumper]
data-source-dir = “/home/tidb/test-rds-data/”

[tidb]
host = “10.0.59.176”
port = 4000
user = “root”
password = “vPT3r7&xxxxxxxd0xic”

$ ll /home/tidb/test-rds-data/
total 84
-rw-r–r-- 1 tidb tidb 70776 Nov 18 10:59 merchant_0.merchant_account_record_0.0.sql
-rw-r–r-- 1 tidb tidb 1997 Nov 18 10:59 merchant_0.merchant_account_record_0-schema.sql
-rw-r–r-- 1 tidb tidb 101 Nov 18 10:59 merchant_0-schema-create.sql
-rw-r–r-- 1 tidb tidb 514 Nov 18 10:59 metadata

$ ./tidb-lightning -config tidb-lightning.toml
Verbose debug logs will be written to /tmp/lightning.log.2020-11-18T11.21.34+0800

[2020/11/18 11:21:34.034 +08:00] [INFO] [client.go:166] ["[pd] create pd client with endpoints"] [pd-address="[10.0.59.178:2379]"]
[2020/11/18 11:21:34.035 +08:00] [INFO] [base_client.go:236] ["[pd] update member urls"] [old-urls="[http://10.0.59.178:2379]"] [new-urls="[http://10.0.59.174:2379,http://10.0.59.175:2379,http://10.0.59.178:2379]"]
[2020/11/18 11:21:34.035 +08:00] [INFO] [base_client.go:252] ["[pd] switch leader"] [new-leader=http://10.0.59.175:2379] [old-leader=]
[2020/11/18 11:21:34.036 +08:00] [INFO] [base_client.go:102] ["[pd] init cluster id"] [cluster-id=6864420848409801722]
[2020/11/18 11:21:34.036 +08:00] [INFO] [client.go:166] ["[pd] create pd client with endpoints"] [pd-address="[10.0.59.178:2379]"]
[2020/11/18 11:21:34.037 +08:00] [INFO] [base_client.go:236] ["[pd] update member urls"] [old-urls="[http://10.0.59.178:2379]"] [new-urls="[http://10.0.59.174:2379,http://10.0.59.175:2379,http://10.0.59.178:2379]"]
[2020/11/18 11:21:34.037 +08:00] [INFO] [base_client.go:252] ["[pd] switch leader"] [new-leader=http://10.0.59.175:2379] [old-leader=]
[2020/11/18 11:21:34.037 +08:00] [INFO] [base_client.go:102] ["[pd] init cluster id"] [cluster-id=6864420848409801722]
Error: restore table merchant_0.merchant_account_record_0 failed: rpc error: code = Unavailable desc = connection error: desc = “transport: Error while dialing dial tcp: missing address”
tidb lightning encountered error: restore table merchant_0.merchant_account_record_0 failed: rpc error: code = Unavailable desc = connection error: desc = “transport: Error while dialing dial tcp: missing address”

ligjtning 执行服务器是否与 pd 网络畅通?ping 看下,这个 ip 可以检查下,lightning 服务器是否能登录这个 tidb server ?

使用 import/local backend 的时候,都需要设置 pd 的地址。 我看上面这个配置没有设置「pd-addr」这个配置项?

@CaoZhenggg 请问你的问题解决了吗

我这也遇到这个问题,配置如下:


当前机器连接tidb如下
image
当前机器telnet PD端口如下:
image
报错信息如下:
image