Failed to start MySQL Multi Server for instance 1

Support and Discussion Database Server
1

– Subject: Unit [email protected] has begun start-up
– Defined-By: systemd
– Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

– Unit [email protected] has begun starting up.
Sep 13 20:18:31 cibilbndi.novalocal mysqld_multi[11347]: elseif should be elsif at /usr/bin/mysqld_multi line 352.
Sep 13 20:18:31 cibilbndi.novalocal mysqld_multi[11347]: syntax error at /usr/bin/mysqld_multi line 353, near “)
Sep 13 20:18:31 cibilbndi.novalocal mysqld_multi[11347]: {”
Sep 13 20:18:31 cibilbndi.novalocal mysqld_multi[11347]: syntax error at /usr/bin/mysqld_multi line 356, near “else”
Sep 13 20:18:31 cibilbndi.novalocal mysqld_multi[11347]: syntax error at /usr/bin/mysqld_multi line 404, near “}”
Sep 13 20:18:31 cibilbndi.novalocal mysqld_multi[11347]: Illegal declaration of subroutine main::stop_mysqlds at /usr/bin/mysqld_multi line 416.
Sep 13 20:18:31 cibilbndi.novalocal systemd[1]: [email protected]: control process exited, code=exited status=255
Sep 13 20:18:31 cibilbndi.novalocal systemd[1]: Failed to start MySQL Multi Server for instance 1.
– Subject: Unit [email protected] has failed
– Defined-By: systemd
– Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

– Unit [email protected] has failed.

– The result is failed.
Sep 13 20:18:31 cibilbndi.novalocal systemd[1]: Unit [email protected] entered failed state.
Sep 13 20:18:31 cibilbndi.novalocal systemd[1]: [email protected] failed.
Sep 13 20:18:31 cibilbndi.novalocal polkitd[799]: Unregistered Authentication Agent for unix-process:11341:212302 (system bus name :1.47, object path
Sep 13 20:18:31 cibilbndi.novalocal systemd[1]: [email protected] holdoff time over, scheduling restart.
Sep 13 20:18:31 cibilbndi.novalocal systemd[1]: Cannot add dependency job for unit tmp.mount, ignoring: Unit is masked.
Sep 13 20:18:31 cibilbndi.novalocal systemd[1]: Stopped MySQL Multi Server for instance 1.
– Subject: Unit [email protected] has finished shutting down
– Defined-By: systemd
– Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

– Unit [email protected] has finished shutting down.
Sep 13 20:18:31 cibilbndi.novalocal systemd[1]: Starting MySQL Multi Server for instance 1…

How to fix this error ?? the error occurred after the server update, with the yum update command. I have been updating the server in the same way for a year, and there was no problem before.

2

I upload /usr/bin/mysqld_multi file

3

What are you trying to do?

4

I had the same problem. It started after an update. The problem was on line 352 the line should be changed from:
elseif ("–defaults-group-suffix=" eq substr($options[$j], 0, 24))
to:
elsif ("–defaults-group-suffix=" eq substr($options[$j], 0, 24))

5

I had further problems with the mysqld_multi program and I thought I would share my solution incase it would help anyone else.

after removing the syntax error I noticed I couldn’t start any of my mysqld instances
In the error log, I have:

[ERROR] /usr/sbin/mysqld: unknown variable ‘defaults-group-suffix=mysqld1’

The only way to have my instances up, is to comment out the following code:

if (!$suffix_found)
{
$com.= " --defaults-group-suffix=";
$com.= $groups[$i];
}

This is not a real good solution , but it was the only way I could get it to work.