v6.4.0备份失败

【 TiDB 使用环境】生产环境 /测试/ Poc

使用dumpling工具备份显示报错
./dumpling -h 10.200.78.103 -P 4003 -u root -p ‘密码’ --filetype sql -t 32 -F 256m -o /opt/data/
Release version: v6.4.0
Git commit hash: cf36a9ce2fe1039db3cf3444d51930b887df18a1
Git branch: heads/refs/tags/v6.4.0
Build timestamp: 2022-11-13 05:17:51Z
Go version: go version go1.19.2 linux/amd64

[2023/04/20 17:52:35.923 +08:00] [INFO] [versions.go:54] [“Welcome to dumpling”] [“Release Version”=v6.4.0] [“Git Commit Hash”=cf36a9ce2fe1039db3cf3444d51930b887df18a1] [“Git Branch”=heads/refs/tags/v6.4.0] [“Build timestamp”=“2022-11-13 05:17:51”] [“Go Version”=“go version go1.19.2 linux/amd64”]
[2023/04/20 17:52:35.928 +08:00] [INFO] [version.go:398] [“detect server version”] [type=TiDB] [version=6.4.0]
[2023/04/20 17:52:35.943 +08:00] [INFO] [global.go:34] [“[pd] create pd client with endpoints”] [pd-address=“[10.200.78.102:2379,10.200.78.101:2379]”]
[2023/04/20 17:52:35.951 +08:00] [INFO] [global.go:34] [“[pd] update member urls”] [old-urls=“[http://10.200.78.102:2379,http://10.200.78.101:2379]”] [new-urls=“[http://10.200.78.101:2379,http://10.200.78.102:2379]”]
[2023/04/20 17:52:35.951 +08:00] [INFO] [global.go:34] [“[pd] switch leader”] [new-leader=http://10.200.78.102:2379] [old-leader=]
[2023/04/20 17:52:35.951 +08:00] [INFO] [global.go:34] [“[pd] init cluster id”] [cluster-id=7173715422814811436]
[2023/04/20 17:52:35.951 +08:00] [INFO] [global.go:34] [“[pd] tso dispatcher created”] [dc-location=global]
[2023/04/20 17:52:35.953 +08:00] [INFO] [dump.go:1488] [“generate dumpling gc safePoint id”] [id=dumpling_1681984355953297887]
[2023/04/20 17:52:35.969 +08:00] [INFO] [dump.go:131] [“begin to run Dump”] [conf=“{“s3”:{“endpoint”:“”,“region”:“”,“storage-class”:“”,“sse”:“”,“sse-kms-key-id”:“”,“acl”:“”,“access-key”:“”,“secret-access-key”:“”,“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”:“10.200.78.103”,“Port”:4003,“Threads”:32,“User”:“root”,“Security”:{“CAPath”:“”,“CertPath”:“”,“KeyPath”:“”},“LogLevel”:“info”,“LogFile”:“”,“LogFormat”:“text”,“OutputDirPath”:“/opt/data/”,“StatusAddr”:“:8281”,“Snapshot”:“440922107003011073”,“Consistency”:“snapshot”,“CsvNullValue”:“\N”,“SQL”:“”,“CsvSeparator”:“,”,“CsvDelimiter”:“"”,“Databases”:[],“Where”:“”,“FileType”:“sql”,“ServerInfo”:{“ServerType”:3,“ServerVersion”:“6.4.0”,“HasTiKV”:true},“Rows”:0,“ReadTimeout”:900000000000,“TiDBMemQuotaQuery”:0,“FileSize”:268435456,“StatementSize”:1000000,“SessionParams”:{“tidb_snapshot”:“440922107003011073”},“Tables”:{},“CollationCompatible”:“loose”}”]
[2023/04/20 17:52:36.973 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=hsq-system] [table=gen_table] []
[2023/04/20 17:52:36.974 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=hsq-system] [table=gen_table]
[2023/04/20 17:52:36.978 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=hsq-system] [table=gen_table] [chunkIdx=0]
[2023/04/20 17:52:36.988 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=hsq-system] [table=gen_table_column] []
[2023/04/20 17:52:36.988 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=hsq-system] [table=gen_table_column]
[2023/04/20 17:52:36.993 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=hsq-system] [table=gen_table_column] [chunkIdx=0]
[2023/04/20 17:52:37.104 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=hsq-system] [table=sys_oss] []
[2023/04/20 17:52:37.104 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=hsq-system] [table=sys_oss]
[2023/04/20 17:52:37.107 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=hsq-system] [table=sys_oss] [chunkIdx=0]
[2023/04/20 17:52:37.215 +08:00] [INFO] [dump.go:741] [“get estimated rows count”] [database=hsq-system] [table=undo_log] [estimateCount=10000]
[2023/04/20 17:52:37.215 +08:00] [INFO] [dump.go:747] [“fallback to sequential dump due to estimate count < rows. This won’t influence the whole dump process”] [“estimate count”=10000] [conf.rows=200000] [database=hsq-system] [table=undo_log]
[2023/04/20 17:52:37.215 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=hsq-system] [table=undo_log]
[2023/04/20 17:52:37.218 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=hsq-system] [table=undo_log] [chunkIdx=0]
[2023/04/20 17:52:37.277 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=ins-collect] [table=gen_table] []
[2023/04/20 17:52:37.277 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=ins-collect] [table=gen_table]
[2023/04/20 17:52:37.281 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=ins-collect] [table=gen_table] [chunkIdx=0]
[2023/04/20 17:52:37.287 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=ins-collect] [table=gen_table_column] []
[2023/04/20 17:52:37.287 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=ins-collect] [table=gen_table_column]
[2023/04/20 17:52:37.290 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=ins-collect] [table=gen_table_column] [chunkIdx=0]
[2023/04/20 17:52:37.298 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=ins-collect] [table=ins_blog_info] []
[2023/04/20 17:52:37.298 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=ins-collect] [table=ins_blog_info]
[2023/04/20 17:52:37.306 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=ins-collect] [table=ins_blog_info] [chunkIdx=0]
[2023/04/20 17:52:37.333 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=ins-collect] [table=ins_fans_info] []
[2023/04/20 17:52:37.333 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=ins-collect] [table=ins_fans_info]
[2023/04/20 17:52:37.338 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=ins-collect] [table=ins_fans_info] [chunkIdx=0]
[2023/04/20 17:52:37.359 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=ins-collect] [table=ins_media_info] []
[2023/04/20 17:52:37.359 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=ins-collect] [table=ins_media_info]
[2023/04/20 17:52:37.362 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=ins-collect] [table=ins_media_info] [chunkIdx=0]
[2023/04/20 17:52:37.428 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=tiktok_data_audit] [table=super_operate_log] []
[2023/04/20 17:52:37.429 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=tiktok_data_audit] [table=super_operate_log]
[2023/04/20 17:52:37.431 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=tiktok_data_audit] [table=super_operate_log] [chunkIdx=0]
[2023/04/20 17:52:37.541 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=tiktok] [table=t_account_proxy_flow_record] []
[2023/04/20 17:52:37.541 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=tiktok] [table=t_account_proxy_flow_record]
[2023/04/20 17:52:37.544 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=tiktok] [table=t_account_proxy_flow_record] [chunkIdx=0]
[2023/04/20 17:52:37.604 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=tiktok] [table=t_apps] []
[2023/04/20 17:52:37.604 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=tiktok] [table=t_apps]
[2023/04/20 17:52:37.608 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=tiktok] [table=t_apps] [chunkIdx=0]
[2023/04/20 17:52:37.629 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=tiktok] [table=t_comment_task_detail] []
[2023/04/20 17:52:37.629 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=tiktok] [table=t_comment_task_detail]
[2023/04/20 17:52:37.631 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=tiktok] [table=t_comment_task_detail] [chunkIdx=0]
[2023/04/20 17:52:37.665 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=tiktok] [table=t_device] []
[2023/04/20 17:52:37.665 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=tiktok] [table=t_device]
[2023/04/20 17:52:37.667 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=tiktok] [table=t_device] [chunkIdx=0]
[2023/04/20 17:52:37.674 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=tiktok] [table=t_handle_queue] []
[2023/04/20 17:52:37.674 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=tiktok] [table=t_handle_queue]
[2023/04/20 17:52:37.681 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=tiktok] [table=t_handle_queue] [chunkIdx=0]
[2023/04/20 17:52:37.691 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=tiktok] [table=t_label] []
[2023/04/20 17:52:37.691 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=tiktok] [table=t_label]
[2023/04/20 17:52:37.693 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=tiktok] [table=t_label] [chunkIdx=0]
[2023/04/20 17:52:37.935 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=tiktok] [table=t_problem] []
[2023/04/20 17:52:37.935 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=tiktok] [table=t_problem]
[2023/04/20 17:52:37.938 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=tiktok] [table=t_problem] [chunkIdx=0]
[2023/04/20 17:52:38.000 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=tiktok] [table=t_proxy_group] []
[2023/04/20 17:52:38.000 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=tiktok] [table=t_proxy_group]
[2023/04/20 17:52:38.002 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=tiktok] [table=t_proxy_group] [chunkIdx=0]
[2023/04/20 17:52:38.022 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=tiktok] [table=t_reply] []
[2023/04/20 17:52:38.022 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=tiktok] [table=t_reply]
[2023/04/20 17:52:38.048 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=tiktok] [table=t_reply] [chunkIdx=0]
[2023/04/20 17:52:38.119 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=tiktok] [table=t_search_video_detail] []
[2023/04/20 17:52:38.119 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=tiktok] [table=t_search_video_detail]
[2023/04/20 17:52:38.122 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=tiktok] [table=t_search_video_detail] [chunkIdx=0]
[2023/04/20 17:52:38.417 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=tiktok] [table=t_task_result] []
[2023/04/20 17:52:38.417 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=tiktok] [table=t_task_result]
[2023/04/20 17:52:38.420 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=tiktok] [table=t_task_result] [chunkIdx=0]
[2023/04/20 17:52:38.441 +08:00] [INFO] [dump.go:735] [“fallback to sequential dump due to no proper field. This won’t influence the whole dump process”] [database=tiktok] [table=t_task_target_pool] []
[2023/04/20 17:52:38.441 +08:00] [INFO] [dump.go:698] [“didn’t build tidb concat sqls, will select all from table now”] [database=tiktok] [table=t_task_target_pool]
[2023/04/20 17:52:38.451 +08:00] [INFO] [writer.go:265] [“no data written in table chunk”] [database=tiktok] [table=t_task_target_pool] [chunkIdx=0]
[2023/04/20 17:52:53.855 +08:00] [WARN] [writer_util.go:194] [“fail to dumping table(chunk), will revert some metrics and start a retry if possible”] [database=tiktok] [table=t_user] [“finished rows”=23774] [“finished size”=240175226] [error=“Error 1105: other error for mpp stream: Receive cancel request from TiDB”]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=7]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=11]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=1]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=2]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=6]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=27]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=0]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=22]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=31]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=14]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=23]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=4]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=15]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=18]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=29]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=28]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=20]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=26]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=5]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=30]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=24]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=12]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=10]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=21]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=17]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=25]
[2023/04/20 17:52:53.856 +08:00] [INFO] [writer.go:85] [“context has been done, the writer will exit”] [“writer ID”=3]
[2023/04/20 17:52:53.856 +08:00] [INFO] [conn.go:44] [“cannot execute query”] [retryTime=1] [sql=“SHOW CREATE TABLE tiktok.t_user_info”] [args=null] [error=“sql: SHOW CREATE TABLE tiktok.t_user_info, args: []: context canceled”] [errorVerbose=“context canceled\nsql: SHOW CREATE TABLE tiktok.t_user_info, args: []\ngithub.com/pingcap/tidb/dumpling/export.simpleQueryWithArgs\n\tgithub.com/pingcap/tidb/dumpling/export/sql.go:1147\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\n\tgithub.com/pingcap/tidb/br/pkg/utils/retry.go:52\ngithub.com/pingcap/tidb/dumpling/export.(*BaseConn).QuerySQL\n\tgithub.com/pingcap/tidb/dumpling/export/conn.go:34\ngithub.com/pingcap/tidb/dumpling/export.ShowCreateTable\n\tgithub.com/pingcap/tidb/dumpling/export/sql.go:93\ngithub.com/pingcap/tidb/dumpling/export.dumpTableMeta\n\tgithub.com/pingcap/tidb/dumpling/export/dump.go:1230\ngithub.com/pingcap/tidb/dumpling/export.(*Dumper).dumpDatabases\n\tgithub.com/pingcap/tidb/dumpling/export/dump.go:423\ngithub.com/pingcap/tidb/dumpling/export.(*Dumper).Dump\n\tgithub.com/pingcap/tidb/dumpling/export/dump.go:295\nmain.main\n\t./main.go:74\nruntime.main\n\truntime/proc.go:250\nruntime.goexit\n\truntime/asm_amd64.s:1594”]
[2023/04/20 17:52:53.856 +08:00] [WARN] [writer_util.go:194] [“fail to dumping table(chunk), will revert some metrics and start a retry if possible”] [database=tiktok] [table=t_third_party_log] [“finished rows”=8726] [“finished size”=106292489] [error=“context canceled”]
[2023/04/20 17:52:53.857 +08:00] [WARN] [writer_util.go:194] [“fail to dumping table(chunk), will revert some metrics and start a retry if possible”] [database=tiktok] [table=t_user_depot] [“finished rows”=4617] [“finished size”=23860080] [error=“context canceled”]
[2023/04/20 17:52:53.857 +08:00] [WARN] [writer_util.go:194] [“fail to dumping table(chunk), will revert some metrics and start a retry if possible”] [database=tiktok] [table=t_user_depot_preserve] [“finished rows”=1021] [“finished size”=4937330] [error=“context canceled”]
[2023/04/20 17:52:53.857 +08:00] [INFO] [global.go:34] [“units canceled”] [cancel-unit=0]
[2023/04/20 17:52:53.857 +08:00] [INFO] [collector.go:205] [“backup failed summary”] [total-ranges=1] [ranges-succeed=0] [ranges-failed=1] [unit-name=“dump table data”] [error=“Error 1105: other error for mpp stream: Receive cancel request from TiDB”] [errorVerbose=“Error 1105: other error for mpp stream: Receive cancel request from TiDB\ngithub.com/pingcap/errors.AddStack\n\tgithub.com/pingcap/errors@v0.11.5-0.20220729040631-518f63d66278/errors.go:174\ngithub.com/pingcap/errors.Trace\n\tgithub.com/pingcap/errors@v0.11.5-0.20220729040631-518f63d66278/juju_adaptor.go:15\ngithub.com/pingcap/tidb/dumpling/export.(*multiQueriesChunkIter).nextRows.func1\n\tgithub.com/pingcap/tidb/dumpling/export/ir_impl.go:86\ngithub.com/pingcap/tidb/dumpling/export.(*multiQueriesChunkIter).nextRows\n\tgithub.com/pingcap/tidb/dumpling/export/ir_impl.go:104\ngithub.com/pingcap/tidb/dumpling/export.(*multiQueriesChunkIter).Next\n\tgithub.com/pingcap/tidb/dumpling/export/ir_impl.go:152\ngithub.com/pingcap/tidb/dumpling/export.WriteInsert\n\tgithub.com/pingcap/tidb/dumpling/export/writer_util.go:247\ngithub.com/pingcap/tidb/dumpling/export.FileFormat.WriteInsert\n\tgithub.com/pingcap/tidb/dumpling/export/writer_util.go:656\ngithub.com/pingcap/tidb/dumpling/export.(*Writer).tryToWriteTableData\n\tgithub.com/pingcap/tidb/dumpling/export/writer.go:239\ngithub.com/pingcap/tidb/dumpling/export.(*Writer).WriteTableData.func1\n\tgithub.com/pingcap/tidb/dumpling/export/writer.go:224\ngithub.com/pingcap/tidb/br/pkg/utils.WithRetry\n\tgithub.com/pingcap/tidb/br/pkg/utils/retry.go:52\ngithub.com/pingcap/tidb/dumpling/export.(*Writer).WriteTableData\n\tgithub.com/pingcap/tidb/dumpling/export/writer.go:192\ngithub.com/pingcap/tidb/dumpling/export.(*Writer).handleTask\n\tgithub.com/pingcap/tidb/dumpling/export/writer.go:115\ngithub.com/pingcap/tidb/dumpling/export.(*Writer).run\n\tgithub.com/pingcap/tidb/dumpling/export/writer.go:93\ngithub.com/pingcap/tidb/dumpling/export.(*Dumper).startWriters.func4\n\tgithub.com/pingcap/tidb/dumpling/export/dump.go:356\ngolang.org/x/sync/errgroup.(*Group).Go.func1\n\tgolang.org/x/sync@v0.0.0-20220722155255-886fb9371eb4/errgroup/errgroup.go:75\nruntime.goexit\n\truntime/asm_amd64.s:1594”]
[2023/04/20 17:52:53.858 +08:00] [INFO] [global.go:34] [“[pd] stop fetching the pending tso requests due to context canceled”] [dc-location=global]
[2023/04/20 17:52:53.858 +08:00] [INFO] [global.go:34] [“[pd] exit tso dispatcher”] [dc-location=global]
[2023/04/20 17:52:53.858 +08:00] [ERROR] [main.go:77] [“dump failed error stack info”] [error=“Error 1105: other error for mpp stream: Receive cancel request from TiDB”] [errorVerbose=“Error 1105: other error for mpp stream: Receive cancel request from TiDB\ngithub.com/pingcap/errors.AddStack\n\tgithub.com/pingcap/errors@v0.11.5-0.20220729040631-518f63d66278/errors.go:174\ngithub.com/pingcap/errors.Trace\n\tgithub.com/pingcap/errors@v0.11.5-0.20220729040631-518f63d66278/juju_adaptor.go:15\ngithub.com/pingcap/tidb/dumpling/export.(*multiQueriesChunkIter).nextRows.func1\n\tgithub.com/pingcap/tidb/dumpling/export/ir_impl.go:86\ngithub.com/pingcap/tidb/dumpling/export.(*multiQueriesChunkIter).nextRows\n\tgithub.com/pingcap/tidb/dumpling/export/ir_impl.go:104\ngithub.com/pingcap/tidb/dumpling/export.(*multiQueriesChunkIter).Next\n\tgithub.com/pingcap/tidb/dumpling/export/ir_impl.go:152\ngithub.com/pingcap/tidb/dumpling/export.WriteInsert\n\tgithub.com/pingcap/tidb/dumpling/export/writer_util.go:247\ngithub.com/pingcap/tidb/dumpling/export.FileFormat.WriteInsert\n\tgithub.com/pingcap/tidb/dumpling/export/writer_util.go:656\ngithub.com/pingcap/tidb/dumpling/export.(*Writer).tryToWriteTableData\n\tgithub.com/pingcap/tidb/dumpling/export/writer.go:239\ngithub.com/pingcap/tidb/dumpling/export.(*Writer).WriteTableData.func1\n\tgithub.com/pingcap/tidb/dumpling/export/writer.go:224\ngithub.com/pingcap/tidb/br/pkg/utils.WithRetry\n\tgithub.com/pingcap/tidb/br/pkg/utils/retry.go:52\ngithub.com/pingcap/tidb/dumpling/export.(*Writer).WriteTableData\n\tgithub.com/pingcap/tidb/dumpling/export/writer.go:192\ngithub.com/pingcap/tidb/dumpling/export.(*Writer).handleTask\n\tgithub.com/pingcap/tidb/dumpling/export/writer.go:115\ngithub.com/pingcap/tidb/dumpling/export.(*Writer).run\n\tgithub.com/pingcap/tidb/dumpling/export/writer.go:93\ngithub.com/pingcap/tidb/dumpling/export.(*Dumper).startWriters.func4\n\tgithub.com/pingcap/tidb/dumpling/export/dump.go:356\ngolang.org/x/sync/errgroup.(*Group).Go.func1\n\tgolang.org/x/sync@v0.0.0-20220722155255-886fb9371eb4/errgroup/errgroup.go:75\nruntime.goexit\n\truntime/asm_amd64.s:1594”]

dump failed: Error 1105: other error for mpp stream: Receive cancel request from TiDB

根据你提供的信息,报错信息为 “fallback to sequential dump due to no proper field. This won’t influence the whole dump process”,意思是由于没有合适的字段,导致备份过程中需要回退到顺序备份模式。这个报错不会影响整个备份过程,只是会导致备份速度变慢。

建议你检查一下备份的表是否存在,以及是否有足够的权限进行备份。此外,你也可以尝试使用其他备份工具,比如 TiDB Lightning,来进行备份。TiDB Lightning 是 TiDB 官方提供的一款高速数据导入工具,支持从 MySQL、TiDB、MariaDB 等数据库导入数据到 TiDB 中。

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