An error related to TiFlash occurs when using the dumpling command to import a specified table, causing the backup export to be interrupted

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

Original topic: 使用dumpling命令导入指定的表时,报一个tiflash的错误,导致备份导出中断

| username: vcdog

[TiDB Usage Environment] Production Environment
[TiDB Version] v6.5.0
[Reproduction Path] Operations performed that led to the issue
[Encountered Issue: Issue Phenomenon and Impact]

  1. When using the dumpling command to export a specified table, a tiflash error occurs, causing the backup export to be interrupted. The error is as follows:
**dump failed: sql: SELECT * FROM `my_db`.`es_order_details` LIMIT 1, args: []: Error 1105: DB::TiFlashException: Failed to register MPP Task MPP<query:440416279155703816,task:11>, reason: query is being aborted, error message = Receive cancel request from TiDB**
**[2023/03/29 09:52:57.810 +08:00] [INFO] [writer.go:85] ["context has been done, the writer will exit"] ["writer ID"=1]**
**[2023/03/29 09:52:57.810 +08:00] [INFO] [writer.go:85] ["context has been done, the writer will exit"] ["writer ID"=4]**
**[2023/03/29 09:52:57.810 +08:00] [INFO] [writer.go:85] ["context has been done, the writer will exit"] ["writer ID"=7]**
**[2023/03/29 09:52:57.810 +08:00] [INFO] [writer.go:85] ["context has been done, the writer will exit"] ["writer ID"=14]**

[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]

| username: tidb菜鸟一只 | Original post link

Export it? Maybe there’s an issue with the TiFlash data of your table. Try setting the TiFlash replica to 0.

| username: vcdog | Original post link

Yes, there was a typo. The error occurred when exporting data. I tried setting the number of replicas for this table in TiFlash to 0, but there was no response. When I reconnected and queried, the number of replicas was still 2. I thought of another way and successfully executed the dumpling export on the replica cluster.

| username: WalterWj | Original post link

Dumpling backup can specify session-level variables and back up directly from TiKV.