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

buf_flush_LRU(): mysql_mutex_assert_owner(&buf_pool.mutex) failed

    XMLWordPrintable

Details

    Description

      In MDEV-26827, an error was introduced in a rarely executed code path of the buf_flush_page_cleaner() thread. As a result, the function buf_flush_LRU() could be invoked while not holding buf_pool.mutex.

      This may explain the failures that have been reported in MDEV-33189, MDEV-33208 and MDEV-33178. More testing is needed to be sure. I caught this bug by accident in a debug build:

      mariadbd: /mariadb/10.6/storage/innobase/buf/buf0flu.cc:1787: ulint buf_flush_LRU(ulint, bool): Assertion `((&(&buf_pool.mutex)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&buf_pool.mutex)->m_mutex)->thread))' failed.

      This bug can be worked around by setting innodb_adaptive_flushing=OFF.

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26827 Make page flushing even faster

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33178 Random slave replication error, others continues without error

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33189 Server crash after reading outside of bounds on ibdata1 , file corrupted, no auto-recovery

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33208 InnoDB: Trying to access update undo rec field 50 in index `PRIMARY` of table NNN but index has only 14 fields

          • Major - Major loss of function.
          • Needs Feedback

          Activity

            People

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