Debian Codegraph @

mysql-test/suite/galera/r/galera_many_rows.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 connection node_1;
6 SET SESSION innodb_lock_wait_timeout=600;
7 SET SESSION lock_wait_timeout=600;
8 CREATE TABLE ten (f1 INTEGER NOT NULL PRIMARY KEY) engine=InnoDB;
9 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
10 CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 INTEGER) Engine=InnoDB;
11 INSERT INTO t1 (f2) SELECT a1.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
12 connection node_2;
13 SET SESSION wsrep_sync_wait = 0;
14 SET SESSION wsrep_sync_wait = 15;
15 SET GLOBAL wsrep_provider_options = 'repl.causal_read_timeout=PT1H';
16 SELECT COUNT(*) FROM t1;
17 COUNT(*)
18 10000
19 INSERT INTO t1 (f2) SELECT a1.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
20 connection node_1;
21 SELECT COUNT(*) FROM t1;
22 COUNT(*)
23 20000
24 UPDATE t1 SET f2 = 1;
25 connection node_2;
26 SELECT COUNT(*) FROM t1 WHERE f2 = 1;
27 COUNT(*)
28 20000
29 connection node_1;
30 START TRANSACTION;
31 SELECT COUNT(*) FROM t1;
32 COUNT(*)
33 20000
34 UPDATE t1 SET f2 = 3;
35 connection node_2;
36 START TRANSACTION;
37 UPDATE t1 SET f2 = 4;
38 connection node_1;
39 COMMIT;
40 connection node_2;
41 COMMIT;
42 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
43 DROP TABLE t1;
44 DROP TABLE ten;