Description:
The master and the slave set the maximum value of parameter max_allowed_packet, the master can be successfully executed, but the slave will fail, and the error is 1236. Due to parameter constraints, this caused a replication exception.
Last_IO_Errno 1236
Last_IO_Error Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master; the first event '' at 4, the last event read from './master-bin.000001' at 1544, the last byte read from './master-bin.000001' at 1563.
How to repeat:
test-mater.opt
--max_allowed_packet=1073741824
test-slave.opt
--max_allowed_packet=1073741824
test.test
--source include/master-slave.inc
CREATE TABLE LONGTEXT_001(id int PRIMARY KEY not null, c_longtext LONGTEXT);
delimiter $$;
create procedure proc_001(in id_value int,in longtext_value longtext)
begin
insert into LONGTEXT_001(id, c_longtext) values(id_value, longtext_value);
end$$
delimiter ;$$
call proc_001(101, concat((select repeat('a',943718400)), (select repeat('a',130023424)))); call proc_longtext_boundary_insert_002(104, concat((select repeat('中',314572800)), (select repeat('中',43341141))));
--source include/sync_slave_sql_with_master.inc
--source include/rpl_end.inc
Description: The master and the slave set the maximum value of parameter max_allowed_packet, the master can be successfully executed, but the slave will fail, and the error is 1236. Due to parameter constraints, this caused a replication exception. Last_IO_Errno 1236 Last_IO_Error Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master; the first event '' at 4, the last event read from './master-bin.000001' at 1544, the last byte read from './master-bin.000001' at 1563. How to repeat: test-mater.opt --max_allowed_packet=1073741824 test-slave.opt --max_allowed_packet=1073741824 test.test --source include/master-slave.inc CREATE TABLE LONGTEXT_001(id int PRIMARY KEY not null, c_longtext LONGTEXT); delimiter $$; create procedure proc_001(in id_value int,in longtext_value longtext) begin insert into LONGTEXT_001(id, c_longtext) values(id_value, longtext_value); end$$ delimiter ;$$ call proc_001(101, concat((select repeat('a',943718400)), (select repeat('a',130023424)))); call proc_longtext_boundary_insert_002(104, concat((select repeat('中',314572800)), (select repeat('中',43341141)))); --source include/sync_slave_sql_with_master.inc --source include/rpl_end.inc