Prv8 Shell
Server : Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/1.0.0-fips mod_auth_passthrough/2.1 mod_bwlimited/1.4
System : Linux server.jackjohnson.com 2.6.32-279.5.2.el6.x86_64 #1 SMP Fri Aug 24 01:07:11 UTC 2012 x86_64
User : jackjohn ( 502)
PHP Version : 5.3.17
Disable Function : NONE
Directory :  /usr/share/mysql-test/t/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : //usr/share/mysql-test/t/myisam_crash_before_flush_keys.test
--echo #
--echo # BUG#41330 - Myisam table open count set to zero before index blocks are written.
--echo #
--source include/not_embedded.inc
--echo # Don't test this under valgrind, memory leaks will occur
--source include/not_valgrind.inc

--echo # Binary must be compiled with debug for crash to occur
--source include/have_debug.inc

# Avoid CrashReporter popup on Mac
--source include/not_crashrep.inc

let $MYSQLD_DATADIR= `select @@datadir`;
SET GLOBAL delay_key_write=ALL;
CREATE TABLE t1(a INT, 
                b INT, 
                PRIMARY KEY(a , b), 
                KEY(b)) ENGINE=MyISAM DELAY_KEY_WRITE = 1;
INSERT INTO t1 VALUES (1,2),(2,3),(3,4),(4,5),(5,6);

--echo # Setup the mysqld to crash at certain point
SET SESSION debug="d,crash_before_flush_keys";

--echo # Write file to make mysql-test-run.pl expect crash
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect

--echo # Run the crashing query
--error 2013
FLUSH TABLE t1;

--echo # Write file to make mysql-test-run.pl start the server 
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect

--echo # Turn on reconnect
--enable_reconnect

--echo # Call script that will poll the server waiting for
--echo # it to be back online again
--source include/wait_until_connected_again.inc

# Must report that the table wasn't closed properly
CHECK TABLE t1;
DROP TABLE t1;

haha - 2025