4 messages in com.mysql.lists.bugsRe: Reproducible MyISAM table corruption
FromSent OnAttachments
Dpto.Sistemas Ylos20 Mar 2003 03:02 
Alexander Keremidarski20 Mar 2003 03:19 
Dpto.Sistemas Ylos20 Mar 2003 03:54 
Alexander Keremidarski20 Mar 2003 05:06 
Subject:Re: Reproducible MyISAM table corruption
From:Alexander Keremidarski (sal@mysql.com)
Date:03/20/2003 05:06:26 AM
List:com.mysql.lists.bugs

Hi,

Dpto.Sistemas Ylos wrote:

Ok. I tried stopping MySQL server before checking integrity and the result is the same.

How-To-Repeat: 1.- Create an empty database 2.- Dump into the SQL sentences (http://www2.ylos.com/myisamcorruption_ylos.sql.gz). 3.- Stop MySQL server 3.- Check the table integrity with myisamchk 4.- The result should be something like this:

# /usr/local/mysql/bin/myisamchk logweb.MYI Checking MyISAM file: logweb.MYI Data records: 156 Deleted blocks: 457 - check file-size - check key delete-chain - check record delete-chain /usr/local/mysql/bin/myisamchk: warning: Not used space is supposed to be: 25344 but is: 25292 /usr/local/mysql/bin/myisamchk: error: record delete-link-chain corrupted

Ok. I did more tests and you are right table becomes corrupted. Thank you for a good bug report and perfect test case.

We will check it thourughly and willlet you know when it's fixed.

-- MySQL Conference and Expo 2003 http://www.mysql.com/events/uc2003/index.html For technical support contracts, visit https://order.mysql.com/?ref=msal __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski <sal@mysql.com> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria <___/ www.mysql.com