Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_sql_delay_multiple.result

raw
1 include/rpl_init.inc [topology=1->2,1->3]
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 Warnings:
6 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
7 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.
8 [connection server_2]
9 CHANGE REPLICATION SOURCE TO SOURCE_DELAY= 5;
10 include/start_slave.inc
11 [connection server_3]
12 CHANGE REPLICATION SOURCE TO SOURCE_DELAY= 8;
13 include/start_slave.inc
14 [connection server_1]
15 CREATE TABLE t1 (a INT);
16 include/sync_slave_sql_with_master.inc
17 [connection server_1]
18 include/sync_slave_sql_with_master.inc
19 [connection server_1]
20 [connection server_2]
21 [connection server_3]
22 include/assert.inc [The difference between the immediate_commit_timestamp should be at least the SQL_Delay]
23 include/assert.inc [The difference between the immediate_commit_timestamp should be at least the SQL_Delay]
24 [connection server_1]
25 INSERT INTO t1 VALUES (1);
26 include/sync_slave_sql_with_master.inc
27 [connection server_1]
28 include/sync_slave_sql_with_master.inc
29 [connection server_1]
30 [connection server_2]
31 [connection server_3]
32 include/assert.inc [The difference between the immediate_commit_timestamp should be at least the SQL_Delay]
33 include/assert.inc [The difference between the immediate_commit_timestamp should be at least the SQL_Delay]
34 [connection server_1]
35 UPDATE t1 SET a=2;
36 include/sync_slave_sql_with_master.inc
37 [connection server_1]
38 include/sync_slave_sql_with_master.inc
39 [connection server_1]
40 [connection server_2]
41 [connection server_3]
42 include/assert.inc [The difference between the immediate_commit_timestamp should be at least the SQL_Delay]
43 include/assert.inc [The difference between the immediate_commit_timestamp should be at least the SQL_Delay]
44 [connection server_1]
45 DELETE FROM t1 WHERE a=2;
46 include/sync_slave_sql_with_master.inc
47 [connection server_1]
48 include/sync_slave_sql_with_master.inc
49 [connection server_1]
50 [connection server_2]
51 [connection server_3]
52 include/assert.inc [The difference between the immediate_commit_timestamp should be at least the SQL_Delay]
53 include/assert.inc [The difference between the immediate_commit_timestamp should be at least the SQL_Delay]
54 [connection server_1]
55 START TRANSACTION;
56 INSERT INTO t1 VALUES (1);
57 INSERT INTO t1 VALUES (2);
58 INSERT INTO t1 VALUES (3);
59 COMMIT;
60 include/sync_slave_sql_with_master.inc
61 [connection server_1]
62 include/sync_slave_sql_with_master.inc
63 [connection server_1]
64 [connection server_2]
65 [connection server_3]
66 include/assert.inc [The difference between the immediate_commit_timestamp should be at least the SQL_Delay]
67 include/assert.inc [The difference between the immediate_commit_timestamp should be at least the SQL_Delay]
68 [connection server_1]
69 DROP TABLE t1;
70 include/sync_slave_sql_with_master.inc
71 [connection server_1]
72 include/sync_slave_sql_with_master.inc
73 [connection server_1]
74 [connection server_2]
75 [connection server_3]
76 include/assert.inc [The difference between the immediate_commit_timestamp should be at least the SQL_Delay]
77 include/assert.inc [The difference between the immediate_commit_timestamp should be at least the SQL_Delay]
78 [connection server_1]
79 [connection server_2]
80 include/stop_slave_sql.inc
81 CHANGE REPLICATION SOURCE TO SOURCE_DELAY= 0;
82 include/start_slave_sql.inc
83 [connection server_3]
84 include/stop_slave_sql.inc
85 CHANGE REPLICATION SOURCE TO SOURCE_DELAY= 0;
86 include/start_slave_sql.inc
87 include/rpl_end.inc