Debian Codegraph @

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

raw
1 # Scenario:
2 # T1= ({R(Z), R(B)})
3 # T2= ({R(C), R(B), W(B)})
4 # T3= ({R(B), W(B), C}, HIGH_PRIORITY)
5 #
6 # Outcome: T1 must commit, T3 must commit, T2 must commit
7 # after T3 (no data change).
8
9 --source include/have_debug_sync.inc
10 --source include/count_sessions.inc
11
12 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 INT NOT NULL) ENGINE=InnoDB;
13 INSERT INTO t1 VALUES (0, 0, 0);
14
15 --connect(con1,localhost,root,,test)
16 --connect(con2,localhost,root,,test)
17 --connect(con3,localhost,root,,test)
18
19 --echo
20 --echo # On connection 1
21 --connection con1
22 START TRANSACTION READ ONLY;
23 SELECT c1, c2 FROM t1 WHERE c1=0 LOCK IN SHARE MODE;
24
25 --echo
26 --echo # On connection 2
27 --connection con2
28 let $con2_id=`SELECT CONNECTION_ID()`;
29 START TRANSACTION;
30 --send UPDATE t1 SET c1=2 WHERE c1=0 AND c2=0
31
32 --echo
33 --echo # On connection 3
34 --connection con3
35 --source include/start_transaction_high_prio.inc
36 --replace_result $con2_id <con2_id>
37 eval SET @con2_id = $con2_id;
38 let $wait_timeout = 10;
39 let $wait_condition= SELECT COUNT(*) = 1 FROM information_schema.processlist
40 WHERE id = @con2_id AND INFO = 'update t1 set c1=2 where c1=0 and c2=0'
41 AND STATE = 'updating';
42 --source include/wait_condition.inc
43 --sleep 1
44 SET DEBUG_SYNC='rec_lock_add_to_waitq SIGNAL signal1 WAIT_FOR waiting1';
45 --send UPDATE t1 SET c1=3 WHERE c1=0;
46
47 --echo
48 --echo # On connection 1
49 --connection con1
50 SET DEBUG_SYNC='now WAIT_FOR signal1';
51 SET DEBUG_SYNC='now SIGNAL waiting1';
52 COMMIT;
53 --disconnect con1
54
55 --echo
56 --echo # On connection 3
57 --connection con3
58 --reap
59 COMMIT;
60 --disconnect con3
61
62 --echo
63 --echo # On connection 2
64 --connection con2
65 --reap
66 COMMIT;
67 --disconnect con2
68
69 --connection default
70 --let $assert_text= 'There is a 3.0.0 in t1'
71 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE t1.c1 = 3 AND t1.c2 = 0 AND t1.c3 = 0, count, 1] = 1
72 --source include/assert.inc
73
74 --let $assert_text= 'There is no 0.0.0 in t1'
75 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE t1.c1 = 0 AND t1.c2 = 0 AND t1.c3 = 0, count, 1] = 0
76 --source include/assert.inc
77
78 --let $assert_text= 'There is no 2 in t1.c1'
79 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE t1.c1 = 2, count, 1] = 0
80 --source include/assert.inc
81
82 DROP TABLE t1;
83
84 --source include/wait_until_count_sessions.inc