Debian Codegraph @

mysql-test/suite/rpl/t/rpl_binlog_rollback_cleanup.test

raw
1 # ==== Purpose ====
2 #
3 # Test verifies that when flushing an event to binary log fails the transaction
4 # is successfully rolled back and following COMMIT command doesn't report any
5 # assert.
6 #
7 # ==== Implementation ====
8 #
9 # Steps:
10 # 0 - SET max_binlog_cache_size=64K
11 # 1 - Create an Innodb table and insert required amount of data. Execute an
12 # UPDATE operation which generates a big update event whose size exceeds
13 # max_binlog_cache_size.
14 # 2 - Wait for error 1197. Execute COMMIT command.
15 # 3 - COMMIT should be successful.
16 #
17 # ==== References ====
18 #
19 # MDEV-18514: Assertion `!writer.checksum_len || writer.remains == 0' failed
20 #
21 --source include/have_innodb.inc
22 --source include/have_binlog_format_row.inc
23 --source include/master-slave.inc
24 --connection master
25 let $old_max_binlog_cache_size= query_get_value(SHOW VARIABLES LIKE "max_binlog_cache_size", Value, 1);
26 SET GLOBAL max_binlog_cache_size = 65536;
27 CREATE TABLE t1(a INT PRIMARY KEY, data VARCHAR(30000)) ENGINE=INNODB CHARSET=latin1;
28 let $data = `select concat('"', repeat('a',6000), '"')`;
29 let $data1 = `select concat('"', repeat('b',6000), '"')`;
30 --disable_query_log
31 eval INSERT INTO t1 (a, data) VALUES (1, CONCAT($data, $data));
32 eval INSERT INTO t1 (a, data) VALUES (2, CONCAT($data, $data));
33 eval INSERT INTO t1 (a, data) VALUES (3, CONCAT($data, $data));
34 eval INSERT INTO t1 (a, data) VALUES (4, CONCAT($data, $data));
35 eval INSERT INTO t1 (a, data) VALUES (5, CONCAT($data, $data));
36 START TRANSACTION;
37 --error ER_TRANS_CACHE_FULL
38 eval UPDATE t1 SET data=$data1;
39 COMMIT;
40 --enable_query_log
41
42 --replace_result $old_max_binlog_cache_size ORIGINAL_VALUE
43 --eval SET GLOBAL max_binlog_cache_size= $old_max_binlog_cache_size
44 DROP TABLE t1;
45
46 --source include/rpl_end.inc