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

[Warning] InnoDB: Could not free any blocks in the buffer pool!

    XMLWordPrintable

Details

    Description

      To help identify hangs, MDEV-33053 introduced an InnoDB warning message. This warning is occasionally being issued during the execution of a number tests. So far, the following tests have been observed failing due to this added warning:

      encryption.innodb_encrypt_temporary_tables
      galera.galera_gcache_recover_full_gcache
      innodb_fts.innodb_fts_misc_1
      innodb.ibuf_delete
      innodb.innodb-64k-crash
      innodb.innodb_stats_external_pages
      innodb.innodb-wl5522-debug
      innodb.purge_secondary
      

      Here is an example:

      bb-11.2-release fccc1fa3f5e0fed4033a0bb46155e60220a3ba1

      galera.galera_gcache_recover_full_gcache 'innodb' w1 [ fail ]  Found warnings/errors in server log file!
              Test ended at 2024-01-25 17:27:49
      line
      2024-01-25 17:27:34 0 [Warning] InnoDB: Could not free any blocks in the buffer pool! 496 blocks are in use and 0 free. Consider increasing innodb_buffer_pool_size.
      ^ Found warnings in /home/buildbot/amd64-ubuntu-2304/build/mysql-test/var/1/log/mysqld.1.err
      ok
       
       - saving '/home/buildbot/amd64-ubuntu-2304/build/mysql-test/var/1/log/galera.galera_gcache_recover_full_gcache-innodb/' to '/home/buildbot/amd64-ubuntu-2304/build/mysql-test/var/log/galera.galera_gcache_recover_full_gcache-innodb/'
      

      I think that we simply need to add a global suppression for this warning:

      diff --git a/mysql-test/mariadb-test-run.pl b/mysql-test/mariadb-test-run.pl
      index 2750e10ecf5..3253de4185f 100755
      --- a/mysql-test/mariadb-test-run.pl
      +++ b/mysql-test/mariadb-test-run.pl
      @@ -4454,6 +4454,7 @@ sub extract_warning_lines ($$) {
            qr/InnoDB: Warning: a long semaphore wait:/,
            qr/InnoDB: Dumping buffer pool.*/,
            qr/InnoDB: Buffer pool.*/,
      +     qr/InnoDB: Could not free any blocks in the buffer pool!/,
            qr/InnoDB: Warning: Writer thread is waiting this semaphore:/,
            qr/InnoDB: innodb_open_files .* should not be greater than/,
            qr/Slave: Unknown table 't1' .* 1051/,
      

      Attachments

        Issue Links

          Activity

            People

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