Debian Codegraph @

mysql-test/suite/wsrep/t/wsrep_rpl.test

raw
1 --source include/have_wsrep.inc
2 --source include/have_innodb.inc
3 --source include/master-slave.inc
4
5 --echo #
6 --echo # MDEV-10714: Could not execute Delete_rows event on table;
7 --echo # wsrep_max_ws_rows exceeded. Error_Code 1180
8 --echo #
9 # Save wsrep_max_ws_rows on master and slave.
10 connection master;
11 let $wsrep_max_ws_rows_master = `SELECT @@GLOBAL.wsrep_max_ws_rows`;
12 connection slave;
13 let $wsrep_max_ws_rows_slave = `SELECT @@GLOBAL.wsrep_max_ws_rows`;
14
15 connection master;
16 CREATE TABLE t1(i INT) ENGINE = INNODB;
17
18 SET @@GLOBAL.wsrep_max_ws_rows = 2;
19 INSERT INTO t1 VALUES(1), (2);
20 sync_slave_with_master;
21 SELECT COUNT(*) = 2 FROM t1;
22
23 connection slave;
24 SET @@GLOBAL.wsrep_max_ws_rows = 2;
25
26 connection master;
27 DELETE FROM t1;
28
29 sync_slave_with_master;
30 SELECT COUNT(*) = 0 FROM t1;
31
32 connection master;
33 DROP TABLE t1;
34
35 sync_slave_with_master;
36 # Restore wsrep_max_ws_rows on master and slave
37 connection master;
38 eval SET @@GLOBAL.wsrep_max_ws_rows = $wsrep_max_ws_rows_master;
39 connection slave;
40 eval SET @@GLOBAL.wsrep_max_ws_rows = $wsrep_max_ws_rows_slave;
41
42 --source include/rpl_end.inc
43 --echo # End of test.