Debian Codegraph @

mysql-test/suite/rpl_nogtid/t/rpl_set_gtid_mode_ongoing_wait_function.test

raw
1 # ==== Purpose ====
2 #
3 # 1) Test that it is not allowed to execute SET GTID_MODE = OFF when
4 # there is an ongoing call to WAIT_FOR_EXECUTED_GTID_SET or
5 # WAIT_FOR_EXECUTED_GTID_SET.
6 #
7 # ==== Implementation ====
8 #
9 # Execute three iterations:
10 # - In iterations 1 and 2, use WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS.
11 # - In iterations 2 and 3, use WAIT_FOR_EXECUTED_GTID_SET.
12 #
13 # In each iteration, check that it is not allowed to set GTID_MODE=OFF
14 # while the wait function is waiting; and check that it is allowed to
15 # set all the other GTID_MODEs. In iteration 2, additionally check
16 # that SET GTID_MODE=OFF is disallowed after releasing one of the
17 # waiting threads.
18 #
19 # 2) Test that SELECT WAIT_FOR_EXECUTED_GTID_SET() gives an error if
20 # gtid-mode=off.
21
22 # Test sets GTID_MODE explicitly, so only meaningful to run in one GTID_MODE.
23 # Not meaningful to run in more than one binlog_format.
24 --source include/have_binlog_format_row.inc
25 --source include/have_debug_sync.inc
26
27 --source include/master-slave.inc
28 --let $uuida= aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa
29
30 --connection slave
31 SET GLOBAL ENFORCE_GTID_CONSISTENCY = ON;
32 --connection master
33 SET GLOBAL ENFORCE_GTID_CONSISTENCY = ON;
34
35 SET GLOBAL GTID_MODE = OFF_PERMISSIVE;
36
37 --let $i= 0
38 while ($i < 3)
39 {
40 --echo ==== Iteration $i ====
41 # Set GTID_MODE
42 --connection slave
43 SET GLOBAL GTID_MODE = OFF_PERMISSIVE;
44 SET GLOBAL GTID_MODE = ON_PERMISSIVE;
45 SET GLOBAL GTID_MODE = ON;
46
47 # Begin to wait.
48 if ($i < 2)
49 {
50 --connection server_2
51 --let $id= `SELECT CONNECTION_ID()`
52
53 # Multiply by 0 since the return value is nondeterministic.
54 --send
55 eval SELECT WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS('$uuida:1$i') * 0;
56
57 --connection slave
58 --let $wait_condition= SELECT COUNT(*) = 1 FROM performance_schema.threads WHERE PROCESSLIST_ID = $id AND PROCESSLIST_STATE = 'Waiting for the replica SQL thread to advance position'
59 --source include/wait_condition_or_abort.inc
60 }
61 if ($i > 0)
62 {
63 --connection server_2_1
64 --let $id= `SELECT CONNECTION_ID()`
65
66 SET @@SESSION.DEBUG_SYNC = 'begin_wait_for_executed_gtid_set SIGNAL reached_wait_function';
67 --send
68 eval SELECT WAIT_FOR_EXECUTED_GTID_SET('$uuida:2$i');
69
70 --connection slave
71 # Doesn't work because of BUG#20451305.
72 #--let $wait_condition= SELECT COUNT(*) = 1 FROM performance_schema.threads WHERE PROCESSLIST_ID = $id AND PROCESSLIST_STATE = 'waiting for GTID to be written to binary log'
73 #--source include/wait_condition_or_abort.inc
74
75 SET @@SESSION.DEBUG_SYNC = 'now WAIT_FOR reached_wait_function';
76 }
77
78 # Check that all GTID_MODEs except OFF are allowed.
79 --connection slave
80 SET GLOBAL GTID_MODE = ON;
81 SET GLOBAL GTID_MODE = ON_PERMISSIVE;
82 SET GLOBAL GTID_MODE = ON_PERMISSIVE;
83 SET GLOBAL GTID_MODE = OFF_PERMISSIVE;
84 SET GLOBAL GTID_MODE = OFF_PERMISSIVE;
85
86 --error ER_CANT_SET_GTID_MODE
87 SET GLOBAL GTID_MODE = OFF;
88
89 # Release the waiters.
90 if ($i < 2)
91 {
92 --connection master
93 eval SET GTID_NEXT = '$uuida:1$i';
94 COMMIT;
95 SET GTID_NEXT = 'AUTOMATIC';
96 --source include/sync_slave_sql_with_master.inc
97
98 --connection server_2
99 --reap
100 }
101
102 # If $i==1, we released one waiter and the other is still ongoing,
103 # so setting OFF is still an error.
104 if ($i == 1)
105 {
106 --error ER_CANT_SET_GTID_MODE
107 SET GLOBAL GTID_MODE = OFF;
108 }
109
110 if ($i > 0)
111 {
112 eval SET GTID_NEXT = '$uuida:2$i';
113 COMMIT;
114 SET GTID_NEXT = 'AUTOMATIC';
115
116 --connection server_2_1
117 --reap
118 }
119
120 --connection slave
121 SET GLOBAL GTID_MODE = OFF;
122
123 --inc $i
124 }
125
126 --connection master
127 SET GLOBAL GTID_MODE = OFF;
128 --source include/sync_slave_sql_with_master.inc
129
130 --echo #
131 --echo # Test that SELECT WAIT_FOR_EXECUTED_GTID_SET() gives an error if
132 --echo # gtid-mode=off.
133 --echo #
134
135 --error ER_GTID_MODE_OFF
136 eval SELECT WAIT_FOR_EXECUTED_GTID_SET('master_uuid', 1);
137
138 --connection slave
139 SET GLOBAL ENFORCE_GTID_CONSISTENCY = OFF;
140 --connection master
141 SET GLOBAL ENFORCE_GTID_CONSISTENCY = OFF;
142
143 --source include/rpl_end.inc
144