No available path for table xxx with the store type TiFlash of the hint

Translated
1

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

Original topic: No available path for table xxx with the store type tiflash of the hint

| username: Kongdom

[Test Environment] TiDB
[TiDB Version] 5.7.25-TiDB-v5.3.0
[Problem Encountered] When executing a query statement, a prompt is output along with the result.
[Reproduction Path] None
[Problem Phenomenon and Impact]

The executed statement is as follows:

SELECT /*+ read_from_storage(tiflash[t]) */ * FROM xxx t

The prompt message is as follows:

No available path for table xxx with the store type tiflash of the hint /*+ read_from_storage */,
please check the status of the table replica and variable value of tidb_isolation_read_engines(map[0:{} 1:{} 2:{}])

PS: When the hint is removed, there is no prompt message.

2
| username: h5n1 | Original post link

Is there TiFlash? Did you set TiFlash replicas for the queried table?

3
| username: Kongdom | Original post link

There is TiFlash, but this table does not have replicas set.

4
| username: h5n1 | Original post link

First, set up the TiFlash replica.

5
| username: Kongdom | Original post link

I didn’t mean that, I was just curious about this prompt message. If it’s just a reminder, then there’s no problem. At first, I thought it was an error, but later I realized it might just be a prompt message.

6
| username: Kongdom | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.