Debian Codegraph @

mysql-test/suite/group_replication/r/gr_multiple_starts_after_clone.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 ############################################################
8 # 1. Install clone plugin on server1.
9 # Bootstrap server1 and add some data.
10 [connection server1]
11 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
12 include/start_and_bootstrap_group_replication.inc
13 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY);
14 INSERT INTO t1 VALUES (1);
15
16 ############################################################
17 # 2. Restart server2 with a monitoring process (mysqld_safe)
18 # if needed.
19 # Install clone plugin on server2.
20 [connection server2]
21 include/spawn_monitoring_process.inc
22 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
23
24 ############################################################
25 # 3. Start GR on server2, forcing clone.
26 SET GLOBAL group_replication_clone_threshold= 1;
27 START GROUP_REPLICATION;
28 include/rpl_reconnect.inc
29 include/gr_wait_for_member_state.inc
30 include/assert.inc [Clone must be completed]
31 include/diff_tables.inc [server1:t1, server2:t1]
32 # group_replication_applier channel relay log files
33 server-relay-log-group_replication_applier.000001
34 server-relay-log-group_replication_applier.000002
35 server-relay-log-group_replication_applier.index
36 include/show_relaylog_events.inc [FOR CHANNEL 'group_replication_applier']
37 Log_name Pos Event_type Server_id End_log_pos Info
38 server-relay-log-group_replication_applier.000001 # Rotate # # server-relay-log-group_replication_applier.000002;pos=4
39 include/show_relaylog_events.inc [FOR CHANNEL 'group_replication_applier']
40 Log_name Pos Event_type Server_id End_log_pos Info
41 server-relay-log-group_replication_applier.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
42 server-relay-log-group_replication_applier.000002 # Query # # BEGIN
43 server-relay-log-group_replication_applier.000002 # Query # # COMMIT
44 ############################################################
45 # 4. Stop GR applier on server2 so that all remote
46 # transactions are only queued on relay log.
47 # Execute some transactions on server1.
48 [connection server2]
49 SET @@GLOBAL.DEBUG='+d,block_applier_updates';
50 [connection server1]
51 INSERT INTO t1 VALUES (2);
52
53 ################################################################
54 # 5. Wait until server2 receives and certifies the transaction.
55 # Make both members leave the group.
56 [connection server2]
57 SET DEBUG_SYNC = "now WAIT_FOR applier_read_blocked";
58 SET @@GLOBAL.DEBUG='-d,block_applier_updates';
59 SET @@GLOBAL.DEBUG='+d,force_sql_thread_error';
60 SET DEBUG_SYNC = "now SIGNAL resume_applier_read";
61 include/gr_wait_for_member_state.inc
62 SET @@GLOBAL.DEBUG='-d,force_sql_thread_error';
63 include/stop_group_replication.inc
64 SET DEBUG_SYNC= 'RESET';
65 [connection server1]
66 include/stop_group_replication.inc
67
68 ############################################################
69 # 6. Start Group Replication only on server2.
70 # Assert that server1 and server2 have the same data.
71 [connection server2]
72 include/start_and_bootstrap_group_replication.inc
73 [connection server1]
74 include/assert.inc ['There are two rows in table t1 on server1']
75 [connection server2]
76 include/assert.inc ['There are two rows in table t1 on server2']
77 include/diff_tables.inc [server1:t1, server2:t1]
78 # group_replication_applier channel relay log files
79 server-relay-log-group_replication_applier.000002
80 server-relay-log-group_replication_applier.000003
81 server-relay-log-group_replication_applier.index
82 include/show_relaylog_events.inc [FOR CHANNEL 'group_replication_applier']
83 Log_name Pos Event_type Server_id End_log_pos Info
84 server-relay-log-group_replication_applier.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
85 server-relay-log-group_replication_applier.000002 # Query # # BEGIN
86 server-relay-log-group_replication_applier.000002 # Query # # COMMIT
87 server-relay-log-group_replication_applier.000002 # Query # # BEGIN
88 server-relay-log-group_replication_applier.000002 # Table_map # # table_id: # (test.t1)
89 server-relay-log-group_replication_applier.000002 # Write_rows # # table_id: # flags: STMT_END_F
90 server-relay-log-group_replication_applier.000002 # Xid # # COMMIT /* XID */
91 server-relay-log-group_replication_applier.000002 # Rotate # # server-relay-log-group_replication_applier.000003;pos=4
92 include/show_relaylog_events.inc [FOR CHANNEL 'group_replication_applier']
93 Log_name Pos Event_type Server_id End_log_pos Info
94 server-relay-log-group_replication_applier.000003 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
95 server-relay-log-group_replication_applier.000003 # Query # # BEGIN
96 server-relay-log-group_replication_applier.000003 # Query # # COMMIT
97
98 ############################################################
99 # 7. Clean up.
100 [connection server1]
101 DROP TABLE t1;
102 UNINSTALL PLUGIN clone;
103 [connection server2]
104 include/stop_group_replication.inc
105 DROP TABLE t1;
106 RESET PERSIST group_replication_group_name;
107 RESET PERSIST group_replication_local_address;
108 RESET PERSIST group_replication_group_seeds;
109 RESET PERSIST group_replication_start_on_boot;
110 RESET PERSIST IF EXISTS group_replication_communication_stack;
111 SET GLOBAL group_replication_clone_threshold= GROUP_REPLICATION_CLONE_THRESHOLD;
112 SET GLOBAL group_replication_start_on_boot= START_ON_BOOT_VALUE;
113 UNINSTALL PLUGIN clone;
114 SET SESSION sql_log_bin= 0;
115 call mtr.add_suppression("Due to the number of missing transactions being higher than the configured threshold of*");
116 call mtr.add_suppression("Clone removing all user data for provisioning: Started");
117 call mtr.add_suppression("Clone removing all user data for provisioning: Finished");
118 call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': Relay log read failure: Could not parse relay log event entry.*");
119 call mtr.add_suppression("The applier thread execution was aborted. Unable to process more transactions, this member will now leave the group.");
120 call mtr.add_suppression("Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.");
121 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
122 call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
123 SET SESSION sql_log_bin= 1;
124 include/clean_monitoring_process.inc
125 include/group_replication_end.inc