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

new collation + analyze panic #20874

Closed
wjhuang2016 opened this issue Nov 5, 2020 · 2 comments · Fixed by #21262
Closed

new collation + analyze panic #20874

wjhuang2016 opened this issue Nov 5, 2020 · 2 comments · Fixed by #21262
Assignees
Labels
severity/major sig/planner SIG: Planner sig/sql-infra SIG: SQL Infra sig/transaction SIG:Transaction type/bug This issue is a bug.

Comments

@wjhuang2016
Copy link
Member

wjhuang2016 commented Nov 5, 2020

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

mysql> show create table t;
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                                                  |
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t     | CREATE TABLE `t` (
  `a` char(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `b` char(20) COLLATE utf8mb4_general_ci NOT NULL,
  `c` int(11) NOT NULL,
  PRIMARY KEY (`a`,`b`,`c`),
  KEY `idx` (`a`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin |
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

insert into t values ('#', 'C', 10), ('$', 'c', 20), ('a', 'a', 10);

mysql> select * from t;
+---+---+----+
| a | b | c  |
+---+---+----+
| # | C | 10 |
| $ | c | 20 |
| a | a | 10 |
+---+---+----+
3 rows in set (0.00 sec)

mysql> analyze table t;
ERROR 1105 (HY000): analyze worker panic

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

No panic

3. What did you see instead (Required)

Panic

4. What is your TiDB version? (Required)

master

@wjhuang2016 wjhuang2016 added type/bug This issue is a bug. severity/critical labels Nov 5, 2020
@SunRunAway SunRunAway added sig/transaction SIG:Transaction sig/sql-infra SIG: SQL Infra labels Nov 11, 2020
@wjhuang2016 wjhuang2016 added the sig/planner SIG: Planner label Nov 20, 2020
@lzmhhh123
Copy link
Member

Hi, clustered index related issues should be maintained the severity to major. It doesn't affect the release branch.

@github-actions github-actions bot added this to Issue Backlog: Need Triage in SIG Planner Kanban Nov 23, 2020
@github-actions github-actions bot added this to Issue Backlog: Need Triage in SIG Infra Kanban Nov 23, 2020
SIG Planner Kanban automation moved this from Issue Backlog: Need Triage to Coding Finished (This Week) Nov 25, 2020
@ti-srebot
Copy link
Contributor

Please edit this comment or add a new comment to complete the following information

Not a bug

  1. Remove the 'type/bug' label
  2. Add notes to indicate why it is not a bug

Duplicate bug

  1. Add the 'type/duplicate' label
  2. Add the link to the original bug

Bug

Note: Make Sure that 'component', and 'severity' labels are added
Example for how to fill out the template: #20100

1. Root Cause Analysis (RCA) (optional)

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

6. Fixed versions

@winoros winoros changed the title clustered index + new collation + analyze panic new collation + analyze panic Nov 26, 2020
@ghost ghost moved this from Issue Backlog: Need Triage to Done in SIG Infra Kanban Dec 3, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
severity/major sig/planner SIG: Planner sig/sql-infra SIG: SQL Infra sig/transaction SIG:Transaction type/bug This issue is a bug.
Projects
No open projects
SIG Planner Kanban
  
Coding Finished (This Week)
Development

Successfully merging a pull request may close this issue.

5 participants