Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 SELECT COUNT(*) = 100 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME LIKE 't%';
6 COUNT(*) = 100
7 1
8 connection node_1;
9 SET AUTOCOMMIT=OFF;
10 START TRANSACTION;
11 COMMIT;
12 connection node_2;
13 CREATE TABLE sum_table (f1 INTEGER);
14 SELECT SUM(f1) = 100 FROM sum_table;
15 SUM(f1) = 100
16 1
17 connection node_1;
18 SET AUTOCOMMIT=OFF;
19 START TRANSACTION;
20 connection node_2;
21 SET AUTOCOMMIT=OFF;
22 START TRANSACTION;
23 UPDATE t100 SET f1 = 3;
24 connection node_1;
25 COMMIT;
26 connection node_2;
27 COMMIT;
28 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
29 include/diff_servers.inc [servers=1 2]
30 DROP SCHEMA test;
31 CREATE SCHEMA test;