Debian Codegraph @

mysql-test/suite/galera_sr/r/GCF-585.result

raw
1 connection node_2;
2 connection node_1;
3 create table t1 (f1 integer primary key) engine=innodb;
4 set autocommit=off;
5 set session wsrep_trx_fragment_size=1;
6 start transaction;
7 insert into t1 values (1);
8 insert into t1 values (2),(1);
9 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
10 alter table t1 drop primary key;
11 drop table t1;
12 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
13 INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
14 SET SESSION wsrep_trx_fragment_size=1;
15 SET AUTOCOMMIT=OFF;
16 START TRANSACTION;
17 update t1 set f1 = 100 where f1 = 10;
18 connection node_2;
19 INSERT INTO t1 VALUES (11),(12),(13),(14),(15),(16),(17),(18),(19),(20);
20 SET SESSION wsrep_trx_fragment_size=1;
21 SET SESSION innodb_lock_wait_timeout=1;
22 SET AUTOCOMMIT=OFF;
23 START TRANSACTION;
24 delete from t1 where f1 > 10;
25 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
26 delete from t1 where f1 > 10 and f1 < 100;
27 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
28 DROP TABLE t1;