Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 SELECT COUNT(*) = 3 FROM mysql.wsrep_allowlist;
4 COUNT(*) = 3
5 1
6 connection node_2;
7 SELECT COUNT(*) = 3 FROM mysql.wsrep_allowlist;
8 COUNT(*) = 3
9 1
10 connection node_1;
11 connection node_2;
12 connection node_3;
13 connection node_3;
14 SET @@global.wsrep_desync = 1;
15 SET SESSION wsrep_sync_wait = 0;
16 SET GLOBAL wsrep_provider_options = 'gmcast.isolate=1';
17 connection node_1;
18 DELETE FROM mysql.wsrep_allowlist WHERE ip LIKE '127.0.0.3';
19 SELECT COUNT(*) = 2 FROM mysql.wsrep_allowlist;
20 COUNT(*) = 2
21 1
22 connection node_2;
23 SELECT COUNT(*) = 2 FROM mysql.wsrep_allowlist;
24 COUNT(*) = 2
25 1
26 connection node_3;
27 SET GLOBAL wsrep_provider_options = 'gmcast.isolate=0';
28 SET @@global.wsrep_desync = 0;
29 connection node_1;
30 INSERT INTO mysql.wsrep_allowlist(ip) VALUES ('127.0.0.3');
31 connection node_3;
32 # restart
33 connection node_1;
34 CALL mtr.add_suppression('WSREP: Connection not allowed');
35 connection node_2;
36 CALL mtr.add_suppression('WSREP: Connection not allowed');
37 connection node_3;
38 CALL mtr.add_suppression('WSREP: Ignoring lack of quorum');