diff options
Diffstat (limited to 'mysql-test/suite/innodb_zip/t')
| -rw-r--r-- | mysql-test/suite/innodb_zip/t/wl6501_1.opt | 1 | ||||
| -rw-r--r-- | mysql-test/suite/innodb_zip/t/wl6501_1.test | 450 | ||||
| -rw-r--r-- | mysql-test/suite/innodb_zip/t/wl6501_crash_3.opt | 1 | ||||
| -rw-r--r-- | mysql-test/suite/innodb_zip/t/wl6501_crash_3.test | 26 | ||||
| -rw-r--r-- | mysql-test/suite/innodb_zip/t/wl6501_crash_4.opt | 1 | ||||
| -rw-r--r-- | mysql-test/suite/innodb_zip/t/wl6501_crash_4.test | 26 | ||||
| -rw-r--r-- | mysql-test/suite/innodb_zip/t/wl6501_crash_5.opt | 1 | ||||
| -rw-r--r-- | mysql-test/suite/innodb_zip/t/wl6501_crash_5.test | 24 | ||||
| -rw-r--r-- | mysql-test/suite/innodb_zip/t/wl6501_scale_1.opt | 1 | ||||
| -rw-r--r-- | mysql-test/suite/innodb_zip/t/wl6501_scale_1.test | 36 |
10 files changed, 0 insertions, 567 deletions
diff --git a/mysql-test/suite/innodb_zip/t/wl6501_1.opt b/mysql-test/suite/innodb_zip/t/wl6501_1.opt deleted file mode 100644 index 6966a4e3352..00000000000 --- a/mysql-test/suite/innodb_zip/t/wl6501_1.opt +++ /dev/null @@ -1 +0,0 @@ ---innodb_page_size=16384
\ No newline at end of file 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 -} - - - diff --git a/mysql-test/suite/innodb_zip/t/wl6501_crash_3.opt b/mysql-test/suite/innodb_zip/t/wl6501_crash_3.opt deleted file mode 100644 index 6966a4e3352..00000000000 --- a/mysql-test/suite/innodb_zip/t/wl6501_crash_3.opt +++ /dev/null @@ -1 +0,0 @@ ---innodb_page_size=16384
\ No newline at end of file diff --git a/mysql-test/suite/innodb_zip/t/wl6501_crash_3.test b/mysql-test/suite/innodb_zip/t/wl6501_crash_3.test deleted file mode 100644 index 8d938ab5db8..00000000000 --- a/mysql-test/suite/innodb_zip/t/wl6501_crash_3.test +++ /dev/null @@ -1,26 +0,0 @@ -# -# WL#6501: make truncate table atomic -# - -# TC tries to hit crash point during truncate of -# compressed non-temp table residing in single tablespace -# with page-size=16k - ---source include/have_innodb.inc ---source include/have_debug.inc ---source include/big_test.inc - -# Valgrind would complain about memory leaks when we crash on purpose. ---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 -let $innodb_file_format_orig=`select @@innodb_file_format`; -SET GLOBAL innodb_file_format=Barracuda; -let $wl6501_file_per_table = 1; -let $wl6501_row_fmt = compressed; -let $wl6501_kbs = 16; ---source include/innodb_wl6501_crash.inc -eval SET GLOBAL innodb_file_format=$innodb_file_format_orig; - diff --git a/mysql-test/suite/innodb_zip/t/wl6501_crash_4.opt b/mysql-test/suite/innodb_zip/t/wl6501_crash_4.opt deleted file mode 100644 index 67124777fd9..00000000000 --- a/mysql-test/suite/innodb_zip/t/wl6501_crash_4.opt +++ /dev/null @@ -1 +0,0 @@ ---innodb_page_size=4096
\ No newline at end of file diff --git a/mysql-test/suite/innodb_zip/t/wl6501_crash_4.test b/mysql-test/suite/innodb_zip/t/wl6501_crash_4.test deleted file mode 100644 index b042715ed94..00000000000 --- a/mysql-test/suite/innodb_zip/t/wl6501_crash_4.test +++ /dev/null @@ -1,26 +0,0 @@ -# -# WL#6501: make truncate table atomic -# - -# TC tries to hit crash point during truncate of -# compressed non-temp table residing in single tablespace. -# with page-size=4k - ---source include/have_innodb.inc ---source include/have_debug.inc ---source include/big_test.inc - -# Valgrind would complain about memory leaks when we crash on purpose. ---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 - -let $wl6501_file_per_table = 1; -let $wl6501_row_fmt = compressed; -let $wl6501_kbs = 4; ---source suite/innodb/include/innodb_wl6501_crash.inc - -let $wl6501_temp = temporary; ---source suite/innodb/include/innodb_wl6501_crash_temp.inc diff --git a/mysql-test/suite/innodb_zip/t/wl6501_crash_5.opt b/mysql-test/suite/innodb_zip/t/wl6501_crash_5.opt deleted file mode 100644 index f0fc19df677..00000000000 --- a/mysql-test/suite/innodb_zip/t/wl6501_crash_5.opt +++ /dev/null @@ -1 +0,0 @@ ---innodb_page_size=8192
\ No newline at end of file diff --git a/mysql-test/suite/innodb_zip/t/wl6501_crash_5.test b/mysql-test/suite/innodb_zip/t/wl6501_crash_5.test deleted file mode 100644 index 9686f5aa6a1..00000000000 --- a/mysql-test/suite/innodb_zip/t/wl6501_crash_5.test +++ /dev/null @@ -1,24 +0,0 @@ -# -# WL#6501: make truncate table atomic -# - -# TC tries to hit crash point during truncate of -# compressed non-temp table residing in single tablespace. -# with page-size=8k - ---source include/have_innodb.inc ---source include/have_debug.inc ---source include/big_test.inc - -# Valgrind would complain about memory leaks when we crash on purpose. ---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 - -let $wl6501_file_per_table = 1; -let $wl6501_row_fmt = compressed; -let $wl6501_kbs = 8; ---source suite/innodb/include/innodb_wl6501_crash.inc - diff --git a/mysql-test/suite/innodb_zip/t/wl6501_scale_1.opt b/mysql-test/suite/innodb_zip/t/wl6501_scale_1.opt deleted file mode 100644 index 6966a4e3352..00000000000 --- a/mysql-test/suite/innodb_zip/t/wl6501_scale_1.opt +++ /dev/null @@ -1 +0,0 @@ ---innodb_page_size=16384
\ No newline at end of file diff --git a/mysql-test/suite/innodb_zip/t/wl6501_scale_1.test b/mysql-test/suite/innodb_zip/t/wl6501_scale_1.test deleted file mode 100644 index 988f76e1151..00000000000 --- a/mysql-test/suite/innodb_zip/t/wl6501_scale_1.test +++ /dev/null @@ -1,36 +0,0 @@ -# -# WL#6501: make truncate table atomic -# - -# load table with some significiant amount of data -# and then try truncate - ---source include/have_innodb.inc ---source include/have_debug.inc ---source include/big_test.inc - -# Valgrind would complain about memory leaks when we crash on purpose. ---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 - - -# Single-Tablespace/Non-Compressed -let $wl6501_file_per_table = 1; -let $wl6501_row_fmt = compact; -let $wl6501_kbs = 16; ---source suite/innodb_zip/include/innodb_wl6501_scale.inc - -# Single-Tablespace/Compressed -let $wl6501_file_per_table = 1; -let $wl6501_row_fmt = compressed; -let $wl6501_kbs = 16; ---source suite/innodb_zip/include/innodb_wl6501_scale.inc - -# System-Tablespace/Non-Compressed -let $wl6501_file_per_table = 0; -let $wl6501_row_fmt = compact; -let $wl6501_kbs = 16; ---source suite/innodb_zip/include/innodb_wl6501_scale.inc |