Debian Codegraph @

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

raw
1 include/group_replication.inc
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 # Bootstrap group with server 1.
8 #
9 include/start_and_bootstrap_group_replication.inc
10 #
11 # Restart group replication on server 2
12 # with group_replication_start_on_boot=1
13 #
14 # restart:--group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_start_on_boot=1
15 include/rpl_reconnect.inc
16 include/gr_wait_for_member_state.inc
17 include/stop_group_replication.inc
18 RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
19 Warnings:
20 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
21 #
22 # Add some data to server 1.
23 #
24 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
25 INSERT INTO t1 VALUES (1);
26 SET @@GLOBAL.DEBUG='+d,block_applier_updates';
27 #
28 # On server 2 uninstall and install the plugin with auto start.
29 # The plugin should start automatically and recover the missing data
30 #
31 include/uninstall_group_replication_plugin.inc
32 include/install_group_replication_plugin.inc
33 #
34 # On server 2 after restart, recovery should be stuck
35 # Query execution is not allowed
36 #
37 include/gr_wait_for_member_state.inc
38 INSERT INTO t1 VALUES (2);
39 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
40 #
41 # After unblocking recovery all should be fine
42 #
43 SET DEBUG_SYNC = "now WAIT_FOR applier_read_blocked";
44 SET @@GLOBAL.DEBUG='-d,block_applier_updates';
45 SET DEBUG_SYNC = "now SIGNAL resume_applier_read";
46 include/gr_wait_for_member_state.inc
47 #
48 # Clean up
49 #
50 SET DEBUG_SYNC= 'RESET';
51 DROP TABLE t1;
52 include/rpl_sync.inc
53 include/stop_group_replication.inc
54 include/restore_group_replication_auto_increment.inc
55 include/group_replication_end.inc