diff options
Diffstat (limited to 'mysql-test/suite/innodb_zip/t/wl6501_1.test')
| -rw-r--r-- | mysql-test/suite/innodb_zip/t/wl6501_1.test | 450 |
1 files changed, 0 insertions, 450 deletions
diff --git a/mysql-test/suite/innodb_zip/t/wl6501_1.test b/mysql-test/suite/innodb_zip/t/wl6501_1.test deleted file mode 100644 index c054d54c34a..00000000000 --- a/mysql-test/suite/innodb_zip/t/wl6501_1.test +++ /dev/null @@ -1,450 +0,0 @@ - -#################################################################### -# TC to check truncate table statement atomicity for single # -# tablespace # -# Sceanrio covered: # -# 1. Debug points added for worklog # -# 2. Table with differnt row types # -# 3. Transactional statement. # -#################################################################### - - ---source include/have_innodb.inc ---source include/have_debug.inc ---source include/big_test.inc - -# Valgrind would result in a "long semaphore wait" inside InnoDB ---source include/not_valgrind.inc -# Embedded server does not support crashing ---source include/not_embedded.inc -# Avoid CrashReporter popup on Mac ---source include/not_crashrep.inc - -#----------------------------------------------------------------------- ---disable_query_log -let $MYSQL_DATA_DIR= `select @@datadir`; -let $data_directory = data directory='$MYSQL_TMP_DIR/alt_dir'; -let $innodb_file_per_table_orig=`select @@innodb_file_per_table`; - -call mtr.add_suppression("InnoDB.*table did not exist in the InnoDB data dictionary.*"); -call mtr.add_suppression("InnoDB: A page in the doublewrite buffer is not within space bounds.*"); -call mtr.add_suppression("InnoDB: Cannot create file.*"); -call mtr.add_suppression("InnoDB: Error number 17 means 'File exists'.*"); -call mtr.add_suppression("InnoDB: A page in the doublewrite buffer is not within space bounds"); -call mtr.add_suppression("InnoDB: Error: table .* does not exist in the InnoDB internal"); ---enable_query_log - -#----------------------------------------------------------------------- -set global innodb_file_per_table=on; ---echo # Verify that 'TRUNCATE TABLE' statement works fine and the size ---echo # of .ibd file is equal to the initial size after truncation. - -#----------------------------------------------------------------------- -drop table if exists t1,t2,t3,t4,t6; -let $cnt = 6; -while ($cnt) { - - # table with basic data type + primary ,secondary,composite,prefix index - create table t1(c1 int not null, - c2 int not null, - c3 char(255) not null, - c4 text(500) not null, - c5 blob(500) not null, - c6 varchar(500) not null, - c7 varchar(500) not null, - c8 datetime, - c9 decimal(5,3), - primary key (c1), - index (c3,c4(50),c5(50)), - index (c2)) - engine=innodb row_format=redundant; - - - create table t2(c1 int not null, - c2 int not null, - c3 char(255) not null, - c4 text(500) not null, - c5 blob(500) not null, - c6 varchar(500) not null, - c7 varchar(500) not null, - c8 datetime, - c9 decimal(5,3), - primary key (c1), - index (c3,c4(50),c5(50)), - index (c2)) - engine=innodb row_format=compact; - - - # with row type , key block size = 4K - create table t3(c1 int not null, - c2 int not null, - c3 char(255) not null, - c4 text(500) not null, - c5 blob(500) not null, - c6 varchar(500) not null, - c7 varchar(500) not null, - c8 datetime, - c9 decimal(5,3), - primary key (c1), - index (c3,c4(50),c5(50)), - index (c2)) - engine=innodb row_format=compressed key_block_size=4; - - - create table t4(c1 int not null, - c2 int not null, - c3 char(255) not null, - c4 text(500) not null, - c5 blob(500) not null, - c6 varchar(500) not null, - c7 varchar(500) not null, - c8 datetime, - c9 decimal(5,3), - primary key (c1), - index (c3,c4(50),c5(50)), - index (c2)) - engine=innodb row_format=dynamic; - - - create temporary table t5(c1 int not null, - c2 int not null, - c3 char(255) not null, - c4 text(500) not null, - c5 blob(500) not null, - c6 varchar(500) not null, - c7 varchar(500) not null, - c8 datetime, - c9 decimal(5,3), - primary key (c1), - index (c3,c4(50),c5(50)), - index (c2)) - engine=innodb; - - create table t6 ( a int ) engine = innodb; - insert into t6 values (50),(100),(150); - - --disable_query_log - --disable_result_log - let $n=5; - - # load created tables. - while ($n) - { - start transaction; - - eval insert ignore into t1 values( - $n, $n, - repeat(concat(' tc3_',$n), 42), - repeat(concat(' tc4_',$n), 300), - repeat(concat(' tc5_',$n), 300), - repeat(concat(' tc6_',$n), 300), - repeat(concat(' tc7_',$n), 300), - now(), (100.55+$n)); - - eval insert ignore into t2 values( - $n, $n, - repeat(concat(' tc3_',$n), 42), - repeat(concat(' tc4_',$n), 300), - repeat(concat(' tc5_',$n), 300), - repeat(concat(' tc6_',$n), 300), - repeat(concat(' tc7_',$n), 300), - now(), (100.55+$n)); - - eval insert ignore into t3 values( - $n, $n, - repeat(concat(' tc3_',$n), 42), - repeat(concat(' tc4_',$n), 300), - repeat(concat(' tc5_',$n), 300), - repeat(concat(' tc6_',$n), 300), - repeat(concat(' tc7_',$n), 300), - now(), (100.55+$n)); - - eval insert ignore into t4 values( - $n, $n, - repeat(concat(' tc3_',$n), 42), - repeat(concat(' tc4_',$n), 300), - repeat(concat(' tc5_',$n), 300), - repeat(concat(' tc6_',$n), 300), - repeat(concat(' tc7_',$n), 300), - now(), (100.55+$n)); - - eval insert ignore into t5 values( - $n, $n, - repeat(concat(' tc3_',$n), 42), - repeat(concat(' tc4_',$n), 300), - repeat(concat(' tc5_',$n), 300), - repeat(concat(' tc6_',$n), 300), - repeat(concat(' tc7_',$n), 300), - now(), (100.55+$n)); - - if ($n <= 3) - { - commit; - } - - if ($n > 3) - { - rollback; - } - - dec $n; - } - - # validate loading of the tables. - --enable_result_log - --enable_query_log - select count(*) from t1; - select count(*) from t2; - select count(*) from t3; - select count(*) from t4; - select count(*) from t5; - select count(*) from t6; - - # set the debug crash point and exercise them. - if ($cnt == 6) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_during_drop_index_temp_table"; - --echo "---debug ib_trunc_crash_during_drop_index_temp_table point---" - } - if ($cnt == 5) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_drop_reinit_done_create_to_start"; - --echo "---debug ib_trunc_crash_drop_reinit_done_create_to_start---" - } - - if ($cnt >= 5) { - --echo # Write file to make mysql-test-run.pl expect crash and restart - --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect - --echo # Run the crashing query - --error 2013 - truncate table t5; - --source include/wait_until_disconnected.inc - --enable_reconnect - --echo # Restart the MySQL server - --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect - --source include/wait_until_connected_again.inc - --disable_reconnect - select count(*) from t1; - select count(*) from t2; - select count(*) from t3; - select count(*) from t4; - --error ER_NO_SUCH_TABLE - select count(*) from t5; - select count(*) from t6; - } - - # set the debug crash point and exercise them. - if ($cnt == 6) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_on_drop_of_sec_index"; - --echo "---debug ib_trunc_crash_on_drop_of_sec_index point---" - } - if ($cnt == 5) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_on_create_of_sec_index"; - --echo "---debug ib_trunc_crash_on_create_of_sec_index---" - } - if ($cnt == 4) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_before_log_removal"; - --echo "---debug ib_trunc_crash_before_log_removal point---" - } - if ($cnt == 3) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_after_truncate_done"; - --echo "---debug ib_trunc_crash_after_truncate_done point---" - } - if ($cnt == 2) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_after_truncate_done"; - --echo "---debug ib_trunc_crash_after_truncate_done point---" - } - if ($cnt == 1) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_after_redo_log_write_complete"; - --echo "---debug ib_trunc_crash_after_redo_log_write_complete point---" - } - - --echo # Write file to make mysql-test-run.pl expect crash and restart - --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect - --echo # Run the crashing query - --error 2013 - truncate table t1; - --source include/wait_until_disconnected.inc - --enable_reconnect - --echo # Restart the MySQL server - --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect - --source include/wait_until_connected_again.inc - --disable_reconnect - select count(*) from t1; - select count(*) from t2; - select count(*) from t3; - select count(*) from t4; - --error ER_NO_SUCH_TABLE - select count(*) from t5; - select count(*) from t6; - - if ($cnt == 6) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_on_drop_of_sec_index"; - --echo "---debug ib_trunc_crash_on_drop_of_sec_index point---" - } - if ($cnt == 5) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_on_create_of_sec_index"; - --echo "---debug ib_trunc_crash_on_create_of_sec_index---" - } - if ($cnt == 4) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_before_log_removal"; - --echo "---debug ib_trunc_crash_before_log_removal point---" - } - if ($cnt == 3) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_after_truncate_done"; - --echo "---debug ib_trunc_crash_after_truncate_done point---" - } - if ($cnt == 2) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_after_truncate_done"; - --echo "---debug ib_trunc_crash_after_truncate_done point---" - } - if ($cnt == 1) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_after_redo_log_write_complete"; - --echo "---debug ib_trunc_crash_after_redo_log_write_complete point---" - } - - - --echo # Write file to make mysql-test-run.pl expect crash and restart - --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect - --echo # Run the crashing query - --error 2013 - truncate table t2; - --source include/wait_until_disconnected.inc - --enable_reconnect - --echo # Restart the MySQL server - --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect - --source include/wait_until_connected_again.inc - --disable_reconnect - select count(*) from t1; - select count(*) from t2; - select count(*) from t3; - select count(*) from t4; - --error ER_NO_SUCH_TABLE - select count(*) from t5; - select count(*) from t6; - - if ($cnt == 6) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_on_drop_of_sec_index"; - --echo "---debug ib_trunc_crash_on_drop_of_sec_index point---" - } - if ($cnt == 5) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_on_create_of_sec_index"; - --echo "---debug ib_trunc_crash_on_create_of_sec_index---" - } - if ($cnt == 4) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_before_log_removal"; - --echo "---debug ib_trunc_crash_before_log_removal point---" - } - if ($cnt == 3) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_after_truncate_done"; - --echo "---debug ib_trunc_crash_after_truncate_done point---" - } - if ($cnt == 2) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_after_truncate_done"; - --echo "---debug ib_trunc_crash_after_truncate_done point---" - } - if ($cnt == 1) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_after_redo_log_write_complete"; - --echo "---debug ib_trunc_crash_after_redo_log_write_complete point---" - } - - - --echo # Write file to make mysql-test-run.pl expect crash and restart - --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect - --echo # Run the crashing query - --error 2013 - truncate table t3; - --source include/wait_until_disconnected.inc - --enable_reconnect - --echo # Restart the MySQL server - --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect - --source include/wait_until_connected_again.inc - --disable_reconnect - select count(*) from t1; - select count(*) from t2; - select count(*) from t3; - select count(*) from t4; - --error ER_NO_SUCH_TABLE - select count(*) from t5; - select count(*) from t6; - - - if ($cnt == 6) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_on_drop_of_sec_index"; - --echo "---debug ib_trunc_crash_on_drop_of_sec_index point---" - } - if ($cnt == 5) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_on_create_of_sec_index"; - --echo "---debug ib_trunc_crash_on_create_of_sec_index---" - } - if ($cnt == 4) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_before_log_removal"; - --echo "---debug ib_trunc_crash_before_log_removal point---" - } - if ($cnt == 3) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_after_truncate_done"; - --echo "---debug ib_trunc_crash_after_truncate_done point---" - } - if ($cnt == 2) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_after_truncate_done"; - --echo "---debug ib_trunc_crash_after_truncate_done point---" - } - if ($cnt == 1) - { - SET SESSION debug_dbug="+d,ib_trunc_crash_after_redo_log_write_complete"; - --echo "---debug ib_trunc_crash_after_redo_log_write_complete point---" - } - - --echo # Write file to make mysql-test-run.pl expect crash and restart - --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect - --echo # Run the crashing query - --error 2013 - truncate table t4; - --source include/wait_until_disconnected.inc - --enable_reconnect - --echo # Restart the MySQL server - --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect - --source include/wait_until_connected_again.inc - --disable_reconnect - select count(*) from t1; - select count(*) from t2; - select count(*) from t3; - select count(*) from t4; - --error ER_NO_SUCH_TABLE - select count(*) from t5; - select count(*) from t6; - - drop table t1, t2, t3, t4, t6; - - dec $cnt; - - --disable_query_log - eval set global innodb_file_per_table=$innodb_file_per_table_orig; - --enable_query_log -} - - - |