Debian Codegraph @

mysql-test/suite/group_replication/r/gr_error_state_deadlock_stop_gr.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 # 1. Create a table on server 1 and replicate.
8
9 [connection server1]
10 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
11 include/rpl_sync.inc
12
13 # 2. Insert a row on server 2 with log to the binlog disabled.
14
15 [connection server2]
16 SET @debug_save= @@GLOBAL.DEBUG;
17 SET @@GLOBAL.DEBUG='+d,group_replication_applier_thread_wait_kill_pending_transaction';
18 SET SESSION sql_log_bin= 0;
19 call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': Worker [0-9] failed executing transaction*");
20 call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': ... The replica coordinator and worker threads are stopped,*");
21 call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': Could not execute Write_rows event on table .*");
22 call mtr.add_suppression("The applier thread execution was aborted. Unable to process more transactions, this member will now leave the group.");
23 call mtr.add_suppression("Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.");
24 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
25 call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
26 INSERT INTO t1 VALUES (1);
27 SET SESSION sql_log_bin= 1;
28
29 # 3. Insert record in server1 to put server2 in error state.
30 # Server2 will go in ERROR state due to PRIMARY key violation.
31
32 [connection server1]
33 INSERT INTO t1 VALUES (1);
34 [connection server2]
35 include/gr_wait_for_member_state.inc
36
37 # 4. Stop GR should succed when member is in ERROR state.
38
39 SET DEBUG_SYNC= 'RESET';
40 SET @@GLOBAL.DEBUG= @debug_save;
41 SET @@GLOBAL.DEBUG='+d,group_replication_continue_kill_pending_transaction';
42 include/stop_group_replication.inc
43
44 # 5. Clean up.
45
46 SET @@GLOBAL.DEBUG= @debug_save;
47 SET GLOBAL read_only= 0;
48 SET SESSION sql_log_bin= 0;
49 DELETE from t1;
50 SET SESSION sql_log_bin= 1;
51 include/start_group_replication.inc
52 DROP TABLE t1;
53 include/group_replication_end.inc