MySQL Bugs: #15286: SELECT with WHERE clause suddenly fails

Bug #15286	SELECT with WHERE clause suddenly fails - need to rebuild table
Submitted:	28 Nov 2005 13:16	Modified:	28 Dec 2005 14:00
Reporter:	Peter McCabe	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	4.1	OS:	Windows (Windows 2003 (ODBC 3.51))
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
Hi,

I am running an application that works fine for periods of time, in that it makes SELECT calls to a table and keeps getting the correct result back, until suddenly the same call to thr same table, that has not been altered, suddenly fails to return any results.

Usually, looking at the table using Navicat I can see all the data seems to still be there - i.e. a SELECT all rows seems to work - and Navicat reports that the table is fine and not in need of repair. However, the problem persists until I delete table and rebuild it from scratch from a backup .sql file.

I say usually, as there has been the odd the occasion where attempting to view the table in Navicat shows all the column headers as gibberish and now data/ rows.

The table is becoming corrupted in some way, but not as result of my scripts, as none of them ever do anything except perform a SELECT on the table. But how, and how do I fix?

Thanks in advance.

How to repeat:
I have no idea I'm afraid, it just seems to happen at random. Sorry.

We need more information for to handle this bug: which exactly version
of server are you using i.e.: 4.1.15? when the issue happens can you
send the output of show status; and show variables; ?

Also if you can provide the table dump file and your my.ini file will
be useful.

Thanks in advance.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".