systemctl start mysqld fails with timeout if custom path for socket specified
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Tomislav Plavcic | ||
5.5 |
Fix Released
|
High
|
Tomislav Plavcic | ||
5.6 |
Fix Released
|
High
|
Tomislav Plavcic |
Bug Description
Fedora 23 Linux evl-db-01 4.2.7-300.
Percona Server 5.6.28:
Percona-
Percona-
Percona-
If customer uses default socket location (/var/lib/
But if specifies custom path to socket (/opt/evl-
However mysqld actually started.
tags: | added: pkg |
I did this change to verify this report:
#socket= /var/lib/ mysql/mysql. sock /tmp/mysql. sock
socket=
And indeed systemctl timeouts after the change:
[root@localhost ~]# cat /etc/redhat-release
CentOS Linux release 7.2.1511 (Core)
[root@localhost ~]# systemctl start mysqld
Job for mysqld.service failed because a timeout was exceeded. See "systemctl status mysqld.service" and "journalctl -xe" for details.
[root@localhost ~]# systemctl status mysqld systemd/ system/ mysqld. service; enabled; vendor preset: disabled) /usr/bin/ mysql-systemd pre (code=exited, status=0/SUCCESS) slice/mysqld. service mysqld_ safe /var/lib/ mysql --plugin- dir=/usr/ lib64/mysql/ plugin --user=mysql --log-error= /var/lib/ mysql/err. log --open- files-limit= 548000 --pid-file= /var/lib/ mysql/localhost .localdomain. p...
`-control mysql-systemd post
* mysqld.service - MySQL Percona Server
Loaded: loaded (/usr/lib/
Active: activating (start-post) since Mon 2016-01-18 09:21:30 EST; 6min ago
Process: 6734 ExecStartPre=
Main PID: 6763 (mysqld_safe); : 6764 (mysql-systemd)
CGroup: /system.
|-6763 /bin/sh /usr/bin/
|-6982 /usr/sbin/mysqld --basedir=/usr --datadir=
|-6764 /bin/bash /usr/bin/
`-8065 sleep 1
Jan 18 09:21:30 localhost. localdomain systemd[1]: Starting MySQL Percona Server... localdomain mysqld_safe[6763]: 160118 09:21:31 mysqld_safe Logging to '/var/lib/ mysql/err. log'. localdomain mysqld_safe[6763]: 160118 09:21:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jan 18 09:21:31 localhost.
Jan 18 09:21:31 localhost.
[root@localhost ~]# ps -ef|grep mysqld mysqld_ safe /var/lib/ mysql --plugin- dir=/usr/ lib64/mysql/ plugin --user=mysql --log-error= /var/lib/ mysql/err. log --open- files-limit= 548000 --pid-file= /var/lib/ mysql/localhost .localdomain. pid --socket= /tmp/mysql. sock
root 6763 1 0 09:21 ? 00:00:00 /bin/sh /usr/bin/
mysql 6982 6763 0 09:21 ? 00:00:02 /usr/sbin/mysqld --basedir=/usr --datadir=
root 8466 11972 0 09:29 pts/2 00:00:00 grep --color=auto mysqld
Server version: 5.6.28-76.1 Percona Server (GPL), Release 76.1, Revision 5759e76
But so was failing the mysql client who still tries to connect to default socket.. But when I also added this to my.cnf:
[mysql] /tmp/mysql. sock
socket=
[client] /tmp/mysql. sock
socket=
the systemctl start mysqld works just fine.