Bug #28138 indexing column prefixes produces corruption in InnoDB
Submitted: 27 Apr 2007 16:42 Modified: 18 Jun 2010 22:30
Reporter: Matthew Lord Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:5.0.30, 5.0.38, 5.0.42BK, 5.1.18BK OS:Any
Assigned to: Marko Mäkelä CPU Architecture:Any
Tags: bfsm_2007_05_03, corruption, crashing, innodb, Prefix Indexing

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[3 May 2007 3:12] Shane Bester
slightly randomized testcase to cause corruptions.  Run for ~1 minute and observe errors logs of server...

Attachment: bug28138.c (text/plain), 6.06 KiB.

[3 May 2007 3:14] Shane Bester
my complete error log from the above testcase.

Attachment: www.zip (application/zip, text), 209.68 KiB.

[24 May 2007 12:59] Marko Mäkelä
Revert Bug #21638 fix from 5.0

Attachment: 5.0-r792.patch (text/x-diff), 3.88 KiB.

[24 May 2007 13:02] Marko Mäkelä
Revert Bug #21638 fix from 5.1

Attachment: 5.1-r791-799.patch (text/x-diff), 5.36 KiB.