MySQL Bugs: #16856: Inconsistant results with a standard SELECT query

Bug #16856	Inconsistant results with a standard SELECT query
Submitted:	27 Jan 2006 21:33	Modified:	27 Feb 2006 23:11
Reporter:	S Wagner	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.0.25	OS:	Windows (Windows server 2003 and XP)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
Here is an example of a problem query. SELECT * FROM
wicdatacom.wwticketmonitor w. This happens for other SELECT queries on other
tables as well. 99.9% of the time I get the correct result. However once in
awhile I get zero results, sometimes I also recieve a result set that is not
zero, but less results than it should be. This became a big problem for me since
I am building an ajax application that polls the database fairly rapidly so the
incorrect result shows up often. I was able to resolve this by dropping the
indexes on the problem tables. I am running MySql ver. 4.0.25. 

How to repeat:
I am almost positive that the fault is not with my script. As a test case I put the query into the MySql query browser. If I hit the query button over and over again I will produce an empty or dimished result set in 15 seconds or less. It seems completly random.

Suggested fix:

I removed the indexes on the offending tables.

Could you please provide a test case with a dump of table(s) with data and the
offended queries?

Thank you 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".