MySQL Forums
Forum List  »  InnoDB

Re: Problem of data corruption
Posted by: Benjamin Gonay
Date: February 16, 2005 07:58AM

Hi,

I've experienced exactly same problems of corruption, with exactly same errors.
I'm running Mysql4.0.21, with a lighter config of yours. The error occurs on a innodb table about 70000 rows and 16Mb of data, that table has a PK combining 3 fields of different type (varchar(10)+char(3)+smallint(5)) , and with an index on a single varchar field.

The innodb crash + rollback occured on any DML command, even on an ALTER TABLE t type=InnoDB which normally rebuild indexes.

A rename table works fine, this to enable me to re-import table from nightly backup.

But that left me with a corrupted dead table in my innodb tablespace, impossible to drop.
The only way i get off this was to stop Mysql, add a line "innodb_force_recovery=4" in my.cnf , start , check the error server file, stop, remove that line, and restart the server to drop the table.

When reading this thread and seeing data corruption come back again... that's decide me to post... :-/

Any comments on this ??

My soft config is Mysql4.0.21-standard-log icc-glibc23, Official MySQL-standard library on a SuSE9.1, with one innodb tablespace sizing about 250Mb now, on 2.6.5-7.111 kernel. MySQL is running verrry fine until now, for three years now.

Thks
Benjamin

Options: ReplyQuote


Subject
Views
Written By
Posted
4330
January 21, 2005 07:49AM
2731
January 21, 2005 07:53AM
2679
January 21, 2005 03:52PM
2616
January 25, 2005 04:57PM
2851
January 27, 2005 02:55AM
Re: Problem of data corruption
2756
February 16, 2005 07:58AM
2548
February 25, 2005 06:54AM
2568
March 03, 2005 03:07AM
2772
February 16, 2005 11:15AM
3528
February 17, 2005 03:40AM
2580
February 17, 2005 03:25PM
2577
March 17, 2005 01:55AM
2572
March 18, 2005 11:19AM
2900
March 31, 2005 01:04PM
2617
April 04, 2005 08:21AM
2795
April 04, 2005 09:24AM
2971
April 04, 2005 11:38PM
2612
April 19, 2005 09:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.