Debian Codegraph @

mysql-test/suite/group_replication/include/gr_single_primary_with_transaction_isolation.inc

raw
1 # ==== Purpose ====
2 #
3 # This include file is a parametric test that does following:
4 # 1) Configure two servers (server1, server2) to be in group replication
5 # 2) Verifies group_replication_role on both servers
6 # 3) create a table on primary node
7 # 4) tries to insert data into the table, depending on server1 configuration
8 # this operation could fail
9 #
10 # ==== Usage ====
11 #
12 # --let $test_parameter_enforce_checks= TRUE|FALSE
13 # --let $test_parameter_single_primary_mode= TRUE|FALSE
14 # --let $test_parameter_tx_isolation= READ-UNCOMMITTED|READ-COMMITTED|REPEATABLE-READ|SERIALIZABLE
15 # --let $test_parameter_sql_execution_error= N|ERROR_NAME
16 # --let $test_parameter_primary_uuid= UUID
17 # --source ../include/gr_single_primary_with_transaction_isolation.inc
18 #
19 # Parameters:
20 # $test_parameter_enforce_checks
21 # Set value to group_replication_enforce_update_everywhere_checks system variable
22 #
23 # $test_parameter_single_primary_mode
24 # Set value to group_replication_single_primary_mode system variable
25 #
26 # $test_parameter_tx_isolation
27 # Set value to transaction_isolation session system variable
28 #
29 # $test_parameter_sql_execution_error
30 # Should the test expect an error while executing INSERT statement. If not
31 # the test is going to perform additional check to verify data consistency
32 # between server1 and server2
33 #
34 # $test_parameter_primary_uuid
35 # Test verifies if the group_replication_primary_member has this uuid
36 #
37
38 --let $include_filename= gr_single_primary_with_transaction_isolation.inc
39 --source include/begin_include_file.inc
40
41 --let $_saved_connection= $CURRENT_CONNECTION
42
43 --echo # CONFIGURE SERVER 1
44 --let $rpl_connection_name= server1
45 --source include/rpl_connection.inc
46 --eval SET GLOBAL group_replication_enforce_update_everywhere_checks= $test_parameter_enforce_checks
47 --eval SET GLOBAL group_replication_single_primary_mode= $test_parameter_single_primary_mode
48 --eval SET SESSION transaction_isolation=$test_parameter_tx_isolation
49
50 --source include/start_and_bootstrap_group_replication.inc
51
52 --let $group_replication_expected_uuid= $test_parameter_primary_uuid
53 --source include/gr_wait_primary_member_uuid.inc
54
55 --echo # CONFIGURE SERVER 2
56 --let $rpl_connection_name= server2
57 --source include/rpl_connection.inc
58 --eval SET GLOBAL group_replication_enforce_update_everywhere_checks= $test_parameter_enforce_checks
59 --eval SET GLOBAL group_replication_single_primary_mode= $test_parameter_single_primary_mode
60 --eval SET SESSION transaction_isolation=$test_parameter_tx_isolation
61 --source include/start_group_replication.inc
62
63 --let $group_replication_expected_uuid= $test_parameter_primary_uuid
64 --source include/gr_wait_primary_member_uuid.inc
65
66 --echo # WRITE DATA ON SERVER 1 (ISOLATION LEVEL $test_parameter_tx_isolation)
67 --echo # AND VERIFY PRESENCE OF THE DATA ON SERVER 2
68 --let $rpl_connection_name= server1
69 --source include/rpl_connection.inc
70 CREATE TABLE first(c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
71
72 --error $test_parameter_sql_execution_error
73 INSERT INTO first(c1) VALUES(2),(4);
74 if ($test_parameter_sql_execution_error == 0)
75 {
76 --source include/rpl_sync.inc
77 --let $rpl_connection_name= server2
78 --source include/rpl_connection.inc
79
80 --let $assert_text= All data inserted on server1 should be present on server2
81 --let $assert_cond= [SELECT COUNT(*) as count FROM first, count, 1] = 2
82 --source include/assert.inc
83
84 SELECT * FROM first;
85 }
86
87 --let $rpl_connection_name= server1
88 --source include/rpl_connection.inc
89 DROP TABLE first;
90
91 --let $rpl_connection_name= server2
92 --source include/rpl_connection.inc
93 --source include/stop_group_replication.inc
94
95 --let $rpl_connection_name= server1
96 --source include/rpl_connection.inc
97 --source include/stop_group_replication.inc
98
99 --connection $_saved_connection
100
101 --let $test_parameter_primary_uuid=
102
103 --let $include_filename= gr_single_primary_with_transaction_isolation.inc
104 --source include/end_include_file.inc