Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_mts_relay_log_post_crash_recovery.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 #### I. Initialize ####
7 [connection slave]
8 include/stop_slave.inc
9 SET @save.innodb_lock_wait_timeout= @@global.innodb_lock_wait_timeout;
10 set @@global.innodb_lock_wait_timeout=5 + 1000;
11 include/start_slave.inc
12 [connection master]
13 CREATE DATABASE d1;
14 CREATE DATABASE d2;
15 CREATE TABLE d1.t (a INT PRIMARY KEY, name text) ENGINE=INNODB;
16 CREATE TABLE d2.t (a INT PRIMARY KEY, name text) ENGINE=INNODB;
17 #### II. Prepare test scenario ####
18 include/sync_slave_sql_with_master.inc
19 BEGIN;
20 INSERT INTO d2.t VALUES (2, 'Slave local');
21 INSERT INTO d1.t VALUES (3, 'Slave local');
22 [connection master]
23 INSERT INTO d1.t VALUES (1, 'T1');
24 INSERT INTO d2.t VALUES (1, 'T2');
25 INSERT INTO d2.t VALUES (2, 'T3');
26 INSERT INTO d2.t VALUES (3, 'T4');
27 INSERT INTO d1.t VALUES (2, 'T5');
28 [connection slave1]
29 # Now d1.t has two rows and d2.t has one row.
30 CALL mtr.add_suppression("Recovery from source pos");
31 [connection slave]
32 # Kill the server
33 include/rpl_start_server.inc [server_number=2 parameters: --skip_replica_start=FALSE --sync_source_info=1 --relay-log-recovery=1]
34 After restart gaps should be filled.
35 include/assert.inc [Table d1.t should contain 2 rows.]
36 include/assert.inc [Table d2.t should contain 3 rows.]
37 [connection master]
38 include/sync_slave_sql_with_master.inc
39 include/diff_tables.inc [master:d1.t, slave:d1.t]
40 include/diff_tables.inc [master:d2.t, slave:d2.t]
41 [connection master]
42 DROP DATABASE d1;
43 DROP DATABASE d2;
44 #### I. Initialize ####
45 [connection slave]
46 include/stop_slave.inc
47 SET @save.innodb_lock_wait_timeout= @@global.innodb_lock_wait_timeout;
48 set @@global.innodb_lock_wait_timeout=5 + 1000;
49 include/start_slave.inc
50 [connection master]
51 CREATE DATABASE d1;
52 CREATE DATABASE d2;
53 CREATE TABLE d1.t (a INT PRIMARY KEY, name text) ENGINE=INNODB;
54 CREATE TABLE d2.t (a INT PRIMARY KEY, name text) ENGINE=INNODB;
55 #### II. Prepare test scenario ####
56 include/sync_slave_sql_with_master.inc
57 BEGIN;
58 INSERT INTO d2.t VALUES (2, 'Slave local');
59 INSERT INTO d1.t VALUES (3, 'Slave local');
60 [connection master]
61 INSERT INTO d1.t VALUES (1, 'T1');
62 INSERT INTO d2.t VALUES (1, 'T2');
63 INSERT INTO d2.t VALUES (2, 'T3');
64 INSERT INTO d2.t VALUES (3, 'T4');
65 INSERT INTO d1.t VALUES (2, 'T5');
66 [connection slave1]
67 # Now d1.t has two rows and d2.t has one row.
68 CALL mtr.add_suppression("Recovery from source pos");
69 [connection slave]
70 # Kill the server
71 include/rpl_start_server.inc [server_number=2 parameters: --skip_replica_start=TRUE --sync_source_info=1 --relay-log-recovery=1]
72 After restart gaps should be filled.
73 include/assert.inc [Table d1.t should contain 2 rows.]
74 include/assert.inc [Table d2.t should contain 3 rows.]
75 include/start_slave.inc
76 [connection master]
77 include/sync_slave_sql_with_master.inc
78 include/diff_tables.inc [master:d1.t, slave:d1.t]
79 include/diff_tables.inc [master:d2.t, slave:d2.t]
80 [connection master]
81 DROP DATABASE d1;
82 DROP DATABASE d2;
83 include/rpl_end.inc