Re: NOT [solved] Re: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5)
You can manually restart the slave process. On Wed, May 21, 2008 at 9:11 PM, Dominik Klein [EMAIL PROTECTED] wrote: Hello mysql list I posted this problem to the list earlier this month: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5) I was then told to upgrade to the newest version, which I did and which seemed to solve the problem. Today, I got this in my log: 080521 14:18:22 [ERROR] Error reading packet from server: Out of memory (Needed 2848 bytes) ( server_errno=5) 080521 14:18:22 [ERROR] Stopping slave I/O thread due to out-of-memory error from master Now, not only does it report an error, it also stops the slave process instead of auto re-starting it as it did in version 5.0.45 (which I used before). So all slave machines do not replicate until I manually start the slave again. What can I do about this problem? Regards Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: NOT [solved] Re: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5)
Moon's Father schrieb: You can manually restart the slave process. Sure I can. But that's not sufficient. For now, I scripted some log watch thing that re-starts the slave in the particular situation. But this is not good. On Wed, May 21, 2008 at 9:11 PM, Dominik Klein [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hello mysql list I posted this problem to the list earlier this month: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5) I was then told to upgrade to the newest version, which I did and which seemed to solve the problem. Today, I got this in my log: 080521 14:18:22 [ERROR] Error reading packet from server: Out of memory (Needed 2848 bytes) ( server_errno=5) 080521 14:18:22 [ERROR] Stopping slave I/O thread due to out-of-memory error from master Now, not only does it report an error, it also stops the slave process instead of auto re-starting it as it did in version 5.0.45 (which I used before). So all slave machines do not replicate until I manually start the slave again. What can I do about this problem? Regards Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
NOT [solved] Re: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5)
Hello mysql list I posted this problem to the list earlier this month: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5) I was then told to upgrade to the newest version, which I did and which seemed to solve the problem. Today, I got this in my log: 080521 14:18:22 [ERROR] Error reading packet from server: Out of memory (Needed 2848 bytes) ( server_errno=5) 080521 14:18:22 [ERROR] Stopping slave I/O thread due to out-of-memory error from master Now, not only does it report an error, it also stops the slave process instead of auto re-starting it as it did in version 5.0.45 (which I used before). So all slave machines do not replicate until I manually start the slave again. What can I do about this problem? Regards Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [solved] Re: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5)
The general version can not be replaced *frequently * On Fri, May 9, 2008 at 4:23 PM, Dominik Klein [EMAIL PROTECTED] wrote: Upgrade to 5.0.51b seems to have solved the problem. On wednesday, I saw the problem about a dozen times during a peak time. Upgraded wednesday night and have not seen the error since. Thanks Dominik Juan Eduardo Moreno wrote: Hi, This error occur when slave servers could incorrectly interpret an out-of-memory error from the master and reconnect using the wrong binary log position. This was fix in 5.0.48 version. Please, try to update your version ( from 5.0.45) of mysql and try again. regards, Juan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
[solved] Re: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5)
Upgrade to 5.0.51b seems to have solved the problem. On wednesday, I saw the problem about a dozen times during a peak time. Upgraded wednesday night and have not seen the error since. Thanks Dominik Juan Eduardo Moreno wrote: Hi, This error occur when slave servers could incorrectly interpret an out-of-memory error from the master and reconnect using the wrong binary log position. This was fix in 5.0.48 version. Please, try to update your version ( from 5.0.45) of mysql and try again. regards, Juan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5)
Francisco Rodrigo Cortinas Maseda wrote: 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. Well, that was yesterday - so I guess I could. I see the binlog ids where replication stopped and resumed. They match every time. How would I find out that replication resumed at a wrong position? Regards Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5)
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 '[EMAIL PROTECTED]: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 '[EMAIL PROTECTED]: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 '[EMAIL PROTECTED]: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 '[EMAIL PROTECTED]: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 '[EMAIL PROTECTED]:3306',replication resumed in log 'SRV02-bin.000131' at position 665146758 Regards Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5)
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º Stop replication 2º Use mysqlbinlog to see what is on the repl files. 3º Manually apply the changes (on the slave, of course) to a defined position (50K queries far away the failure). 4º 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:[EMAIL PROTECTED] Enviado el: lunes 28 de abril de 2008 16:28 Para: mysql@lists.mysql.com Asunto: Re: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5) 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 '[EMAIL PROTECTED]: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 '[EMAIL PROTECTED]: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 '[EMAIL PROTECTED]: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 '[EMAIL PROTECTED]: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 '[EMAIL PROTECTED]:3306',replication resumed in log 'SRV02-bin.000131' at position 665146758 Regards Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] 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ún sentido. Le rogamos lo comunique al remitente y borre dicho mensaje y cualquier documento adjunto que pudiera contener. El correo electrónico via Internet no permite asegurar la confidencialidad de los mensajes que se transmiten ni su integridad o correcta recepción. JAZZTEL no asume responsabilidad por estas circunstancias. Si el destinatario de este mensaje no consintiera la utilización del correo electrónico via Internet y la grabación de los mensajes, rogamos lo ponga en nuestro conocimiento de forma inmediata.Cualquier opinión expresada en este mensaje pertenece únicamente al autor remitente, y no representa necesariamente la opinión de JAZZTEL, a no ser que expresamente se diga y el remitente esté 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
Re: Error reading packet from server: Out of memory (Needed 6560 bytes) ( server_errno=5)
Hi, This error occur when slave servers could incorrectly interpret an out-of-memory error from the master and reconnect using the wrong binary log position. This was fix in 5.0.48 version. Please, try to update your version ( from 5.0.45) of mysql and try again. regards, Juan On 4/28/08, Dominik Klein [EMAIL PROTECTED] wrote: 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 ' [EMAIL PROTECTED]: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 ' [EMAIL PROTECTED]: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 ' [EMAIL PROTECTED]: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 ' [EMAIL PROTECTED]: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 ' [EMAIL PROTECTED]:3306',replication resumed in log 'SRV02-bin.000131' at position 665146758 Regards Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]