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

          Activity

            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/

            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)

            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()

            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 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?

            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.