galera.mdev-41075 fails: query 'RESET MASTER' failed with ER_BINLOG_IN_USE (4243)

galera.mdev-41075 fails on the 12.3, 13.1 and main (13.2) branches: RESET MASTER on connection primary (test line 68) fails with ER_BINLOG_IN_USE (4243).

Build Run Info

Failure text

Latest run on 13.1 (worker number, timestamps and paths differ between runs; the latest runs on 12.3 and main show the same error at the same line):

galera.mdev-41075                        w9 [ fail ]

        Test ended at 2026-11-02 04:36:14

CURRENT_TEST: galera.mdev-41075

mysqltest: At line 68: 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 >

SELECT COUNT(*) AS EXPECT_150 FROM base;

EXPECT_150

150

connection node_1;

connection primary;

DROP TABLE base;

connection node_1;

STOP SLAVE;

RESET SLAVE ALL;

SET GLOBAL wsrep_on = OFF;

RESET MASTER;

SET GLOBAL wsrep_on = ON;

SET GLOBAL gtid_slave_pos = "";

connection node_2;

SET GLOBAL wsrep_on = OFF;

RESET MASTER;

SET GLOBAL wsrep_on = ON;

SET GLOBAL gtid_slave_pos = "";

connection primary;

RESET MASTER;

More results from queries before failure can be found in /home/buildbot/s390x-ubuntu-2204/build/mysql-test/var/9/log/mdev-41075.log

 - saving '/home/buildbot/s390x-ubuntu-2204/build/mysql-test/var/9/log/galera.mdev-41075/' to '/home/buildbot/s390x-ubuntu-2204/build/mysql-test/var/log/galera.mdev-41075/'

Retrying test galera.mdev-41075, attempt(2/3)...

Analysis

The test, result and cnf files are identical on 10.11, 11.4, 11.8, 12.3, 13.1 and main; the test was added by the fix of MDEV-41075 (commit 60ea725e7ec8, https://github.com/MariaDB/server/pull/5785, merged into 10.11 on 2026-09-29). It stops the replica on node_1 with STOP SLAVE and RESET SLAVE ALL and then runs a plain RESET MASTER on primary, the server node_1 replicates from. ER_BINLOG_IN_USE is defined on 12.3 and later only. MDEV-40903 (https://github.com/MariaDB/server/pull/5610 and https://github.com/MariaDB/server/pull/5651, merged into 12.3 on 2026-08-31 and 2026-09-14) changed the RESET MASTER calls of the galera tests that existed on 12.3 to -source include/reset_master.inc, which kills lingering binlog dump threads and retries on ER_BINLOG_IN_USE; that include does not exist on 10.11, 11.4 and 11.8, and no release-branch failure of this test is recorded there. The test reached 12.3 with the merge commit ffaba7b55c7f (2026-10-22), whose first parent has no copy of it, so the plain RESET MASTER came along. Between 2026-10-12 and 2026-11-02 the failure was recorded 357 times (72 on release branches: 12.3 26, 13.1 39, main 7), the first one on that merge commit itself (branch bb-12.3-knielsen, 2026-10-22); the first and the latest failing build of each of 12.3, 13.1 and main contain the merge commit. Eight builders report it (s390x-ubuntu-2204, ppc64le-ubuntu-2204, aarch64-debian-12, aarch64-debian-13, amd64-freebsd-14, amd64-last-N-failed, amd64-debian-12-deb-autobake-migration and amd64-rhel-9-rpm-autobake-migration; the two autobake-migration builders store only the tail of the output, which ends with the failing RESET MASTER), on four CPU architectures, which points at the test and not at a builder. Line 68 needs -source include/reset_master.inc on 12.3 and later, as in the other galera tests.

Created via the mtr-failure-create-bug skill.