Percona XtraDB Storage Engine for MySQL

rename columns and add unique index cause serious inconsistent with mysqld

Reported by Yasufumi Kinoshita on 2009-11-25
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona-XtraDB
Fix Released
High
Unassigned

Bug Description

http://bugs.mysql.com/bug.php?id=47621
http://bugs.mysql.com/bug.php?id=47622

They are serious bugs on the fast index creation.
For now, the table should be recreated to avoid inconsistency between mysqld and XtraDB(InnoDB Plugin).

The inconsistency may destruct relation between index and table, or completely wrong index using for queries.

Sorry for shortage of words.

The table should be recreated to avoid inconsistency between mysqld and XtraDB(InnoDB Plugin)
"when rename columns or add unique indexes"

Changed in percona-xtradb:
importance: Undecided → High
assignee: nobody → Yasufumi Kinoshita (yasufumi-kinoshita)

Fixes are added to the current branch as I commented in
http://bugs.mysql.com/bug.php?id=47621
http://bugs.mysql.com/bug.php?id=47622

Changed in percona-xtradb:
status: New → Fix Committed
Ryan Mack (ryan-d-mack) on 2010-01-15
Changed in percona-xtradb:
status: Fix Committed → Fix Released
status: Fix Released → Fix Committed
Stewart Smith (stewart) wrote :

All development of XtraDB has moved under the Percona Server project - https://launchpad.net/percona-server - If this bug can be reproduced against current Percona Server, please file this bug against percona-server (you can simply do so by using the "Also affects project" link above).

Thanks,
Stewart Smith
Director of Server Development
Percona.

Changed in percona-xtradb:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.