Dumpling reports an error when exporting tables with TiFlash replicas

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: dumpling在导出含有tiflash副本的表时候会报错

| username: dba-kit

The error message is as follows:

dump failed: sql:  ******* : Error 1105: other error for mpp stream: From MPP<query:441036080350232595,task:2>: DB::TiFlashException: Failed to register MPP Task MPP<query:441036080350232595,task:2>, reason: task has been registered

For now, you can add the parameter --params "tidb_isolation_read_engines=tikv" to force it to back up data from TiKV, which will allow the export to succeed.

| username: lilinghai | Original post link

Please provide the complete command for dumpling, and you can also post the full error log from TiDB when an error occurs.

| username: dba-kit | Original post link

Here is the detailed error stack. The command is very simple, it’s a full backup of a table with TiFlash replicas. You can try it in a test environment to see if there are any errors.

github.com/pingcap/tidb/dumpling/export.(*tableData).Start
	github.com/pingcap/tidb/dumpling/export/ir_impl.go:207
github.com/pingcap/tidb/dumpling/export.(*Writer).WriteTableData.func1
	github.com/pingcap/tidb/dumpling/export/writer.go:210
github.com/pingcap/tidb/br/pkg/utils.WithRetry
	github.com/pingcap/tidb/br/pkg/utils/retry.go:52
github.com/pingcap/tidb/dumpling/export.(*Writer).WriteTableData
	github.com/pingcap/tidb/dumpling/export/writer.go:192
github.com/pingcap/tidb/dumpling/export.(*Writer).handleTask
	github.com/pingcap/tidb/dumpling/export/writer.go:115
github.com/pingcap/tidb/dumpling/export.(*Writer).run
	github.com/pingcap/tidb/dumpling/export/writer.go:93
github.com/pingcap/tidb/dumpling/export.(*Dumper).startWriters.func4
	github.com/pingcap/tidb/dumpling/export/dump.go:356
golang.org/x/sync/errgroup.(*Group).Go.func1
	golang.org/x/sync@v0.1.0/errgroup/errgroup.go:75
runtime.goexit
	runtime/asm_amd64.s:1594
| username: lilinghai | Original post link

First, let’s record an issue for follow-up. Currently, it seems that queries executed directly on TiDB do not have any problems, but there are issues when using Dumpling. It is possible that Dumpling has some special settings. Dumpling failed with Failed to register MPP Task · Issue #43426 · pingcap/tidb · GitHub

| username: dba-kit | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.