log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master
Hello, In last day I inserted a SQL which is about 5M to the master, the max_allowed_packet in both master and slave was 4M at that time. Then the replication crached, and the info is below: 110928 23:31:53 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.002730' at position 52953235, relay log './mysqld-relay-bin.006210' position: 52953380 110928 23:31:53 [Note] Slave I/O thread: connected to master 'mysqlrepl@119.147.163.137:3306',replication started in log 'mysql-bin.002730' at position 54657199 110928 23:31:53 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with SLAVE START. We stopped at log 'mysql-bin.002730' position 52953235 110928 23:31:53 [ERROR] Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master ( server_errno=1236) 110928 23:31:53 [ERROR] 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 110928 23:31:53 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.002730', position 54657199 I tried to increase the value of max_allowed_packet in both master and slave to 1G: mysql show variables like 'max_allowed_packet'; +++ | Variable_name | Value | +++ | max_allowed_packet | 1073741824 | +++ 1 row in set (0.00 sec) (And restarted both master and slave). But when I start slave, the problem is still there,with the same error log. Please help, thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
log event entry exceeded max_allowed_packet
Is there any way I can find out how big I should set max_allowed_packet? I have changed it from the default 1M to 32M, but I still get that error. Or is it a bug? We use MySQL 4.0.12 on the slave and 4.0.15-max on the master. How big should I set max_allowed_packet? The servers are dual Pentium with 2G ram. Thanks for any help. Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: log event entry exceeded max_allowed_packet
Hello. In my opinion (it is based on looking through the source code, but I can be wrong) - the max_allowed_packet should be at least more than any event in the master's binary log. The tool for researching binary logs is mysqlbinlog utility. See: http://dev.mysql.com/doc/mysql/en/mysqlbinlog.html http://dev.mysql.com/doc/mysql/en/Binary_log.html Your versions of MySQL are very old, I recommend you to upgrade, lots of bugs have been fixed since these releases. Jacob Friis [EMAIL PROTECTED] wrote: Is there any way I can find out how big I should set max_allowed_packet? I have changed it from the default 1M to 32M, but I still get that error. Or is it a bug? We use MySQL 4.0.12 on the slave and 4.0.15-max on the mast= er. How big should I set max_allowed_packet? The servers are dual Pentium with 2G ram. Thanks for any help. Jacob -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: log event entry exceeded max_allowed_packet
packet too big errors in replication are often a sign of corrupt binary logs. If it's on a slave reading the relay log often times flushing it will temporarily solve the problem. The easiest way to flush the relay logs is to do a slave stop; change master to back to the current file name and position. MySQL will delete all the current relay logs, open new ones and redownload any unprocessed events from the master. Gleb Paharenko wrote: Hello. In my opinion (it is based on looking through the source code, but I can be wrong) - the max_allowed_packet should be at least more than any event in the master's binary log. The tool for researching binary logs is mysqlbinlog utility. See: http://dev.mysql.com/doc/mysql/en/mysqlbinlog.html http://dev.mysql.com/doc/mysql/en/Binary_log.html Your versions of MySQL are very old, I recommend you to upgrade, lots of bugs have been fixed since these releases. Jacob Friis [EMAIL PROTECTED] wrote: Is there any way I can find out how big I should set max_allowed_packet? I have changed it from the default 1M to 32M, but I still get that error. Or is it a bug? We use MySQL 4.0.12 on the slave and 4.0.15-max on the mast= er. How big should I set max_allowed_packet? The servers are dual Pentium with 2G ram. Thanks for any help. Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
log event entry exceeded max_allowed_packet error: findings (again)
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
: log event entry exceeded max_allowed_packet
Hello, I'm trying to set up replication, but I cant get any further than this message on the slave. Error reading packet from server: log event entry exceeded max_allowed_packet My max allowed packet size is 512M which I've gradually reached while trying to stop the above error message. Is this the real problem or is there another issue causing this ? Cheers Steve Goodliff
log event entry exceeded max_allowed_packet error: findings
Today on a slave I got: 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 = 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? -- SQL Jean-Luc Fontaine - 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