Error Executing SQL with TiFlash and TiDB Engines Enabled

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

Original topic: 启用tiflash、tidb引擎,执行sql报错

| username: wenyi

Globally enabling TiFlash and TiDB storage engines results in the following error when executing SQL:
ERROR 1105 (HY000): other error for mpp stream: From MPPquery:441050903959044097:4,task: Code: 0, e.displayText() = DB::Exception: write to tunnel which is already closed, Receiver cancelled, reason: Push mpp packet failed. Receiver state: CLOSED, e.what() = DB::Exception,

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

Does the corresponding table have a TiFlash replica? What is the status of the TiFlash node?

| username: wenyi | Original post link

Yes, and the status is normal. The first query is very fast and returns results normally. When querying the second time, this error is reported.

| username: wenyi | Original post link

The issue was said to be resolved in the minor version 5.4, why does it still exist in version 6.5.1?

| username: tidb狂热爱好者 | Original post link

I don’t use TiFlash…