[MDEV-10145] Systemd fails to start mysqld in multi-instance mode Created: 2016-05-27  Updated: 2016-06-28  Resolved: 2016-05-27

Status: Closed
Project: MariaDB Server
Component/s: Scripts & Clients
Affects Version/s: 10.1.14
Fix Version/s: 10.1.15

Type: Bug Priority: Major
Reporter: Nirbhay Choubey (Inactive) Assignee: Nirbhay Choubey (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

systemd


 Description   

The multi-instance version of systemd has the following lines which incorrectly place
defaults options after other options.

ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER --defaults-file=@INSTALL_SYSCONF2DIR@/my%I.cnf
 
# Alternate: (remove ConditionPathExists above)
 
# use [mysqld.INSTANCENAME] as sections in my.cnf
 
#
 
# ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS --defaults-group-suffix=%I

How to repeat:

  • sudo systemctl set-environment MYSQLD_OPTS="--general_log=1"
  • sudo systemctl start mariadb@_node1

May 27 10:08:54 debian-jessie-amd64 mysqld[3611]: 2016-05-27 10:08:54 140556653737920 [ERROR] /usr/sbin/mysqld: unknown variable 'defaults-file=/etc/mysql/conf.d/my_node1.cnf'
 
May 27 10:08:54 debian-jessie-amd64 mysqld[3611]: 2016-05-27 10:08:54 140556653737920 [ERROR] Aborting


Generated at Thu Feb 08 07:40:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.