Database page corruption on disk or a failed space, Assertion failure in file buf0buf.cc line 2856 on querying a table using wrong default encryption key

InnoDB: Database page corruption on disk or a failed

InnoDB: space 4 file test/t1 read of page 3.

InnoDB: You may have to recover from a backup.

2015-08-09 19:56:14 7efe086b8700 InnoDB: Page dump in ascii and hex (16384 bytes):

...

InnoDB: End of page dump

2015-08-09 19:56:17 7efe086b8700 InnoDB: uncompressed page, stored checksum in field1 2405105318, calculated checksums for field1: crc32 4172384744, innodb 2132655181, none 3735928559,

 stored checksum in field2 3749994095, calculated checksums for field2: crc32 4172384744, innodb 3749994095, none 3735928559, page LSN 0 1633250, low 4 bytes of LSN at page end 1633250, page number (if stored to page already) 3, space id (if created with >= MySQL-4.1.1 and stored already) 4

InnoDB: page type 1170145280 meaning PAGE TYPE CORRUPTED

InnoDB: Page may be an index page where index id is 4322600208618841523

InnoDB: Database page corruption on disk or a failed

InnoDB: file read of page 3.

InnoDB: You may have to recover from a backup.

InnoDB: It is also possible that your operating

InnoDB: system has corrupted its own file cache

InnoDB: and rebooting your computer removes the

InnoDB: error.

InnoDB: If the corrupt page is an index page

InnoDB: you can also try to fix the corruption

InnoDB: by dumping, dropping, and reimporting

InnoDB: the corrupt table. You can use CHECK

InnoDB: TABLE to scan your table for corruption.

InnoDB: See also http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html

InnoDB: about forcing recovery.

InnoDB: Error: Unable to read tablespace 4 page no 3 into the buffer pool after 100 attempts

InnoDB: The most probable cause of this error may be that the table has been corrupted.

InnoDB: You can try to fix this problem by using innodb_force_recovery.

InnoDB: Please see reference manual for more details.

InnoDB: Aborting...

2015-08-09 19:56:17 7efe086b8700  InnoDB: Assertion failure in thread 139629528057600 in file buf0buf.cc line 2856

InnoDB: We intentionally generate a memory trap.

#5  0x00007efe062e63e0 in *__GI_abort () at abort.c:92

#6  0x00007efdffa37750 in buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=2, guess=0x0, mode=10, file=0x7efdffca59d0 "10.1/storage/innobase/btr/btr0btr.cc", line=736, mtr=0x7efe086b49c0) at 10.1/storage/innobase/buf/buf0buf.cc:2856

#7  0x00007efdff9f5cf0 in btr_block_get_func (space=4, zip_size=0, page_no=3, mode=2, file=0x7efdffca59d0 "10.1/storage/innobase/btr/btr0btr.cc", line=736, index=0x7efdfef24ff8, mtr=0x7efe086b49c0) at 10.1/storage/innobase/include/btr0btr.ic:60

#8  0x00007efdff9f6a9a in btr_root_block_get (index=0x7efdfef24ff8, mode=2, mtr=0x7efe086b49c0) at 10.1/storage/innobase/btr/btr0btr.cc:736

#9  0x00007efdff9f6bd4 in btr_root_get (index=0x7efdfef24ff8, mtr=0x7efe086b49c0) at 10.1/storage/innobase/btr/btr0btr.cc:763

#10 0x00007efdff9f79c1 in btr_get_size_and_reserved (index=0x7efdfef24ff8, flag=2, used=0x7efe086b4988, mtr=0x7efe086b49c0) at 10.1/storage/innobase/btr/btr0btr.cc:1256

#11 0x00007efdff9f78be in btr_get_size (index=0x7efdfef24ff8, flag=2, mtr=0x7efe086b49c0) at 10.1/storage/innobase/btr/btr0btr.cc:1220

#12 0x00007efdffa902f2 in dict_stats_update_transient_for_index (index=0x7efdfef24ff8) at 10.1/storage/innobase/dict/dict0stats.cc:889

#13 0x00007efdffa90527 in dict_stats_update_transient (table=0x7efdfd599df8) at 10.1/storage/innobase/dict/dict0stats.cc:965

#14 0x00007efdffa94e15 in dict_stats_update (table=0x7efdfd599df8, stats_upd_option=DICT_STATS_RECALC_TRANSIENT) at 10.1/storage/innobase/dict/dict0stats.cc:3387

#15 0x00007efdffaf90ca in dict_stats_init (table=0x7efdfd599df8) at 10.1/storage/innobase/include/dict0stats.ic:174

#16 0x00007efdffaff88e in ha_innodb::open (this=0x7efdfef4c088, name=0x7efdfef3af60 "./test/t1", mode=2, test_if_locked=18) at 10.1/storage/innobase/handler/ha_innodb.cc:5594

#17 0x00007efe08e8bf72 in handler::ha_open (this=0x7efdfef4c088, table_arg=0x7efdfef6da70, name=0x7efdfef3af60 "./test/t1", mode=2, test_if_locked=18) at 10.1/sql/handler.cc:2495

#18 0x00007efe08d4173b in open_table_from_share (thd=0x7efdfd69e070, share=0x7efdfef3aa88, alias=0x7efdfefb1260 "t1", db_stat=39, prgflag=44, ha_open_flags=18, outparam=0x7efdfef6da70, is_create_table=false) at 10.1/sql/table.cc:2920

#19 0x00007efe08bdbe37 in open_table (thd=0x7efdfd69e070, table_list=0x7efdfefb1268, ot_ctx=0x7efe086b5f90) at 10.1/sql/sql_base.cc:2550

#20 0x00007efe08bde66c in open_and_process_table (thd=0x7efdfd69e070, lex=0x7efdfd6a19a0, tables=0x7efdfefb1268, counter=0x7efe086b6034, flags=0, prelocking_strategy=0x7efe086b60a0, has_prelocking_list=false, ot_ctx=0x7efe086b5f90) at 10.1/sql/sql_base.cc:4016

#21 0x00007efe08bdf75b in open_tables (thd=0x7efdfd69e070, options=..., start=0x7efe086b6018, counter=0x7efe086b6034, flags=0, prelocking_strategy=0x7efe086b60a0) at 10.1/sql/sql_base.cc:4527

#22 0x00007efe08be0934 in open_and_lock_tables (thd=0x7efdfd69e070, options=..., tables=0x7efdfefb1268, derived=true, flags=0, prelocking_strategy=0x7efe086b60a0) at 10.1/sql/sql_base.cc:5185

#23 0x00007efe08bd4437 in open_and_lock_tables (thd=0x7efdfd69e070, tables=0x7efdfefb1268, derived=true, flags=0) at 10.1/sql/sql_base.h:530

#24 0x00007efe08c50016 in execute_sqlcom_select (thd=0x7efdfd69e070, all_tables=0x7efdfefb1268) at 10.1/sql/sql_parse.cc:5750

#25 0x00007efe08c4669f in mysql_execute_command (thd=0x7efdfd69e070) at 10.1/sql/sql_parse.cc:2947

#26 0x00007efe08c53a7d in mysql_parse (thd=0x7efdfd69e070, rawbuf=0x7efdfefb1088 "SELECT * FROM t1", length=16, parser_state=0x7efe086b71a0) at 10.1/sql/sql_parse.cc:7205

#27 0x00007efe08c42935 in dispatch_command (command=COM_QUERY, thd=0x7efdfd69e070, packet=0x7efdfd57b071 "SELECT * FROM t1", packet_length=16) at 10.1/sql/sql_parse.cc:1475

#28 0x00007efe08c4165b in do_command (thd=0x7efdfd69e070) at 10.1/sql/sql_parse.cc:1097

#29 0x00007efe08d8328d in do_handle_one_connection (thd_arg=0x7efdfd69e070) at 10.1/sql/sql_connect.cc:1350

#30 0x00007efe08d82fde in handle_one_connection (arg=0x7efdfd69e070) at 10.1/sql/sql_connect.cc:1262

#31 0x00007efe09304337 in pfs_spawn_thread (arg=0x7efdfef263f0) at 10.1/storage/perfschema/pfs.cc:1860

#32 0x00007efe082f7b50 in start_thread (arg=<optimized out>) at pthread_create.c:304

#33 0x00007efe0638c95d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

-- source include/have_innodb.inc

--echo

--echo # Start server with keys.txt

-- let $restart_parameters=--file-key-management-filename=$MYSQL_TEST_DIR/std_data/keys.txt --plugin-load-add=file_key_management

-- source include/restart_mysqld.inc

CREATE TABLE t1 (c VARCHAR(8)) ENGINE=InnoDB ENCRYPTED=YES;

INSERT INTO t1 VALUES ('foobar');

--echo

--echo # Retart server with keys2.txt

-- let $restart_parameters=--file-key-management-filename=$MYSQL_TEST_DIR/std_data/keys2.txt --plugin-load-add=file_key_management

-- source include/restart_mysqld.inc

SELECT * FROM t1;

DROP TABLE t1;