Bug 反馈
清晰准确地描述您发现的问题，提供任何可能复现问题的步骤有助于研发同学及时处理问题
【 Bug 的影响】
全表备份 导出异常中断 。
【可能的问题复现步骤】
./dumpling -h 127.0.0.1 -P 4000 -u backup -p wPjNXy9z8lrApDVb -B yixintui_operate --tables-list “yixintui_operate.Agent_material_report_cost” --filetype sql --threads 1 -o ${Bak_dir}/${Ip}/${Port}/${Time} -F 1024MiB --compress gz --params “tidb_distsql_scan_concurrency=1,tidb_mem_quota_query=8589934592” --where=" report_date >=’${lastMonth1}’" >> $Bak_log 2
【看到的非预期行为】
[2022/08/08 02:46:39.794 +08:00] [WARN] [writer_util.go:181] [“fail to dumping table(chunk), will revert some metrics and start a retry if possible”] [database=yixintui_operate] [table=Agent_material_report_cost] [“finished rows”=2024142] [“finished size”=757458552] [error=“Error 9005: Region is unavailable”]
[2022/08/08 02:46:39.796 +08:00] [INFO] [collector.go:203] [“backup failed summary”] [total-ranges=1] [ranges-succeed=0] [ranges-failed=1] [unit-name=“dump table data”] [error=“Error 9005: Region is unavailable”] [errorVerbose=“Error 9005: Region is unavailable\ngithub.com/pingcap/errors.AddStack\
\tgithub.com/pingcap/errors@v0.11.5-0.20211224045212-9687c2b0f87c/errors.go:174\
github.com/pingcap/errors.Trace\
\tgithub.com/pingcap/errors@v0.11.5-0.20211224045212-9687c2b0f87c/juju_adaptor.go:15\
github.com/pingcap/tidb/dumpling/export.(*multiQueriesChunkIter).nextRows.func1\
\tgithub.com/pingcap/tidb/dumpling/export/ir_impl.go:87\
github.com/pingcap/tidb/dumpling/export.(*multiQueriesChunkIter).nextRows\
\tgithub.com/pingcap/tidb/dumpling/export/ir_impl.go:107\
github.com/pingcap/tidb/dumpling/export.(*multiQueriesChunkIter).Next\
\tgithub.com/pingcap/tidb/dumpling/export/ir_impl.go:155\
github.com/pingcap/tidb/dumpling/export.WriteInsert\
\tgithub.com/pingcap/tidb/dumpling/export/writer_util.go:233\
github.com/pingcap/tidb/dumpling/export.FileFormat.WriteInsert\
\tgithub.com/pingcap/tidb/dumpling/export/writer_util.go:625\
github.com/pingcap/tidb/dumpling/export.(*Writer).tryToWriteTableData\
\tgithub.com/pingcap/tidb/dumpling/export/writer.go:216\
github.com/pingcap/tidb/dumpling/export.(*Writer).WriteTableData.func1\
\tgithub.com/pingcap/tidb/dumpling/export/writer.go:201\
github.com/pingcap/tidb/br/pkg/utils.WithRetry\
\tgithub.com/pingcap/tidb/br/pkg/utils/retry.go:60\
github.com/pingcap/tidb/dumpling/export.(*Writer).WriteTableData\
\tgithub.com/pingcap/tidb/dumpling/export/writer.go:172\
github.com/pingcap/tidb/dumpling/export.(*Writer).handleTask\
\tgithub.com/pingcap/tidb/dumpling/export/writer.go:105\
github.com/pingcap/tidb/dumpling/export.(*Writer).run\
\tgithub.com/pingcap/tidb/dumpling/export/writer.go:85\
github.com/pingcap/tidb/dumpling/export.(*Dumper).startWriters.func4\
\tgithub.com/pingcap/tidb/dumpling/export/dump.go:302\
golang.org/x/sync/errgroup.(*Group).Go.func1\
\tgolang.org/x/sync@v0.0.0-20210220032951-036812b2e83c/errgroup/errgroup.go:57\
runtime.goexit\
\truntime/asm_amd64.s:1371”]
[2022/08/08 02:46:39.796 +08:00] [ERROR] [client.go:752] ["[pd] fetch pending tso requests error"] [dc-location=global] [error="[PD:client:ErrClientGetTSO]context canceled: context canceled"]
[2022/08/08 02:46:39.797 +08:00] [ERROR] [main.go:76] [“dump failed error stack info”] [error=“Error 9005: Region is unavailable”] [errorVerbose=“Error 9005: Region is unavailable\ngithub.com/pingcap/errors.AddStack\
\tgithub.com/pingcap/errors@v0.11.5-0.20211224045212-9687c2b0f87c/errors.go:174\
github.com/pingcap/errors.Trace\
\tgithub.com/pingcap/errors@v0.11.5-0.20211224045212-9687c2b0f87c/juju_adaptor.go:15\
github.com/pingcap/tidb/dumpling/export.(*multiQueriesChunkIter).nextRows.func1\
\tgithub.com/pingcap/tidb/dumpling/export/ir_impl.go:87\
github.com/pingcap/tidb/dumpling/export.(*multiQueriesChunkIter).nextRows\
\tgithub.com/pingcap/tidb/dumpling/export/ir_impl.go:107\
github.com/pingcap/tidb/dumpling/export.(*multiQueriesChunkIter).Next\
\tgithub.com/pingcap/tidb/dumpling/export/ir_impl.go:155\
github.com/pingcap/tidb/dumpling/export.WriteInsert\
\tgithub.com/pingcap/tidb/dumpling/export/writer_util.go:233\
github.com/pingcap/tidb/dumpling/export.FileFormat.WriteInsert\
\tgithub.com/pingcap/tidb/dumpling/export/writer_util.go:625\
github.com/pingcap/tidb/dumpling/export.(*Writer).tryToWriteTableData\
\tgithub.com/pingcap/tidb/dumpling/export/writer.go:216\
github.com/pingcap/tidb/dumpling/export.(*Writer).WriteTableData.func1\
\tgithub.com/pingcap/tidb/dumpling/export/writer.go:201\
github.com/pingcap/tidb/br/pkg/utils.WithRetry\
\tgithub.com/pingcap/tidb/br/pkg/utils/retry.go:60\
github.com/pingcap/tidb/dumpling/export.(*Writer).WriteTableData\
\tgithub.com/pingcap/tidb/dumpling/export/writer.go:172\
github.com/pingcap/tidb/dumpling/export.(*Writer).handleTask\
\tgithub.com/pingcap/tidb/dumpling/export/writer.go:105\
github.com/pingcap/tidb/dumpling/export.(*Writer).run\
\tgithub.com/pingcap/tidb/dumpling/export/writer.go:85\
github.com/pingcap/tidb/dumpling/export.(*Dumper).startWriters.func4\
\tgithub.com/pingcap/tidb/dumpling/export/dump.go:302\
golang.org/x/sync/errgroup.(*Group).Go.func1\
\tgolang.org/x/sync@v0.0.0-20210220032951-036812b2e83c/errgroup/errgroup.go:57\
runtime.goexit\
\truntime/asm_amd64.s:1371”]
dump failed: Error 9005: Region is unavailable
【相关组件及具体版本】
统一 5.4.2 版本
