Debian Codegraph @

mysql-test/suite/innodb/r/binlog_consistent.result

raw
1 RESET MASTER;
2 connect con1,localhost,root,,;
3 connect con2,localhost,root,,;
4 connect con3,localhost,root,,;
5 connect con4,localhost,root,,;
6 connection default;
7 CREATE TABLE t1 (a INT, b VARCHAR(100), PRIMARY KEY (a,b)) ENGINE=innodb;
8 INSERT INTO t1 VALUES(9, "");
9 SHOW MASTER STATUS;
10 File Position Binlog_Do_DB Binlog_Ignore_DB
11 master-bin.000001 <pos>
12 SHOW STATUS LIKE 'binlog_snapshot_%';
13 Variable_name Value
14 Binlog_snapshot_file master-bin.000001
15 Binlog_snapshot_position <pos>
16 BEGIN;
17 INSERT INTO t1 VALUES (0, "");
18 connection con1;
19 BEGIN;
20 INSERT INTO t1 VALUES (1, "");
21 connection con2;
22 CREATE TABLE t2 (a INT PRIMARY KEY) ENGINE=myisam;
23 BEGIN;
24 INSERT INTO t1 VALUES (2, "first");
25 INSERT INTO t2 VALUES (2);
26 INSERT INTO t1 VALUES (2, "second");
27 connection default;
28 COMMIT;
29 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
30 START TRANSACTION WITH CONSISTENT SNAPSHOT;
31 connection con3;
32 BEGIN;
33 INSERT INTO t1 VALUES (3, "");
34 INSERT INTO t2 VALUES (3);
35 connection con4;
36 BEGIN;
37 INSERT INTO t1 VALUES (4, "");
38 COMMIT;
39 connection default;
40 SELECT * FROM t1 ORDER BY a,b;
41 a b
42 0
43 9
44 SHOW STATUS LIKE 'binlog_snapshot_%';
45 Variable_name Value
46 Binlog_snapshot_file master-bin.000001
47 Binlog_snapshot_position <pos>
48 SHOW MASTER STATUS;
49 File Position Binlog_Do_DB Binlog_Ignore_DB
50 master-bin.000001 <pos>
51 SELECT * FROM t2 ORDER BY a;
52 a
53 2
54 3
55 connection con1;
56 COMMIT;
57 connection con2;
58 COMMIT;
59 connection con3;
60 COMMIT;
61 FLUSH LOGS;
62 connection default;
63 SELECT * FROM t1 ORDER BY a,b;
64 a b
65 0
66 9
67 SHOW STATUS LIKE 'binlog_snapshot_%';
68 Variable_name Value
69 Binlog_snapshot_file master-bin.000001
70 Binlog_snapshot_position <pos>
71 SHOW MASTER STATUS;
72 File Position Binlog_Do_DB Binlog_Ignore_DB
73 master-bin.000002 <pos>
74 COMMIT;
75 SHOW STATUS LIKE 'binlog_snapshot_%';
76 Variable_name Value
77 Binlog_snapshot_file master-bin.000002
78 Binlog_snapshot_position <pos>
79 SHOW MASTER STATUS;
80 File Position Binlog_Do_DB Binlog_Ignore_DB
81 master-bin.000002 <pos>
82 include/show_binlog_events.inc
83 Log_name Pos Event_type Server_id End_log_pos Info
84 master-bin.000001 # Gtid # # GTID #-#-#
85 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT, b VARCHAR(100), PRIMARY KEY (a,b)) ENGINE=innodb
86 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
87 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES(9, "")
88 master-bin.000001 # Xid # # COMMIT /* XID */
89 master-bin.000001 # Gtid # # GTID #-#-#
90 master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (a INT PRIMARY KEY) ENGINE=myisam
91 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
92 master-bin.000001 # Query # # use `test`; INSERT INTO t2 VALUES (2)
93 master-bin.000001 # Query # # COMMIT
94 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
95 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (0, "")
96 master-bin.000001 # Xid # # COMMIT /* XID */
97 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
98 master-bin.000001 # Query # # use `test`; INSERT INTO t2 VALUES (3)
99 master-bin.000001 # Query # # COMMIT
100 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
101 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (4, "")
102 master-bin.000001 # Xid # # COMMIT /* XID */
103 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
104 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1, "")
105 master-bin.000001 # Xid # # COMMIT /* XID */
106 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
107 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2, "first")
108 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2, "second")
109 master-bin.000001 # Xid # # COMMIT /* XID */
110 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
111 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3, "")
112 master-bin.000001 # Xid # # COMMIT /* XID */
113 master-bin.000001 # Rotate # # master-bin.000002;pos=POS
114 *** MDEV-7310: last_commit_pos_offset set to wrong value after binlog rotate in group commit ***
115 SET @old_size= @@GLOBAL.max_binlog_size;
116 SET GLOBAL max_binlog_size=4096;
117 CREATE TABLE t3 (a INT PRIMARY KEY, b VARBINARY(8192)) ENGINE=MyISAM;
118 INSERT INTO t3 VALUES (10, '');
119 INSERT INTO t3 VALUES (11, 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
120 test_result
121 OK
122 SET GLOBAL max_binlog_size=@old_size;
123 DROP TABLE t1,t2, t3;