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

Recovery of INSERT_HEAP_DYNAMIC into secondary index fails

    XMLWordPrintable

    Details

      Description

      --source include/have_innodb.inc
       
      CREATE TABLE t (a YEAR PRIMARY KEY, KEY(a)) ENGINE=InnoDB;
      INSERT INTO t VALUES (2005),(2030);
       
      --let $shutdown_timeout=0
      --source include/restart_mysqld.inc
       
      # Cleanup
      DROP TABLE t;
      

      10.5 fb70bb44

      2022-09-16 23:50:59 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=47807,47807
      2022-09-16 23:50:59 0 [Note] InnoDB: Starting final batch to recover 11 pages from redo log.
      2022-09-16 23:50:59 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=5, page number=4]
      2022-09-16 23:50:59 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
      2022-09-16 23:50:59 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1501] with error Data structure corruption
      

      10.6+ produces a bit more output

      10.6 fd0bdd31

      2022-09-17  0:17:10 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=42790,42790
      2022-09-17  0:17:10 0 [Note] InnoDB: Starting final batch to recover 7 pages from redo log.
      2022-09-17  0:17:10 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=5, page number=4]
      2022-09-17  0:17:10 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
      2022-09-17  0:17:10 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=5, page number=4]; set innodb_force_recovery to ignore
      2022-09-17  0:17:10 0 [Note] InnoDB: Set innodb_force_recovery=1 to ignore corrupted pages.
      2022-09-17  0:17:10 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
      2022-09-17  0:17:10 0 [Note] InnoDB: Starting shutdown...
      2022-09-17  0:17:10 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=0, page number=9]; set innodb_force_recovery to ignore
      2022-09-17  0:17:10 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=1, page number=3]; set innodb_force_recovery to ignore
      2022-09-17  0:17:10 0 [ERROR] InnoDB: Failed to read page 3 from file './mysql/innodb_table_stats.ibd': Page read from tablespace is corrupted.
      2022-09-17  0:17:10 0 [ERROR] InnoDB: Failed to read page 9 from file './ibdata1': Page read from tablespace is corrupted.
      2022-09-17  0:17:10 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=2, page number=3]; set innodb_force_recovery to ignore
      2022-09-17  0:17:10 0 [ERROR] InnoDB: Failed to read page 3 from file './mysql/innodb_index_stats.ibd': Page read from tablespace is corrupted.
      2022-09-17  0:17:10 0 [ERROR] Plugin 'InnoDB' init function returned error.
      

      Reproducible on 10.5-10.10, including older minor releases.
      Not reproducible on 10.4.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.