Debian Codegraph @

mysql-test/suite/rpl/r/rpl_mts_replica_preserve_commit_order.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 master]
7 CREATE TABLE t1 (a INT) ENGINE = InnoDB;
8 include/sync_slave_sql_with_master.inc
9 [connection slave]
10 FLUSH BINARY LOGS;
11 #
12 # Verify the transactions are ordered correctly on slave
13 #
14 [connection master]
15 SET @save_debug = @@GLOBAL.debug;
16 SET GLOBAL debug = "+d,set_commit_parent_100";
17 [connection slave]
18 LOCK TABLE t1 WRITE;
19 [connection master]
20 INSERT INTO t1(a) VALUES (1);
21 include/save_master_pos.inc
22 [connection slave]
23 UNLOCK TABLES;
24 include/sync_slave_sql.inc
25 SET DEBUG_SYNC = 'RESET';
26 [connection slave]
27 LOCK TABLE t1 WRITE;
28 [connection master]
29 INSERT INTO t1(a) VALUES (2);
30 INSERT INTO t1(a) VALUES (3);
31 include/save_master_pos.inc
32 [connection slave]
33 UNLOCK TABLES;
34 include/sync_slave_sql.inc
35 SET DEBUG_SYNC = 'RESET';
36 [connection slave]
37 LOCK TABLE t1 WRITE;
38 [connection master]
39 INSERT INTO t1(a) VALUES (4);
40 INSERT INTO t1(a) VALUES (5);
41 INSERT INTO t1(a) VALUES (6);
42 include/save_master_pos.inc
43 [connection slave]
44 UNLOCK TABLES;
45 include/sync_slave_sql.inc
46 SET DEBUG_SYNC = 'RESET';
47 [connection slave]
48 LOCK TABLE t1 WRITE;
49 [connection master]
50 INSERT INTO t1(a) VALUES (7);
51 INSERT INTO t1(a) VALUES (8);
52 INSERT INTO t1(a) VALUES (9);
53 INSERT INTO t1(a) VALUES (10);
54 include/save_master_pos.inc
55 [connection slave]
56 UNLOCK TABLES;
57 include/sync_slave_sql.inc
58 SET DEBUG_SYNC = 'RESET';
59 [connection slave]
60 LOCK TABLE t1 WRITE;
61 [connection master]
62 INSERT INTO t1(a) VALUES (11);
63 INSERT INTO t1(a) VALUES (12);
64 INSERT INTO t1(a) VALUES (13);
65 INSERT INTO t1(a) VALUES (14);
66 INSERT INTO t1(a) VALUES (15);
67 include/save_master_pos.inc
68 [connection slave]
69 UNLOCK TABLES;
70 include/sync_slave_sql.inc
71 SET DEBUG_SYNC = 'RESET';
72 [connection slave]
73 LOCK TABLE t1 WRITE;
74 [connection master]
75 INSERT INTO t1(a) VALUES (16);
76 INSERT INTO t1(a) VALUES (17);
77 INSERT INTO t1(a) VALUES (18);
78 INSERT INTO t1(a) VALUES (19);
79 INSERT INTO t1(a) VALUES (20);
80 INSERT INTO t1(a) VALUES (21);
81 include/save_master_pos.inc
82 [connection slave]
83 UNLOCK TABLES;
84 include/sync_slave_sql.inc
85 SET DEBUG_SYNC = 'RESET';
86 [connection slave]
87 DROP TABLE t1;
88 CREATE TABLE t1 (a INT, id INT AUTO_INCREMENT KEY) ENGINE = InnoDB;
89 SELECT * FROM t1 WHERE id <> a;
90 a id
91 include/assert.inc ['There are no mismatched rows']
92 include/assert.inc ['There are no row which is null']
93 include/assert.inc ['There are 21 rows']
94 [connection master]
95 SET GLOBAL debug = @save_debug;
96 DROP TABLE t1;
97 include/sync_slave_sql_with_master.inc
98 #
99 # Verify that it will generate a warning if slave-preserve-commit is
100 # used with DB PARTITIONED MTS together
101 #
102 include/stop_slave_sql.inc
103 SET GLOBAL replica_parallel_type = 'DATABASE';
104 Warnings:
105 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
106 START SLAVE SQL_THREAD;
107 ERROR HY000: replica_preserve_commit_order is not supported when replica_parallel_type is DATABASE.
108 SET GLOBAL replica_parallel_type = 'LOGICAL_CLOCK';
109 Warnings:
110 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
111 include/rpl_end.inc