Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
Lily2025 opened this issue Jul 2, 2024 · 4 comments
Assignees
Labels
affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. affects-8.2 report/community The community has encountered this bug. severity/major sig/transaction SIG:Transaction type/bug The issue is confirmed as a bug.

Comments

@Lily2025
Copy link

Lily2025 commented Jul 2, 2024

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 Lily2025 added the type/bug The issue is confirmed as a bug. label Jul 2, 2024
@Lily2025
Copy link
Author

Lily2025 commented Jul 2, 2024

/assign you06
/severity major

@lance6716
Copy link
Contributor

also #54277

@Lily2025 Lily2025 changed the title tpcc report error “GROUP BY ol_d_id failed Error 1105: PD returned no region, range num: 2, limit: 128” after kill one of tikv tpcc report error “GROUP BY ol_d_id failed Error 1105: PD returned no region, range num: 2, limit: 128” Jul 2, 2024
@you06
Copy link
Contributor

you06 commented Jul 4, 2024

Fixed by #54365

@windtalker
Copy link
Contributor

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

@windtalker windtalker added affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. labels Jul 22, 2024
ti-chi-bot bot pushed a commit that referenced this issue Jul 22, 2024
ti-chi-bot bot pushed a commit that referenced this issue Jul 22, 2024
@seiya-annie seiya-annie added the report/community The community has encountered this bug. label Jul 23, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. affects-8.2 report/community The community has encountered this bug. severity/major sig/transaction SIG:Transaction type/bug The issue is confirmed as a bug.
Projects
None yet
Development

No branches or pull requests

7 participants