Debian Codegraph @

mysql-test/suite/galera/r/galera_bf_abort_mariabackup.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 # Case 1 : MariaBackup SST
6 connection node_1;
7 CREATE TABLE t(i INT NOT NULL PRIMARY KEY) ENGINE INNODB;
8 INSERT INTO t VALUES(1);
9 # Restart node_2, force SST.
10 connection node_2;
11 connection node_1;
12 connection node_2;
13 Starting server ...
14 connection node_1;
15 # Both should return NOT FOUND as we have mariabackup with backup locks
16 NOT FOUND /Desyncing and pausing the provider/ in mysqld.1.err
17 NOT FOUND /Resuming and resyncing the provider/ in mysqld.1.err
18 connection node_1;
19 SET GLOBAL wsrep_mode = "BF_ABORT_MARIABACKUP";
20 # Restart node_2, force SST.
21 connection node_2;
22 connection node_1;
23 INSERT INTO t VALUES(2);
24 connection node_2;
25 Starting server ...
26 connection node_2;
27 connection node_1;
28 # Both should return NOT FOUND as we have mariabackup with backup locks
29 NOT FOUND /Desyncing and pausing the provider/ in mysqld.1.err
30 NOT FOUND /Resuming and resyncing the provider/ in mysqld.1.err
31 SET GLOBAL wsrep_mode = "";
32 DROP TABLE t;
33 # Case 2: MariaBackup backup from node_2
34 connection node_1;
35 CREATE TABLE t(i INT NOT NULL PRIMARY KEY) ENGINE INNODB;
36 INSERT INTO t VALUES(1),(2),(3),(4),(5);
37 connection node_2;
38 SET GLOBAL wsrep_mode = "";
39 SELECT @@wsrep_mode;
40 @@wsrep_mode
41
42 # Both should return FOUND 1 as we have backup
43 FOUND 1 /Desyncing and pausing the provider/ in mysqld.2.err
44 FOUND 1 /Resuming and resyncing the provider/ in mysqld.2.err
45 SET GLOBAL wsrep_mode = "BF_ABORT_MARIABACKUP";
46 SELECT @@wsrep_mode;
47 @@wsrep_mode
48 BF_ABORT_MARIABACKUP
49 # Both should return FOUND 2 because both backups do desync but on different points
50 FOUND 2 /Desyncing and pausing the provider/ in mysqld.2.err
51 FOUND 2 /Resuming and resyncing the provider/ in mysqld.2.err
52 # Should return FOUND 1 as server did not desync at BLOCK_DDL
53 FOUND 1 /Server not desynched from group at BLOCK_DDL because WSREP_MODE_BF_MARIABACKUP is used./ in mysqld.2.err
54 # Should return FOUND 1 as server did desync and pause at BLOCK_COMMIT
55 FOUND 1 /Server desynched from group during BACKUP STAGE BLOCK_COMMIT./ in mysqld.2.err
56 SET GLOBAL wsrep_mode = DEFAULT;
57 connection node_1;
58 DROP TABLE t;
59 disconnect node_2;
60 disconnect node_1;