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

innodb.undo_space_dblwr test case fails with Unknown Storage Engine InnoDB

    XMLWordPrintable

Details

    Description

      undo_space_dblwr test case fails if the first page of undo
      tablespace is not flushed before restart the server. While restarting
      the server, InnoDB fails to detect the first page of undo
      tablespace from doublewrite buffer.

      Steps to repeat the scenario:

      diff --git a/mysql-test/suite/innodb/t/undo_space_dblwr.test b/mysql-test/suite/innodb/t/undo_space_dblwr.test
      index b6fd6738a1c..c93c45dd7f6 100644
      --- a/mysql-test/suite/innodb/t/undo_space_dblwr.test
      +++ b/mysql-test/suite/innodb/t/undo_space_dblwr.test
      @@ -21,7 +21,7 @@ set global innodb_fil_make_page_dirty_debug = 1;
       SET GLOBAL innodb_max_dirty_pages_pct_lwm=0.0;
       SET GLOBAL innodb_max_dirty_pages_pct=0.0;
       
      -sleep 1;
      +#sleep 1;
       --let CLEANUP_IF_CHECKPOINT=drop table t1;
       --source ../include/no_checkpoint_end.inc
       
      

      Error log file contains:

      2024-01-31 14:40:46 0 [ERROR] InnoDB: Checksum mismatch in the first page of file .//undo001
      2024-01-31 14:40:46 0 [ERROR] InnoDB: Unable to read first page of file .//undo001
      2024-01-31 14:40:46 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1386] with error Data structure corruption
      

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              thiru Thirunarayanan Balathandayuthapani
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.