| 1 |
|
| 2 |
--disable_query_log |
| 3 |
--eval $insert_statement |
| 4 |
--disable_result_log |
| 5 |
|
| 6 |
--eval SELECT * FROM $table_name LIMIT 1 |
| 7 |
--enable_result_log |
| 8 |
--enable_query_log |
| 9 |
|
| 10 |
if ($get_create_template) |
| 11 |
{ |
| 12 |
let $create_template= query_get_value(SHOW CREATE TABLE $table_name, Create Table, 1); |
| 13 |
} |
| 14 |
|
| 15 |
let $did_crash= 0; |
| 16 |
|
| 17 |
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect |
| 18 |
--disable_reconnect |
| 19 |
|
| 20 |
--error 0,CR_SERVER_LOST,ER_INTERNAL_ERROR |
| 21 |
--eval $crash_statement |
| 22 |
|
| 23 |
# 2013 - CR_SERVER_LOST |
| 24 |
if ($mysql_errno != 2013) |
| 25 |
{ |
| 26 |
--echo # No such crash injection, statement did not crash, cleaning up |
| 27 |
--remove_file $MYSQLTEST_VARDIR/tmp/mysqld.1.expect |
| 28 |
} |
| 29 |
|
| 30 |
# 2013 - CR_SERVER_LOST |
| 31 |
if ($mysql_errno == 2013) |
| 32 |
{ |
| 33 |
let $did_crash= 1; |
| 34 |
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect |
| 35 |
--enable_reconnect |
| 36 |
let $WAIT_COUNT=6000; |
| 37 |
--source include/wait_time_until_connected_again.inc |
| 38 |
let $check= query_get_value(CHECK TABLE $final_table_name, Msg_text, 1); |
| 39 |
if ($check != "OK") |
| 40 |
{ |
| 41 |
--echo "Check table after recovery is not OK!" |
| 42 |
} |
| 43 |
let $create = query_get_value(SHOW CREATE TABLE $final_table_name, Create Table, 1); |
| 44 |
if ($create != $create_template) |
| 45 |
{ |
| 46 |
--echo "Table definition is not as expected!" |
| 47 |
} |
| 48 |
# A full scan would be nice, no need to check the result |
| 49 |
--disable_query_log |
| 50 |
--disable_result_log |
| 51 |
--eval SELECT * FROM $final_table_name |
| 52 |
--enable_result_log |
| 53 |
--enable_query_log |
| 54 |
} |