systemd mysql.service start hangs forever

[johan]

Hi,

I think the post script called by the systemd script is problematic.

I have the following

percona-server-server-5.7 5.7.14-8-1.xenial

In /lib/systemd/system/mysql.service the

ExecStartPost=/usr/share/mysql/mysql-systemd-start post

is eventually called.

However, it does not terminate b/c

pinger () {
        while /bin/true ; do
                sleep 1
                mysqladmin ping >/dev/null 2>&1 && break
        done
}

tries to ping 4-ever to the mysql server.

Now if you mistype a configuration variable, eg:

max_connection=200

(instead of the correct max_connections=200)

And do a

 sudo systemctl restart mysql

the systemd script will hang forever.

[EvgeniyPatlan (evgeniy-patlan)]

fixed. here is the commit: https://github.com/percona/percona-server/commit/e43dfc0acb981262dfec4f47c96263581f576a23

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3582