Debian Codegraph @

mysql-test/suite/innodb/t/parallel_read_kill.test

raw
1 --source include/have_debug.inc
2 # Save the initial number of concurrent sessions
3 --source include/count_sessions.inc
4
5 --echo #
6 --echo # Bug#31016076 SELECT COUNT(*) ON LARGE TABLE HANG FOREVER EVEN AFTER CTRL+C
7 --echo #
8
9 DELIMITER |;
10 CREATE PROCEDURE populate_t1(IN BASE INT, IN SIZE INT)
11 BEGIN
12 DECLARE i INT DEFAULT BASE;
13 WHILE (i <= SIZE) DO
14 INSERT INTO t1(f2, f3) values (i, i);
15 SET i = i + 1;
16 END WHILE;
17 END|
18 DELIMITER ;|
19
20 CREATE TABLE t1(
21 f1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
22 f2 INT NOT NULL,
23 f3 INT NOT NULL)
24 ENGINE=INNODB;
25
26 let $counter = 1;
27 let $max_counter=9;
28 while($counter < $max_counter){
29 connect (c$counter, localhost, root,,);
30 inc $counter;
31 }
32
33 --disable_query_log
34 --echo # Create 150000 uncommitted rows
35 let $counter = 1;
36 let $base=1;
37 # Each of 8 connections creates 18750 records
38 let $size = 18750;
39 while($counter < $max_counter) {
40 connection c$counter;
41 BEGIN;
42 send_eval CALL populate_t1($base, $size);
43 connection default;
44 let $base = `SELECT $base + $size`;
45 inc $counter;
46 }
47
48 let $counter = 1;
49 while($counter < $max_counter) {
50 connection c$counter;
51 reap;
52 inc $counter;
53 }
54 --enable_query_log
55
56 connect (con1,localhost,root,,);
57 connection con1;
58 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
59
60 # To make the select slow
61 SET SESSION innodb_parallel_read_threads=2;
62
63 let $ID= `SELECT @id := CONNECTION_ID()`;
64
65 --echo # Count committed rows
66 SET DEBUG_SYNC='parallel_read_wait_for_kill_query SIGNAL ready WAIT_FOR kill_query';
67 --send SELECT count(*) FROM t1
68
69 connection default;
70 SET DEBUG_SYNC='now WAIT_FOR ready';
71 SET DEBUG_SYNC='now SIGNAL kill_query';
72
73 --echo # Killing select query
74 let $ignore= `SELECT @id := $ID`;
75 kill query @id;
76
77 # Wait 1 second for select to be aborted
78 --sleep 1
79
80 --echo # Should be 0 since the query should not be active
81 SELECT COUNT(*) FROM information_schema.processlist WHERE id = @id AND
82 INFO = 'SELECT count(*) FROM t1' AND state="executing";
83
84 connection con1;
85 --error ER_QUERY_INTERRUPTED
86 --reap
87
88
89 --disable_query_log
90 let $counter = 1;
91 while($counter < $max_counter){
92 connection c$counter;
93 COMMIT;
94 disconnect c$counter;
95 inc $counter;
96 }
97 --enable_query_log
98
99 --echo # Cleanup
100 connection default;
101 SET DEBUG_SYNC="RESET";
102 DROP PROCEDURE populate_t1;
103 DROP TABLE t1;
104 disconnect con1;
105
106 # Wait till all disconnects are completed
107 --source include/wait_until_count_sessions.inc