Debian Codegraph @

mysql-test/suite/galera_3nodes/r/galera_garbd_backup.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 connection node_3;
6 connection node_1;
7 SET GLOBAL innodb_max_dirty_pages_pct=0.0;
8 SET GLOBAL innodb_max_dirty_pages_pct_lwm=0.0;
9 SET GLOBAL innodb_max_dirty_pages_pct=99;
10 SET GLOBAL innodb_max_dirty_pages_pct_lwm=99;
11 CREATE TABLE t1 (f1 INTEGER, f2 varchar(1024)) Engine=InnoDB;
12 CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
13 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
14 INSERT INTO t1 (f2) SELECT REPEAT('x', 1024) FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
15 FLUSH TABLES WITH READ LOCK;
16 UNLOCK TABLES;
17 connection node_2;
18 SELECT COUNT(*) FROM t1;
19 COUNT(*)
20 10000
21 SELECT COUNT(*) FROM ten;
22 COUNT(*)
23 10
24 Killing node #3 to free ports for garbd ...
25 connection node_3;
26 connection node_1;
27 SET GLOBAL debug_dbug = "+d,sync.wsrep_donor_state";
28 Starting garbd ...
29 SET SESSION debug_sync = "now WAIT_FOR sync.wsrep_donor_state_reached";
30 SET GLOBAL innodb_max_dirty_pages_pct_lwm=0.0;
31 SET GLOBAL innodb_max_dirty_pages_pct=0.0;
32 SET SESSION debug_sync = "now SIGNAL signal.wsrep_donor_state";
33 SET GLOBAL debug_dbug = "";
34 SET debug_sync='RESET';
35 connection node_1;
36 Killing garbd ...
37 connection node_1;
38 connection node_2;
39 DROP TABLE t1;
40 DROP TABLE ten;
41 Restarting node #3 to satisfy MTR's end-of-test checks
42 connection node_3;
43 connection node_1;