Today on a slave I got (this actually has occured several times in the past months): Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'xxx-bin.040' at position 47694 010511 10:37:19 Error reading packet from server: log event entry exceeded max_allowed_packet - increase max_allowed_packet on master (read_errno 0,server_errno=65535) 010511 10:37:19 Slave: Failed reading log event, reconnecting to retry, log 'xxx-bin.040' position 47694 010511 10:37:19 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'xxx-bin.040' at position 47694 010511 10:37:19 Error reading packet from server: log event entry exceeded max_allowed_packet - increase max_allowed_packet on master (read_errno 0,server_errno=65535) 010511 10:37:31 Slave thread killed while waiting to reconnect after a failed read Then I looked on the master: $ mysqlbinlog xxx-bin.040 | more # at 47032 #010511 8:26:40 server id 1 Query thread_id=1044 exec_time=0 error_code=0 use Xxx; SET TIMESTAMP=989562400; UPDATE xxx set n=n+1,date='2001-05-11 8:26:40' where id='72'; # at 47160 #010511 8:26:40 server id 1 Query thread_id=1044 exec_time=0 error_code=0 Note that the 47694 position does not exist. So I did the following on the slave (picked the valid position right before 47694): > change master to master_log_pos = 47672; then restarted the slave and it now works. Suggestion: maybe the error message in the log could be changed from: * Error reading packet from server: log event entry exceeded max_allowed_packet - increase max_allowed_packet on master (read_errno 0,server_errno=65535) to: * Error: position 47694 does not exist in log 'xxx-bin.040' What do you think? -- Jean-Luc Fontaine SQL MySQL --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
