List:General Discussion« Previous MessageNext Message »
From:Jeff Pang Date:September 29 2011 1:51am
Subject:log event entry exceeded max_allowed_packet; Increase
max_allowed_packet on master
View as plain text  
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@stripped: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.
Thread
log event entry exceeded max_allowed_packet; Increasemax_allowed_packet on masterJeff Pang29 Sep