Tiflash Query: DB::Exception: cannot load checksum framed data

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

Original topic: Tiflash 查询时:DB::Exception: cannot load checksum framed data

| username: TiDBer_WE2MGZ35

When querying with Tiflash, the following error is reported:

Error 1105 (HY000): other error for mpp stream: DB::Exception: Exchange receiver meet error: DB::Exception: cannot load checksum framed data from /tidb-tiflash/data/data/t_106/stable/dmf_1590/%2D1.dat (errno = 22): (while reading from DTFile: /tidb-tiflash/data/data/t_106/stable/dmf_1590)

Error 1105 (HY000): other error for mpp stream: DB::Exception: Exchange receiver meet error: DB::Exception: Exchange receiver meet error: DB::Exception: Exchange receiver meet error: DB::Exception: checksum framed file /tidb-tiflash/data/data/t_106/stable/dmf_323/%2D1.dat is not seekable: (while reading from DTFile: /tidb-tiflash/data/data/t_106/stable/dmf_323)

The error occurs on the first query, but it does not reappear on subsequent queries.
I am not sure what is causing this?

| username: 大飞哥online | Original post link

It looks like an error occurred when TiFlash was reading the data file.
No more errors reported, just keep an eye on it.

| username: Kongdom | Original post link

Refer to similar ones and take a look

| username: Fly-bird | Original post link

Didn’t use TiFlash, let’s take a look at the solution.

| username: ti-tiger | Original post link

  • Tiflash uses the dynamic Region feature during queries, which can improve data synchronization efficiency but may also lead to issues such as being unable to load checksum data or files being unaddressable. These problems are usually caused by network latency or data inconsistency between Tiflash and TiKV.
  • Tiflash uses MPP mode during queries, which can enhance query performance but may also result in errors such as being unable to register MPP tasks or serialization response failures. These errors are typically due to communication issues between Tiflash and TiDB or unreasonable query plans.

To resolve these errors, you can try the following methods:

  • Check if your Tiflash version is the latest. If not, you can upgrade to the latest version as some known issues might have been fixed in the new version.
  • Check if your network conditions are normal. If there is network latency or packet loss, you can try optimizing your network configuration or adjusting your TiDB parameters.
  • Check if your query statements are reasonable. If there are unrelated subqueries or complex join operations, you can try simplifying your query statements or using hints to specify the query mode.