TiFlash SQL Query Error, Exchange Receiver Meet Error: DB::Exception: get store failed:

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

Original topic: Tiflash SQL查询报错,Exchange receiver meet error : DB::Exception: get store failed:

| username: 大飞飞呀

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issue: Issue Phenomenon and Impact]

       SELECT '20230907' I_DATE, '2023' I_ACCUMULATE_DATE,
        IFNULL(b.group_id, "") group_id,
        COUNT(DISTINCT a.I_USER_ID) I_USER_COUNT, SUM(a.I_AMOUNT) I_AMOUNT, SUM(I_COUNT) I_COUNT
        FROM table_a a
        LEFT JOIN table_b b
        ON a.ch_d_id = b.ch_d_id
        WHERE a.I_DATE >= '2023-01-01'
        AND a.I_DATE < '2023-09-08'
        GROUP BY IFNULL(b.group_id, "");

The above SQL query reports an error
Exchange receiver meet error: DB::Exception: get store failed: 2: invalid store ID 1231368721, not found
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachment: Screenshot/Log/Monitoring]

| username: xfworld | Original post link

Is the cluster functioning normally? Is there a TiKV node with store ID 1231368721?

| username: 大飞哥online | Original post link

Take a look

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

Is there a TiKV node down?

| username: 像风一样的男子 | Original post link

Check the store using pd-ctl to see if there is a node with ID 1231368721.

| username: TiDBer_oHSwKxOH | Original post link

SELECT * FROM INFORMATION_SCHEMA.TIKV_STORE_STATUS WHERE store_id=‘1231368721’; Let’s see which machine it’s on.

| username: 大飞飞呀 | Original post link

The query result is empty.

| username: 大飞飞呀 | Original post link

Could not find this node.

| username: 像风一样的男子 | Original post link

Have you performed scaling operations on the cluster before?

| username: 大飞哥online | Original post link

Enter interactive mode with tiup ctl:v7.1.0 pd -i -u http://127.0.0.1:2379
Then type store 1231368721
See if there are any results.

| username: TiDBer_oHSwKxOH | Original post link

The table has issues. Rebuild it.

| username: 大飞哥online | Original post link

Take a look too.

| username: 大飞飞呀 | Original post link

No rebuild, suddenly reported an error.

| username: TiDBer_yyy | Original post link

Recently, we performed scaling operations, and currently, the cluster’s GC is quite large (reduced from 100h to 80h). Could it be related to obtaining historical snapshots?

Current cluster status:
image

| username: 有猫万事足 | Original post link

Bug fixed in version 6.1.7