Debian Codegraph @

mysql-test/suite/galera_3nodes_sr/r/GCF-609.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
4 connection node_1;
5 SET SESSION wsrep_trx_fragment_size=1;
6 SET AUTOCOMMIT=OFF;
7 START TRANSACTION;
8 INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
9 connection node_2;
10 SET SESSION wsrep_trx_fragment_size=1;
11 SET AUTOCOMMIT=OFF;
12 START TRANSACTION;
13 INSERT INTO t1 VALUES (11),(12),(13),(14),(15),(16),(17),(18),(19),(20);
14 INSERT INTO t1 VALUES (11),(12),(13),(14),(15),(16),(17),(18),(19),(20);
15 ERROR 23000: Duplicate entry '11' for key 'PRIMARY'
16 INSERT INTO t1 VALUES (31),(32),(33);
17 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
18 COUNT(*) = 0
19 0
20 connection node_1;
21 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
22 COUNT(*) = 0
23 0
24 COMMIT;
25 connection node_2;
26 COMMIT;
27 SELECT * FROM t1;
28 f1
29 1
30 2
31 3
32 4
33 5
34 6
35 7
36 8
37 9
38 10
39 11
40 12
41 13
42 14
43 15
44 16
45 17
46 18
47 19
48 20
49 31
50 32
51 33
52 connection node_1;
53 SELECT * FROM t1;
54 f1
55 1
56 2
57 3
58 4
59 5
60 6
61 7
62 8
63 9
64 10
65 11
66 12
67 13
68 14
69 15
70 16
71 17
72 18
73 19
74 20
75 31
76 32
77 33
78 DROP TABLE t1;