MySQL Bugs: #27423: tables crash and need repair

Bug #27423	tables crash and need repair
Submitted:	25 Mar 2007 15:10	Modified:	9 Apr 2007 16:53
Reporter:	Paul Laudanski	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: General	Severity:	S2 (Serious)
Version:	Ver 14.13 Distrib 5.1.15-beta	OS:	FreeBSD (FreeBSD)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
During the normal course of database usage, SELECT, INSERT, UPDATE, one table crashes and needs repairing before service can be continued.  The table that crashes is not the same and changes.

How to repeat:
Unknown at this time.

Thank you for a problem report. Please, send SHOW CREATE TABLE and SHOW TABLE STATUS results for the problemtic table, and your my.cnf file content.

Calling the init.d script to restart seems to have corrupted some of the tables.  Repairing them and doing a clean stop/start fixed it.