[debian-mysql] Bug#1105029: mariadb-server: mariadb.service generates warning about unset MYSQLD_OPTS and _WSREP_NEW_CLUSTER

[Daniel Lewart]

Package: mariadb-server
Version: 1:11.8.1-4
Severity: minor
Tags: patch

Dear Otto, et al,

After installing mariadb-server:

$ journalctl -p warning -u mariadb
... mariadb.service: Referenced but unset environment variable evaluates to an empty string: MYSQLD_OPTS, _WSREP_NEW_CLUSTER

Untested patch below.

Thank you!
Daniel Lewart
Urbana, Illinois
---
diff -ru a/support-files/mariadb.service.in b/support-files/mariadb.service.in
--- a/support-files/mariadb.service.in	2025-04-23 18:50:43.000000000 -0500
+++ b/support-files/mariadb.service.in	2025-05-10 00:00:00.000000000 -0500
@@ -69,6 +69,7 @@
 ProtectHome=true
 
 # Use an environment file to pass variable _WSREP_NEW_CLUSTER
+Environment=_WSREP_NEW_CLUSTER=''
 EnvironmentFile=- at mysqlunixdir@/wsrep-new-cluster
 
 # Use an environment file to pass variable _WSREP_START_POSITION
@@ -94,6 +95,7 @@
 # Use the [Service] section and Environment="MYSQLD_OPTS=...".
 # This isn't a replacement for my.cnf.
 # _WSREP_NEW_CLUSTER is for the exclusive use of the script galera_new_cluster
+Environment=MYSQLD_OPTS=''
 ExecStart=@sbindir@/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION
 
 # Unset _WSREP_START_POSITION environment variable.