Bugs Fixed
Important Change: InnoDB:
If an ALTER TABLE statement
failed for an InnoDB table due to an error
code from an underlying file-renaming system call,
InnoDB could lose track of the
.ibd file for the table. This issue only
occurred when the
innodb_file_per_table
configuration option was enabled, and when the low-level error
persisted through thousands of retry attempts. In MySQL 5.1,
this issue applied to the InnoDB Plugin but not the built-in
InnoDB storage engine.
For example, if you encounter an error like the following:
mysql> alter table sb2 add column d2 int; ERROR 1025 (HY000): Error on rename of './sbtest/#sql-1eb9_1' to './sbtest/sb2' (errno: -1)
you might be able to access the #sql* table
by copying a .frm file from a table with an
identical schema. The table name to use for the
.frm filewould be
`sbtest.#mysql50##sql-1eb9_1` in the
preceding example.
(Bug #12884631, Bug #62146)
InnoDB:
Issuing INSERT...ON
DUPLICATE KEY statements for InnoDB
tables from concurrent threads could cause a
deadlock, particularly with
the INSERT...ON DUPLICATE KEY UPDATE form.
The problem could also be triggered by issuing multiple
INSERT IGNORE
statements. The fix avoids deadlocks caused by the same row
being accessed by more than one transaction. Deadlocks could
still occur when multiple rows are inserted and updated
simultaneously by different transactions in inconsistent order;
those types of deadlocks require the standard error handling on
the application side, of re-trying the transaction.
(Bug #11759688, Bug #52020, Bug #12842206)
An incorrect InnoDB assertion could cause the
server to halt. This issue only affected debug builds. The
assertion referenced the source file
btr0pcur.ic and the variable
cursor->pos_state.
(Bug #13358468)
The handle_segfault() signal-handler code in
mysqld could itself crash due to calling
unsafe functions.
(Bug #54082, Bug #11761576)
ARCHIVE tables with
NULL columns could cause server crashes or
become corrupt under concurrent load.
(Bug #51252, Bug #11758979)
Enabling myisam_use_mmap could
cause the server to crash.
(Bug #48726, Bug #11756764)
Concurrent access to ARCHIVE tables could
cause corruption.
(Bug #42784, Bug #11751793)

User Comments
Add your own comment.