Bug #24646 Check table is not picking up a crashed table

• Submitted: 28 Nov 2006 8:46
• Modified: 29 Nov 2006 7:22
• Reporter: Jacques
• Status: Closed
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.1.11
• OS: Linux (Redhat Linux RHEL4)
• CPU Architecture: Any

[28 Nov 2006 8:46] Jacques

Description:
While running a query to populate a summary table it tells me that the 'bills' table is crashed:

ERROR 1194 (HY000): Table 'bills' is marked as crashed and should be repaired

Running CHECK TABLE bills returns 'OK'.

How to repeat:
Rerun the SQL query in the comment below and run CHECK TABLE bills;

Suggested fix:
Not sure what is causing MySQL to beleive a table is crashed when check table tells me it's 'OK'.

[28 Nov 2006 9:02] Valeriy Kravchuk

Thank you for a problem report. Please, try to repeat with a newer version, 5.1.12, and, in case of similar problem, send SHOW CREATE TABLE and some data for bills table (or table files, if it is MyISAM).

[28 Nov 2006 9:05] Jacques

This bug might be related to Bug 18036

[28 Nov 2006 9:36] Valeriy Kravchuk

Thank you for additional infromation. Bug #18036 is fixed in 5.1.12, so, please, check with this version and inform about the results.

[28 Nov 2006 11:12] Jacques

I will let you know once the MySQL 5.1.12 rpm's have finished downloading from ftp.is.co.za

[28 Nov 2006 12:47] Jacques

Any reason why "field" no longer works and treats the "field" as the a value of field?

[29 Nov 2006 3:33] Valeriy Kravchuk

> I will let you know once the MySQL 5.1.12 rpm's have finished downloading from
> ftp.is.co.za

Please, do.

> Any reason why "field" no longer works and treats the "field" as the a value of
field?

I do not understand what exactly do you mean and how it is related to this bug report. Please, clarify.

[29 Nov 2006 7:22] Jacques

Confirmed that this is fixed in 5.1.12.