Debian Codegraph @

mysql-test/suite/galera_sr/r/galera_sr_cc_slave.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 connection node_2;
6 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
7 COUNT(*) = 0
8 1
9 connection node_1;
10 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
11 COUNT(*) = 0
12 1
13 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
14 SET SESSION wsrep_trx_fragment_size = 1;
15 SET AUTOCOMMIT=OFF;
16 START TRANSACTION;
17 INSERT INTO t1 VALUES (1);
18 INSERT INTO t1 VALUES (2);
19 INSERT INTO t1 VALUES (3);
20 INSERT INTO t1 VALUES (4);
21 INSERT INTO t1 VALUES (5);
22 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
23 COUNT(*) > 0
24 1
25 connection node_2;
26 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
27 COUNT(*) > 0
28 1
29 connection node_2;
30 SET GLOBAL wsrep_cluster_address = '';
31 SET SESSION wsrep_sync_wait = 0;
32 SET SESSION wsrep_sync_wait = default;
33 connection node_1;
34 SET innodb_snapshot_isolation=OFF;
35 INSERT INTO t1 VALUES (6);
36 INSERT INTO t1 VALUES (7);
37 INSERT INTO t1 VALUES (8);
38 INSERT INTO t1 VALUES (9);
39 INSERT INTO t1 VALUES (10);
40 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
41 COUNT(*) > 0
42 1
43 connection node_2;
44 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
45 COUNT(*) > 0
46 1
47 connection node_1;
48 INSERT INTO t1 VALUES (11);
49 INSERT INTO t1 VALUES (12);
50 INSERT INTO t1 VALUES (13);
51 INSERT INTO t1 VALUES (14);
52 INSERT INTO t1 VALUES (16);
53 COMMIT;
54 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
55 COUNT(*) = 0
56 1
57 connection node_2;
58 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
59 COUNT(*) = 0
60 1
61 DROP TABLE t1;
62 CALL mtr.add_suppression("points to own listening address, blacklisting");