Debian Codegraph @

mysql-test/suite/rpl/r/rpl_sql_delay_old.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 [connection slave]
7 CHANGE REPLICATION SOURCE TO SOURCE_DELAY= 7;
8 include/start_slave.inc
9 include/assert.inc [Assert that the desired delay from performance_schema is same as set in the Change master to command.]
10 include/assert.inc [Assert that the sql_delay in show slave status is same as set in the Change master to command.]
11 # Adding debug point 'sql_delay_without_timestamps' to @@GLOBAL.debug
12 [connection master]
13 CREATE TABLE t1 (a INT);
14 [connection slave]
15 include/assert.inc [Assert that the REMAINING_DELAY from performance_schema is same as SQL_Remaining_Delay in the output of show slave status.]
16 [connection master]
17 include/sync_slave_sql_with_master.inc
18 [connection master]
19 [connection slave]
20 include/assert.inc [In the old infrastructure, the execution time of the transaction in the slave must be at least the delay]
21 include/assert.inc [Status should not be 'Waiting until SOURCE_DELAY seconds after source executed event']
22 [connection master]
23 INSERT INTO t1 VALUES (1);
24 [connection slave]
25 include/assert.inc [Assert that the REMAINING_DELAY from performance_schema is same as SQL_Remaining_Delay in the output of show slave status.]
26 [connection master]
27 include/sync_slave_sql_with_master.inc
28 [connection master]
29 [connection slave]
30 include/assert.inc [In the old infrastructure, the execution time of the transaction in the slave must be at least the delay]
31 include/assert.inc [Status should not be 'Waiting until SOURCE_DELAY seconds after source executed event']
32 [connection master]
33 UPDATE t1 SET a=2;
34 [connection slave]
35 include/assert.inc [Assert that the REMAINING_DELAY from performance_schema is same as SQL_Remaining_Delay in the output of show slave status.]
36 [connection master]
37 include/sync_slave_sql_with_master.inc
38 [connection master]
39 [connection slave]
40 include/assert.inc [In the old infrastructure, the execution time of the transaction in the slave must be at least the delay]
41 include/assert.inc [Status should not be 'Waiting until SOURCE_DELAY seconds after source executed event']
42 [connection master]
43 DELETE FROM t1 WHERE a=2;
44 [connection slave]
45 include/assert.inc [Assert that the REMAINING_DELAY from performance_schema is same as SQL_Remaining_Delay in the output of show slave status.]
46 [connection master]
47 include/sync_slave_sql_with_master.inc
48 [connection master]
49 [connection slave]
50 include/assert.inc [In the old infrastructure, the execution time of the transaction in the slave must be at least the delay]
51 include/assert.inc [Status should not be 'Waiting until SOURCE_DELAY seconds after source executed event']
52 [connection master]
53 START TRANSACTION;
54 INSERT INTO t1 VALUES (1);
55 INSERT INTO t1 VALUES (2);
56 INSERT INTO t1 VALUES (3);
57 COMMIT;
58 [connection slave]
59 include/assert.inc [Assert that the REMAINING_DELAY from performance_schema is same as SQL_Remaining_Delay in the output of show slave status.]
60 [connection master]
61 include/sync_slave_sql_with_master.inc
62 [connection master]
63 [connection slave]
64 include/assert.inc [In the old infrastructure, the execution time of the transaction in the slave must be at least the delay]
65 include/assert.inc [Status should not be 'Waiting until SOURCE_DELAY seconds after source executed event']
66 [connection master]
67 DROP TABLE t1;
68 [connection slave]
69 include/assert.inc [Assert that the REMAINING_DELAY from performance_schema is same as SQL_Remaining_Delay in the output of show slave status.]
70 [connection master]
71 include/sync_slave_sql_with_master.inc
72 [connection master]
73 [connection slave]
74 include/assert.inc [In the old infrastructure, the execution time of the transaction in the slave must be at least the delay]
75 include/assert.inc [Status should not be 'Waiting until SOURCE_DELAY seconds after source executed event']
76 [connection master]
77 [connection slave]
78 # Removing debug point 'sql_delay_without_timestamps' from @@GLOBAL.debug
79 include/stop_slave_sql.inc
80 CHANGE REPLICATION SOURCE TO SOURCE_DELAY= 0;
81 include/start_slave_sql.inc
82 [connection master]
83 include/rpl_end.inc