MySQL Forums
Forum List  »  MySQL Query Browser

Error 2013: Lost Connection To Mysql Server During Query
Posted by: ajay naga
Date: April 14, 2012 03:16AM

I am using MySQL version 5.5.14 , And My application is connecting to DB for customer
details . Now I am getting 2013 error on all select queries(which returns single result
only) and when ever I got this error i am checking in MySQL console on that query. Below
details are the observations at that moment.

1. Same query copy from my application and paste in MySQL console and execute i am
getting 2013 error. Now i give a space(No syntax changes) in the query 2013 error is not
coming.

2. The table status is OK. (command : check table table_name )

3. After 2 or 3 min the 2013 error is clearing. And the same executing properly. Or if i repair the table it is resolving temporarly.
But every 5 min i can not wait or repair table.

4.In the DB error , it is filled with below warning.
[Warning] Aborted connection 36 to db: 'storage' user:
'customer' host: 'xx.xx.xx.xx' (Got an error reading communication packets).


Can anybody tell me why it is happening and how to reproduce this issue and resolve it as well.

Thanks in advance.



Edited 1 time(s). Last edit at 04/14/2012 04:32AM by ajay naga.

Options: ReplyQuote


Subject
Written By
Posted
Error 2013: Lost Connection To Mysql Server During Query
April 14, 2012 03:16AM


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.