Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19394

InnoDB: Operating system error number 2 and SIGABRT in fil_load_single_table_tablespace upon crash recovery

    XMLWordPrintable

    Details

      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.

        Attachments

          Activity

            People

            Assignee:
            marko Marko Mäkelä
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration