Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 SELECT WSREP_LAST_WRITTEN_GTID();
4 WSREP_LAST_WRITTEN_GTID()
5 100-1-0
6 connection node_1;
7 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
8 INSERT INTO t1 VALUES (1);
9 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;;
10 connection node_1a;
11 SELECT WSREP_LAST_WRITTEN_GTID() != '100-1-2' AS wsrep_written_does_not_match_different_conn;
12 wsrep_written_does_not_match_different_conn
13 1
14 connection node_2;
15 SELECT WSREP_LAST_WRITTEN_GTID() != '100-1-2' AS wsrep_written_does_not_match_different_nodes;
16 wsrep_written_does_not_match_different_nodes
17 1
18 connection node_1;
19 INSERT INTO t1 VALUES (1);
20 connection node_2;
21 wsrep_last_written_seen_id_match
22 1
23 connection node_1;
24 SET AUTOCOMMIT=OFF;
25 START TRANSACTION;
26 INSERT INTO t1 VALUES (1);
27 WSREP_LAST_SEEN_GTID() = '100-1-3'
28 1
29 wsrep_last_written_id_match
30 1
31 COMMIT;
32 wsrep_last_written_id_advanced
33 1
34 SET AUTOCOMMIT=ON;
35 DROP TABLE t1;
36 connection node_2;
37 CALL mtr.add_suppression("Ignoring server id .* for non bootstrap node");