tpcc report error “GROUP BY ol_d_id failed Error 1105: PD returned no region, range num: 2, limit: 128”

[Lily2025]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

1、run tpcc
2、kill one of tikv
[2024/07/01 23:58:03.221 +08:00] [INFO] [chaos.go:172] ["Run chaos"] [name=kill]

3、tpcc report error
[2024/07/02 00:03:21.064 +08:00] [INFO] [workload.go:680] ["[2024-07-01 16:03:21] execute run failed, err exec SELECT ol_d_id, SUM(ol_amount) FROM order_line WHERE (ol_w_id, ol_d_id, ol_o_id) IN (\r\n"]
[2024/07/02 00:03:21.064 +08:00] [INFO] [workload.go:680] ["\t(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?)\r\n"]
[2024/07/02 00:03:21.064 +08:00] [INFO] [workload.go:680] [") GROUP BY ol_d_id failed Error 1105: PD returned no region, range num: 2, limit: 128\r\n"]

2. What did you expect to see? (Required)

no unexpected errors

3. What did you see instead (Required)

tpcc report error

4. What is your TiDB version? (Required)

./tidb-server -V
Release Version: v8.2.0-alpha
Edition: Community
Git Commit Hash: 7df4f66
Git Branch: heads/refs/tags/v8.2.0-alpha
UTC Build Time: 2024-06-29 11:47:18
GoVersion: go1.21.10
Race Enabled: false
Check Table Before Drop: false
Store: unistore

./pd-server -V
Release Version: v8.2.0-alpha
Edition: Community
Git Commit Hash: e7c9d1514bd385d045b14aae4b51c1aec51be3aa
Git Branch: heads/refs/tags/v8.2.0-alpha
UTC Build Time: 2024-06-28 11:38:10
2024-07-01T19:06:52.020+0800 INFO

[Lily2025]

/assign you06
/severity major

[lance6716]

also #54277

[you06]

Fixed by #54365

[windtalker]

This bug also affects release 7.1/7.5/8.1 since TiFlash already uses ScanRegions in these branch