Debian Codegraph @

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

raw
1 #
2 # Tests for threadpool support
3 #
4 --source include/galera_cluster.inc
5
6 --let $node_1 = node_1
7 --let $node_2 = node_2
8 --source ../galera/include/auto_increment_offset_save.inc
9
10 #
11 # start connections in node 2, and execute some SQL statements
12 # leave also open transactions in the node
13 #
14 --connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2
15 --connect node_2b, 127.0.0.1, root, , test, $NODE_MYPORT_2
16 --connect node_2c, 127.0.0.1, root, , test, $NODE_MYPORT_2
17 --connect node_2d, 127.0.0.1, root, , test, $NODE_MYPORT_2
18 --connect node_2e, 127.0.0.1, root, , test, $NODE_MYPORT_2
19
20 --connection node_2a
21 CREATE TABLE t1 (f1 INTEGER NOT NULL PRIMARY KEY, f2 char) ENGINE=InnoDB;
22 INSERT INTO t1 VALUES (0,'a');
23 INSERT INTO t1 VALUES (1,'a');
24
25 --connection node_2b
26 SELECT * FROM t1;
27
28 --connection node_2c
29 INSERT INTO t1 VALUES (2,'c');
30
31 --connection node_2d
32 BEGIN;
33 SELECT * FROM t1;
34
35 --connection node_2e
36 BEGIN;
37 UPDATE t1 SET f2='e' WHERE f1=0;
38
39 #
40 # Shut down node 2, all open connections should be closed
41 #
42 --connection node_2
43 --source include/shutdown_mysqld.inc
44
45 --connection node_1
46 --let $wait_condition = SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
47 --source include/wait_condition.inc
48
49 # And restart the node
50 --connection node_2
51 let $restart_noprint=2;
52 --let $_expect_file_name= $MYSQLTEST_VARDIR/tmp/mysqld.2.expect
53 --source include/start_mysqld.inc
54
55 --connection node_1
56 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
57 --source include/wait_condition.inc
58
59 --connection node_2
60
61 DROP TABLE t1;
62
63 #
64 # Restore auto increment variables.
65 #
66 --source ../galera/include/auto_increment_offset_restore.inc