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

TiDB crashed while analyzing table in tpcc with tidb_analyze_version=2 #26547

Closed
PragmaTwice opened this issue Jul 26, 2021 · 4 comments
Closed
Assignees
Labels
severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@PragmaTwice
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

mysql -Be RESTORE DATABASE * from 's3://benchmark/tpcc-1000-new'
mysql> set tidb_analyze_version=1;
Query OK, 0 rows affected (0.03 sec)

mysql> analyze table tpcc.customer;
Query OK, 0 rows affected (59.23 sec)

mysql> set tidb_analyze_version=2;
Query OK, 0 rows affected (0.03 sec)

mysql> analyze table tpcc.customer;
ERROR 2013 (HY000): Lost connection to MySQL server during query

4. What is your TiDB version? (Required)

+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version()

                                                                            |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v5.2.0-alpha-316-g014005ab6
Edition: Community
Git Commit Hash: 014005ab68b5c9a28795d13c1ca685cf46a3be7e
Git Branch: master
UTC Build Time: 2021-07-17 09:44:18
GoVersion: go1.16.4
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.14 sec)
@PragmaTwice PragmaTwice added type/bug The issue is confirmed as a bug. severity/critical sig/planner SIG: Planner labels Jul 26, 2021
@winoros
Copy link
Member

winoros commented Jul 28, 2021

I guess this is caused by OOM. I'll contact you for more information.

@winoros
Copy link
Member

winoros commented Aug 5, 2021

It will be improved in the next sprint. Move down the severity.

@winoros
Copy link
Member

winoros commented Nov 23, 2021

closed via #28999

@github-actions
Copy link

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants