Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
11.3.2, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4
-
None
Description
Run the following statements, in which the ALTER statement is expected to execute successfully. However, the ALTER statement failed, and it seems that the table `mysql.innodb_table_stats` does not timely update its info.
CREATE TABLE t1 (c1 INT) ENGINE=InnoDB; |
CREATE TABLE t2 (c1 INT) ENGINE=InnoDB; |
ALTER TABLE t1 STATS_PERSISTENT 0; |
DROP TABLE IF EXISTS t1; |
ALTER TABLE t2 RENAME t1; -- [23000][1022] (conn=33) Can't write; duplicate key in table 'mysql.innodb_table_stats' |
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Component/s | Storage Engine - InnoDB [ 10129 ] | |
| Component/s | Server [ 13907 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Fix Version/s | 10.11 [ 27614 ] | |
| Fix Version/s | 11.1 [ 28549 ] | |
| Fix Version/s | 11.2 [ 28603 ] | |
| Fix Version/s | 11.4 [ 29301 ] | |
| Affects Version/s | 10.6 [ 24028 ] | |
| Affects Version/s | 10.7 [ 24805 ] | |
| Affects Version/s | 10.8 [ 26121 ] | |
| Affects Version/s | 10.9 [ 26905 ] | |
| Affects Version/s | 10.10 [ 27530 ] | |
| Affects Version/s | 10.11 [ 27614 ] | |
| Affects Version/s | 11.0 [ 28320 ] | |
| Affects Version/s | 11.1 [ 28549 ] | |
| Affects Version/s | 11.2 [ 28603 ] | |
| Affects Version/s | 11.3 [ 28565 ] | |
| Affects Version/s | 11.4 [ 29301 ] | |
| Assignee | Marko Mäkelä [ marko ] |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Summary | Can't write; duplicate key in table 'mysql.innodb_table_stats' | Can't write; duplicate key in table 'mysql.innodb_table_stats' |
| Fix Version/s | 11.1 [ 28549 ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Assignee | Marko Mäkelä [ marko ] | Thirunarayanan Balathandayuthapani [ thiru ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| issue.field.resolutiondate | 2024-09-30 17:23:02.0 | 2024-09-30 17:23:01.731 |
| Fix Version/s | 10.6.20 [ 29903 ] | |
| Fix Version/s | 10.11.10 [ 29904 ] | |
| Fix Version/s | 11.2.6 [ 29906 ] | |
| Fix Version/s | 11.4.4 [ 29907 ] | |
| Fix Version/s | 11.6.2 [ 29908 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Fix Version/s | 10.11 [ 27614 ] | |
| Fix Version/s | 11.2 [ 28603 ] | |
| Fix Version/s | 11.4 [ 29301 ] | |
| Assignee | Thirunarayanan Balathandayuthapani [ thiru ] | Marko Mäkelä [ marko ] |
| Resolution | Fixed [ 1 ] | |
| Status | In Review [ 10002 ] | Closed [ 6 ] |