Debian Codegraph @

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

raw
1 ################################################################################
2 # Verify server behaviour when a transaction is negatively certified.
3 #
4 # Test:
5 # 0. The test requires two servers: M1 and M2.
6 # 1. With both members ONLINE. Execute some transactions on M1.
7 # 2. Force negative certification outcome of the next transaction using DEBUG
8 # sync point.
9 # 3. First insert must be aborted. Validate the data on table and information
10 # in P_S tables on both M1 and M2.
11 # 4. Clean debug flag on MTR side.
12 # 5. Clean up. Validate gtid_executed on M1 and M2.
13 ################################################################################
14 --source include/have_debug.inc
15 --let $group_replication_group_name= 8a94f357-aab4-11df-86ab-c80aa9429123
16 --source include/have_group_replication_plugin.inc
17
18 --source include/group_replication.inc
19
20 --echo ############################################################
21 --echo # 1. Execute some transactions on server1.
22 --connection server1
23
24 --let $group_replication_number_of_members= 2
25 --source include/gr_wait_for_number_of_members.inc
26 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
27 INSERT INTO t1 VALUES (1);
28
29 --let $sync_slave_connection= server2
30 --source include/sync_slave_sql_with_master.inc
31
32 --echo
33 --echo ############################################################
34 --echo # 2. Force negative certification outcome of the next
35 --echo # transaction.
36 --connection server1
37 SET @debug_save= @@GLOBAL.DEBUG;
38 SET @@GLOBAL.DEBUG= '+d,certifier_force_1_negative_certification';
39 --connection server2
40 SET @debug_save= @@GLOBAL.DEBUG;
41 SET @@GLOBAL.DEBUG= '+d,certifier_force_1_negative_certification';
42
43 --echo
44 --echo ############################################################
45 --echo # 3. First insert must be aborted.
46 --connection server1
47 --error ER_TRANSACTION_ROLLBACK_DURING_COMMIT
48 INSERT INTO t1 VALUES (2);
49 INSERT INTO t1 VALUES (3);
50
51 --let $sync_slave_connection= server2
52 --source include/sync_slave_sql_with_master.inc
53
54 --connection server1
55 --let $assert_text= 'There is no value 2 in table t1 on server 1'
56 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE t1.c1 = 2, count, 1] = 0
57 --source include/assert.inc
58 --let $assert_text= 'There is a value 3 in table t1 on server 1'
59 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE t1.c1 = 3, count, 1] = 1
60 --source include/assert.inc
61
62 --let $transaction_in_queue= query_get_value(SELECT Count_Transactions_in_queue FROM performance_schema.replication_group_member_stats where member_id in (SELECT @@server_uuid), Count_Transactions_in_queue, 1)
63 --let $assert_text= 'The value of Count_Transactions_in_queue should be 0 on server 1'
64 --let $assert_cond= $transaction_in_queue = 0
65 --source include/assert.inc
66 --let $certified_transactions= query_get_value(SELECT Count_transactions_checked FROM performance_schema.replication_group_member_stats where member_id in (SELECT @@server_uuid), Count_transactions_checked, 1)
67 --let $assert_text= 'The value of Count_transactions_checked should be 4 on server 1'
68 --let $assert_cond= $certified_transactions = 4
69 --source include/assert.inc
70 --let $negatively_certified= query_get_value(SELECT Count_conflicts_detected FROM performance_schema.replication_group_member_stats where member_id in (SELECT @@server_uuid), Count_conflicts_detected, 1)
71 --let $assert_text= 'The value of Count_conflicts_detected should be 1 on server 1'
72 --let $assert_cond= $negatively_certified = 1
73 --source include/assert.inc
74 --let $last_certified_transaction= query_get_value(SELECT Last_conflict_free_transaction from performance_schema.replication_group_member_stats where member_id in (SELECT @@server_uuid), Last_conflict_free_transaction, 1)
75 --let $assert_text= 'The value of Last_conflict_free_transaction should be 8a94f357-aab4-11df-86ab-c80aa9429123:5 on server 1'
76 --let $assert_cond= "$last_certified_transaction" = "$group_replication_group_name:5"
77 --source include/assert.inc
78
79 --connection server2
80 --let $assert_text= 'There is no value 2 in table t1 on server 2'
81 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE t1.c1 = 2, count, 1] = 0
82 --source include/assert.inc
83 --let $assert_text= 'There is a value 3 in table t1 on server 2'
84 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE t1.c1 = 3, count, 1] = 1
85 --source include/assert.inc
86
87 --let $transaction_in_queue= query_get_value(SELECT Count_Transactions_in_queue FROM performance_schema.replication_group_member_stats where member_id in (SELECT @@server_uuid), Count_Transactions_in_queue, 1)
88 --let $assert_text= 'The value of Count_Transactions_in_queue should be 0 on server 2'
89 --let $assert_cond= $transaction_in_queue = 0
90 --source include/assert.inc
91 --let $certified_transactions= query_get_value(SELECT Count_transactions_checked FROM performance_schema.replication_group_member_stats where member_id in (SELECT @@server_uuid), Count_transactions_checked, 1)
92 --let $assert_text= 'The value of Count_transactions_checked should be 4 on server 2'
93 --let $assert_cond= $certified_transactions = 4
94 --source include/assert.inc
95 --let $negatively_certified= query_get_value(SELECT Count_conflicts_detected FROM performance_schema.replication_group_member_stats where member_id in (SELECT @@server_uuid), Count_conflicts_detected, 1)
96 --let $assert_text= 'The value of Count_conflicts_detected should be 1 on server 2'
97 --let $assert_cond= $negatively_certified = 1
98 --source include/assert.inc
99 --let $last_certified_transaction= query_get_value(SELECT Last_conflict_free_transaction from performance_schema.replication_group_member_stats where member_id in (SELECT @@server_uuid), Last_conflict_free_transaction, 1)
100 --let $assert_text= 'The value of Last_conflict_free_transaction should be 8a94f357-aab4-11df-86ab-c80aa9429123:5 on server 2'
101 --let $assert_cond= "$last_certified_transaction" = "$group_replication_group_name:5"
102 --source include/assert.inc
103
104 --echo
105 --echo ############################################################
106 --echo # 4. Clean debug flag on MTR side.
107 --connection server1
108 SET @@GLOBAL.DEBUG= @debug_saved;
109 --connection server2
110 SET @@GLOBAL.DEBUG= @debug_saved;
111
112 --echo
113 --echo ############################################################
114 --echo # 5. Shutdown.
115 --connection server1
116 DROP TABLE t1;
117
118 --let $sync_slave_connection= server2
119 --source include/sync_slave_sql_with_master.inc
120
121 --connection server1
122 --let $assert_text= 'Aborted transaction should not have increased GNO to 7 on server 1'
123 --let $assert_cond= "[SELECT @@GLOBAL.GTID_EXECUTED]" = "$group_replication_group_name:1-6"
124 --source include/assert.inc
125
126 --connection server2
127 --let $assert_text= 'Aborted transaction should not have increased GNO to 7 on server 2'
128 --let $assert_cond= "[SELECT @@GLOBAL.GTID_EXECUTED]" = "$group_replication_group_name:1-6"
129 --source include/assert.inc
130
131 --source include/group_replication_end.inc