[MDEV-34207] Can't write; duplicate key in table 'mysql.innodb_table_stats' - Jira

XML

Word

Printable

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Critical
Resolution: Unresolved
Affects Version/s: 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0, 11.1, 11.2, 11.3, 11.4, 11.3.2
Fix Version/s: 10.6, 10.11, 11.1, 11.2, 11.4
Component/s: Storage Engine - InnoDB
Labels:
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

People

Assignee:: Marko Mäkelä

Reporter:: John Jove

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2024-05-21 13:10

Updated:: 2024-05-28 19:15

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.