>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.
In order for changes to the max_allowed_packet to take effect, you'll need to restart mysqld on that server. Cheers, Andrew -----Original Message----- From: Bruce Dembecki [mailto:[EMAIL PROTECTED] Sent: Friday 13 June 2003 13:24 To: [EMAIL PROTECTED] Subject: 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 '[EMAIL PROTECTED]: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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
