From: Date: April 28 2008 5:02pm Subject: RE: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5) List-Archive: http://lists.mysql.com/mysql/212560 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I have experienced similar problems to the one you have; the problem you = have is that the time gap between the failure and now is so big that you = cannot resume replication, because of the big data portion you have to = replicate. When this happens to me, increasing the value of the variable you have = posted did not work; i did: 1=BA Stop replication 2=BA Use mysqlbinlog to see what is on the repl files. 3=BA Manually apply the changes (on the slave, of course) to a defined = position (50K queries far away the failure). 4=BA Start replication on this position, manually especifying the = position on the command "start slave" (see manual). This worked fine to me. Regards. -----Mensaje original----- De: Dominik Klein [mailto:dk@stripped]=20 Enviado el: lunes 28 de abril de 2008 16:28 Para: mysql@stripped Asunto: Re: Error reading packet from server: Out of memory (Needed 6560 = bytes) ( server_errno=3D5) 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=20 involved in this: 080428 13:07:04 [ERROR] Error reading packet from server: Out of memory=20 (Needed 2704 bytes) ( server_errno=3D5) 080428 13:07:04 [Note] Slave I/O thread: Failed reading log event,=20 reconnecting to retry, log 'SRV02bin.000131' position 447892967 080428 = 13:07:04 [Note] Slave: connected to master=20 'mmrepli@stripped:3306',replication resumed in log=20 'SRV02-bin.000131' at position 447892967 080428 13:22:14 [ERROR] Error reading packet from server: Out of memory=20 (Needed 2704 bytes) ( server_errno=3D5) 080428 13:22:14 [Note] Slave I/O thread: Failed reading log event,=20 reconnecting to retry, log 'SRV02-bin.000131' position 471157588 080428 = 13:22:14 [Note] Slave: connected to master=20 'mmrepli@stripped:3306',replication resumed in log=20 'SRV02-bin.000131' at position 471157588 080428 14:38:06 [ERROR] Error reading packet from server: Out of memory=20 (Needed 3464 bytes) ( server_errno=3D5) 080428 14:38:06 [Note] Slave I/O thread: Failed reading log event,=20 reconnecting to retry, log 'SRV02-bin.000131' position 583864714 080428 = 14:38:06 [Note] Slave: connected to master=20 'mmrepli@stripped:3306',replication resumed in log=20 'SRV02-bin.000131' at position 583864714 080428 15:13:24 [ERROR] Error reading packet from server: Out of memory=20 (Needed 3128 bytes) ( server_errno=3D5) 080428 15:13:24 [Note] Slave I/O thread: Failed reading log event,=20 reconnecting to retry, log 'SRV02-bin.000131' position 635409380 080428 = 15:13:24 [Note] Slave: connected to master=20 'mmrepli@stripped:3306',replication resumed in log=20 'SRV02-bin.000131' at position 635409380 080428 15:32:14 [ERROR] Error reading packet from server: Out of memory=20 (Needed 2688 bytes) ( server_errno=3D5) 080428 15:32:14 [Note] Slave I/O thread: Failed reading log event,=20 reconnecting to retry, log 'SRV02-bin.000131' position 665146758 080428 = 15:32:14 [Note] Slave: connected to master=20 'mmrepli@stripped:3306',replication resumed in log=20 'SRV02-bin.000131' at position 665146758 Regards Dominik --=20 MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: = http://lists.mysql.com/mysql?unsub=3Dfrancisco.cortinas@stripped Antes de imprimir este e-mail piense bien si es necesario hacerlo. Antes de imprimir este e-mail piense bien si es necesario hacerlo. ********* Este mensaje es privado y CONFIDENCIAL y se dirige exclusivamente a su = destinatario. Si usted ha recibido este mensaje por error, no debe = revelar, copiar, distribuir o usarlo en ning=FAn sentido. Le rogamos lo = comunique al remitente y borre dicho mensaje y cualquier documento = adjunto que pudiera contener. El correo electr=F3nico via Internet no = permite asegurar la confidencialidad de los mensajes que se transmiten = ni su integridad o correcta recepci=F3n. JAZZTEL no asume = responsabilidad por estas circunstancias. Si el destinatario de este = mensaje no consintiera la utilizaci=F3n del correo electr=F3nico via = Internet y la grabaci=F3n de los mensajes, rogamos lo ponga en nuestro = conocimiento de forma inmediata.Cualquier opini=F3n expresada en este = mensaje pertenece =FAnicamente al autor remitente, y no representa = necesariamente la opini=F3n de JAZZTEL, a no ser que expresamente se = diga y el remitente est=E9 autorizado para hacerlo. ********* This message is private and CONFIDENTIAL and it is intended exclusively = for its addressee. If you receive this message in error, you should not = disclose, copy, distribute this e-mail or use it in any other way. = Please inform the sender and delete the message and attachments from = your system.Internet e-mail neither guarantees the confidentiality nor = the integrity or proper receipt of the messages sent. JAZZTEL does not = assume any liability for those circumstances. If the addressee of this = message does not consent to the use of Internet e-mail and message = recording, please notify us immediately.Any views or opinions contained = in this message are solely those of the author, and do not necessarily = represent those of JAZZTEL, unless otherwise specifically stated and the = sender is authorised to do so.=20 *********