MySQL Forums
Forum List  »  General

intermittent query results
Posted by: Ian Hunt
Date: November 09, 2004 06:27AM

Hi,

Not sure if this post should go to the newbies but anyway.

I'm having a real problem with a particular query ( i appreciate that i havent shown the tables etc.) But this query appears to work for 30 seconds then stop working for about 30 seconds and then start working again etc. I have been doing this query via the mysql gui browser. It almost seem to be this table? but all integrity checks work fine

select hosts.host_name, server_version.server_app, server_version.version, server_version.start_time, server_version.end_time
from rigs, server_version, hosts
where rigs.rig_name = '$T&H3.0'
and rigs.rig_id = server_version.rig_id
and hosts.host_id = server_version.host_id
and server_version.start_time > (NOW() - 365)


I have also tried it on the database server via the command line with the same result.

There is nothing in the general log or slow-log or error.log.

I am completely stumped as to how to debug this problem.

The rest of the queries which contain equi-joins seem ok.

TIA

Ian

Options: ReplyQuote


Subject
Written By
Posted
intermittent query results
November 09, 2004 06:27AM
November 09, 2004 08:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.