[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Replication troubles


I thought I had most things figured out for our challenging replication
setup. However this morning we have a failure I can't figure out... Here are
the errors:

030613  5:13:50  Slave I/O thread: connected to master 'suppressed:3306',
replication started in log 'binary-log.035' at position 11496356
030613  5:13:50  Error reading packet from server: log event entry exceeded
max_allowed_packet; Increase max_allowed_packet on master
(server_errno=1236)
030613  5:13:50  Got fatal error 1236: 'log event entry exceeded
max_allowed_packet; Increase max_allowed_packet on master' from master when
reading data from binary log
030613  5:13:50  Slave I/O thread exiting, read up to log 'binary-log.035',
position 11496356


In the case of both the master and the slave the max_allowed_packet is set
to 1047552. In both cases I raised it to 2047552 just to be generous. Same
failure.

I can stop and start this slave as it's not in live production, I can't stop
and start the master which feeds live discussion boards.

Any ideas?

Best Regards, Bruce


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/suppressed


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.