Debian Codegraph @

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

raw
1 --source include/have_debug.inc
2 --source include/have_debug_sync.inc
3 --source include/count_sessions.inc
4
5 --echo # Setup connections
6 SET @old_innodb_thread_concurrency := @@innodb_thread_concurrency;
7 SET @old_innodb_concurrency_tickets := @@innodb_concurrency_tickets;
8 SET @old_innodb_thread_sleep_delay := @@innodb_thread_sleep_delay;
9
10 connect (con1, localhost, root);
11 connect (con2, localhost, root);
12
13 --echo #
14 --echo # Bug #19386426 SHUTDOWN HANGS: CLIENT THREAD IN A LOOP
15 --echo # AROUND SRV_CONC_ENTER_INNODB()
16 --echo #
17
18 SET GLOBAL innodb_thread_concurrency = 1;
19 create table t1(f1 int) engine=innodb;
20 connection con1;
21 SET DEBUG_SYNC= 'ib_after_row_insert
22 SIGNAL opened WAIT_FOR flushed';
23 send insert into t1 values(12);
24 connection default;
25 --echo connection default;
26 SET DEBUG_SYNC= 'now WAIT_FOR opened';
27 # User thread is waiting in FIFO queue.
28 SET DEBUG_SYNC= 'user_thread_waiting
29 SIGNAL flushed WAIT_FOR opened1';
30 send insert into t1 values(13);
31 connection con1;
32 reap;
33 # Set thread_concurrency to zero
34 set global innodb_thread_concurrency=0;
35 SET DEBUG_SYNC= 'now SIGNAL opened1';
36 connection default;
37 reap;
38 select * from t1;
39 drop table t1;
40
41 --echo #
42 --echo # bug#23476050 THREADS STUCK WAITING TO ENTER INNODB
43 --echo #
44
45 --echo # Scenario-1: High Priority Transaction
46 --echo In connection DEFAULT
47 SET GLOBAL innodb_thread_concurrency = 1;
48
49 CREATE TABLE t1(col1 INT PRIMARY KEY);
50 INSERT INTO t1 VALUES(10);
51
52 START TRANSACTION;
53 --echo # Lock Row
54 UPDATE t1 SET col1 = 20 where col1 = 10;
55
56 --echo # stop after TrxInInnoDB and before innodb thread concurrency
57 SET DEBUG_SYNC= 'ha_innobase_index_read_begin SIGNAL kill_me WAIT_FOR proceed';
58
59 --send UPDATE t1 SET col1 = 30 where col1 = 20
60
61 --echo In connection CON-1
62 connection con1;
63 SET DEBUG_SYNC='now WAIT_FOR kill_me';
64 --source include/start_transaction_high_prio.inc
65
66 SET DEBUG_SYNC= 'trx_kill_blocking_enter SIGNAL proceed';
67 UPDATE t1 SET col1 = 100;
68 COMMIT;
69
70 --echo In connection DEFAULT
71 --connection default
72
73 --echo # Rolled back by high priority transaction
74 --error ER_LOCK_DEADLOCK
75 --reap
76
77 SELECT * FROM t1;
78 DROP TABLE t1;
79
80 --echo # Scenario-2: Auto Increment in partitioned table
81 SET GLOBAL innodb_thread_concurrency = 1;
82
83 CREATE TABLE t1 (col1 INT AUTO_INCREMENT PRIMARY KEY, col2 int)
84 PARTITION BY KEY(col1) PARTITIONS 2;
85
86 INSERT INTO t1(col2) VALUES(10);
87
88 SELECT * FROM t1;
89
90 --echo # stop after innodb thread concurrency before auto increment lock
91 SET DEBUG_SYNC='ib_after_row_insert SIGNAL got_innodb_ticket WAIT_FOR proceed';
92
93 --send INSERT INTO t1(col2) VALUES (20)
94
95 --echo In connection CON-1
96 connection con1;
97 SET LOCAL binlog_format = 'STATEMENT';
98 SET DEBUG_SYNC='now WAIT_FOR got_innodb_ticket';
99 --send INSERT INTO t1(col2) SELECT 30
100
101 # wait for insert statement to block on innodb thread concurrency
102 --sleep 1
103
104 --echo In connection CON-2
105 connection con2;
106 SET DEBUG_SYNC='now SIGNAL proceed';
107
108 --echo In connection CON-1
109 connection con1;
110 --reap
111
112 --echo In connection DEFAULT
113 --connection default
114 --reap
115
116 SELECT * FROM t1 ORDER BY col1;
117 DROP TABLE t1;
118
119 --echo #
120 --echo # bug#27661171 INNODB: TRX->DECLARED_TO_BE_INSIDE_INNODB
121 --echo #
122 CREATE TABLE t1 (col1 INT AUTO_INCREMENT PRIMARY KEY, col2 int)
123 PARTITION BY KEY(col1) PARTITIONS 2;
124
125 --echo # Insert 2 rows in same statement consuming the tickets
126 SET GLOBAL innodb_concurrency_tickets = 2;
127 SHOW VARIABLES LIKE 'innodb_concurrency_tickets';
128 INSERT INTO t1(col2) VALUES (10), (20);
129
130 SELECT * FROM t1 ORDER BY col1;
131 DROP TABLE t1;
132
133 --echo # Cleanup
134 disconnect con1;
135 disconnect con2;
136
137 SET DEBUG_SYNC='reset';
138 SET GLOBAL innodb_thread_concurrency = @old_innodb_thread_concurrency;
139 SET GLOBAL innodb_concurrency_tickets = @old_innodb_concurrency_tickets;
140 SET GLOBAL innodb_thread_sleep_delay = @old_innodb_thread_sleep_delay;
141
142 --source include/wait_until_count_sessions.inc