MariaDB 10.11.8 from ports, with all options off except INNOBASE and GSSAPI_NONE, hangs indefinitely on restart (service mysql restart). The following warning appears in the error log: > [Warning] Signal handler thread did not exit in a timely manner. Continuing to wait for it to stop.. This issue does not occur in version 10.11.7, which works fine under the same conditions. Steps to Reproduce: - Install MariaDB 10.11.8 from ports with all options off except INNOBASE and GSSAPI_NONE. - Start the MariaDB service. - Restart the MariaDB service using service mysql restart. FreeBSD version 13.2-RELEASE-p11 amd64
(In reply to Alex Hemp from comment #0) Same happens here running on FreeBSD 14.1-RC1 amd64. [....] 2024-05-27 23:24:23 0 [Note] /usr/local/libexec/mariadbd (initiated by: unknown): Normal shutdown 2024-05-27 23:24:34 0 [Warning] Signal handler thread did not exit in a timely manner. Continuing to wait for it to stop.. [....]
forget to mention - i'm using zfs on single machine so have disabled binlog and doublewrite rc.conf > mysql_args="--socket=/var/run/mysql/mysql.sock \ > --skip-name-resolve \ > --disable-log-bin \ > --skip-innodb-doublewrite \ > --innodb-undo-log-truncate=1 \ > --innodb-use-atomic-writes=0 \ > --innodb-flush-method=O_DSYNC \ > --innodb-flush-neighbors=0 \ > --innodb-flush-log-at-trx-commit=2 \ > --transaction-isolation=READ-COMMITTED \ > --sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,TIME_ROUND_FRACTIONAL \ > --log-error=/var/log/mysql/error.log \ > --collation-server=utf8_general_ci --character-set-server=utf8 "
Hi, Same here. If trying to stop or restart MariaDB it tooks forever. As a workaround, to proper database shutdown, don't use `rc.d' start/stop script, just use ``mariadb-admin'' command like: # mariadb-admin -u root -pPASS shutdown MariaDB version: 10.6.18 installed from ports tree. FreeBSD version: 14.0-RELEASE running on Hyper-V VM Gen2.
Can you please log an upstream ticket? Nothing changed in the port. https://jira.mariadb.org
Upstream bug https://jira.mariadb.org/browse/MDEV-34254
Looks like a "known issue" upstream? I've got the 11.4 port lined up, but it's not in ports yet as it's a release candidate still. Download https://brnrd.eu/bsd/mariadb114.tar.gz contains drop-in directories for your `PORTSDIR` and a patch-ports git diff to wire it into your tree.
Can confirm that mariadb 11.4.1 does not have this issue.
Preparing a patch based on https://jira.mariadb.org/browse/MDEV-34254 feedback. See https://github.com/MariaDB/server/pull/3253 Apparently is also an issue on MacOS.
Created attachment 251082 [details] git diff for databases/mariadb1011-server from https://github.com/MariaDB/server/pull/3253
has anyone already tested the patch?
I tested the patch here on 13-3, 13-stable and 14.1. It works without a problem, means the db itself of course and also stoping from the rc-script.
(In reply to Bernard Spil from comment #6) Can confirm that mariadb 11.4.1 did work for me too. I have upgraded your port to 11.4.2 today than in files patch-mysys_crc32_crc32c.cc can be deleted. 11.4.2 is stable released and is no longer a RC. Regards
Works for me on mariadb1011-server on 14.1-ish stable/14.
Created attachment 251494 [details] git diff for databases/mariadb1011-server redid the patch based on a git diff of the sql/mysqld.cc file. Please test and respond back on outcome!
(In reply to Bernard Spil from comment #14) Works fine and doesn't hang anymore on shutdown. Thanks.
(In reply to Bernard Spil from comment #14) Also works here, thanks!
Works for my setup too.
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=06c03bcd2f1a0a88cc1a5e8cb1a39a1327bad62d commit 06c03bcd2f1a0a88cc1a5e8cb1a39a1327bad62d Author: Bernard Spil <brnrd@FreeBSD.org> AuthorDate: 2024-06-16 11:32:13 +0000 Commit: Bernard Spil <brnrd@FreeBSD.org> CommitDate: 2024-06-16 11:32:13 +0000 databases/mariadb1011-server: Fix Hangs Indefinitely PR: 279362 Obtained from: https://jira.mariadb.org/browse/MDEV-34254 databases/mariadb1011-server/Makefile | 1 + .../mariadb1011-server/files/patch-PR279362 (new) | 85 ++++++++++++++++++++++ 2 files changed, 86 insertions(+)
Thanks everyone for the feedback. Took me longer than anticipated, the whole merging stuff in MariaDB (10.5 -> 10.6 -> 10.11) makes things pretty murky.
FYI: Just committed MariaDB 11.4.2 to ports. https://cgit.freebsd.org/ports/tree/databases/mariadb114-server
(In reply to Bernard Spil from comment #20) FYI: I did UNSET all options except INNOBASE and GSSAPI_NONE. The compilation fails with: ===> Building packages for mariadb114-server-11.4.2 ===> Building mariadb114-server-11.4.2 pkg-static: Unable to access file /wrkdirs/usr/ports/databases/mariadb114-server/work/stage/usr/local/share/man/man1/galera_new_cluster.1.gz:No such file or directory pkg-static: Unable to access file /wrkdirs/usr/ports/databases/mariadb114-server/work/stage/usr/local/share/man/man1/galera_recovery.1.gz:No such file or directory *** Error code 1 The following patch fixes that: MWNt> diff -u pkg-plist pkg-plist.unpatched --- pkg-plist 2024-06-16 18:42:21.628454000 +0200 +++ pkg-plist.unpatched 2024-06-16 18:42:06.965259000 +0200 @@ -227,8 +227,8 @@ share/man/man1/aria_ftdump.1.gz share/man/man1/aria_pack.1.gz share/man/man1/aria_read_log.1.gz -%%WSREP%%share/man/man1/galera_new_cluster.1.gz -%%WSREP%%share/man/man1/galera_recovery.1.gz +share/man/man1/galera_new_cluster.1.gz +share/man/man1/galera_recovery.1.gz share/man/man1/innochecksum.1.gz share/man/man1/mariabackup.1.gz share/man/man1/mariadb-backup.1.gz BUT: I do *not* know if this is nonsense, especially since pkg-plist of mariadb1011-server doesn't have these additions, but compiles perfectly well without. HTH
(In reply to Michael Grimm from comment #21) Sorry, here is the correct patch: mer-waases|root> diff -u pkg-plist.unpatched pkg-plist --- pkg-plist.unpatched 2024-06-16 18:42:06.965259000 +0200 +++ pkg-plist 2024-06-16 18:50:03.253013000 +0200 @@ -227,8 +227,8 @@ share/man/man1/aria_ftdump.1.gz share/man/man1/aria_pack.1.gz share/man/man1/aria_read_log.1.gz -share/man/man1/galera_new_cluster.1.gz -share/man/man1/galera_recovery.1.gz +%%WSREP%%share/man/man1/galera_new_cluster.1.gz +%%WSREP%%share/man/man1/galera_recovery.1.gz share/man/man1/innochecksum.1.gz share/man/man1/mariabackup.1.gz share/man/man1/mariadb-backup.1.gz
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=9f97021574ac4b7d1ee5641fd58c5e4fa551a9bc commit 9f97021574ac4b7d1ee5641fd58c5e4fa551a9bc Author: Bernard Spil <brnrd@FreeBSD.org> AuthorDate: 2024-06-16 17:11:31 +0000 Commit: Bernard Spil <brnrd@FreeBSD.org> CommitDate: 2024-06-16 17:11:31 +0000 databases/mariadb106-server: Fix hang on restart PR: 279362 Obtained from: https://jira.mariadb.org/browse/MDEV-34254 databases/mariadb106-server/Makefile | 2 +- .../mariadb106-server/files/patch-MDEV-34254 (new) | 52 ++++++++++++++++++++++ 2 files changed, 53 insertions(+), 1 deletion(-)