Debian Codegraph @

mysql-test/suite/galera/r/galera_ftwrl_concurrent.result

raw
1 connection node_2;
2 connection node_1;
3 connect node_1_ctrl, 127.0.0.1, root, , test, $NODE_MYPORT_1;
4 SET SESSION wsrep_sync_wait=0;
5 #
6 # Case 1: FTWRL
7 #
8 connection node_1;
9 SET SESSION wsrep_sync_wait=0;
10 FLUSH TABLES WITH READ LOCK;
11 SHOW STATUS LIKE 'wsrep_local_state_comment';
12 Variable_name Value
13 wsrep_local_state_comment Donor/Desynced
14 SET SESSION debug_sync = "wsrep_unlock_global_read_lock_after_resume_and_resync SIGNAL unlock_ready WAIT_FOR unlock_continue";
15 UNLOCK TABLES;
16 connection node_1_ctrl;
17 SET debug_sync = "now WAIT_FOR unlock_ready";
18 connect node_1_a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
19 connection node_1_a;
20 SET SESSION debug_sync = "wsrep_global_read_lock_block_commit_after_pause SIGNAL lock_ready WAIT_FOR lock_continue";
21 FLUSH TABLES WITH READ LOCK;
22 connection node_1_ctrl;
23 SET debug_sync = "now WAIT_FOR lock_ready";
24 SET debug_sync = "now SIGNAL unlock_continue";
25 connection node_1;
26 connection node_1_ctrl;
27 SET debug_sync = "now SIGNAL lock_continue";
28 connection node_1_a;
29 UNLOCK TABLES;
30 CREATE TABLE t1 (f1 INT PRIMARY KEY) ENGINE=InnoDB;
31 DROP TABLE t1;
32 connection node_1_ctrl;
33 SET debug_sync = "RESET";
34 #
35 # Case 2: BACKUP STAGE
36 #
37 connection node_1;
38 SET SESSION wsrep_sync_wait=0;
39 BACKUP STAGE START;
40 BACKUP STAGE BLOCK_DDL;
41 SHOW STATUS LIKE 'wsrep_local_state_comment';
42 Variable_name Value
43 wsrep_local_state_comment Donor/Desynced
44 SET SESSION debug_sync = "wsrep_backup_stage_after_resume_and_resync SIGNAL resume_and_resync_ready WAIT_FOR resume_and_resync_continue";
45 BACKUP STAGE END;
46 connection node_1_ctrl;
47 SET debug_sync = "now WAIT_FOR resume_and_resync_ready";
48 connection node_1_a;
49 BACKUP STAGE START;
50 SET SESSION debug_sync = "wsrep_backup_stage_after_desync_and_pause SIGNAL desync_and_pause_ready WAIT_FOR desync_and_pause_continue";
51 BACKUP STAGE BLOCK_DDL;
52 connection node_1_ctrl;
53 SET debug_sync = "now WAIT_FOR desync_and_pause_ready";
54 SET debug_sync = "now SIGNAL resume_and_resync_continue";
55 connection node_1;
56 connection node_1_ctrl;
57 SET debug_sync = "now SIGNAL desync_and_pause_continue";
58 connection node_1_a;
59 BACKUP STAGE END;
60 CREATE TABLE t1 (f1 INT PRIMARY KEY) ENGINE=InnoDB;
61 DROP TABLE t1;
62 connection node_1_ctrl;
63 SET debug_sync = "RESET";
64 #
65 # Case 3: FTWRL first, BACKUP STAGE second
66 #
67 connection node_1;
68 SET SESSION wsrep_sync_wait=0;
69 SET SESSION wsrep_sync_wait=0;
70 FLUSH TABLES WITH READ LOCK;
71 SHOW STATUS LIKE 'wsrep_local_state_comment';
72 Variable_name Value
73 wsrep_local_state_comment Donor/Desynced
74 SET SESSION debug_sync = "wsrep_unlock_global_read_lock_after_resume_and_resync SIGNAL unlock_ready WAIT_FOR unlock_continue";
75 UNLOCK TABLES;
76 connection node_1_ctrl;
77 SET debug_sync = "now WAIT_FOR unlock_ready";
78 connection node_1_a;
79 BACKUP STAGE START;
80 SET SESSION debug_sync = "wsrep_backup_stage_after_desync_and_pause SIGNAL desync_and_pause_ready WAIT_FOR desync_and_pause_continue";
81 BACKUP STAGE BLOCK_DDL;
82 connection node_1_ctrl;
83 SET debug_sync = "now WAIT_FOR desync_and_pause_ready";
84 SET debug_sync = "now SIGNAL unlock_continue";
85 connection node_1;
86 connection node_1_ctrl;
87 SET debug_sync = "now SIGNAL desync_and_pause_continue";
88 connection node_1_a;
89 BACKUP STAGE END;
90 CREATE TABLE t1 (f1 INT PRIMARY KEY) ENGINE=InnoDB;
91 DROP TABLE t1;
92 connection node_1_ctrl;
93 SET debug_sync = "RESET";
94 #
95 # Case 4: BACKUP STAGE first, then FTWRL
96 #
97 connection node_1;
98 SET SESSION wsrep_sync_wait=0;
99 BACKUP STAGE START;
100 BACKUP STAGE BLOCK_DDL;
101 SHOW STATUS LIKE 'wsrep_local_state_comment';
102 Variable_name Value
103 wsrep_local_state_comment Donor/Desynced
104 SET SESSION debug_sync = "wsrep_backup_stage_after_resume_and_resync SIGNAL resume_and_resync_ready WAIT_FOR resume_and_resync_continue";
105 BACKUP STAGE END;
106 connection node_1_ctrl;
107 SET debug_sync = "now WAIT_FOR resume_and_resync_ready";
108 connection node_1_a;
109 SET SESSION debug_sync = "wsrep_global_read_lock_block_commit_after_pause SIGNAL lock_ready WAIT_FOR lock_continue";
110 FLUSH TABLES WITH READ LOCK;
111 connection node_1_ctrl;
112 SET debug_sync = "now WAIT_FOR lock_ready";
113 SET debug_sync = "now SIGNAL resume_and_resync_continue";
114 connection node_1;
115 connection node_1_ctrl;
116 SET debug_sync = "now SIGNAL lock_continue";
117 connection node_1_a;
118 UNLOCK TABLES;
119 CREATE TABLE t1 (f1 INT PRIMARY KEY) ENGINE=InnoDB;
120 DROP TABLE t1;
121 connection node_1_ctrl;
122 SET debug_sync = "RESET";