Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Bug#1058671: mariadb-server: [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.

2,054 views
Skip to first unread message

Daniel Lewart

unread,
Dec 14, 2023, 6:10:06 AM12/14/23
to
Package: mariadb-server
Version: 1:10.11.4-1~deb12u1
Severity: minor
Tags: patch

Otto, et al,

Starting mariadb-server generates the following message:
[Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.

50-server.cnf includes the following lines:
#log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
log_bin defaults to OFF, thus the warning.

Commenting out "expire_log_days" is a simple fix.
Patch below.

Thank you!
Daniel Lewart
Urbana, Illinois
---
diff -ru a/debian/additions/mariadb.conf.d/50-server.cnf b/debian/additions/mariadb.conf.d/50-server.cnf
--- a/debian/additions/mariadb.conf.d/50-server.cnf 2023-11-26 20:58:10.000000000 -0600
+++ b/debian/additions/mariadb.conf.d/50-server.cnf 2023-12-14 00:00:00.000000000 -0600
@@ -72,7 +72,7 @@
# settings you may need to change.
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
-expire_logs_days = 10
+#expire_logs_days = 10
#max_binlog_size = 100M

#

Otto Kekäläinen

unread,
Dec 19, 2023, 1:00:05 AM12/19/23
to
Thanks Daniel Lewart!

I filed your submission at
https://salsa.debian.org/mariadb-team/mariadb-server/-/merge_requests/61
for review/testing/feedback.

Otto Kekäläinen

unread,
Jan 5, 2024, 11:20:05 PM1/5/24
to
The Salsa-CI autopkgtests shows that this change affects the default
mariadbd server command-line parameters:
https://salsa.debian.org/mariadb-team/mariadb-server/-/merge_requests/61

Hence I did not merge this and it is not included in 1:10.11.6-2

Otto Kekäläinen

unread,
Jan 14, 2024, 7:10:05 PM1/14/24
to
FYI: Discussion about this continued in
https://salsa.debian.org/mariadb-team/mariadb-server/-/merge_requests/61
0 new messages