Debian Codegraph @

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

raw
1 # ==== Purpose ====
2 #
3 # Verify that `REQUIRE_TABLE_PRIMARY_KEY_CHECK` option is settable for GR channels.
4 # Except the value `GENERATE`
5 #
6 # ==== Implementation ====
7 #
8 # 1. Check that the value GENERATE can not be used for REQUIRE_TABLE_PRIMARY_KEY_CHECK
9 # with Group Replication channels
10 # 2. Set `REQUIRE_TABLE_PRIMARY_KEY_CHECK` option for the applier channel
11 # Start a member and check the `REQUIRE_TABLE_PRIMARY_KEY_CHECK` option is set
12 # 3. Block the applier to block server 2 recovery
13 # 4. Set `REQUIRE_TABLE_PRIMARY_KEY_CHECK` option for the recovery channel
14 # Start the member and check the `REQUIRE_TABLE_PRIMARY_KEY_CHECK` option is set
15 # 5. Cleanup
16 #
17 # ==== References ====
18 #
19 # WL#13239: Enable/disable primary key checks on slaves
20 # WL#15419: Make the replica_generate_invisible_primary_key option settable per channel
21 #
22
23 --source include/have_debug_sync.inc
24 --source include/have_group_replication_plugin.inc
25 --let $rpl_skip_group_replication_start= 1
26 --source include/group_replication.inc
27
28 --echo
29 --echo # 1. Check that the value GENERATE can not be used for REQUIRE_TABLE_PRIMARY_KEY_CHECK
30 --echo # with Group Replication channels
31
32 --error ER_REQUIRE_TABLE_PRIMARY_KEY_CHECK_GENERATE_WITH_GR
33 --eval CHANGE REPLICATION SOURCE TO REQUIRE_TABLE_PRIMARY_KEY_CHECK = GENERATE FOR CHANNEL "group_replication_recovery"
34
35 --error ER_REQUIRE_TABLE_PRIMARY_KEY_CHECK_GENERATE_WITH_GR
36 --eval CHANGE REPLICATION SOURCE TO REQUIRE_TABLE_PRIMARY_KEY_CHECK = GENERATE FOR CHANNEL "group_replication_applier"
37
38 --echo
39 --echo # 2. Set `REQUIRE_TABLE_PRIMARY_KEY_CHECK` option for the applier channel
40 --echo # Start a member and check the `REQUIRE_TABLE_PRIMARY_KEY_CHECK` option is set
41
42 --eval CHANGE REPLICATION SOURCE TO REQUIRE_TABLE_PRIMARY_KEY_CHECK = OFF FOR CHANNEL "group_replication_applier"
43
44 --source include/start_and_bootstrap_group_replication.inc
45
46 --let $count = `SELECT COUNT(*) FROM performance_schema.replication_applier_configuration WHERE require_table_primary_key_check = 'OFF' AND channel_name = "group_replication_applier"`
47 --let $assert_text = require_table_primary_key_check in performance_schema.replication_applier_configuration is set to OFF for "group_replication_applier"
48 --let $assert_cond = 1 = $count
49 --source include/assert.inc
50
51 --echo
52 --echo # 3. Block the applier to block server 2 recovery
53
54 SET @@GLOBAL.DEBUG='+d,block_applier_updates';
55
56 --echo
57 --echo # 4. Set `REQUIRE_TABLE_PRIMARY_KEY_CHECK` option for the recovery channel
58 --echo # Start the member and check the `REQUIRE_TABLE_PRIMARY_KEY_CHECK` option is set
59
60 --let $rpl_connection_name= server2
61 --source include/rpl_connection.inc
62
63 --eval CHANGE REPLICATION SOURCE TO REQUIRE_TABLE_PRIMARY_KEY_CHECK = ON FOR CHANNEL "group_replication_recovery"
64
65 --let $group_replication_start_member_state= RECOVERING
66 --source include/start_group_replication.inc
67
68 --let $wait_condition=SELECT COUNT(*)=1 FROM performance_schema.replication_applier_configuration WHERE require_table_primary_key_check = 'ON' AND channel_name = "group_replication_recovery"
69 --source include/wait_condition.inc
70
71 --let $count = `SELECT COUNT(*) FROM performance_schema.replication_applier_configuration WHERE require_table_primary_key_check = 'ON' AND channel_name = "group_replication_recovery"`
72 --let $assert_text = require_table_primary_key_check in performance_schema.replication_applier_configuration is set to ON for "group_replication_recovery"
73 --let $assert_cond = 1 = $count
74 --source include/assert.inc
75
76 --echo
77 --echo # 5. Cleanup
78
79 --let $rpl_connection_name= server1
80 --source include/rpl_connection.inc
81
82 SET DEBUG_SYNC = "now WAIT_FOR applier_read_blocked";
83 SET @@GLOBAL.DEBUG='-d,block_applier_updates';
84 SET DEBUG_SYNC = "now SIGNAL resume_applier_read";
85
86 --let $rpl_connection_name= server2
87 --source include/rpl_connection.inc
88
89 --let $group_replication_member_state= ONLINE
90 --source include/gr_wait_for_member_state.inc
91
92 --let $rpl_connection_name= server1
93 --source include/rpl_connection.inc
94 SET DEBUG_SYNC= 'RESET';
95
96 --source include/group_replication_end.inc