Debian Codegraph @

mysql-test/suite/group_replication/r/gr_start_replication_auto_write_protection.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 # Start the member 1 and 2 and add some data
8 #
9 include/start_and_bootstrap_group_replication.inc
10 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
11 INSERT INTO t1 VALUES (1);
12 include/start_group_replication.inc
13 include/stop_group_replication.inc
14 #
15 # Block the applier on server 1 to block recovery on server 2
16 #
17 SET @@GLOBAL.DEBUG='+d,block_applier_updates';
18 #
19 # On server 2 restart the server. Group replication should start at boot
20 #
21 # restart:--group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_start_on_boot=1 --group-replication-group-name=f68d2bd0-8964-11e5-a837-0800200c9a66
22 [connection server_2]
23 [connection server2]
24 include/gr_wait_for_member_state.inc
25 #
26 # On server 2 after restart, recovery should be stuck
27 # Query execution is not allowed
28 #
29 INSERT INTO t1 VALUES (2);
30 ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
31 include/assert.inc [On the recovered member, the table should exist and have 1 elements;]
32 #
33 # Unblock recovery by resuming the applier on server 1
34 #
35 SET DEBUG_SYNC = "now WAIT_FOR applier_read_blocked";
36 SET @@GLOBAL.DEBUG='-d,block_applier_updates';
37 SET DEBUG_SYNC = "now SIGNAL resume_applier_read";
38 include/gr_wait_for_member_state.inc
39 INSERT INTO t1 VALUES (2);
40 #
41 # Cleanup
42 #
43 SET DEBUG_SYNC= 'RESET';
44 DROP TABLE t1;
45 include/group_replication_end.inc