Debian Codegraph @

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