Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.22
-
None
-
10.1.24, 10.1.30
Description
When trying to install database with rest encryption and config like :
innodb_file_per_table=0
|
innodb_data_home_dir=/
|
innodb_data_file_path=/home/a/innodb_data_home_dir/ibdata1:3M;/home/a/innodb_data_home_dir/ibdata2:10M:autoextend
|
Errors below are shown:
Space id in fsp header 3176603904,but in the page header 0
|
[Note] InnoDB: Highest supported file format is Barracuda.
|
[ERROR] InnoDB: Corruption: Block in space_id 0 in file //home/a/innodb_data_home_dir/ibdata1 corrupted
|
[ERROR] InnoDB: Based on page type SYS (6)
|
[ERROR] InnoDB: Database page corruption on disk or a failed
|
[ERROR] InnoDB: Space 0 file //home/a/innodb_data_home_dir/ibdata1 read of page 192.
|
[ERROR] InnoDB: You may have to recover from a backup.
|
InnoDB: Page dump in ascii and hex (16384 bytes):
|
len 16384; hex c32efd07000000c000000000000000000000000000042...
|
2017-02-22 15:11:15 7fb0eb12ebc0 InnoDB: uncompressed page, stored checksum in field1 3274636551, calculated checksums for field1: crc32 1289775906, innodb 511039384, none 3735928559, stored checksum in field2 3103017090, calculated checksums for field2: crc32 1289775906, innodb 3103017090, none 3735928559, page LSN 0 274306, low 4 bytes of LSN at page end 274306, page number (if stored to page already) 192, space id (if created with >= MySQL-4.1.1 and stored already) 0
|
and later:
|
2017-02-22 15:11:15 7fb0eb12ebc0 InnoDB: Assertion failure in thread 140397834857408 in file buf0buf.cc line 4844
|
..
|
mysys/stacktrace.c:268(my_print_stacktrace)[0x7fb0e91b43ea]
|
buf/buf0buf.cc:4710(buf_page_io_complete(buf_page_t*))[0x558c4c25bc1a]
|
buf/buf0rea.cc:262(buf_read_page_low(dberr_t*, bool, unsigned long, unsigned long, unsigned long, unsigned long, long, unsigned long, trx_t*, buf_page_t**))[0x558c4c26febf]
|
buf/buf0rea.cc:474(buf_read_page(unsigned long, unsigned long, unsigned long, trx_t*, buf_page_t**))[0x558c4c2710f4]
|
buf/buf0buf.cc:3002(buf_page_get_gen(unsigned long, unsigned long, unsigned long, unsigned long, buf_block_t*, unsigned long, char const*, unsigned long, mtr_t*, dberr_t*))[0x558c4c2569ea]
|
include/trx0rseg.ic:73(trx_rsegf_get_new)[0x558c4c21015e]
|
trx/trx0rseg.cc:289(trx_rseg_create_instance)[0x558c4c210a4c]
|
trx/trx0sys.cc:661(trx_sys_init_at_db_start())[0x558c4c211f6e]
|
srv/srv0start.cc:2545(innobase_start_or_create_for_mysql())[0x558c4c1fb93b]
|
/sql/mysqld(+0x79a5ed)[0x558c4c1385ed]
|
handler/ha_innodb.cc:4439(innobase_init(void*))[0x558c4bf01ec5]
|
sql/handler.cc:513(ha_initialize_handlerton(st_plugin_int*))[0x558c4bda663b]
|
sql/sql_plugin.cc:1687(plugin_init(int*, char**, int))[0x558c4bda753a]
|
sql/mysqld.cc:5148(init_server_components())[0x558c4bd121ad]
|
sql/mysqld.cc:5739(mysqld_main(int, char**))[0x558c4bd16a4a]
|
When trying the same without encryption - no crash happens.
When trying single ibdata file - no crash happens (e.g. innodb_data_file_path=/home/a/innodb_data_home_dir/ibdata1:3M:autoextend )
Attachments
Issue Links
- causes
-
MDEV-12114 install_db shows corruption for rest encryption and innodb_checksum_algorithm=strict_none
- Closed
- relates to
-
MDEV-14701 install_db shows corruption for rest encryption with innodb_data_file_path=ibdata1:3M
- Closed