mirror of
https://github.com/MariaDB/server.git
synced 2025-04-22 07:05:33 +02:00
25737dbab7
Problem was that transacton was BF-aborted after certification succeeded and transaction tried to rollback and during rollback binlog stmt cache containing sequence value reservations was written into binlog. Transaction must replay because certification succeeded but transaction must not be written into binlog yet, it will be done during commit after the replay. Fix is to skip binlog write if transaction must replay and in replay we need to reset binlog stmt cache. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
350 lines
6.4 KiB
Text
350 lines
6.4 KiB
Text
connection node_2;
|
|
connection node_1;
|
|
connection node_1;
|
|
CREATE SEQUENCE s INCREMENT=0 CACHE=5 ENGINE=InnoDB;
|
|
CREATE TABLE t1 (f1 INT PRIMARY KEY DEFAULT NEXTVAL(s), f2 INT) ENGINE=InnoDB;
|
|
connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
|
|
connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
|
|
connection node_1;
|
|
BEGIN;
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
COMMIT;
|
|
connection node_2;
|
|
BEGIN;
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
COMMIT;
|
|
connection node_2a;
|
|
BEGIN;
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
COMMIT;
|
|
connection node_1a;
|
|
BEGIN;
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
COMMIT;
|
|
connection node_2;
|
|
SELECT LASTVAL(s);
|
|
LASTVAL(s)
|
|
40
|
|
connection node_1;
|
|
SELECT LASTVAL(s);
|
|
LASTVAL(s)
|
|
19
|
|
connection node_2a;
|
|
SELECT LASTVAL(s);
|
|
LASTVAL(s)
|
|
60
|
|
connection node_1a;
|
|
SELECT LASTVAL(s);
|
|
LASTVAL(s)
|
|
79
|
|
connection node_1;
|
|
SELECT * FROM t1;
|
|
f1 f2
|
|
1 1
|
|
3 1
|
|
5 1
|
|
7 1
|
|
9 1
|
|
11 1
|
|
13 1
|
|
15 1
|
|
17 1
|
|
19 1
|
|
22 1
|
|
24 1
|
|
26 1
|
|
28 1
|
|
30 1
|
|
32 1
|
|
34 1
|
|
36 1
|
|
38 1
|
|
40 1
|
|
42 1
|
|
44 1
|
|
46 1
|
|
48 1
|
|
50 1
|
|
52 1
|
|
54 1
|
|
56 1
|
|
58 1
|
|
60 1
|
|
61 1
|
|
63 1
|
|
65 1
|
|
67 1
|
|
69 1
|
|
71 1
|
|
73 1
|
|
75 1
|
|
77 1
|
|
79 1
|
|
connection node_2;
|
|
SELECT * FROM t1;
|
|
f1 f2
|
|
1 1
|
|
3 1
|
|
5 1
|
|
7 1
|
|
9 1
|
|
11 1
|
|
13 1
|
|
15 1
|
|
17 1
|
|
19 1
|
|
22 1
|
|
24 1
|
|
26 1
|
|
28 1
|
|
30 1
|
|
32 1
|
|
34 1
|
|
36 1
|
|
38 1
|
|
40 1
|
|
42 1
|
|
44 1
|
|
46 1
|
|
48 1
|
|
50 1
|
|
52 1
|
|
54 1
|
|
56 1
|
|
58 1
|
|
60 1
|
|
61 1
|
|
63 1
|
|
65 1
|
|
67 1
|
|
69 1
|
|
71 1
|
|
73 1
|
|
75 1
|
|
77 1
|
|
79 1
|
|
connection node_1;
|
|
DROP TABLE t1;
|
|
DROP SEQUENCE s;
|
|
connection node_1;
|
|
CREATE SEQUENCE s INCREMENT=0 CACHE=5 ENGINE=InnoDB;
|
|
CREATE TABLE t1 (f1 INT PRIMARY KEY DEFAULT NEXTVAL(s), f2 INT) ENGINE=InnoDB;
|
|
connection node_1;
|
|
BEGIN;
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
ROLLBACK;
|
|
connection node_2;
|
|
BEGIN;
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
ROLLBACK;
|
|
connection node_2a;
|
|
BEGIN;
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
ROLLBACK;
|
|
connection node_1a;
|
|
BEGIN;
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
ROLLBACK;
|
|
connection node_2;
|
|
SELECT LASTVAL(s);
|
|
LASTVAL(s)
|
|
20
|
|
connection node_1;
|
|
SELECT LASTVAL(s);
|
|
LASTVAL(s)
|
|
19
|
|
connection node_2a;
|
|
SELECT LASTVAL(s);
|
|
LASTVAL(s)
|
|
40
|
|
connection node_1a;
|
|
SELECT LASTVAL(s);
|
|
LASTVAL(s)
|
|
39
|
|
connection node_1;
|
|
SELECT * FROM t1;
|
|
f1 f2
|
|
connection node_2;
|
|
SELECT * FROM t1;
|
|
f1 f2
|
|
connection node_1;
|
|
DROP TABLE t1;
|
|
DROP SEQUENCE s;
|
|
connection node_1;
|
|
CREATE SEQUENCE s INCREMENT=0 CACHE=5 ENGINE=InnoDB;
|
|
CREATE TABLE t1 (f1 INT PRIMARY KEY DEFAULT NEXTVAL(s), f2 INT) ENGINE=InnoDB;
|
|
connection node_1;
|
|
BEGIN;
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
connection node_1a;
|
|
BEGIN;
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
connection node_2a;
|
|
BEGIN;
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
connection node_2;
|
|
BEGIN;
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
INSERT INTO t1(f2) values (1);
|
|
connection node_1;
|
|
COMMIT;
|
|
connection node_1a;
|
|
ROLLBACK;
|
|
connection node_2;
|
|
COMMIT;
|
|
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
|
|
connection node_2a;
|
|
ROLLBACK;
|
|
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
|
|
connection node_2;
|
|
SELECT LASTVAL(s);
|
|
LASTVAL(s)
|
|
40
|
|
connection node_1;
|
|
SELECT LASTVAL(s);
|
|
LASTVAL(s)
|
|
19
|
|
connection node_2a;
|
|
SELECT LASTVAL(s);
|
|
LASTVAL(s)
|
|
20
|
|
connection node_1a;
|
|
SELECT LASTVAL(s);
|
|
LASTVAL(s)
|
|
39
|
|
connection node_1;
|
|
SELECT * FROM t1;
|
|
f1 f2
|
|
1 1
|
|
3 1
|
|
5 1
|
|
7 1
|
|
9 1
|
|
11 1
|
|
13 1
|
|
15 1
|
|
17 1
|
|
19 1
|
|
connection node_2;
|
|
SELECT * FROM t1;
|
|
f1 f2
|
|
1 1
|
|
3 1
|
|
5 1
|
|
7 1
|
|
9 1
|
|
11 1
|
|
13 1
|
|
15 1
|
|
17 1
|
|
19 1
|
|
connection node_1;
|
|
DROP TABLE t1;
|
|
DROP SEQUENCE s;
|