【 TiDB 使用环境`】生产
【 TiDB 版本】3.0.3
【遇到的问题】
下载命令:nohup /home/tidb/tidb-toolkit-v5.0.1-linux-amd64/bin/dumpling -u root -p’tidb’ -P 4000 -h 192.168.80.203 --filetype sql -t 16 -r 200000 -o /data > dumpling.out 2>&1 &
19:30开始下载, 23:39开始报错,
[mysql] 2022/10/09 23:39:24 packets.go:72: unexpected EOF
[mysql] 2022/10/09 23:39:24 packets.go:427: busy buffer
[2022/10/09 23:39:24.740 +08:00] [INFO] [collector.go:188] [“backup Failed summary : total backup ranges: 0, total success: 0, total failed: 0”]
[mysql] 2022/10/09 23:39:24 packets.go:72: unexpected EOF
[mysql] 2022/10/09 23:39:24 packets.go:427: busy buffer
[2022/10/09 23:39:24.744 +08:00] [ERROR] [main.go:77] [“dump failed error stack info”] [error=“sql: SELECT * FROM wtlivedbrds_xa
.EVDataRT
LIMIT 1: invalid connection”] [errorVerbose=“invalid connection\
sql: SELECT * FROM wtlivedbrds_xa
.EVDataRT
LIMIT 1\ngithub.com/pingcap/dumpling/v4/export.GetColumnTypes\
\tgithub.com/pingcap/dumpling@/v4/export/sql.go:307\
github.com/pingcap/dumpling/v4/export.dumpTableMeta\
\tgithub.com/pingcap/dumpling@/v4/export/dump.go:696\
github.com/pingcap/dumpling/v4/export.(*Dumper).dumpDatabases\
\tgithub.com/pingcap/dumpling@/v4/export/dump.go:302\
github.com/pingcap/dumpling/v4/export.(*Dumper).Dump\
\tgithub.com/pingcap/dumpling@/v4/export/dump.go:223\
main.main\
\tgithub.com/pingcap/dumpling@/cmd/dumpling/main.go:74\
runtime.main\
\truntime/proc.go:203\
runtime.goexit\
\truntime/asm_amd64.s:1357”]
dump failed: sql: SELECT * FROM wtlivedbrds_xa
.EVDataRT
LIMIT 1: invalid connection
最终连接失败,dump失败。
【复现路径】Dumpling下载测试了4次均失败,尝试将线程数-t由128改为64 、32,将-r改为100000还是报同样的错误失败。