Debian Codegraph @

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

raw
1 # Scenario: High prio setup with crash points.
2 # T1= ({R(B), W(B)}, )
3 # T2= ({R(B), W(B), C}, HIGH PRIORITY)
4 #
5 # Outcome: T2 completes according to crash point. T1 aborts.
6
7 --source include/have_debug.inc
8 # Valgrind would complain about memory leaks when we crash on purpose.
9 --source include/not_valgrind.inc
10 # # Avoid CrashReporter popup on Mac
11 --source include/not_crashrep.inc
12
13 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
14 INSERT INTO t1 VALUES (0);
15
16 --connect(con1,localhost,root,,test)
17 --connect(con2,localhost,root,,test)
18
19 --echo
20 --echo # On connection con1
21 --connection con1
22 START TRANSACTION;
23 UPDATE t1 SET c1=1 WHERE c1=0;
24
25 --echo
26 --echo # On connection con2
27 --connection con2
28 --source include/start_transaction_high_prio.inc
29 UPDATE t1 SET c1=2 WHERE c1=0;
30 SET DEBUG='+d,crash_commit_after';
31 # Request a crash, and restart the server.
32 # Write file to make mysql-test-run.pl restart the server
33 --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
34 --error 2013
35 COMMIT;
36
37 --disconnect con1
38 --disconnect con2
39
40 --echo
41 --echo # On connection default
42 --connection default
43 --enable_reconnect
44 --source include/wait_until_connected_again.inc
45 --echo # Value 2 is expected as server crash on high prio txn (crash_commit_after point)
46 SELECT * FROM t1;
47
48 DROP TABLE t1;
49
50 --echo # Case : crash before commit on high prio transaction
51 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
52 INSERT INTO t1 VALUES (0);
53
54 --connect(con1,localhost,root,,test)
55 --connect(con2,localhost,root,,test)
56
57 --echo
58 --echo # On connection con1
59 --connection con1
60 START TRANSACTION;
61 UPDATE t1 SET c1=1 WHERE c1=0;
62
63 --echo
64 --echo # On connection con2
65 --connection con2
66 --source include/start_transaction_high_prio.inc
67 UPDATE t1 SET c1=2 WHERE c1=0;
68 --connection default
69 --source include/kill_and_restart_mysqld.inc
70
71 --disconnect con1
72 --disconnect con2
73
74 --echo # Value 0 is expected as server crash on high prio txn (crash_commit_before point)
75 SELECT * FROM t1;
76
77 DROP TABLE t1;