MySQL Bugs: #8114: Error reading packet from server: Lost connection to MySQL server during query

Bug #8114	Error reading packet from server: Lost connection to MySQL server during query
Submitted:	24 Jan 2005 15:59	Modified:	25 Feb 2005 6:42
Reporter:	Jesse Tutt	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S1 (Critical)
Version:		OS:	Windows (Windows 2000)
Assigned to:		CPU Architecture:	Any

Description:
I am receiving the following error every 1 hour in the event log.

"Event Type:	Error
Event Source:	MySQL
Event Category:	None
Event ID:	100
Date:		1/24/2005
Time:		8:05:03 AM
User:		N/A
Computer:	*SERVERNAME*
Description:
Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013)

For more information, see Help and Support Center at http://www.mysql.com.   
"

This error is filling up out event logs.  Replication is key but we are unable to easily filter the event logs for important events with the mass of errors that are currently in the logs due to MYSQL.

Thanks!
Jesse Tutt 

How to repeat:
This error is recurring every 1 hour.

Hi!
We need more info. Could you please attach mysql error log? It must be in data directory, the file with .err extension.

I have the same problem with a 4.1.7 slave to a 3.23.51 master:

050220 17:00:03 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013)
050220 17:00:03 [ERROR] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'xxxxxxxx3-bin.446' position 73
050220 17:00:03 [Note] Slave: connected to master 'xxxxxxxx2_slave@xxxxxxxx3:3306',replication resumed in log 'xxxxxxxx3-bin.446' at position 73
050220 18:00:04 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013)
050220 18:01:04 [ERROR] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'xxxxxxxx3-bin.446' position 73
050220 18:01:04 [Note] Slave: connected to master 'xxxxxxxx2_slave@xxxxxxxx3:3306',replication resumed in log 'xxxxxxxx3-bin.446' at position 73
050220 19:01:05 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013)
050220 19:02:05 [ERROR] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'xxxxxxxx3-bin.446' position 73
050220 19:02:05 [Note] Slave: connected to master 'xxxxxxxx2_slave@xxxxxxxx3:3306',replication resumed in log 'xxxxxxxx3-bin.446' at position 73
050220 20:02:06 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013)
050220 20:03:06 [ERROR] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'xxxxxxxx3-bin.446' position 73
050220 20:03:06 [Note] Slave: connected to master 'xxxxxxxx2_slave@xxxxxxxx3:3306',replication resumed in log 'xxxxxxxx3-bin.446' at position 73
050220 22:00:02 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013)
050220 22:00:02 [ERROR] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'xxxxxxxx3-bin.447' position 73
050220 22:00:03 [Note] Slave: connected to master 'xxxxxxxx2_slave@xxxxxxxx3:3306',replication resumed in log 'xxxxxxxx3-bin.447' at position 73

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".

With some 30 PHP/Apache boxes connecting to a unix MySQL server I see large numbers of these in the master error log file. I filter them out with grep before attempting to do any serious analysis of the error log file. That filtering makes this only an inconvenience on unix.

For web sites with many connections and many normal and routine connection errors this is an error message which it would be good to be able to disable or rate limit.

Ask if you'd like a sample .err.bz2 file to examine to find the messages most in need of filtering.

I am seeing this error too. Any ideas what's going on? 
060824 11:52:46 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
060824 11:52:46 [Note] Slave I/O thread killed while reading event