Bug #74506 Packets out of order
Submitted: 22 Oct 2014 13:06 Modified: 15 Nov 2015 20:14
Reporter: Ezequiel Alvarez Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Connection Handling Severity:S1 (Critical)
Version:5.5.40 OS:Linux (Ubuntu 14.04)
Assigned to: CPU Architecture:Any

[22 Oct 2014 13:06] Ezequiel Alvarez
Description:
I'm having problems when I was working with mysql. Sometimes the connection, doing a specific select, started to return  :
-Packets out of order, or
-Connection lost during query, or
-Error reading communication packets.

I solved this optimizing the tables of the database where the select is executed. But after some time start to do it again.

I realized that is common to happen when a heavy SQL is executed. That broke a table of database of the server.

I analyze everything in :
-http://dev.mysql.com/doc/refman/5.5/en/gone-away.html, and
-http://dev.mysql.com/doc/refman/5.5/en/communication-errors.html

How to repeat:
I realized that is common to happen when a heavy SQL is executed. That broke a table of database of the server.
[15 Oct 2015 20:14] Miguel Solorzano
Thank you for the bug report. Which client are you using (own application?).
[16 Nov 2015 1: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".