Debian Codegraph @

mysql-test/suite/group_replication/t/gr_single_primary_super_read_at_exit.test

raw
1 ############################################################
2 # WL#9426: Single Primary Mode in Group Replication
3 #
4 # This test case verifies if overwriting `super_read_only`
5 # system variable on PRIMARY node doesn't crashes the server
6 # (BUG#22857926).
7 #
8 ############################################################
9 --source include/have_group_replication_plugin.inc
10 --source include/force_restart.inc
11
12 --let $rpl_skip_group_replication_start= 1
13 --let $rpl_group_replication_single_primary_mode=1
14 --source include/group_replication.inc
15
16 --echo # CONFIGURE SERVER 1
17 --let $rpl_connection_name= server1
18 --source include/rpl_connection.inc
19 --source include/start_and_bootstrap_group_replication.inc
20 --let $primary_server_uuid= `SELECT @@server_uuid`
21
22 --let $group_replication_expected_uuid= $primary_server_uuid
23 --source include/gr_wait_primary_member_uuid.inc
24
25 --echo # CONFIGURE SERVER 2
26 --let $rpl_connection_name= server2
27 --source include/rpl_connection.inc
28 --source include/start_group_replication.inc
29
30 --let $group_replication_expected_uuid= $primary_server_uuid
31 --source include/gr_wait_primary_member_uuid.inc
32
33 --let $rpl_connection_name= server1
34 --source include/rpl_connection.inc
35 CREATE TABLE first(c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
36 INSERT INTO first(c1) VALUES(2),(4);
37
38 --source include/rpl_sync.inc
39 --let $rpl_connection_name= server2
40 --source include/rpl_connection.inc
41 SELECT * FROM first;
42
43 --let $rpl_connection_name= server2
44 --source include/rpl_connection.inc
45 --source include/stop_group_replication.inc
46 --let $wait_condition= SELECT @@super_read_only = 0
47 --source include/wait_condition_or_abort.inc
48 # This crashes the server
49 # Fix for this problem is going to be a part of
50 # BUG#22857926 : ASSERTION `! IS_SET()' AT SQL_ERROR.CC:38 IN READ_ONLY MODE FOR MANY RPL CMDS
51 # Uncomment line bellow to trigger the fault
52 # SET GLOBAL super_read_only=1;
53 --let $rpl_connection_name= server1
54 --source include/rpl_connection.inc
55 --source include/stop_group_replication.inc
56
57 --echo # CLEANUP
58 --let $rpl_connection_name= server1
59 --source include/rpl_connection.inc
60 DROP TABLE first;
61 --source include/group_replication_end.inc