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

Crash upgrade from previous 10.2 (minor upgrade) failed with "Cannot determine the space ID from the first 64 pages"

    Details

      Description

      10.2 d315b4ff

      2019-04-23  0:50:14 139760450823616 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49435537
      2019-04-23  0:50:14 139760450823616 [Note] InnoDB: Checksum mismatch in datafile: ./test/t011.ibd, Space ID:33, Flags: 481
      2019-04-23  0:50:14 139760450823616 [Note] InnoDB: Page size:1024. Pages to analyze:64
      2019-04-23  0:50:14 139760450823616 [Note] InnoDB: Page size: 1024. Possible space_id count:0
      2019-04-23  0:50:14 139760450823616 [Note] InnoDB: Page size:2048. Pages to analyze:64
      2019-04-23  0:50:14 139760450823616 [Note] InnoDB: Page size: 2048. Possible space_id count:0
      2019-04-23  0:50:14 139760450823616 [Note] InnoDB: Page size:4096. Pages to analyze:64
      2019-04-23  0:50:14 139760450823616 [Note] InnoDB: Page size: 4096. Possible space_id count:0
      2019-04-23  0:50:14 139760450823616 [Note] InnoDB: Page size:8192. Pages to analyze:64
      2019-04-23  0:50:14 139760450823616 [Note] InnoDB: Page size: 8192. Possible space_id count:0
      2019-04-23  0:50:14 139760450823616 [Note] InnoDB: Page size:16384. Pages to analyze:64
      2019-04-23  0:50:14 139760450823616 [Note] InnoDB: Page size: 16384. Possible space_id count:0
      2019-04-23  0:50:14 139760450823616 [Note] InnoDB: Page size:32768. Pages to analyze:32
      2019-04-23  0:50:14 139760450823616 [Note] InnoDB: Page size: 32768. Possible space_id count:0
      2019-04-23  0:50:14 139760450823616 [Note] InnoDB: Page size:65536. Pages to analyze:16
      2019-04-23  0:50:14 139760450823616 [Note] InnoDB: Page size: 65536. Possible space_id count:0
      2019-04-23  0:50:14 139760450823616 [ERROR] InnoDB: Datafile './test/t011.ibd' is corrupted. Cannot determine the space ID from the first 64 pages.
      2019-04-23  0:50:15 139760450823616 [ERROR] InnoDB: Tablespace 33 was not found at ./test/t011.ibd.
      2019-04-23  0:50:15 139760450823616 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.
      2019-04-23  0:50:15 139760450823616 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2193] with error Tablespace not found
      2019-04-23  0:50:15 139760450823616 [Note] InnoDB: Starting shutdown...
      2019-04-23  0:50:15 139760450823616 [ERROR] Plugin 'InnoDB' init function returned error.
      2019-04-23  0:50:15 139760450823616 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
      2019-04-23  0:50:15 139760450823616 [Note] Plugin 'FEEDBACK' is disabled.
      2019-04-23  0:50:15 139760450823616 [ERROR] Unknown/unsupported storage engine: InnoDB
      2019-04-23  0:50:15 139760450823616 [ERROR] Aborting
      

      To reproduce:

      • download and unpack the datadir ftp://perro.askmonty.org/public/jira/mdev19305.tar.gz
      • start 10.2 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  --innodb-page-size=64K --innodb-compression-algorithm=none --loose-innodb-file-format=Barracuda --loose-innodb-file-per-table=1  --loose-innodb_log_compressed_pages=on
        

        (check if this form of file-key-management-filename is applicable in your case).

      The data directory was created using 10.2.23 release server, which was killed by SIGKILL during execution of DML. Server error and general (SQL) logs can be found in the same datadir.
      No obvious signs of hardware failure were observed during the test.

        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: