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
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]
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:
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
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
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
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 |
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
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,