Debian Codegraph @

mysql-test/suite/galera/t/galera_many_tables_pk.test

raw
1 --source include/big_test.inc
2 --source include/galera_cluster.inc
3 --source include/have_innodb.inc
4
5 if (!`SELECT @@open_files_limit >= 1024`){
6 skip Need at least an open file limit of 1024;
7 }
8
9 #
10 # First, create 100 tables and make sure the DDLs are all propagated
11 #
12
13 --connection node_1
14
15 --let $count = 100
16 while ($count)
17 {
18 --disable_query_log
19 --let $ddl_var = `SELECT CONCAT("CREATE TABLE t", $count, " (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB")`
20 --eval $ddl_var
21 --enable_query_log
22 --dec $count
23 }
24
25 --connection node_2
26 SELECT COUNT(*) = 100 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME LIKE 't%';
27
28 #
29 # Second, create a transaction that uses all those tables
30 #
31
32 --connection node_1
33 SET AUTOCOMMIT=OFF;
34 START TRANSACTION;
35
36 --let $count = 100
37 while ($count)
38 {
39 --disable_query_log
40 --let $ddl_var = `SELECT CONCAT("INSERT INTO t", $count, " VALUES (1)")`
41 --eval $ddl_var
42 --enable_query_log
43 --dec $count
44 }
45
46 COMMIT;
47
48 #
49 # Third, confirm that all the inserts have arrived on the second node
50 #
51
52 --connection node_2
53 CREATE TABLE sum_table (f1 INTEGER);
54
55 --let $count = 100
56 while ($count)
57 {
58 --disable_query_log
59 --let $ddl_var = `SELECT CONCAT("INSERT INTO sum_table SELECT COUNT(*) FROM t", $count)`
60 --eval $ddl_var
61 --enable_query_log
62 --dec $count
63 }
64
65 SELECT SUM(f1) = 100 FROM sum_table;
66
67 #
68 # Fourth, create a deadlock
69 #
70
71 --connection node_1
72 SET AUTOCOMMIT=OFF;
73 START TRANSACTION;
74
75 --let $count = 100
76 while ($count)
77 {
78 --disable_query_log
79 --let $ddl_var = `SELECT CONCAT("UPDATE t", $count, " SET f1 = 2")`
80 --eval $ddl_var
81 --enable_query_log
82 --dec $count
83 }
84
85 --connection node_2
86 SET AUTOCOMMIT=OFF;
87 START TRANSACTION;
88 UPDATE t100 SET f1 = 3;
89
90 --connection node_1
91 COMMIT;
92
93 --connection node_2
94 --error ER_LOCK_DEADLOCK
95 COMMIT;
96
97 --let $diff_servers = 1 2
98 --source include/diff_servers.inc
99
100 DROP SCHEMA test;
101 CREATE SCHEMA test;