Debian Codegraph @

mysql-test/suite/rpl/r/rpl_mts_logical_clock_recovery.result

raw
1 include/only_with_option.inc [GLOBAL.replica_parallel_workers > 2]
2 include/master-slave.inc
3 Warnings:
4 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
5 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.
6 [connection master]
7 # Adding debug point 'set_commit_parent_100' to @@GLOBAL.debug
8 CREATE TABLE t1 (a int primary key) engine=innodb;
9 CREATE TABLE t2 (a int primary key) engine=innodb;
10 CREATE TABLE t3 (a int primary key) engine=innodb;
11 CREATE TABLE t4 (a int primary key) engine=innodb;
12 include/sync_slave_sql_with_master.inc
13 include/stop_slave_sql.inc
14 # Adding debug point 'crash_in_a_worker' to @@GLOBAL.debug
15 # Removing debug point 'set_commit_parent_100' from @@GLOBAL.debug
16 # Adding debug point 'set_commit_parent_150' to @@GLOBAL.debug
17 INSERT INTO t1 values (0);
18 BEGIN;
19 INSERT INTO t2 values (1),(2),(3);
20 UPDATE t2 SET a= a+1 WHERE a=3;
21 COMMIT;
22 BEGIN;
23 INSERT INTO t3 values (1),(2),(3);
24 UPDATE t3 SET a= a+1 WHERE a=3;
25 COMMIT;
26 BEGIN;
27 INSERT INTO t4 values (1),(2),(3);
28 UPDATE t4 SET a= a+1 WHERE a=3;
29 COMMIT;
30 BEGIN;
31 INSERT INTO t1 values (1),(2),(3);
32 UPDATE t1 SET a= a+1 WHERE a=3;
33 COMMIT;
34 # Removing debug point 'set_commit_parent_150' from @@GLOBAL.debug
35 include/sync_slave_io_with_master.inc
36 [connection slave1]
37 BEGIN;
38 INSERT INTO t1 (a) VALUES (4);
39 INSERT INTO t2 (a) VALUES (4);
40 INSERT INTO t3 (a) VALUES (4);
41 INSERT INTO t4 (a) VALUES (4);
42 [connection slave]
43 START SLAVE;
44 Warnings:
45 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
46 include/rpl_start_server.inc [server_number=2]
47 # Reconnecting to the slave server
48 START SLAVE UNTIL SQL_AFTER_MTS_GAPS;
49 CREATE TABLE t5 (a int);
50 include/wait_for_slave_sql_to_stop.inc
51 include/start_slave.inc
52 DROP TABLES t1, t2, t3, t4, t5;
53 include/sync_slave_sql_with_master.inc
54 include/rpl_end.inc