Debian Codegraph @

mysql-test/suite/group_replication/r/gr_stop_while_recovery_locked.result

raw
1 include/group_replication.inc [rpl_server_count=2]
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6
7 # 1. Bootstrap the group on server1
8 include/start_and_bootstrap_group_replication.inc
9
10 # 2. Set a lower components timeout and lock tables on server2.
11 # Start group replication that will block when applying VCLE
12 [connection server2]
13 SET @group_replication_components_stop_timeout_save = @@GLOBAL.group_replication_components_stop_timeout;
14 SET GLOBAL group_replication_components_stop_timeout = 30;
15 [connection server_2]
16 SET GLOBAL super_read_only= 1;
17 FLUSH TABLES WITH READ LOCK;
18 [connection server2]
19 include/start_group_replication.inc
20
21 # 3. Wait recovery is on hold due lock on tables and Stop Group
22 # Replication.
23 include/stop_group_replication.inc
24 Warnings:
25 Warning 4022 The group_replication_recovery channel is still running, most likely it is waiting for a database/table lock, which is preventing the channel from stopping. Please check database/table locks, including the ones created by backup tools.
26
27 # 4. Starting server2 will fail, recovery module fail to stop, as it is
28 # blocked
29 START GROUP_REPLICATION;
30 ERROR HY000: The group_replication_recovery channel is still running, most likely it is waiting for a database/table lock, which is preventing the channel from stopping. Please check database/table locks, including the ones created by backup tools.
31
32 # 5. UNLOCK tables on server2 and recovery module shall stop. Now Group
33 # Replication is able to start
34 [connection server_2]
35 UNLOCK TABLES;
36 include/start_group_replication.inc
37 # 6. Assert that even stop command returns a warning is thrown as
38 # recovery fails to stop
39 include/assert_grep.inc [STOP GROUP REPLICATION return timeout on stopping recovery module]
40
41 # 7. Cleanup
42 [connection server2]
43 SET SESSION sql_log_bin= 0;
44 call mtr.add_suppression("Error when stopping the group replication incremental recovery's donor connection");
45 call mtr.add_suppression('On shutdown there was a timeout on the Group Replication recovery module termination. Check the log for more details');
46 SET SESSION sql_log_bin= 1;
47 SET @@GLOBAl.group_replication_components_stop_timeout = @group_replication_components_stop_timeout_save;
48 include/group_replication_end.inc