[#MDEV-19394] InnoDB: Operating system error number 2 and SIGABRT in fil_load_single_table

10.1 15f06559
2019-05-05 2:03:37 140167802328640 [Note] InnoDB: Starting crash recovery from checkpoint LSN=38133686
2019-05-05 2:03:37 140167802328640 [ERROR] InnoDB: checksum mismatch in tablespace ./test/t008.ibd (table test/t008)
2019-05-05 2:03:37 140167802328640 [Note] InnoDB: Page size:1024 Pages to analyze:64
2019-05-05 2:03:37 140167802328640 [Note] InnoDB: Page size: 1024, Possible space_id count:0
2019-05-05 2:03:37 140167802328640 [Note] InnoDB: Page size:2048 Pages to analyze:64
2019-05-05 2:03:37 140167802328640 [Note] InnoDB: Page size: 2048, Possible space_id count:0
2019-05-05 2:03:37 140167802328640 [Note] InnoDB: Page size:4096 Pages to analyze:64
2019-05-05 2:03:37 140167802328640 [Note] InnoDB: Page size: 4096, Possible space_id count:0
2019-05-05 2:03:37 140167802328640 [Note] InnoDB: Page size:8192 Pages to analyze:64
2019-05-05 2:03:37 140167802328640 [Note] InnoDB: Page size: 8192, Possible space_id count:0
2019-05-05 2:03:37 140167802328640 [Note] InnoDB: Page size:16384 Pages to analyze:48
2019-05-05 2:03:37 140167802328640 [Note] InnoDB: Page size: 16384, Possible space_id count:0
2019-05-05 2:03:37 140167802328640 [Note] InnoDB: Page size:32768 Pages to analyze:24
2019-05-05 2:03:37 140167802328640 [Note] InnoDB: Page size: 32768, Possible space_id count:0
2019-05-05 2:03:37 140167802328640 [Note] InnoDB: Page size:65536 Pages to analyze:12
2019-05-05 2:03:37 140167802328640 [Note] InnoDB: Page size: 65536, Possible space_id count:0

2019-05-05 02:03:37 7f7b5c111640  InnoDB: Operating system error number 2 in a file operation.

#5  0x00007f7b5a65542a in __GI_abort () at abort.c:89

#6  0x00005564959f30ec in fil_load_single_table_tablespace (dbname=0x7ffc84899620 "test", filename=0x7ffc8489a5f0 "t008.ibd") at /data/src/10.1/storage/xtradb/fil/fil0fil.cc:4830

#7  0x00005564959f3acf in fil_load_single_table_tablespaces (pred=0x0) at /data/src/10.1/storage/xtradb/fil/fil0fil.cc:5199

#8  0x00005564958071d2 in recv_init_crash_recovery () at /data/src/10.1/storage/xtradb/log/log0recv.cc:2997

#9  0x0000556495806dd2 in recv_scan_log_recs (available_memory=100597760, store_to_hash=1, buf=0x7f7b3d400200 "\200\001\"\360\002", len=262144, start_lsn=38133248, contiguous_lsn=0x7ffc8489c160, group_scanned_lsn=0x7ffc8489c158, err=0x7ffc8489c13c) at /data/src/10.1/storage/xtradb/log/log0recv.cc:2837

#10 0x00005564958070ff in recv_group_scan_log_recs (group=0x7f7b59cfd6f8, contiguous_lsn=0x7ffc8489c160, group_scanned_lsn=0x7ffc8489c158, err=0x7ffc8489c13c) at /data/src/10.1/storage/xtradb/log/log0recv.cc:2964

#11 0x0000556495807881 in recv_recovery_from_checkpoint_start_func (type=78656949, limit_lsn=18446744073709551615, flushed_lsn=6074347) at /data/src/10.1/storage/xtradb/log/log0recv.cc:3238

#12 0x00005564958ea5c8 in innobase_start_or_create_for_mysql () at /data/src/10.1/storage/xtradb/srv/srv0start.cc:2638

#13 0x0000556495779836 in innobase_init (p=0x7f7b59c36a70) at /data/src/10.1/storage/xtradb/handler/ha_innodb.cc:4542

#14 0x000055649543b51e in ha_initialize_handlerton (plugin=0x7f7b59e34880) at /data/src/10.1/sql/handler.cc:522

#15 0x00005564952107d5 in plugin_initialize (tmp_root=0x7ffc8489feb0, plugin=0x7f7b59e34880, argc=0x556496537d68 <remaining_argc>, argv=0x7f7b59c33428, options_only=false) at /data/src/10.1/sql/sql_plugin.cc:1409

#16 0x00005564952113d7 in plugin_init (argc=0x556496537d68 <remaining_argc>, argv=0x7f7b59c33428, flags=2) at /data/src/10.1/sql/sql_plugin.cc:1686

#17 0x000055649512e1b3 in init_server_components () at /data/src/10.1/sql/mysqld.cc:5204

#18 0x000055649512f284 in mysqld_main (argc=25, argv=0x7f7b59c33428) at /data/src/10.1/sql/mysqld.cc:5797

#19 0x0000556495124b10 in main (argc=25, argv=0x7ffc848a0c48) at /data/src/10.1/sql/main.cc:25

To reproduce:

download and unpack the datadir from ftp://perro.askmonty.org/public/jira/mdev19394-data.tar.gz

start the server with

--file-key-management --file-key-management-filename=`pwd`/mysql-test/std_data/keys.txt --plugin-load-add=file_key_management.so --innodb-encrypt-tables --innodb-encrypt-log --innodb-encryption-threads=4 --aria-encrypt-tables=1 --encrypt-tmp-disk-tables=1 --encrypt-binlog --innodb-page-size=64K --innodb-compression-algorithm=zlib --innodb-file-format=Barracuda --innodb-file-per-table=1 --loose-innodb_log_compressed_pages=on

(check if the location of keys.txt works for you.

[MDEV-19394] InnoDB: Operating system error number 2 and SIGABRT in fil_load_single_table_tablespace upon crash recovery Created: 2019-05-04 Updated: 2019-05-04
Status:	Open
Project:	MariaDB Server
Component/s:	Storage Engine - InnoDB
Affects Version/s:	10.1
Fix Version/s:	10.1

[MDEV-19394] InnoDB: Operating system error number 2 and SIGABRT in fil_load_single_table_tablespace upon crash recovery Created: 2019-05-04 Updated: 2019-05-04