Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE DATABASE database1;
5 USE database1;
6 CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
7 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
8 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
9 CREATE TABLE t2 (f1 INTEGER) ENGINE=InnoDB;
10 SET SESSION wsrep_retry_autocommit = 0;
11 INSERT INTO t1 (f1) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5, ten AS a6;;
12 connection node_1a;
13 USE database1;
14 SET SESSION wsrep_retry_autocommit = 0;
15 INSERT INTO t2 (f1) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5, ten AS a6;;
16 connection node_2;
17 DROP DATABASE database1;;
18 connection node_1;
19 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
20 connection node_1a;
21 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
22 connection node_2;
23 connection node_1;
24 SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'database1';
25 COUNT(*) = 0
26 1
27 USE database1;
28 ERROR 42000: Unknown database 'database1'
29 connection node_2;
30 SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'database1';
31 COUNT(*) = 0
32 1
33 USE database1;
34 ERROR 42000: Unknown database 'database1'