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