pingcap / pingcap/tidb

some query of tpcc cost more than 3h due to wrong execution plan

Open
#60,874 4 comments 0 reactions 1 assignee Claimed by @time-and-fate View on GitHub
severity/moderate sig/planner type/bug
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)
1、run tpcc 10000 warehouse
2、workload report Error 9002 (HY000): TiKV server timeout
3、workload stopped at 2025/04/23 16:57:05

### 2. What did you expect to see? (Required)
no blocked query

### 3. What did you see instead (Required)
some query of tpcc cost more than 3h even if workload stopped

![Image](https://github.com/user-attachments/assets/b0d29fc1-2778-4749-a48c-ca287967c778)

![Image](https://github.com/user-attachments/assets/ffca2ebc-7333-4b38-9abf-f9f202aac1db)
![Image](https://github.com/user-attachments/assets/7dbed61f-dfc2-4f63-8576-60c50962e19d)
![Image](https://github.com/user-attachments/assets/c376b12b-ff41-4e01-b36b-7ec69acc7404)

### 4. What is your TiDB version? (Required)
./tidb-server -V
Release Version: v8.5.2
Edition: Community
Git Commit Hash: ba894d6e1443fb47878cf44d67c0f0f310f53ec8
Git Branch: HEAD
UTC Build Time: 2025-04-18 16:19:45
GoVersion: go1.23.6
Race Enabled: false
Check Table Before Drop: false
Store: unistore

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.