Debian Codegraph @

mysql-test/suite/galera_sr/r/galera_sr_multirow_rollback.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY DEFAULT 0, f2 char(12));
4 connection node_1;
5 SET SESSION wsrep_trx_fragment_size = 1;
6 START TRANSACTION;
7 INSERT INTO t1 (f2) VALUES ('a'), ('b');
8 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
9 COMMIT;
10 SELECT COUNT(*) AS expect_0 FROM t1;
11 expect_0
12 0
13 connection node_2;
14 SELECT COUNT(*) AS expect_0 FROM t1;
15 expect_0
16 0
17 DROP TABLE t1;
18 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY DEFAULT 0, f2 char(12));
19 connection node_1;
20 SET SESSION wsrep_trx_fragment_size = 1000;
21 START TRANSACTION;
22 INSERT INTO t1 (f2) VALUES ('a'), ('b');
23 ERROR 23000: Duplicate entry '0' for key 'PRIMARY'
24 COMMIT;
25 SELECT COUNT(*) AS expect_0 FROM t1;
26 expect_0
27 0
28 connection node_2;
29 SELECT COUNT(*) AS expect_0 FROM t1;
30 expect_0
31 0
32 DROP TABLE t1;
33 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY DEFAULT 0, f2 char(12));
34 connection node_1;
35 SET SESSION wsrep_trx_fragment_size = 1000;
36 START TRANSACTION;
37 INSERT INTO t1 VALUES (1, 'a');
38 INSERT INTO t1 VALUES (2, 'b');
39 INSERT INTO t1 (f2) VALUES ('c'), ('d');
40 ERROR 23000: Duplicate entry '0' for key 'PRIMARY'
41 COMMIT;
42 expect (1,'a'), (2, 'b')
43 SELECT * FROM t1;
44 f1 f2
45 1 a
46 2 b
47 connection node_2;
48 expect (1,'a'), (2, 'b')
49 SELECT * FROM t1;
50 f1 f2
51 1 a
52 2 b
53 DROP TABLE t1;
54 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY DEFAULT 0, f2 char(12));
55 connection node_1;
56 SET SESSION wsrep_trx_fragment_size = 1;
57 INSERT INTO t1 (f2) VALUES ('a'), ('b');
58 ERROR 23000: Duplicate entry '0' for key 'PRIMARY'
59 SELECT COUNT(*) AS expect_0 FROM t1;
60 expect_0
61 0
62 connection node_2;
63 SELECT COUNT(*) AS expect_0 FROM t1;
64 expect_0
65 0
66 connection node_1;
67 SET SESSION wsrep_trx_fragment_size = 1000;
68 INSERT INTO t1 (f2) VALUES ('a'), ('b');
69 ERROR 23000: Duplicate entry '0' for key 'PRIMARY'
70 SELECT COUNT(*) AS expect_0 FROM t1;
71 expect_0
72 0
73 connection node_2;
74 SELECT COUNT(*) AS expect_0 FROM t1;
75 expect_0
76 0
77 DROP TABLE t1;
78 connection node_1;
79 CREATE TABLE p(id int primary key, j int) ENGINE=InnoDB;
80 CREATE TABLE c(id int primary key, fk1 int) ENGINE=InnoDB;
81 ALTER TABLE c ADD FOREIGN KEY (fk1) references p(id);
82 INSERT INTO p VALUES(1, 0);
83 SET SESSION wsrep_trx_fragment_size=1;
84 START TRANSACTION;
85 INSERT INTO c VALUES (3,1);
86 INSERT INTO c VALUES (1,1), (2,2);
87 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
88 COMMIT;
89 SELECT * FROM p;
90 id j
91 1 0
92 SELECT * FROM c;
93 id fk1
94 connection node_2;
95 SELECT * FROM p;
96 id j
97 1 0
98 SELECT * FROM c;
99 id fk1
100 DROP TABLE c;
101 DROP TABLE p;
102 connection node_1;
103 CREATE TABLE p(id int primary key, j int) ENGINE=InnoDB;
104 CREATE TABLE c(id int primary key, fk1 int) ENGINE=InnoDB;
105 ALTER TABLE c ADD FOREIGN KEY (fk1) references p(id);
106 INSERT INTO p VALUES(1, 0);
107 SET SESSION wsrep_trx_fragment_size=1000;
108 START TRANSACTION;
109 INSERT INTO c VALUES (3,1);
110 INSERT INTO c VALUES (1,1), (2,2);
111 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`c`, CONSTRAINT `c_ibfk_1` FOREIGN KEY (`fk1`) REFERENCES `p` (`id`))
112 COMMIT;
113 SELECT * FROM p;
114 id j
115 1 0
116 SELECT * FROM c;
117 id fk1
118 3 1
119 connection node_2;
120 SELECT * FROM p;
121 id j
122 1 0
123 SELECT * FROM c;
124 id fk1
125 3 1
126 DROP TABLE c;
127 DROP TABLE p;