最后竟然报错了,不止是慢。
[tidb@b67 tidb-toolkit]$ ./dumpling -uroot -P 4000 -hb85 -p 'xxxx' -T bsppr.xpost --where "update_time < '2025-02-10 00:00:00'" -t 16 -o /tmp/dumpling-bsppr-xpost-test -r 100000 -F 256MiBRelease version: v7.1.5
Git commit hash: caa60c0917a886933a525d25e17057faac5b4da2
Git branch: HEAD
Build timestamp: 2024-04-24 11:09:23Z
Go version: go version go1.20.10 linux/amd64
[2026/07/10 13:20:46.505 +08:00] [INFO] [versions.go:54] ["Welcome to dumpling"] ["Release Version"=v7.1.5] ["Git Commit Hash"=caa60c0917a886933a525d25e17057faac5b4da2] ["Git Branch"=HEAD] ["Build timestamp"="2024-04-24 11:09:23"] ["Go Version"="go version go1.20.10 linux/amd64"]
[2026/07/10 13:20:46.510 +08:00] [INFO] [version.go:434] ["detect server version"] [type=TiDB] [version=7.1.5]
[2026/07/10 13:20:46.521 +08:00] [INFO] [client.go:311] ["[pd] create pd client with endpoints and keyspace"] [pd-address="[192.168.241.60:2379,192.168.241.59:2379,192.168.241.61:2379]"] [keyspace-id=0]
[2026/07/10 13:20:46.527 +08:00] [INFO] [pd_service_discovery.go:521] ["[pd] update member urls"] [old-urls="[http://192.168.241.60:2379,http://192.168.241.59:2379,http://192.168.241.61:2379]"] [new-urls="[http://192.168.241.59:2379,http://192.168.241.60:2379,http://192.168.241.61:2379]"]
[2026/07/10 13:20:46.527 +08:00] [INFO] [pd_service_discovery.go:546] ["[pd] switch leader"] [new-leader=http://192.168.241.59:2379] [old-leader=]
[2026/07/10 13:20:46.527 +08:00] [INFO] [pd_service_discovery.go:177] ["[pd] init cluster id"] [cluster-id=7210697100626091534]
[2026/07/10 13:20:46.528 +08:00] [INFO] [client.go:386] ["[pd] changing service mode"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2026/07/10 13:20:46.528 +08:00] [INFO] [tso_client.go:231] ["[tso] switch dc tso allocator serving address"] [dc-location=global] [new-address=http://192.168.241.59:2379]
[2026/07/10 13:20:46.528 +08:00] [INFO] [tso_dispatcher.go:296] ["[tso] tso dispatcher created"] [dc-location=global]
[2026/07/10 13:20:46.528 +08:00] [INFO] [client.go:428] ["[pd] service mode changed"] [old-mode=PD_SVC_MODE] [new-mode=PD_SVC_MODE]
[2026/07/10 13:20:46.529 +08:00] [INFO] [dump.go:1519] ["generate dumpling gc safePoint id"] [id=dumpling_1783660846529742592]
[2026/07/10 13:20:46.544 +08:00] [INFO] [dump.go:151] ["begin to run Dump"] [conf="{\"s3\":{\"endpoint\":\"\",\"region\":\"\",\"storage-class\":\"\",\"sse\":\"\",\"sse-kms-key-id\":\"\",\"acl\":\"\",\"access-key\":\"\",\"secret-access-key\":\"\",\"session-token\":\"\",\"provider\":\"\",\"force-path-style\":true,\"use-accelerate-endpoint\":false,\"role-arn\":\"\",\"external-id\":\"\",\"object-lock-enabled\":false},\"gcs\":{\"endpoint\":\"\",\"storage-class\":\"\",\"predefined-acl\":\"\",\"credentials-file\":\"\"},\"azblob\":{\"endpoint\":\"\",\"account-name\":\"\",\"account-key\":\"\",\"access-tier\":\"\"},\"AllowCleartextPasswords\":false,\"SortByPk\":true,\"NoViews\":true,\"NoSequences\":true,\"NoHeader\":false,\"NoSchemas\":false,\"NoData\":false,\"CompleteInsert\":false,\"TransactionalConsistency\":true,\"EscapeBackslash\":true,\"DumpEmptyDatabase\":true,\"PosAfterConnect\":false,\"CompressType\":0,\"Host\":\"b85\",\"Port\":4000,\"Threads\":16,\"User\":\"root\",\"Security\":{\"CAPath\":\"\",\"CertPath\":\"\",\"KeyPath\":\"\"},\"LogLevel\":\"info\",\"LogFile\":\"\",\"LogFormat\":\"text\",\"OutputDirPath\":\"/tmp/dumpling-bsppr-xpost-test\",\"StatusAddr\":\":8281\",\"Snapshot\":\"467575988952236033\",\"Consistency\":\"snapshot\",\"CsvNullValue\":\"\\\\N\",\"SQL\":\"\",\"CsvSeparator\":\",\",\"CsvDelimiter\":\"\\\"\",\"Databases\":[],\"Where\":\"update_time \\u003c '2025-02-10 00:00:00'\",\"FileType\":\"sql\",\"ServerInfo\":{\"ServerType\":3,\"ServerVersion\":\"7.1.5\",\"HasTiKV\":true},\"Rows\":100000,\"ReadTimeout\":900000000000,\"TiDBMemQuotaQuery\":0,\"FileSize\":268435456,\"StatementSize\":1000000,\"SessionParams\":{\"tidb_snapshot\":\"467575988952236033\"},\"Tables\":{\"bsppr\":[{\"Name\":\"xpost\",\"AvgRowLength\":0,\"Type\":0}]},\"CollationCompatible\":\"loose\",\"IOTotalBytes\":null,\"Net\":\"\"}"]
[2026/07/10 13:22:46.642 +08:00] [INFO] [status.go:37] [progress] [tables="0/1 (0.0%)"] ["finished rows"=0] ["estimate total rows"=6469461330] ["finished size"=0B] ["average speed(MiB/s)"=0] ["recent speed bps"=0] ["chunks progress"=]
[2026/07/10 13:24:46.642 +08:00] [INFO] [status.go:37] [progress] [tables="0/1 (0.0%)"] ["finished rows"=0] ["estimate total rows"=6469461330] ["finished size"=0B] ["average speed(MiB/s)"=0] ["recent speed bps"=0] ["chunks progress"=]
[2026/07/10 13:26:46.642 +08:00] [INFO] [status.go:37] [progress] [tables="0/1 (0.0%)"] ["finished rows"=0] ["estimate total rows"=6469461330] ["finished size"=0B] ["average speed(MiB/s)"=0] ["recent speed bps"=0] ["chunks progress"=]
[2026/07/10 13:28:46.642 +08:00] [INFO] [status.go:37] [progress] [tables="0/1 (0.0%)"] ["finished rows"=0] ["estimate total rows"=6469461330] ["finished size"=0B] ["average speed(MiB/s)"=0] ["recent speed bps"=0] ["chunks progress"=]
[2026/07/10 13:30:46.642 +08:00] [INFO] [status.go:37] [progress] [tables="0/1 (0.0%)"] ["finished rows"=0] ["estimate total rows"=6469461330] ["finished size"=0B] ["average speed(MiB/s)"=0] ["recent speed bps"=0] ["chunks progress"=]
[2026/07/10 13:32:46.642 +08:00] [INFO] [status.go:37] [progress] [tables="0/1 (0.0%)"] ["finished rows"=0] ["estimate total rows"=6469461330] ["finished size"=0B] ["average speed(MiB/s)"=0] ["recent speed bps"=0] ["chunks progress"=]
[2026/07/10 13:34:46.642 +08:00] [INFO] [status.go:37] [progress] [tables="0/1 (0.0%)"] ["finished rows"=0] ["estimate total rows"=6469461330] ["finished size"=0B] ["average speed(MiB/s)"=0] ["recent speed bps"=0] ["chunks progress"=]
[2026/07/10 13:36:46.642 +08:00] [INFO] [status.go:37] [progress] [tables="0/1 (0.0%)"] ["finished rows"=0] ["estimate total rows"=6469461330] ["finished size"=0B] ["average speed(MiB/s)"=0] ["recent speed bps"=0] ["chunks progress"=]
[mysql] 2026/07/10 13:37:46 packets.go:37: read tcp 192.168.241.67:58932->192.168.241.85:4000: i/o timeout
[2026/07/10 13:37:46.567 +08:00] [INFO] [conn.go:44] ["cannot execute query"] [retryTime=1] [sql="SELECT `postid` FROM `bsppr`.`xpost` TABLESAMPLE REGIONS() ORDER BY `postid`"] [args=null] [error="sql: SELECT `postid` FROM `bsppr`.`xpost` TABLESAMPLE REGIONS() ORDER BY `postid`, args: []: invalid connection"] [errorVerbose="invalid connection\nsql: SELECT `postid` FROM `bsppr`.`xpost` TABLESAMPLE REGIONS() ORDER BY `postid`, args: []\ngithub.com/pingcap/tidb/dumpling/export.simpleQueryWithArgs\n\tgithub.com/pingcap/tidb/dumpling/export/sql.go:1153\ngithub.com/pingcap/tidb/dumpling/export.(*BaseConn).QuerySQL.func1\n\tgithub.com/pingcap/tidb/dumpling/export/conn.go:42\ngithub.com/pingcap/tidb/br/pkg/utils.WithRetry.func1\n\tgithub.com/pingcap/tidb/br/pkg/utils/retry.go:215\ngithub.com/pingcap/tidb/br/pkg/utils.WithRetryV2[...]\n\tgithub.com/pingcap/tidb/br/pkg/utils/retry.go:233\ngithub.com/pingcap/tidb/br/pkg/utils.WithRetry\n\tgithub.com/pingcap/tidb/br/pkg/utils/retry.go:214\ngithub.com/pingcap/tidb/dumpling/export.(*BaseConn).QuerySQL\n\tgithub.com/pingcap/tidb/dumpling/export/conn.go:34\ngithub.com/pingcap/tidb/dumpling/export.selectTiDBTableSample\n\tgithub.com/pingcap/tidb/dumpling/export/dump.go:980\ngithub.com/pingcap/tidb/dumpling/export.(*Dumper).concurrentDumpTiDBTables\n\tgithub.com/pingcap/tidb/dumpling/export/dump.go:880\ngithub.com/pingcap/tidb/dumpling/export.(*Dumper).concurrentDumpTable\n\tgithub.com/pingcap/tidb/dumpling/export/dump.go:737\ngithub.com/pingcap/tidb/dumpling/export.(*Dumper).dumpTableData\n\tgithub.com/pingcap/tidb/dumpling/export/dump.go:627\ngithub.com/pingcap/tidb/dumpling/export.(*Dumper).dumpDatabases\n\tgithub.com/pingcap/tidb/dumpling/export/dump.go:478\ngithub.com/pingcap/tidb/dumpling/export.(*Dumper).Dump\n\tgithub.com/pingcap/tidb/dumpling/export/dump.go:315\nmain.main\n\t./main.go:75\nruntime.main\n\truntime/proc.go:250\nruntime.goexit\n\truntime/asm_amd64.s:1598"]