There could be large amount of remote request when querying on a large and hot-write table #10300
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
Observed from a certain cluster
2. What did you expect to see? (Required)
3. What did you see instead (Required)
-- first not match, rebuild the local read inputstreams
[2025/07/11 01:13:07.471 +00:00] [WARN] [DAGStorageInterpreter.cpp:748] ["RegionException after read from storage, regions [23874359,], message: EPOCH_NOT_MATCH, retry to read from local"] [source=MPP<query:459327769121916622,task:3>]
-- another not match happen, 21,700 regions need to be retry
[2025/07/11 01:13:07.649 +00:00] [WARN] [DAGStorageInterpreter.cpp:765] ["RegionException after read from storage, regions [24184535, .....,24109478,], message: EPOCH_NOT_MATCH"] [source=MPP<query:459327769121916622,task:3>] [thread_id=690]
[2025/07/11 01:13:07.699 +00:00] [INFO] [RemoteRequest.cpp:42] ["Start to build remote request for 21775 regions (23874359,24184535,...,24109478) for table 8132"] [source=MPP<query:459327769121916622,task:3>] [thread_id=690]
4. What is your TiFlash version? (Required)
v6.5.10