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

Atomic DDL: InnoDB: Datafile './test/<tablename>.ibd' is corrupted. Cannot determine the space ID from the first 64 pages

    XMLWordPrintable

    Details

      Description

      I had this failure once so far, in atomic DDL tests on bb-10.6-monty-innodb of May 7th.
      The recovery failure is still the same on the current bb-10.6-monty-innodb, however I have no information on whether the guilty part is the recovery or the logic preceding the crash.

      Couldn't reproduce so far with rr (or without rr, for that matter).
      The datadir and logs are available.

      bb-10.6-monty-innodb 78846b639

      2021-05-10 19:19:31 0 [Note] InnoDB: Header page consists of zero bytes in datafile: ./test/t9_Aria.ibd, Space ID:0, Flags: 0
      2021-05-10 19:19:31 0 [Note] InnoDB: Page size:1024. Pages to analyze:64
      2021-05-10 19:19:31 0 [Note] InnoDB: Page size: 1024. Possible space_id count:0
      2021-05-10 19:19:31 0 [Note] InnoDB: Page size:2048. Pages to analyze:32
      2021-05-10 19:19:31 0 [Note] InnoDB: Page size: 2048. Possible space_id count:0
      2021-05-10 19:19:31 0 [Note] InnoDB: Page size:4096. Pages to analyze:16
      2021-05-10 19:19:31 0 [Note] InnoDB: Page size: 4096. Possible space_id count:0
      2021-05-10 19:19:31 0 [Note] InnoDB: Page size:8192. Pages to analyze:8
      2021-05-10 19:19:31 0 [Note] InnoDB: Page size: 8192. Possible space_id count:0
      2021-05-10 19:19:31 0 [Note] InnoDB: Page size:16384. Pages to analyze:4
      2021-05-10 19:19:31 0 [Note] InnoDB: Page size: 16384. Possible space_id count:0
      2021-05-10 19:19:31 0 [Note] InnoDB: Page size:32768. Pages to analyze:2
      2021-05-10 19:19:31 0 [Note] InnoDB: Page size: 32768. Possible space_id count:0
      2021-05-10 19:19:31 0 [Note] InnoDB: Page size:65536. Pages to analyze:1
      2021-05-10 19:19:31 0 [Note] InnoDB: Page size: 65536. Possible space_id count:0
      2021-05-10 19:19:31 0 [ERROR] InnoDB: Datafile './test/t9_Aria.ibd' is corrupted. Cannot determine the space ID from the first 64 pages.
      2021-05-10 19:19:31 0 [Note] InnoDB: Tablespace 72 was not found at './test/t9_Aria.ibd', but there were no modifications either.
      2021-05-10 19:19:31 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 3 row operations to undo
      

      (don't pay attention to the table name – it was initially Aria, but was altered to InnoDB long before the induced crash).

      The error isn't bogus. Before recovery, there are both .ibd and .frm, after the recovery – only .ibd.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration