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

safe_mutex: Found wrong usage of mutex 'LOCK_commit_ordered' and 'LOCK_global_system_variables', or of mutex 'LOCK_global_system_variables' and 'LOCK_log', on setting max_binlog_size or binlog_checksum and START TRANSACTION

Details

    Description

      # mysqld options required for replay: --log-bin
      		 
      SET GLOBAL max_binlog_size=98304;  # A valid and arbritary setting
      		 
      START TRANSACTION WITH CONSISTENT SNAPSHOT;

      Leads to:

      10.11.0 6ebdd3013a18b01dbecec76b870810329eb76586 (Debug)

      		 
      safe_mutex: Found wrong usage of mutex 'LOCK_commit_ordered' and 'LOCK_global_system_variables'

      And

      # mysqld options required for replay: --log-bin
      		 
      START TRANSACTION WITH CONSISTENT SNAPSHOT;
      		 
      SET GLOBAL max_binlog_size=98304;  # A valid and arbritary setting

      Leads to:

      10.11.0 6ebdd3013a18b01dbecec76b870810329eb76586 (Debug)

      		 
      safe_mutex: Found wrong usage of mutex 'LOCK_global_system_variables' and 'LOCK_log'

      Bug confirmed present in:
      MariaDB: 10.3.37 (dbg), 10.4.27 (dbg), 10.5.18 (dbg), 10.6.10 (dbg), 10.7.6 (dbg), 10.8.5 (dbg), 10.9.3 (dbg), 10.10.2 (dbg), 10.11.0 (dbg)

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35197 Wrong locking order of LOCK_log and LOCK_global_system_variables, potential deadlock of server

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35197 Wrong locking order of LOCK_log and LOCK_global_system_variables, potential deadlock of server

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

          Activity

            Ascending order - Click to sort in descending order
            View 7 older comments
            Roel Roel Van de Paar added a comment -

            knielsen Hi! Thank you for working on this. I see you put this in review but I cannot see an attached patch?

            Roel Roel Van de Paar added a comment - knielsen Hi! Thank you for working on this. I see you put this in review but I cannot see an attached patch?
            knielsen Kristian Nielsen added a comment -

            The patch is in branch bb-10.6-knielsen

            knielsen Kristian Nielsen added a comment - The patch is in branch bb-10.6-knielsen
            knielsen Kristian Nielsen added a comment -

            sergLet me know if you're going to review this week, otherwise I'll just take it back and push it with your suggestion to use mysql_mutex_record_order()

            knielsen Kristian Nielsen added a comment - serg Let me know if you're going to review this week, otherwise I'll just take it back and push it with your suggestion to use mysql_mutex_record_order()
            serg Sergei Golubchik added a comment -

            I was going to review it in about 2-3 weeks (note that the release is planned for the end of Jan)

            serg Sergei Golubchik added a comment - I was going to review it in about 2-3 weeks (note that the release is planned for the end of Jan)
            knielsen Kristian Nielsen added a comment -

            Pushed to 10.6.
            Requires another patch when merged to 11.4, see here: https://lists.mariadb.org/hyperkitty/list/developers@lists.mariadb.org/thread/LN35WETUEUHYUQNZXAKXLVU5EGSCQSVX/

            knielsen Kristian Nielsen added a comment - Pushed to 10.6. Requires another patch when merged to 11.4, see here: https://lists.mariadb.org/hyperkitty/list/developers@lists.mariadb.org/thread/LN35WETUEUHYUQNZXAKXLVU5EGSCQSVX/

            People

              knielsen Kristian Nielsen
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.