| 1 |
# |
| 2 |
# Test inability in opening a table |
| 3 |
# |
| 4 |
|
| 5 |
source include/not_valgrind.inc; |
| 6 |
source include/not_crashrep.inc; |
| 7 |
source include/have_debug.inc; |
| 8 |
|
| 9 |
--disable_query_log |
| 10 |
CALL mtr.add_suppression("\\[ERROR\\] .* Unable to read page \\[page id: space=.*, page number=.*\\] into the buffer pool after 100 attempts"); |
| 11 |
CALL mtr.add_suppression("\\[ERROR\\] .* Database page corruption on disk or a failed"); |
| 12 |
CALL mtr.add_suppression("\\[ERROR\\] .* Assertion failure: buf0buf\.cc:[0-9]+:ib::fatal triggered"); |
| 13 |
CALL mtr.add_suppression("\\[ERROR\\] .* Trying to do I/O to a tablespace which exists without an \.ibd data file"); |
| 14 |
CALL mtr.add_suppression("\\[ERROR\\] .* trying to read page \\[page id: space=.*, page number=.*\\] in nonexisting or being-dropped tablespace"); |
| 15 |
--enable_query_log |
| 16 |
|
| 17 |
CREATE TABLE t1(c1 INT); |
| 18 |
|
| 19 |
# The ibd file for table t1 is loaded when the server |
| 20 |
# is started for the first time after creating the table. |
| 21 |
--let $restart_parameters="restart: --innodb-buffer-pool-load-at-startup=off" |
| 22 |
--source include/restart_mysqld.inc |
| 23 |
|
| 24 |
# Restart the server twice in succession to avoid loading |
| 25 |
# t1.ibd file during server startup |
| 26 |
--let $restart_parameters="restart: --innodb-buffer-pool-load-at-startup=off" |
| 27 |
--source include/restart_mysqld.inc |
| 28 |
|
| 29 |
SET DEBUG='+d,ib_create_table_fail_disk_full'; |
| 30 |
|
| 31 |
--echo # Write file to make mysql-test-run.pl expect the "crash", but don't |
| 32 |
--echo # start it until it's told to |
| 33 |
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect |
| 34 |
|
| 35 |
--error 2013 |
| 36 |
SELECT * FROM t1; |
| 37 |
|
| 38 |
--disable_reconnect |
| 39 |
--source include/wait_until_disconnected.inc |
| 40 |
|
| 41 |
--let $restart_parameters=restart: |
| 42 |
--source include/start_mysqld.inc |
| 43 |
|
| 44 |
--echo # Cleanup |
| 45 |
DROP TABLE t1; |