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: MySQL Verification Team CPU Architecture:Any

[27 Jan 2006 21:33] S Wagner
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.
[27 Jan 2006 23:11] MySQL Verification Team
Could you please provide a test case with a dump of table(s) with data and the
offended queries?

Thank you in advance.
[28 Feb 2006 0:00] Bugs System
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".