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

Unexpected checkpoint in the test innodb.doublewrite

Details

    Description

      Test failure:

      innodb.doublewrite '64k,strict_full_crc32' w23 [ fail ]
              Test ended at 2025-04-19 07:03:22
      CURRENT_TEST: innodb.doublewrite
      mysqltest: In included file "/home/buildbot/amd64-debian-11-msan-clang-16/build/mysql-test/var/23/log/check.txt": 
      included from /home/buildbot/amd64-debian-11-msan-clang-16/build/mysql-test/suite/innodb/t/../include/no_checkpoint_end.inc at line 37:
      included from /home/buildbot/amd64-debian-11-msan-clang-16/build/mysql-test/suite/innodb/t/doublewrite.test at line 65:
      At line 2: query 'drop table t1, unexpected_checkpoint' failed: ER_LOCK_WAIT_TIMEOUT (1205): Lock wait timeout exceeded; try restarting transaction
      The result from queries just before the failure was:
      < snip >
      insert into t1 values(2, repeat('+',12));
      insert into t1 values(3, repeat('/',12));
      insert into t1 values(4, repeat('-',12));
      insert into t1 values(5, repeat('.',12));
      commit work;
      SET GLOBAL innodb_fast_shutdown = 0;
      # restart
      SET GLOBAL innodb_max_dirty_pages_pct_lwm=0,innodb_max_dirty_pages_pct=0;
      SET GLOBAL innodb_max_dirty_pages_pct=99;
      connect  dml,localhost,root,,;
      XA START 'x';
      insert into t1 values(6, repeat('%', @@innodb_page_size/2));
      XA END 'x';
      XA PREPARE 'x';
      disconnect dml;
      connection default;
      flush table t1 for export;
      # Kill the server
      # restart
      drop table t1, unexpected_checkpoint;
      More results from queries before failure can be found in /home/buildbot/amd64-debian-11-msan-clang-16/build/mysql-test/var/23/log/doublewrite.log
       - saving '/home/buildbot/amd64-debian-11-msan-clang-16/build/mysql-test/var/23/log/innodb.doublewrite-64k,strict_full_crc32/' to '/home/buildbot/amd64-debian-11-msan-clang-16/build/mysql-test/var/log/innodb.doublewrite-64k,strict_full_crc32/'
      ***Warnings generated in error logs during shutdown after running tests: innodb.doublewrite
      2025-04-19  7:02:31 0 [Warning] Found 1 prepared XA transactions
      2025-04-19  7:02:31 0 [Warning] Found 1 prepared XA transactions
      

      Reported basing on this build.
      Cross reference shows more failures.

      Attachments

        Issue Links

          Activity

            There are no comments yet on this issue.

            People

              thiru Thirunarayanan Balathandayuthapani
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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