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