Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES (1);
5 connection node_2;
6 SET AUTOCOMMIT=OFF;
7 START TRANSACTION;
8 INSERT INTO t1 VALUES (2);
9 connection node_2a;
10 ALTER TABLE t1 ADD COLUMN f2 INTEGER, LOCK=EXCLUSIVE;
11 connection node_2;
12 COMMIT;
13 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
14 connection node_1;
15 INSERT INTO t1 VALUES (2, 2);
16 SELECT COUNT(*) = 2 FROM t1;
17 COUNT(*) = 2
18 1
19 connection node_2;
20 INSERT INTO t1 VALUES (3, 3);
21 SELECT COUNT(*) = 3 FROM t1;
22 COUNT(*) = 3
23 1
24 DROP TABLE t1;