List:Replication« Previous MessageNext Message »
From:Iwan Aucamp Date:September 29 2009 1:30pm
Subject:Binlog contains event bigger than max value of max_allowed_packet
View as plain text  
binlog event details :

mysqlbinlog --start-position=31440700 --stop-position=31440800
/opt/csw/mysql5/var/mysql-bin.000002
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
ERROR: Error in Log_event::read_log_event(): 'Event too big', data_len:
1380272215, event_type: 48
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;

Details for max_allowed_packet
Command Line Format --max_allowed_packet=#
Config File Format max_allowed_packet
Option Sets Variable Yes, max_allowed_packet
Variable Name max_allowed_packet
Variable Scope Both
Dynamic Variable Yes
Permitted Values Type numeric
Default 1048576
*Range 1024-1073741824**
*

Is there any good reason this is allowed to happen ? and how do i work
around it ?

Regards
*
*

Thread
Binlog contains event bigger than max value of max_allowed_packetIwan Aucamp29 Sep