ERROR 1430... 2013: Lost connection to MySQL server
Posted by:
Rob Blick
Date: November 16, 2005 11:41AM
Hey guys-
Anyone else seen this... after I create a federated connection, the remote server will tear down the connection after the wait_timeout expires on that server. The next time I query the federated table, I get the following error:
ERROR 1430 (HY000): There was a problem processing the query on the foreign data source. Data source error: ': 2013 : Lost connection to MySQL server during query'
If I immediately rerun the query, all is fine. What appears to be happening is that the client server (the server which has the CREATE TABLE ... ENGINE=FEDERATED on it) doesn't try to re-establish the connection with the remote server (the one w/ the federated table physically stored on it) before returning the error.
I've opened a bug on this guy (http://bugs.mysql.com/bug.php?id=14874) but it has apparently gotten lost in "can't repeat" status (I added a more complete test case after it got bumped to "can't repeat"). While I'm waiting on it to bubble back up to the top of the bug queue - has anyone else seen this error, and if so, did you come up with a workaround?
Thanks!
Rob
Subject
Views
Written By
Posted
ERROR 1430... 2013: Lost connection to MySQL server
10182
November 16, 2005 11:41AM
5066
December 16, 2006 06:10AM
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.