Details
-
Bug
-
Status: Closed (View Workflow)
-
Resolution: Fixed
-
None
-
None
-
None
Description
This is a pretty nasty one, because a simple "add index" statement can crash your database in a way that seems unpredictable. Bug is present in latest released MariaDB:
MySQL 44571: InnoDB Plugin crashes on ADD INDEX
http://bugs.mysql.com/bug.php?id=44571
The actual crash looks like so:
InnoDB: Error: no matching column for "renamed_column" in index "index_renamed_column"-temporary- of table "test"."test_table"!
091218 10:40:48 InnoDB: Assertion failure in thread 139964197152528 in file dict/dict0dict.c line 1768
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
InnoDB: about forcing recovery.
 091218 10:40:48 - mysqld got signal 6 ;
This could be because you hit a bug.