Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1
-
None
Description
|
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.