Debian Codegraph @

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

raw
1 --source include/big_test.inc
2 --source include/have_debug.inc
3 --source include/count_sessions.inc
4
5 CREATE TABLE t1(id INT PRIMARY KEY, v INT NOT NULL) ENGINE=InnoDB;
6
7 --let $debug_point=trx_sys_rw_trx_add_rc
8 --let $debug_type=GLOBAL
9 --source include/add_debug_point.inc
10
11 DELIMITER |;
12 CREATE PROCEDURE create_rw_transactions(k INT)
13 BEGIN
14 WHILE 1 DO
15 START TRANSACTION;
16 UPDATE t1 SET v=v+1 WHERE id=k;
17 COMMIT;
18 END WHILE;
19 END|
20 DELIMITER ;|
21 let $N=120;
22 let $i=0;
23 while($i<$N){
24 --connect(C$i,localhost,root,,test)
25 --eval INSERT INTO t1 (id,v) VALUES ($i,0)
26 --send_eval CALL create_rw_transactions($i)
27 --inc $i
28 }
29 --sleep 30
30 let $i=0;
31 while($i<$N){
32 --disconnect C$i
33 --inc $i
34 }
35 --connection default
36
37 DROP PROCEDURE create_rw_transactions;
38 DROP TABLE t1;
39 --source include/remove_debug_point.inc
40
41 --source include/wait_until_count_sessions.inc