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

The test innodb.doublewrite_debug occasionally fails to start up InnoDB

    XMLWordPrintable

Details

    Description

      The test innodb.doublewrite_debug that was recently added in MDEV-32242 is occasionally failing on 10.6 and 10.11 like this:

      10.6 98287bd2d6877969514469ebfbf27f9951b99657

      innodb.doublewrite_debug '32k,innodb,strict_crc32' w28 [ fail ]
              Test ended at 2023-12-19 16:08:33
       
      CURRENT_TEST: innodb.doublewrite_debug
      mysqltest: At line 131: query 'select f1, f2 from t1' failed: ER_UNKNOWN_STORAGE_ENGINE (1286): Unknown storage engine 'InnoDB'
       
      The result from queries just before the failure was:
      < snip >
      # system tablespace is corrupted and 2nd page as corrupted.
      set global innodb_log_checkpoint_now = 1;
      begin;
      insert into t1 values (6, repeat('%', 400));
      # Make the first page dirty for system tablespace
      set global innodb_saved_page_number_debug = 0;
      set global innodb_fil_make_page_dirty_debug = 0;
      # Make the second page dirty for system tablespace
      set global innodb_saved_page_number_debug = 1;
      set global innodb_fil_make_page_dirty_debug = 0;
      set global innodb_buf_flush_list_now = 1;
      # Corrupt the 1st page (page_no=0) and 2nd page of the system tablespace.
      # restart
      FOUND 2 /InnoDB: Restoring page \[page id: space=0, page number=0\] of datafile/ in mysqld.1.err
      FOUND 1 /InnoDB: Recovered page \[page id: space=0, page number=1\]/ in mysqld.1.err
      check table t1;
      Table	Op	Msg_type	Msg_text
      test.t1	check	Error	Unknown storage engine 'InnoDB'
      test.t1	check	error	Corrupt
      select f1, f2 from t1;
      

      Attachments

        1. var.tar.gz
          4.78 MB
          Marko Mäkelä

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              marko Marko Mäkelä
              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.