Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2
3 --echo #
4 --echo # MDEV-39263 Lost update despite innodb_snapshot_isolation
5 --echo #
6
7 CREATE TABLE si_log(seq SERIAL, val INT UNSIGNED)
8 ENGINE=InnoDB STATS_PERSISTENT=0;
9
10 CREATE TABLE si_counter(val INT UNSIGNED) ENGINE=InnoDB STATS_PERSISTENT=0;
11 INSERT INTO si_counter VALUES(0);
12
13 delimiter |;
14 CREATE PROCEDURE step()
15 BEGIN NOT ATOMIC
16 DECLARE EXIT HANDLER FOR 1020, 1213, 1205 BEGIN ROLLBACK; END;
17 START TRANSACTION WITH CONSISTENT SNAPSHOT;
18 SELECT val INTO @val FROM si_counter;
19 UPDATE si_counter SET val=@val+1;
20 INSERT INTO si_log (val) VALUES (@val);
21 DO SLEEP(0.0001);
22 COMMIT;
23 END|
24
25 CREATE PROCEDURE test(c INT UNSIGNED)
26 BEGIN
27 WHILE c DO
28 SET c=c-1;
29 call step();
30 START TRANSACTION;
31 SELECT COUNT(*) INTO @count FROM si_log;
32 SELECT SUM(val) INTO @sum FROM si_counter;
33 COMMIT;
34 IF (@count != @sum) THEN shutdown; END IF;
35 END WHILE;
36 END|
37 delimiter ;|
38
39 --connect stop_purge,localhost,root
40 START TRANSACTION WITH CONSISTENT SNAPSHOT;
41 --connection default
42 SET innodb_snapshot_isolation=ON;
43
44 --disable_query_log
45 send call test(800);
46 --connect con1,localhost,root
47 SET innodb_snapshot_isolation=ON;
48 call test(800);
49 --disconnect con1
50 --connection default
51 --reap
52
53 --enable_query_log
54 --disconnect stop_purge
55
56 DROP TABLE si_log, si_counter;
57 DROP PROCEDURE test;
58 DROP PROCEDURE step;