diff options
Diffstat (limited to 'mysql-test/suite/maria/maria-recovery-rtree-ft.result')
| -rw-r--r-- | mysql-test/suite/maria/maria-recovery-rtree-ft.result | 190 |
1 files changed, 190 insertions, 0 deletions
diff --git a/mysql-test/suite/maria/maria-recovery-rtree-ft.result b/mysql-test/suite/maria/maria-recovery-rtree-ft.result new file mode 100644 index 00000000..329cc71c --- /dev/null +++ b/mysql-test/suite/maria/maria-recovery-rtree-ft.result @@ -0,0 +1,190 @@ +set global aria_log_file_size=4294959104; +drop database if exists mysqltest; +create database mysqltest; +connect admin, localhost, root,,mysqltest,,; +connection default; +use mysqltest; +connection default; +connection admin; +* shut down mysqld, removed logs, restarted it +connection default; +CREATE TABLE t1 ( +line POINT NOT NULL, +kind ENUM('po', 'pp', 'rr', 'dr', 'rd', 'ts', 'cl') NOT NULL DEFAULT 'po', +name VARCHAR(32) +,SPATIAL key (line) +) transactional=1 row_format=page engine=aria; +SHOW INDEX FROM t1; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Ignored +t1 1 line 1 line A NULL 32 NULL SPATIAL NO +CREATE TABLE t2 (a VARCHAR(200), b TEXT, FULLTEXT (a,b) +) transactional=1 row_format=page engine=aria; +SHOW INDEX FROM t2; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Ignored +t2 1 a 1 a NULL NULL NULL NULL YES FULLTEXT NO +t2 1 a 2 b NULL NULL NULL NULL YES FULLTEXT NO +* TEST of REDO: see if recovery can reconstruct if we give it an old table +connection admin; +* copied t2 for feeding_recovery +* copied t1 for feeding_recovery +connection default; +connection admin; +flush table t2; +* copied t2 for comparison +flush table t1; +* copied t1 for comparison +connection default; +connection admin; +SET SESSION debug_dbug="+d,maria_flush_whole_log,maria_crash"; +* crashing mysqld intentionally +set global aria_checkpoint_interval=1; +ERROR HY000: Lost connection to server during query +* copied t2 back for feeding_recovery +* copied t1 back for feeding_recovery +* recovery happens +check table t2 extended; +Table Op Msg_type Msg_text +mysqltest.t2 check status OK +* testing that checksum after recovery is as expected +Checksum-check +ok +check table t1 extended; +Table Op Msg_type Msg_text +mysqltest.t1 check status OK +* testing that checksum after recovery is as expected +Checksum-check +ok +connection default; +use mysqltest; +* TEST of INSERT and DELETE's rollback +connection admin; +flush table t2; +* copied t2 for comparison +flush table t1; +* copied t1 for comparison +connection default; +lock tables t1 write, t2 write; +connection admin; +SET SESSION debug_dbug="+d,maria_crash"; +* crashing mysqld intentionally +set global aria_checkpoint_interval=1; +ERROR HY000: Lost connection to server during query +* recovery happens +check table t2 extended; +Table Op Msg_type Msg_text +mysqltest.t2 check status OK +* testing that checksum after recovery is as expected +Checksum-check +ok +check table t1 extended; +Table Op Msg_type Msg_text +mysqltest.t1 check status OK +* testing that checksum after recovery is as expected +Checksum-check +ok +connection default; +use mysqltest; +connection admin; +flush table t2; +* copied t2 for comparison +flush table t1; +* copied t1 for comparison +connection default; +lock tables t1 write, t2 write; +connection admin; +SET SESSION debug_dbug="+d,maria_flush_whole_page_cache,maria_crash"; +* crashing mysqld intentionally +set global aria_checkpoint_interval=1; +ERROR HY000: Lost connection to server during query +* recovery happens +check table t2 extended; +Table Op Msg_type Msg_text +mysqltest.t2 check status OK +* testing that checksum after recovery is as expected +Checksum-check +ok +check table t1 extended; +Table Op Msg_type Msg_text +mysqltest.t1 check status OK +* testing that checksum after recovery is as expected +Checksum-check +ok +connection default; +use mysqltest; +connection admin; +flush table t2; +* copied t2 for comparison +flush table t1; +* copied t1 for comparison +connection default; +lock tables t1 write, t2 write; +connection admin; +SET SESSION debug_dbug="+d,maria_flush_states,maria_flush_whole_log,maria_crash"; +* crashing mysqld intentionally +set global aria_checkpoint_interval=1; +ERROR HY000: Lost connection to server during query +* recovery happens +check table t2 extended; +Table Op Msg_type Msg_text +mysqltest.t2 check status OK +* testing that checksum after recovery is as expected +Checksum-check +ok +check table t1 extended; +Table Op Msg_type Msg_text +mysqltest.t1 check status OK +* testing that checksum after recovery is as expected +Checksum-check +ok +connection default; +use mysqltest; +connection admin; +flush table t2; +* copied t2 for comparison +flush table t1; +* copied t1 for comparison +connection default; +lock tables t1 write, t2 write; +connection admin; +SET SESSION debug_dbug="+d,maria_flush_whole_log,maria_crash"; +* crashing mysqld intentionally +set global aria_checkpoint_interval=1; +ERROR HY000: Lost connection to server during query +* recovery happens +check table t2 extended; +Table Op Msg_type Msg_text +mysqltest.t2 check status OK +* testing that checksum after recovery is as expected +Checksum-check +ok +check table t1 extended; +Table Op Msg_type Msg_text +mysqltest.t1 check status OK +* testing that checksum after recovery is as expected +Checksum-check +ok +connection default; +use mysqltest; +connection admin; +SET SESSION debug_dbug="+d,maria_flush_whole_log,maria_crash"; +* crashing mysqld intentionally +set global aria_checkpoint_interval=1; +ERROR HY000: Lost connection to server during query +* recovery happens +check table t2 extended; +Table Op Msg_type Msg_text +mysqltest.t2 check status OK +* testing that checksum after recovery is as expected +Checksum-check +ok +check table t1 extended; +Table Op Msg_type Msg_text +mysqltest.t1 check status OK +* testing that checksum after recovery is as expected +Checksum-check +ok +connection default; +use mysqltest; +drop database mysqltest_for_feeding_recovery; +drop database mysqltest_for_comparison; +drop database mysqltest; |