Hi Bruce, I dont know the solution, but error 1236 is a server issue as described below. Starting and stopping the slave wont help anything. Are you sure that the servers binary log is not corrupted ?
Try to reset the master. 4.10.7.5 RESET MASTER (master) Deletes all binary logs listed in the index file, resetting the binlog index file to be empty. Previously named FLUSH MASTER . By doing this you eliminate all old master file and start over at FILENAME-bin-001 position 79. Best regards Nils Valentin Tokyo/Japan 2003年 6月 13日 金曜日 21:23、Bruce Dembecki さんは書きました: > 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 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
