[MDEV-3581] LP:949456 - MyISAM tables continuously crashing Created: 2012-03-07  Updated: 2012-10-04  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: Dreas van Donselaar (Inactive) Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug949456.xml    

 Description   

I have a database with 13.000 tables on a dedicated MySQL server. Running MariaDB 5.2.10. I currently notice tables continuously crashing, syslog shows for such tables:
===
Mar 7 22:45:20 mysql2 mysqld: 120307 22:45:20 [ERROR] mysqld: Incorrect key file for table './mx_messages/table_nl.MYI'; try to repair it
Mar 7 23:03:35 mysql2 mysqld: 120307 23:03:35 [ERROR] mysqld: Table './mx_messages/table_nl' is marked as crashed and should be repaired
Mar 7 23:03:35 mysql2 mysqld: 120307 23:03:35 [Warning] Checking table: './mx_messages/table_nl'
Mar 7 23:03:35 mysql2 mysqld: 120307 23:03:35 [Warning] Recovering table: './mx_messages/table_nl'
Mar 7 23:06:13 mysql2 mysqld: 120307 23:06:13 [Note] Found 5427 of 5541 rows when repairing './mx_messages/table_nl'
===

I'm 100% sure the tables weren't corrupted earlier, because I did a full check/repair of all tables when things were not busy (I firewalled all external servers temporarily). We have around 20 servers writing to these tables at fast rate using REPLACE INTO. I'll upload the syslog, table structure, and part of the general log (private/confidential). This is on Debian Linux.



 Comments   
Comment by Elena Stepanova [ 2012-03-13 ]

Re: MyISAM tables continuously crashing
Hi,

If, as discussed on IRC, the root cause of the table corruption is server crashes due to a problem with archive tables, should we close this bug?

Comment by Dreas van Donselaar (Inactive) [ 2012-03-13 ]

Re: MyISAM tables continuously crashing
This was caused by https://bugs.launchpad.net/maria/+bug/917689

Comment by Rasmus Johansson (Inactive) [ 2012-03-13 ]

Launchpad bug id: 949456

Generated at Thu Feb 08 06:49:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.