From: Date: April 28 2008 4:28pm
Subject: Re: Error reading packet from server: Out of memory (Needed 6560
 bytes) ( server_errno=5)
List-Archive: http://lists.mysql.com/mysql/212559
Message-Id: <4815DF00.1020007@in-telegence.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi.

Juan Eduardo Moreno wrote:
> Sorry, what is your setting for max_allowed_packet variable?

mysql> show variables like "%allowed%";
+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| max_allowed_packet | 16776192 |
+--------------------+----------+
1 row in set (0.00 sec)

Here's an excerpt from the logs. It does not look like that value is 
involved in this:

080428 13:07:04 [ERROR] Error reading packet from server: Out of memory 
(Needed 2704 bytes) ( server_errno=5)
080428 13:07:04 [Note] Slave I/O thread: Failed reading log event, 
reconnecting to retry, log 'SRV02bin.000131' position 447892967
080428 13:07:04 [Note] Slave: connected to master 
'mmrepli@stripped:3306',replication resumed in log 
'SRV02-bin.000131' at position 447892967
080428 13:22:14 [ERROR] Error reading packet from server: Out of memory 
(Needed 2704 bytes) ( server_errno=5)
080428 13:22:14 [Note] Slave I/O thread: Failed reading log event, 
reconnecting to retry, log 'SRV02-bin.000131' position 471157588
080428 13:22:14 [Note] Slave: connected to master 
'mmrepli@stripped:3306',replication resumed in log 
'SRV02-bin.000131' at position 471157588
080428 14:38:06 [ERROR] Error reading packet from server: Out of memory 
(Needed 3464 bytes) ( server_errno=5)
080428 14:38:06 [Note] Slave I/O thread: Failed reading log event, 
reconnecting to retry, log 'SRV02-bin.000131' position 583864714
080428 14:38:06 [Note] Slave: connected to master 
'mmrepli@stripped:3306',replication resumed in log 
'SRV02-bin.000131' at position 583864714
080428 15:13:24 [ERROR] Error reading packet from server: Out of memory 
(Needed 3128 bytes) ( server_errno=5)
080428 15:13:24 [Note] Slave I/O thread: Failed reading log event, 
reconnecting to retry, log 'SRV02-bin.000131' position 635409380
080428 15:13:24 [Note] Slave: connected to master 
'mmrepli@stripped:3306',replication resumed in log 
'SRV02-bin.000131' at position 635409380
080428 15:32:14 [ERROR] Error reading packet from server: Out of memory 
(Needed 2688 bytes) ( server_errno=5)
080428 15:32:14 [Note] Slave I/O thread: Failed reading log event, 
reconnecting to retry, log 'SRV02-bin.000131' position 665146758
080428 15:32:14 [Note] Slave: connected to master 
'mmrepli@stripped:3306',replication resumed in log 
'SRV02-bin.000131' at position 665146758

Regards
Dominik