TiFlash Query Error: Checksum Mismatch

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

Original topic: tiflash查询报错checksum mismatch

| username: 人如其名

[TiDB Usage Environment] Testing
[TiDB Version] v7.0.0

When querying with TiFlash, an error occurs: checksum mismatch.

mysql> explain analyze select count(O_CUSTKEY) from orders;
ERROR 1105 (HY000): checksum mismatch for /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_941/2.dat: (while reading from DTFile: /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_941)
mysql> explain analyze select count(O_CUSTKEY) from orders;
ERROR 1105 (HY000): checksum mismatch for /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_941/2.dat: (while reading from DTFile: /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_941)
mysql> explain select count(O_CUSTKEY) from orders;
+----------------------------+--------------+-------------------+---------------+--------------------------------------------------+
| id                         | estRows      | task              | access object | operator info                                    |
+----------------------------+--------------+-------------------+---------------+--------------------------------------------------+
| StreamAgg_26               | 1.00         | root              |               | funcs:count(Column#13)->Column#10                |
| └─TableReader_27           | 1.00         | root              |               | data:StreamAgg_10                                |
|   └─StreamAgg_10           | 1.00         | batchCop[tiflash] |               | funcs:count(tpch100.orders.o_custkey)->Column#13 |
|     └─TableFullScan_25     | 150000000.00 | batchCop[tiflash] | table:orders  | keep order:false                                 |
+----------------------------+--------------+-------------------+---------------+--------------------------------------------------+
4 rows in set (0.00 sec)
mysql> explain analyze select O_CUSTKEY from orders limit 100000000000000000;
ERROR 1105 (HY000): other error for mpp stream: From MPP<query:<query_ts:1684510835540982449, local_query_id:19, server_id:3457791, start_ts:441584408460525569>,task_id:1>: Code: 0, e.displayText() = DB::Exception: checksum mismatch for /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_941/2.dat: (while reading from DTFile: /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_941), e.what() = DB::Exception,
mysql> explain  select O_CUSTKEY from orders limit 100000000000000000;
+------------------------------+--------------+--------------+---------------+---------------------------------------+
| id                           | estRows      | task         | access object | operator info                         |
+------------------------------+--------------+--------------+---------------+---------------------------------------+
| Limit_9                      | 150000000.00 | root         |               | offset:0, count:100000000000000000    |
| └─TableReader_17             | 150000000.00 | root         |               | MppVersion: 1, data:ExchangeSender_16 |
|   └─ExchangeSender_16        | 150000000.00 | mpp[tiflash] |               | ExchangeType: PassThrough             |
|     └─Limit_15               | 150000000.00 | mpp[tiflash] |               | offset:0, count:100000000000000000    |
|       └─TableFullScan_14     | 150000000.00 | mpp[tiflash] | table:orders  | keep order:false                      |
+------------------------------+--------------+--------------+---------------+---------------------------------------+
5 rows in set (0.00 sec)

tidb log:

[2023/05/19 23:31:35.336 +08:00] [WARN] [collate.go:221] ["The collation utf8mb4_0900_ai_ci specified on connection is not supported when new collation is enabled, switch to the default collation: utf8mb4_bin"]
[2023/05/19 23:31:44.632 +08:00] [INFO] [conn.go:1151] ["command dispatched failed"] [conn=7603762821838406039] [connInfo="id:7603762821838406039, addr:192.168.31.200:59306 status:10, collation:utf8mb4_0900_ai_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="explain analyze select count(O_CUSTKEY) from orders"] [txn_mode=PESSIMISTIC] [timestamp=441584268672237569] [err="[tikv:0]checksum mismatch for /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_941/2.dat: (while reading from DTFile: /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_941)"]
[2023/05/19 23:32:09.115 +08:00] [INFO] [batch_coprocessor.go:1187] ["stream unknown error"] [error="rpc error: code = Canceled desc = context canceled"]
[2023/05/19 23:32:09.115 +08:00] [INFO] [conn.go:1151] ["command dispatched failed"] [conn=7603762821838406039] [connInfo="id:7603762821838406039, addr:192.168.31.200:59306 status:10, collation:utf8mb4_0900_ai_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="explain analyze select count(O_CUSTKEY) from orders"] [txn_mode=PESSIMISTIC] [timestamp=441584275081658369] [err="[tikv:0]checksum mismatch for /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_941/2.dat: (while reading from DTFile: /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_941)"]

tiflash_error.log:

[2023/05/19 23:31:45.089 +08:00] [WARN] [PathCapacityMetrics.cpp:203] ["Available space is only 7.61% of capacity size. Avail size: 33.68 GiB, used size: 53.84 GiB, capacity size: 442.81 GiB"] [thread_id=40]
[2023/05/19 23:31:55.091 +08:00] [WARN] [PathCapacityMetrics.cpp:203] ["Available space is only 7.61% of capacity size. Avail size: 33.68 GiB, used size: 53.84 GiB, capacity size: 442.81 GiB"] [thread_id=40]
[2023/05/19 23:32:05.092 +08:00] [WARN] [PathCapacityMetrics.cpp:203] ["Available space is only 7.61% of capacity size. Avail size: 33.68 GiB, used size: 53.84 GiB, capacity size: 442.81 GiB"] [thread_id=40]
[2023/05/19 23:32:09.047 +08:00] [ERROR] [SegmentReader.cpp:123] ["ErrMsg: checksum mismatch for /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_941/2.dat: (while reading from DTFile: /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_941) StackTrace \n       0x1b529d1\tDB::TiFlashException::TiFlashException(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, DB::TiFlashError const&) [tiflash+28649937]\n                \tdbms/src/Common/TiFlashException.h:250\n       0x1a1d2b0\tDB::FramedChecksumReadBuffer<DB::Digest::XXH3>::checkBody() [tiflash+27382448]\n                \tdbms/src/IO/ChecksumBuffer.h:369\n       0x1a1d37a\tDB::FramedChecksumReadBuffer<DB::Digest::XXH3>::nextImpl() [tiflash+27382650]\n                \tdbms/src/IO/ChecksumBuffer.h:397\n       0x1bbb127\tDB::ReadBuffer::readStrict(char*, unsigned long) [tiflash+29077799]\n                \tdbms/src/IO/ReadBuffer.h:160\n       0x1a20e4d\tDB::CompressedReadBufferBase<false>::readCompressedData(unsigned long&, unsigned long&) [tiflash+27397709]\n                \tdbms/src/IO/CompressedReadBufferBase.cpp:90\n       0x1aa00d1\tDB::CompressedReadBufferFromFileProvider<false>::readBig(char*, unsigned long) [tiflash+27918545]\n                \tdbms/src/Encryption/CompressedReadBufferFromFileProvider.cpp:128\n       0x1a9de3a\tDB::DataTypeNumberBase<long>::deserializeBinaryBulk(DB::IColumn&, DB::ReadBuffer&, unsigned long, double) const [tiflash+27909690]\n                \tdbms/src/DataTypes/DataTypeNumberBase.cpp:246\n       0x73b99d7\tDB::DM::DMFileReader::readColumn(DB::DM::ColumnDefine&, COWPtr<DB::IColumn>::immutable_ptr<DB::IColumn>&, unsigned long, unsigned long, unsigned long, unsigned long) [tiflash+121346519]\n                \tdbms/src/Storages/DeltaMerge/File/DMFileReader.cpp:698\n       0x73b7343\tDB::DM::DMFileReader::read() [tiflash+121336643]\n                \tdbms/src/Storages/DeltaMerge/File/DMFileReader.cpp:615\n       0x73adf95\tDB::DM::DMFileBlockInputStream::read() [tiflash+121298837]\n                \tdbms/src/Storages/DeltaMerge/File/DMFileBlockInputStream.h:64\n       0x731b84d\tDB::DM::ConcatSkippableBlockInputStream<false>::read() [tiflash+120698957]\n                \tdbms/src/Storages/DeltaMerge/SkippableBlockInputStream.h:175\n       0x7341dd1\tDB::DM::readBlock(std::__1::shared_ptr<DB::DM::SkippableBlockInputStream>&, std::__1::shared_ptr<DB::DM::SkippableBlockInputStream>&) [tiflash+120856017]\n                \tdbms/src/Storages/DeltaMerge/ReadUtil.cpp:33\n       0x7371c5c\tDB::DM::BitmapFilterBlockInputStream::readImpl(DB::PODArray<unsigned char, 4096ul, Allocator<false>, 15ul, 16ul>*&, bool) [tiflash+121052252]\n                \tdbms/src/Storages/DeltaMerge/BitmapFilter/BitmapFilterBlockInputStream.cpp:40\n       0x7372254\tDB::DM::BitmapFilterBlockInputStream::readImpl() [tiflash+121053780]\n                \tdbms/src/Storages/DeltaMerge/BitmapFilter/BitmapFilterBlockInputStream.h:46\n       0x755fe15\tDB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator<false>, 15ul, 16ul>*&, bool) [tiflash+123076117]\n                \tdbms/src/DataStreams/IProfilingBlockInputStream.cpp:75\n       0x755fb05\tDB::IProfilingBlockInputStream::read() [tiflash+123075333]\n                \tdbms/src/DataStreams/IProfilingBlockInputStream.cpp:43\n       0x734dc44\tDB::DM::SegmentReadTaskPool::readOneBlock(std::__1::shared_ptr<DB::IBlockInputStream>&, std::__1::shared_ptr<DB::DM::Segment> const&) [tiflash+120904772]\n                \tdbms/src/Storages/DeltaMerge/SegmentReadTaskPool.cpp:244\n       0x744171a\tDB::DM::SegmentReader::run() [tiflash+121902874]\n                \tdbms/src/Storages/DeltaMerge/ReadThread/SegmentReader.cpp:153\n       0x7442d92\tvoid* std::__1::__thread_proxy<std::__1::tuple<std::__1::unique_ptr<std::__1::__thread_struct, std::__1::default_delete<std::__1::__thread_struct> >, void (DB::DM::SegmentReader::*)(), DB::DM::SegmentReader*> >(void*) [tiflash+121908626]\n                \t/usr/local/bin/../include/c++/v1/thread:291\n  0x7fb5a6feeea5\tstart_thread [libpthread.so.0+32421]\n  0x7fb5a68fd96d\t__clone [libc.so.6+1042797]"] [thread_id=5]
[2023/05/19 23:32:09.047 +08:00] [ERROR] [DAGDriver.cpp:207] ["DB Exception: checksum mismatch for /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_941/2.dat: (while reading from DTFile: /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_941)\n\n       0x1b529d1\tDB::TiFlashException::TiFlashException(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, DB::TiFlashError const&) [tiflash+28649937]\n                \tdbms/src/Common/TiFlashException.h:250\n       0x1a1d2b0\tDB::FramedChecksumReadBuffer<DB::Digest::XXH3>::checkBody() [tiflash+27382448]\n                \tdbms/src/IO/ChecksumBuffer.h:369\n       0x1a1d37a\tDB::FramedChecksumReadBuffer<DB::Digest::XXH3>::nextImpl() [tiflash+27382650]\n                \tdbms/src/IO/ChecksumBuffer.h:397\n       0x1bbb127\tDB::ReadBuffer::readStrict(char*, unsigned long) [tiflash+29077799]\n                \tdbms/src/IO/ReadBuffer.h:160\n       0x1a20e4d\tDB::CompressedReadBufferBase<false>::readCompressedData(unsigned long&, unsigned long&) [tiflash+27397709]\n                \tdbms/src/IO/CompressedReadBufferBase.cpp:90\n       0x1aa00d1\tDB::CompressedReadBufferFromFileProvider<false>::readBig(char*, unsigned long) [tiflash+27918545]\n                \tdbms/src/Encryption/CompressedReadBufferFromFileProvider.cpp:128\n       0x1a9de3a\tDB::DataTypeNumberBase<long>::deserializeBinaryBulk(DB::IColumn&, DB::ReadBuffer&, unsigned long, double) const [tiflash+27909690]\n                \tdbms/src/DataTypes/DataTypeNumberBase.cpp:246\n       0x73b99d7\tDB::DM::DMFileReader::readColumn(DB::DM::ColumnDefine&, COWPtr<DB::IColumn>::immutable_ptr<DB::IColumn>&, unsigned long, unsigned long, unsigned long, unsigned long) [tiflash+121346519]\n                \tdbms/src/Storages/DeltaMerge/File/DMFileReader.cpp:698\n       0x73b7343\tDB::DM::DMFileReader::read() [tiflash+121336643]\n                \tdbms/src/Storages/DeltaMerge/File/DMFileReader.cpp:615\n       0x73adf95\tDB::DM::DMFileBlockInputStream::read() [tiflash+121298837]\n                \tdbms/src/Storages/DeltaMerge/File/DMFileBlockInputStream.h:64\n       0x731b84d\tDB::DM::ConcatSkippableBlockInputStream<false>::read() [tiflash+120698957]\n                \tdbms/src/Storages/DeltaMerge/SkippableBlockInputStream.h:175\n       0x7341dd1\tDB::DM::readBlock(std::__1::shared_ptr<DB::DM::SkippableBlockInputStream>&, std::__1::shared_ptr<DB::DM::SkippableBlockInputStream>&) [tiflash+120856017]\n                \tdbms/src/Storages/DeltaMerge/ReadUtil.cpp:33\n       0x7371c5c\tDB::DM::BitmapFilterBlockInputStream::readImpl(DB::PODArray<unsigned char, 4096ul, Allocator<false>, 15ul, 16ul>*&, bool) [tiflash+121052252]\n                \tdbms/src/Storages/DeltaMerge/BitmapFilter/BitmapFilterBlockInputStream.cpp:40\n       0x7372254\tDB::DM::BitmapFilterBlockInputStream::readImpl() [tiflash+121053780]\n                \tdbms/src/Storages/DeltaMerge/BitmapFilter/BitmapFilterBlockInputStream.h:46\n       0x755fe15\tDB::IProfilingBlockInputStream::read(DB::PODArray<unsigned char, 4096ul, Allocator<false>, 15ul, 16ul>*&, bool) [tiflash+123076117]\n                \tdbms/src/DataStreams/IProfiling
| username: 人如其名 | Original post link

There are issues when doing count on some fields, while others are fine:

mysql> explain analyze select count(O_ORDERDATE) from orders;
+----------------------------+--------------+-----------+-------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------+-----------+------+
| id                         | estRows      | actRows   | task              | access object | execution info                                                                                                                                                                                                                                                                                                                 | operator info                                      | memory    | disk |
+----------------------------+--------------+-----------+-------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------+-----------+------+
| StreamAgg_26               | 1.00         | 1         | root              |               | time:2.75s, loops:2, RRU:0.000000, WRU:0.000000                                                                                                                                                                                                                                                                                | funcs:count(Column#13)->Column#10                  | 388 Bytes | N/A  |
| └─TableReader_27           | 1.00         | 1         | root              |               | time:2.75s, loops:2, cop_task: {num: 2, max: 0s, min: 0s, avg: 0s, p95: 0s, copr_cache: disabled, max_distsql_concurrency: 15}                                                                                                                                                                                                 | data:StreamAgg_10                                  | 113 Bytes | N/A  |
|   └─StreamAgg_10           | 1.00         | 1         | batchCop[tiflash] |               | tiflash_task:{time:2.75s, loops:1, threads:1}                                                                                                                                                                                                                                                                                  | funcs:count(tpch100.orders.o_orderdate)->Column#13 | N/A       | N/A  |
|     └─TableFullScan_25     | 150000000.00 | 150000000 | batchCop[tiflash] | table:orders  | tiflash_task:{time:2.75s, loops:2389, threads:1}, tiflash_scan:{dtfile:{total_scanned_packs:36824, total_skipped_packs:0, total_scanned_rows:299998910, total_skipped_rows:0, total_rs_index_load_time: 1ms, total_read_time: 2655ms}, total_create_snapshot_time: 0ms, total_local_region_num: 0, total_remote_region_num: 0} | keep order:false                                   | N/A       | N/A  |
+----------------------------+--------------+-----------+-------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------+-----------+------+
4 rows in set (2.76 sec)

mysql> explain analyze select count(O_CUSTKEY) from orders;
ERROR 1105 (HY000): checksum mismatch for /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_941/2.dat: (while reading from DTFile: /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_941)
mysql> explain analyze select count(O_ORDERKEY) from orders;
+----------------------------+--------------+-----------+-------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------+-----------+------+
| id                         | estRows      | actRows   | task              | access object | execution info                                                                                                                                                                                                                                                                                                                 | operator info                                     | memory    | disk |
+----------------------------+--------------+-----------+-------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------+-----------+------+
| StreamAgg_26               | 1.00         | 1         | root              |               | time:3.26s, loops:2, RRU:0.000000, WRU:0.000000                                                                                                                                                                                                                                                                                | funcs:count(Column#13)->Column#10                 | 388 Bytes | N/A  |
| └─TableReader_27           | 1.00         | 1         | root              |               | time:3.26s, loops:2, cop_task: {num: 2, max: 0s, min: 0s, avg: 0s, p95: 0s, copr_cache: disabled, max_distsql_concurrency: 15}                                                                                                                                                                                                 | data:StreamAgg_10                                 | 113 Bytes | N/A  |
|   └─StreamAgg_10           | 1.00         | 1         | batchCop[tiflash] |               | tiflash_task:{time:3.25s, loops:1, threads:1}                                                                                                                                                                                                                                                                                  | funcs:count(tpch100.orders.o_orderkey)->Column#13 | N/A       | N/A  |
|     └─TableFullScan_25     | 150000000.00 | 150000000 | batchCop[tiflash] | table:orders  | tiflash_task:{time:3.25s, loops:2389, threads:1}, tiflash_scan:{dtfile:{total_scanned_packs:36824, total_skipped_packs:0, total_scanned_rows:299998910, total_skipped_rows:0, total_rs_index_load_time: 1ms, total_read_time: 3564ms}, total_create_snapshot_time: 0ms, total_local_region_num: 0, total_remote_region_num: 0} | keep order:false                                  | N/A       | N/A  |
+----------------------------+--------------+-----------+-------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------+-----------+------+
4 rows in set (3.25 sec)

mysql> 

Sometimes the same query fails on the first run but succeeds on the second run.

mysql> explain analyze select O_ORDERDATE,count(*) from orders group by O_ORDERDATE order by count(*) desc limit 1000;
ERROR 1105 (HY000): other error for mpp stream: From MPP<query:<query_ts:1684511374923080677, local_query_id:2, server_id:3857326, start_ts:441584549858377729>,task_id:1>: Code: 0, e.displayText() = DB::Exception: checksum mismatch for /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_1761/5.dat: (while reading from DTFile: /data/tidb-data/tiflash-9000/data/t_373/stable/dmf_1761), e.what() = DB::Exception,
mysql> explain analyze select O_ORDERDATE,count(*) from orders group by O_ORDERDATE order by count(*) desc limit 1000;
+------------------------------------------+--------------+-----------+--------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+
| id                                       | estRows      | actRows   | task         | access object | execution info                                                                                                                                                                                                                                                                                                                  | operator info                                                                                                                                                  | memory  | disk |
+------------------------------------------+--------------+-----------+--------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+
| Projection_8                             | 1000.00      | 1000      | root         |               | time:1.56s, loops:2, RRU:0.000000, WRU:0.000000, Concurrency:OFF                                                                                                                                                                                                                                                                | tpch100.orders.o_orderdate, Column#10                                                                                                                          | 19.0 KB | N/A  |
| └─TopN_12                                | 1000.00      | 1000      | root         |               | time:1.56s, loops:2                                                                                                                                                                                                                                                                                                             | Column#10:desc, offset:0, count:1000                                                                                                                           | 23.9 KB | N/A  |
|   └─TableReader_55                       | 1000.00      | 1000      | root         |               | time:1.56s, loops:2, cop_task: {num: 2, max: 0s, min: 0s, avg: 0s, p95: 0s, copr_cache: disabled}                                                                                                                                                                                                                               | MppVersion: 1, data:ExchangeSender_54                                                                                                                          | 15.8 KB | N/A  |
|     └─ExchangeSender_54                  | 1000.00      | 1000      | mpp[tiflash] |               | tiflash_task:{time:1.55s, loops:1, threads:10}                                                                                                                                                                                                                                                                                  | ExchangeType: PassThrough                                                                                                                                      | N/A     | N/A  |
|       └─TopN_53                          | 1000.00      | 1000      | mpp[tiflash] |               | tiflash_task:{time:1.52s, loops:1, threads:1}                                                                                                                                                                                                                                                                                   | Column#10:desc, offset:0, count:1000                                                                                                                           | N/A     | N/A  |
|         └─Projection_49                  | 2406.00      | 2406      | mpp[tiflash] |               | tiflash_task:{time:1.52s, loops:10, threads:10}                                                                                                                                                                                                                                                                                 | Column#10, tpch100.orders.o_orderdate                                                                                                                          | N/A     | N/A  |
|           └─HashAgg_50                   | 2406.00      | 2406      | mpp[tiflash] |               | tiflash_task:{time:1.52s, loops:10, threads:10}                                                                                                                                                                                                                                                                                 | group by:tpch100.orders.o_orderdate, funcs:sum(Column#19)->Column#10, funcs:firstrow(tpch100.orders.o_orderdate)->tpch100.orders.o_orderdate, stream_count: 10 | N/A     | N/A  |
|             └─ExchangeReceiver_52        | 2406.00      | 2406      | mpp[tiflash] |               | tiflash_task:{time:1.51s, loops:10, threads:10}                                                                                                                                                                                                                                                                                 | stream_count: 10                                                                                                                                               | N/A     | N/A  |
|               └─ExchangeSender_51        | 2406.00      | 2406      | mpp[tiflash] |               | tiflash_task:{time:1.51s, loops:1, threads:10}                                                                                                                                                                                                                                                                                  | ExchangeType: HashPartition, Compression: FAST, Hash Cols: [name: tpch100.orders.o_orderdate, collate: binary], stream_count: 10                               | N/A     | N/A  |
|                 └─HashAgg_47             | 2406.00      | 2406      | mpp[tiflash] |               | tiflash_task:{time:1.51s, loops:1, threads:10}                                                                                                                                                                                                                                                                                  | group by:tpch100.orders.o_orderdate, funcs:count(1)->Column#19                                                                                                 | N/A     | N/A  |
|                   └─TableFullScan_36     | 150000000.00 | 150000000 | mpp[tiflash] | table:orders  | tiflash_task:{time:1.43s, loops:2389, threads:10}, tiflash_scan:{dtfile:{total_scanned_packs:36824, total_skipped_packs:0, total_scanned_rows:299998910, total_skipped_rows:0, total_rs_index_load_time: 1ms, total_read_time: 6211ms}, total_create_snapshot_time: 0ms, total_local_region_num: 0, total_remote_region_num: 0} | keep order:false                                                                                                                                               | N/A     | N/A  |
+------------------------------------------+--------------+-----------+--------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+
11 rows in set (1.56 sec)
| username: tidb菜鸟一只 | Original post link

Check the TiFlash replica status of this table.