Debian Codegraph @

mysql-test/suite/rpl/r/rpl_concurrency_error.result

raw
1 include/master-slave.inc
2 [connection master]
3 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
4 ########################################################################
5 # Environment
6 ########################################################################
7 connection master;
8 CREATE TABLE t (i INT, PRIMARY KEY(i), f CHAR(8)) engine = Innodb;
9 CREATE TABLE n (d DATETIME, f CHAR(32)) engine = MyIsam;
10 CREATE TRIGGER tr AFTER UPDATE ON t FOR EACH ROW
11 BEGIN
12 INSERT INTO n VALUES ( now(), concat( 'updated t: ', old.f, ' -> ', new.f ) );
13 END |
14 INSERT INTO t VALUES (4,'black'), (2,'red'), (3,'yelow'), (1,'cyan');
15 connect conn1, 127.0.0.1,root,,;
16 connect conn2, 127.0.0.1,root,,;
17 ########################################################################
18 # Testing ER_LOCK_WAIT_TIMEOUT
19 ########################################################################
20 connection conn1;
21 SET AUTOCOMMIT = 1;
22 BEGIN;
23 UPDATE t SET f = 'yellow 2' WHERE i = 3;
24 Warnings:
25 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them
26 connection conn2;
27 SET AUTOCOMMIT = 1;
28 BEGIN;
29 UPDATE IGNORE t SET f = 'magenta 2' WHERE f = 'red';
30 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
31 INSERT INTO t VALUES (5 + (2 * 10),"brown");
32 INSERT INTO n VALUES (now(),"brown");
33 connection conn1;
34 COMMIT;
35 connection conn2;
36 ROLLBACK;
37 Warnings:
38 Warning 1196 Some non-transactional changed tables couldn't be rolled back
39 include/show_binlog_events.inc
40 Log_name Pos Event_type Server_id End_log_pos Info
41 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
42 master-bin.000001 # Query # # use `test`; INSERT INTO n VALUES (now(),"brown")
43 master-bin.000001 # Query # # COMMIT
44 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
45 master-bin.000001 # Query # # use `test`; UPDATE t SET f = 'yellow 2' WHERE i = 3
46 master-bin.000001 # Xid # # COMMIT /* XID */
47 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
48 master-bin.000001 # Query # # use `test`; UPDATE IGNORE t SET f = 'magenta 2' WHERE f = 'red'
49 master-bin.000001 # Query # # use `test`; INSERT INTO t VALUES (5 + (2 * 10),"brown")
50 master-bin.000001 # Query # # ROLLBACK
51 connection conn1;
52 SET AUTOCOMMIT = 1;
53 BEGIN;
54 UPDATE t SET f = 'gray 2' WHERE i = 3;
55 Warnings:
56 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them
57 connection conn2;
58 SET AUTOCOMMIT = 1;
59 BEGIN;
60 UPDATE IGNORE t SET f = 'dark blue 2' WHERE f = 'red';
61 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
62 INSERT INTO t VALUES (6 + (2 * 10),"brown");
63 INSERT INTO n VALUES (now(),"brown");
64 connection conn1;
65 COMMIT;
66 connection conn2;
67 COMMIT;
68 include/show_binlog_events.inc
69 Log_name Pos Event_type Server_id End_log_pos Info
70 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
71 master-bin.000001 # Query # # use `test`; INSERT INTO n VALUES (now(),"brown")
72 master-bin.000001 # Query # # COMMIT
73 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
74 master-bin.000001 # Query # # use `test`; UPDATE t SET f = 'gray 2' WHERE i = 3
75 master-bin.000001 # Xid # # COMMIT /* XID */
76 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
77 master-bin.000001 # Query # # use `test`; UPDATE IGNORE t SET f = 'dark blue 2' WHERE f = 'red'
78 master-bin.000001 # Query # # use `test`; INSERT INTO t VALUES (6 + (2 * 10),"brown")
79 master-bin.000001 # Xid # # COMMIT /* XID */
80 connection conn1;
81 SET AUTOCOMMIT = 0;
82 UPDATE t SET f = 'yellow 1' WHERE i = 3;
83 Warnings:
84 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them
85 connection conn2;
86 SET AUTOCOMMIT = 0;
87 UPDATE IGNORE t SET f = 'magenta 1' WHERE f = 'red';
88 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
89 INSERT INTO t VALUES (5 + (1 * 10),"brown");
90 INSERT INTO n VALUES (now(),"brown");
91 connection conn1;
92 COMMIT;
93 connection conn2;
94 ROLLBACK;
95 Warnings:
96 Warning 1196 Some non-transactional changed tables couldn't be rolled back
97 include/show_binlog_events.inc
98 Log_name Pos Event_type Server_id End_log_pos Info
99 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
100 master-bin.000001 # Query # # use `test`; INSERT INTO n VALUES (now(),"brown")
101 master-bin.000001 # Query # # COMMIT
102 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
103 master-bin.000001 # Query # # use `test`; UPDATE t SET f = 'yellow 1' WHERE i = 3
104 master-bin.000001 # Xid # # COMMIT /* XID */
105 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
106 master-bin.000001 # Query # # use `test`; UPDATE IGNORE t SET f = 'magenta 1' WHERE f = 'red'
107 master-bin.000001 # Query # # use `test`; INSERT INTO t VALUES (5 + (1 * 10),"brown")
108 master-bin.000001 # Query # # ROLLBACK
109 connection conn1;
110 SET AUTOCOMMIT = 0;
111 UPDATE t SET f = 'gray 1' WHERE i = 3;
112 Warnings:
113 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them
114 connection conn2;
115 SET AUTOCOMMIT = 0;
116 UPDATE IGNORE t SET f = 'dark blue 1' WHERE f = 'red';
117 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
118 INSERT INTO t VALUES (6 + (1 * 10),"brown");
119 INSERT INTO n VALUES (now(),"brown");
120 connection conn1;
121 COMMIT;
122 connection conn2;
123 COMMIT;
124 include/show_binlog_events.inc
125 Log_name Pos Event_type Server_id End_log_pos Info
126 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
127 master-bin.000001 # Query # # use `test`; INSERT INTO n VALUES (now(),"brown")
128 master-bin.000001 # Query # # COMMIT
129 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
130 master-bin.000001 # Query # # use `test`; UPDATE t SET f = 'gray 1' WHERE i = 3
131 master-bin.000001 # Xid # # COMMIT /* XID */
132 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
133 master-bin.000001 # Query # # use `test`; UPDATE IGNORE t SET f = 'dark blue 1' WHERE f = 'red'
134 master-bin.000001 # Query # # use `test`; INSERT INTO t VALUES (6 + (1 * 10),"brown")
135 master-bin.000001 # Xid # # COMMIT /* XID */
136 connection master;
137 connection slave;
138 include/rpl_diff.inc
139 include/rpl_diff.inc
140 ########################################################################
141 # Cleanup
142 ########################################################################
143 connection master;
144 DROP TRIGGER tr;
145 DROP TABLE t;
146 DROP TABLE n;
147 connection slave;
148 connection master;
149 disconnect conn1;
150 disconnect conn2;
151 include/rpl_end.inc