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

Unexpected checkpoint in the test innodb.doublewrite

    XMLWordPrintable

Details

    • Not for Release Notes
    • Q3/2025 Maintenance

    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

            People

              thiru Thirunarayanan Balathandayuthapani
              svoj Sergey Vojtovich
              Votes:
              0 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.