Debian Codegraph @

mysql-test/suite/x/t/killconnection_sakiladb.test

raw
1 ## This test file provide specific scenario for connection killing.
2 ## Data structures are borrowed from sakila-db example and reduced to smallest (as possible) state.
3 ##
4
5 --source include/xplugin_preamble.inc
6 --source include/xplugin_create_user.inc
7
8 call mtr.add_suppression("Error in diagnostics area: MY-001317 - Query execution was interrupted");
9
10
11 --write_file $MYSQL_TMP_DIR/killconnection_optimize_table.xpl
12 import assert_notices.macro;
13 -->sql
14 START TRANSACTION;
15 UPDATE sakila.payment SET amount = amount + 1 WHERE payment_id = 5068;
16 -->endsql
17
18 -->newsession second x_root test
19 -->stmtsql SELECT connection_id() AS Value;
20 -->recvtovar %ID% Value
21 -->stmtsql OPTIMIZE TABLE sakila.inventory;
22
23 -->setsession
24 # need delay for starting optimize procedure in 'second' session
25 -->sleep 1
26 -->sql
27 KILL %ID%;
28 -->endsql
29
30 -->quiet
31 -->wait_for 1 SELECT count(*) FROM information_schema.processlist WHERE user = 'x_root'
32 -->noquiet
33
34 -->setsession second
35 -->recvresult
36 -->varlet %ER_SESSION_WAS_KILLED% 3169
37 -->callmacro Assert_notice_warning ERROR %ER_SESSION_WAS_KILLED%
38
39 -->expecterror CR_SERVER_GONE_ERROR
40 -->sql
41 SELECT 1;
42 -->endsql
43 -->recvuntildisc show-received
44
45
46 -->sql
47 COMMIT;
48 -->endsql
49 EOF
50
51
52 --write_file $MYSQL_TMP_DIR/killconnection_select_table.xpl
53 -->import assert_notices.macro
54 -->sql
55 START TRANSACTION;
56 UPDATE sakila.payment SET amount = amount + 1 WHERE payment_id = 5068;
57 -->endsql
58
59 -->newsession second x_root test
60 -->stmtsql SELECT connection_id() AS Value;
61 -->recvtovar %ID% Value
62 -->stmtsql SELECT * FROM sakila.inventory;
63
64 -->setsession
65 # need delay for starting procedure in 'second' session
66 -->sleep 1
67 -->sql
68 KILL %ID%;
69 -->endsql
70
71 -->quiet
72 -->wait_for 1 SELECT count(*) FROM information_schema.processlist WHERE user = 'x_root'
73 -->noquiet
74
75 -->setsession second
76 -->recvresult be-quiet
77 -->varlet %ER_SESSION_WAS_KILLED% 3169
78 -->callmacro Assert_notice_warning ERROR %ER_SESSION_WAS_KILLED%
79 -->recvuntildisc show-received
80
81 -->sql
82 COMMIT;
83 -->endsql
84 EOF
85
86
87 CREATE SCHEMA sakila;
88 USE sakila;
89
90 CREATE TABLE inventory (
91 inventory_id INT NOT NULL AUTO_INCREMENT,
92 PRIMARY KEY (inventory_id)
93 );
94
95 CREATE TABLE rental (
96 rental_id INT NOT NULL AUTO_INCREMENT,
97 inventory_id INT NOT NULL,
98 PRIMARY KEY (rental_id),
99 CONSTRAINT fk_rental_inventory FOREIGN KEY (inventory_id) REFERENCES inventory (inventory_id)
100 );
101
102 CREATE TABLE payment (
103 payment_id INT NOT NULL AUTO_INCREMENT,
104 rental_id INT DEFAULT NULL,
105 amount DECIMAL(5,2) NOT NULL,
106 PRIMARY KEY (payment_id),
107 CONSTRAINT fk_payment_rental FOREIGN KEY (rental_id) REFERENCES rental (rental_id)
108 );
109
110 --replace_regex /KILL [0-9]*/KILL $ID/
111 --exec $MYSQLXTEST -u x_root --password='' --file=$MYSQL_TMP_DIR/killconnection_optimize_table.xpl 2>&1
112
113 --replace_regex /KILL [0-9]*/KILL $ID/
114 --exec $MYSQLXTEST -u x_root --password='' --file=$MYSQL_TMP_DIR/killconnection_select_table.xpl 2>&1
115
116
117 ## Cleanup
118 DROP SCHEMA sakila;
119 --source ../include/xplugin_cleanup.inc