MySQL Forums :: JDBC and Java :: intermittent mysql remote syntax error exception
intermittent mysql remote syntax error exception
Posted by: Bryan Kramer
Date: November 15, 2012 09:02PM
From time to time one of my mysql clients starts reporting
ERROR 1054 (42S22): Unknown column 'xxx' in 'field list'
for queries to a mysql 5.0.17 server (stuck on a vanilla centos 5 server installation) on a different host. This happens both through the mysql command line and through a java application using jdbc. At the same time clients on other hosts can still successfully issue this query both through mysql command line and jdbc. Eventually the client where the query was failing (15 min?) starts working again for a time.
Does anyone know if there are configuration settings that might affect this behaviour? There are no error messages in the mysql log on the server.
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.