Debian Codegraph @

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

raw
1 ## Test case to verify original_commit_timestamp and
2 ## immediate_commit_timestamp are correct for view-change.
3 #
4 ## Test:
5 #
6 # 0. The test requires 2 servers
7 # 1. Start GR on S1
8 # 2. Assert ORIGINAL_COMMIT_TIMESTAMP and IMMEDIATE_COMMIT_TIMESTAMP
9 # are correct on S1
10 # 3. Start GR on S2
11 # 4. Assert ORIGINAL_COMMIT_TIMESTAMP and IMMEDIATE_COMMIT_TIMESTAMP
12 # are correct on S1 and S2
13 # 5. Clean Up
14 #
15
16 --source include/have_group_replication_plugin.inc
17 --let $rpl_skip_group_replication_start= 1
18 --source include/group_replication.inc
19
20 --echo ############################################################
21 --echo # 1. Start GR on S1
22
23 --let $rpl_connection_name= server1
24 --source include/rpl_connection.inc
25
26 --source include/start_and_bootstrap_group_replication.inc
27
28 --echo ############################################################
29 --echo # 2. Assert ORIGINAL_COMMIT_TIMESTAMP and IMMEDIATE_COMMIT_TIMESTAMP
30 --echo # are correct on S1
31
32 --let $rpl_connection_name= server1
33 --source include/rpl_connection.inc
34
35 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP is not 0.'
36 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="group_replication_applier" AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) > 0 AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP) > 0, count, 1] = 1
37 --source include/assert.inc
38
39 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP = LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP.'
40 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="group_replication_applier" AND (UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) - UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP)) = 0, count, 1] = 1
41 --source include/assert.inc
42
43 --echo ############################################################
44 --echo # 3. Start GR on S2
45
46 --let $rpl_connection_name= server2
47 --source include/rpl_connection.inc
48
49 --source include/start_group_replication.inc
50
51 --echo ############################################################
52 --echo # 4. Assert ORIGINAL_COMMIT_TIMESTAMP and IMMEDIATE_COMMIT_TIMESTAMP
53 --echo # are correct on S1 and S2
54
55 --let $rpl_connection_name= server1
56 --source include/rpl_connection.inc
57
58 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP is not 0.'
59 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="group_replication_applier" AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) > 0 AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP) > 0, count, 1] = 1
60 --source include/assert.inc
61
62 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP = LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP.'
63 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="group_replication_applier" AND (UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) - UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP)) = 0, count, 1] = 1
64 --source include/assert.inc
65
66 --let $rpl_connection_name= server2
67 --source include/rpl_connection.inc
68
69 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP is not 0.'
70 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="group_replication_applier" AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) > 0 AND UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP) > 0, count, 1] = 1
71 --source include/assert.inc
72
73 --let $assert_text= 'LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP = LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP.'
74 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME="group_replication_applier" AND (UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP) - UNIX_TIMESTAMP(LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP)) = 0, count, 1] = 1
75 --source include/assert.inc
76
77 --echo ############################################################
78 --echo # 5. Clean Up
79
80 --source include/group_replication_end.inc