1
by brian
clean slate |
1 |
# Don't test this under valgrind, memory leaks will occur |
2 |
--source include/not_valgrind.inc
|
|
3 |
||
4 |
# Binary must be compiled with debug for crash to occur |
|
5 |
--source include/have_debug.inc
|
|
6 |
||
7 |
--source include/have_innodb.inc
|
|
8 |
||
9 |
CREATE TABLE t1(a int) engine=innodb; |
|
10 |
START TRANSACTION; |
|
11 |
insert into t1 values(9); |
|
12 |
||
13 |
# Setup the mysqld to crash at certain point |
|
14 |
SET SESSION debug="d,crash_commit_before"; |
|
15 |
||
16 |
# Write file to make mysql-test-run.pl expect crash and restart |
|
17 |
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/master0.expect
|
|
18 |
||
19 |
# Run the crashing query |
|
20 |
--error 2013
|
|
21 |
COMMIT; |
|
22 |
||
23 |
# Turn on reconnect |
|
24 |
--enable_reconnect
|
|
25 |
||
26 |
# Call script that will poll the server waiting for it to be back online again |
|
27 |
--source include/wait_until_connected_again.inc
|
|
28 |
||
29 |
SHOW CREATE TABLE t1; |
|
30 |
||
31 |
SELECT * FROM t1; |
|
32 |
||
33 |
||
34 |
DROP TABLE t1; |