Debian Codegraph @

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

raw
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;