Debian Codegraph @

mysql-test/suite/galera/t/galera_sync_wait_upto.test

raw
1 #
2 # Tests the wsrep_sync_wait_upto variable.
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7 --source include/have_debug.inc
8
9 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
10 INSERT INTO t1 VALUES (1);
11
12 # Test with invalid values
13
14 --error ER_WRONG_ARGUMENTS
15 SELECT WSREP_SYNC_WAIT_UPTO_GTID(NULL);
16
17 --error ER_INCORRECT_GTID_STATE
18 SELECT WSREP_SYNC_WAIT_UPTO_GTID('a');
19
20 --error ER_INCORRECT_GTID_STATE
21 SELECT WSREP_SYNC_WAIT_UPTO_GTID(2);
22
23 --error ER_WRONG_ARGUMENTS
24 SELECT WSREP_SYNC_WAIT_UPTO_GTID('1-1-1,1-1-2');
25
26 # Expected starting seqno
27
28 --let $last_seen_gtid = `SELECT WSREP_LAST_SEEN_GTID()`
29 --let $s1 = `SELECT SUBSTR('$last_seen_gtid', LOCATE('-', '$last_seen_gtid') + LENGTH('-'))`
30 --let $start_seqno = `SELECT SUBSTR('$s1', LOCATE('-', '$s1') + LENGTH('-'))`
31
32 # If set to low value, expect no waiting
33
34 --disable_query_log
35 --let $lower_seqno = $start_seqno
36 --dec $lower_seqno
37 --eval SELECT WSREP_SYNC_WAIT_UPTO_GTID('100-1-$lower_seqno') AS WSREP_SYNC_WAIT_UPTO;
38 --enable_query_log
39
40 # If set to current last_committed value no waiting
41
42 --disable_query_log
43 --let $wsrep_last_committed_gtid = `SELECT WSREP_LAST_SEEN_GTID()`
44 --eval SELECT WSREP_SYNC_WAIT_UPTO_GTID('$wsrep_last_committed_gtid') AS WSREP_SYNC_WAIT_UPTO;
45 --enable_query_log
46
47 # Timeout if GTID is not received on time
48
49 --disable_query_log
50 --let $high_seqno = $start_seqno
51 --inc $high_seqno
52 --error ER_LOCK_WAIT_TIMEOUT
53 --eval SELECT WSREP_SYNC_WAIT_UPTO_GTID('100-1-$high_seqno', 1) AS WSREP_SYNC_WAIT_UPTO;
54 --enable_query_log
55
56 # Wait for GTID value
57
58 --connection node_2
59 --disable_query_log
60 --let $wait_seqno = $start_seqno
61 --inc $wait_seqno
62 --send_eval SELECT WSREP_SYNC_WAIT_UPTO_GTID('100-1-$wait_seqno') AS WSREP_SYNC_WAIT_UPTO
63 --enable_query_log
64
65 --connection node_1
66 INSERT INTO t1 VALUES (2);
67
68 --connection node_2
69 --reap
70
71 --connection node_1
72 DROP TABLE t1;
73
74 --connection node_2
75 CALL mtr.add_suppression("Ignoring server id .* for non bootstrap node");