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

query 'reset master' failed: ER_BINLOG_IN_USE (4243) in Galera tests

    XMLWordPrintable

Details

    • Bug
    • Status: In Review (View Workflow)
    • Major
    • Resolution: Unresolved
    • 12.3, 13.0
    • 12.3
    • Galera, Tests, MTR
    • None
    • Q4/2026 Replic. Maintenance

    Description

      galera.MDEV-38260 failed while executing the query 'reset master' with error message ER_BINLOG_IN_USE (4243). It's seen on 12.3, 13.0 and main branches.

      build details:

      builder_name : "amd64-freebsd-14"
      commit : "add63991988734383c5e942de2a19c6c45f511f7"
      branch : "12.3"
      dt : "2026-08-17T22:05:57Z"
       
      builder_name : "amd64-freebsd-14"
      commit : "be111d2cd60d035d555b71da019765cfb42ea0d3"
      branch : "13.0"
      dt : "2026-08-20T18:13:02Z"
       
      builder_name : "amd64-freebsd-14"
      commit : "bab03b0fc44e7aeac869b20b0055c6a8f2083eb6"
      branch : "main"
      dt : "2026-08-21T15:50:00Z"
      

      test failure:

      failure_count : 3
       
       
                            galera.MDEV-38260                        w5 [ fail ]
              Test ended at 2026-08-17 22:10:59
       
      CURRENT_TEST: galera.MDEV-38260
      mysqltest: At line 98: query 'reset master' failed: ER_BINLOG_IN_USE (4243): Cannot execute RESET MASTER as the binlog is in use by a connected slave or other RESET MASTER or binlog reader. Check SHOW PROCESSLIST for "Binlog Dump" commands and use KILL to stop such readers
       
      The result from queries just before the failure was:
      < snip >
      connection node_1;
      SET global wsrep_slave_threads = DEFAULT;
      connection node_3;
      DROP SEQUENCE my_seq;
      DROP TABLE t1;
      connection node_1;
      connection node_2;
      STOP SLAVE;
      RESET SLAVE ALL;
      SET GLOBAL gtid_slave_pos = "";
      connection node_1;
      set global wsrep_on=OFF;
      reset master;
      set global wsrep_on=ON;
      connection node_2;
      set global wsrep_on=OFF;
      reset master;
      set global wsrep_on=ON;
      connection node_3;
      reset master;
       
      More results from queries before failure can be found in /data/buildbot/workers/prod/amd64-freebsd-14/build/mysql-test/var/5/log/MDEV-38260.log
       
       - saving '/data/buildbot/workers/prod/amd64-freebsd-14/build/mysql-test/var/5/log/galera.MDEV-38260/' to '/data/buildbot/workers/prod/amd64-freebsd-14/build/mysql-test/var/log/galera.MDEV-38260/'
       
      Retrying test galera.MDEV-38260, attempt(2/3)...
      

      Attachments

        Issue Links

          Activity

            People

              hemantdangi Hemant Dangi
              susil.behera Susil Behera
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 2d
                  2d
                  Remaining:
                  Time Spent - 1.25d Remaining Estimate - 0.75d
                  0.75d
                  Logged:
                  Time Spent - 1.25d Remaining Estimate - 0.75d
                  1.25d

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.