Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_stop_slave.result

raw
1 include/master-slave.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 master]
6
7 # BUG#56118 STOP SLAVE does not wait till trx with CREATE TMP TABLE ends
8 #
9 # If a temporary table is created or dropped, the transaction should be
10 # regarded similarly that a non-transactional table is modified. So
11 # STOP SLAVE should wait until the transaction has finished.
12 CREATE TABLE t1(c1 INT) ENGINE=InnoDB;
13 CREATE TABLE t2(c1 INT) ENGINE=InnoDB;
14 include/sync_slave_sql_with_master.inc
15 SET DEBUG_SYNC= 'RESET';
16 include/stop_slave.inc
17
18 # Suspend the INSERT statement in current transaction on SQL thread.
19 # It guarantees that SQL thread is applying the transaction when
20 # STOP SLAVE command launchs.
21 SET GLOBAL debug= '+d,after_mysql_insert';
22 include/start_slave.inc
23
24 # CREATE TEMPORARY TABLE with InnoDB engine
25 # -----------------------------------------
26
27 [ On Master ]
28 BEGIN;
29 DELETE FROM t1;
30 CREATE TEMPORARY TABLE tt1(c1 INT) ENGINE = InnoDB;
31 INSERT INTO t1 VALUES (1);
32 DROP TEMPORARY TABLE tt1;
33 COMMIT;
34
35 [ On Slave ]
36 STOP SLAVE SQL_THREAD;
37
38 [ On Slave1 ]
39 # To resume slave SQL thread
40 SET DEBUG_SYNC= 'now SIGNAL signal.continue';
41 SET DEBUG_SYNC= 'RESET';
42
43 [ On Slave ]
44 Warnings:
45 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
46 include/wait_for_slave_sql_to_stop.inc
47 # Slave should stop after the transaction has committed.
48 # So t1 on master is same to t1 on slave.
49 include/diff_tables.inc [master:t1, slave:t1]
50 START SLAVE SQL_THREAD;
51 Warnings:
52 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
53 include/wait_for_slave_sql_to_start.inc
54
55 # CREATE TEMPORARY TABLE ... SELECT with InnoDB engine
56 # ----------------------------------------------------
57
58 [ On Master ]
59 BEGIN;
60 DELETE FROM t1;
61 CREATE TEMPORARY TABLE tt1(c1 INT) ENGINE = InnoDB
62 SELECT c1 FROM t2;
63 INSERT INTO t1 VALUES (1);
64 DROP TEMPORARY TABLE tt1;
65 COMMIT;
66
67 [ On Slave ]
68 STOP SLAVE SQL_THREAD;
69
70 [ On Slave1 ]
71 # To resume slave SQL thread
72 SET DEBUG_SYNC= 'now SIGNAL signal.continue';
73 SET DEBUG_SYNC= 'RESET';
74
75 [ On Slave ]
76 Warnings:
77 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
78 include/wait_for_slave_sql_to_stop.inc
79 # Slave should stop after the transaction has committed.
80 # So t1 on master is same to t1 on slave.
81 include/diff_tables.inc [master:t1, slave:t1]
82 START SLAVE SQL_THREAD;
83 Warnings:
84 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
85 include/wait_for_slave_sql_to_start.inc
86
87 # Test end
88 SET GLOBAL debug= '-d,after_mysql_insert';
89 include/restart_slave.inc
90 call mtr.add_suppression("Replica SQL.*Request to stop replica SQL Thread received while applying a group that has non-transactional changes; waiting for completion of the group");
91 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
92 [connection master]
93 DROP TABLE t1, t2;
94 include/rpl_end.inc