Debian Codegraph @

mysql-test/suite/galera_sr/t/GCF-580.test

raw
1 #
2 # GCF-580 wsrep_last_committed_counter increases twice for every SR fragment
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
9
10 SET SESSION wsrep_trx_fragment_size = 1;
11 --let $wsrep_last_committed_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
12
13 START TRANSACTION;
14 INSERT INTO t1 VALUES (1);
15 INSERT INTO t1 VALUES (2);
16 INSERT INTO t1 VALUES (3);
17 INSERT INTO t1 VALUES (4);
18
19 --let $fragments_count = `SELECT COUNT(*) FROM mysql.wsrep_streaming_log`
20 --let $wsrep_last_committed_after = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
21 --disable_query_log
22 --eval SELECT ($wsrep_last_committed_after - $wsrep_last_committed_before) = $fragments_count AS last_committed_matches_fragment_count
23 --enable_query_log
24
25 COMMIT;
26
27 DROP TABLE t1;