mysql under daemontools, missing mysq.sock
hsabina <[email protected]> Mon, 25 Jul 2016 03:06:20 -0700 (MST)
| Newsgroups | gmane.org.djb.miscellaneous |
|---|---|
| Message-ID | <[email protected]> |
Hi. Just installed daemontools (daemontools-0.76) lates version on my test
machine:
CentOS release 6.3 (Final). I have created related directories and symbolin=
k
link for mysqld.:
ln -s /var/service/mysqld /service/
=E2=94=9C=E2=94=80svscanboot(19336)=E2=94=80=E2=94=AC=E2=94=80readp=
roctitle(19339)
=E2=94=82 =20
=E2=94=94=E2=94=80svscan(19338)=E2=94=80=E2=94=AC=E2=94=80supervise(19340)=
=E2=94=80=E2=94=80=E2=94=80mysqld(19342)=E2=94=80=E2=94=AC=E2=94=80{mysqld}=
(19345)
=E2=94=82 =E2=94=82 =
=20
=E2=94=9C=E2=94=80{mysqld}(19346)
=E2=94=82 =E2=94=82 =
=20
=E2=94=9C=E2=94=80{mysqld}(19347)
=E2=94=82 =E2=94=82 =
=20
=E2=94=9C=E2=94=80{mysqld}(19348)
=E2=94=82 =E2=94=82 =
=20
=E2=94=9C=E2=94=80{mysqld}(19351)
=E2=94=82 =E2=94=82 =
=20
=E2=94=9C=E2=94=80{mysqld}(19352)
=E2=94=82 =E2=94=82 =
=20
=E2=94=9C=E2=94=80{mysqld}(19353)
=E2=94=82 =E2=94=82 =
=20
=E2=94=9C=E2=94=80{mysqld}(19354)
=E2=94=82 =E2=94=82 =
=20
=E2=94=94=E2=94=80{mysqld}(19355)
=E2=94=82 =20
=E2=94=94=E2=94=80supervise(19341)=E2=94=80=E2=94=80=E2=94=80supervise(2020=
7)
During setting up under daemontools i have faced an issue with missing
mysql.sock in my /var/lib/mysql directory after stopping mysqld via
/etc/init.d/mysqld stop ( just testing if daemontools will start it )
cat /var/service/mysqld/run
#!/bin/sh
exec 2>&1
exec /usr/libexec/mysqld \
--basedir=3D/usr \
--datadir=3D/var/lib/mysql \
--pid-file=3D/var/run/mysqld/mysqld.pid \
--socket=3D/var/lib/mysql/mysql.sock \
--skip-locking \
--user=3Dmysql
# svstat /service/mysqld/
/service/mysqld/: up (pid 19342) 1024 seconds
# service mysqld status
mysqld (pid 19342) is running...
And mysql.sock file exists and i can issue mysql -p and login successfully
# ls -la /var/lib/mysql/
total 28684
drwxr-xr-x. 3 mysql mysql 4096 Jul 25 15:03 .
drwxr-xr-x. 30 root root 4096 Jul 19 11:14 ..
-rw-rw----. 1 mysql mysql 18874368 Jul 25 15:03 ibdata1
-rw-rw----. 1 mysql mysql 5242880 Jul 25 15:03 ib_logfile0
-rw-rw----. 1 mysql mysql 5242880 Dec 22 2015 ib_logfile1
drwx------. 2 mysql mysql 4096 Dec 22 2015 mysql
srwxrwxrwx. 1 mysql mysql 0 Jul 25 15:03 mysql.sock
Now i'm going to stop mysqld( just to emualte mysqld failure and check if i=
t
will be restarted by daemontools:
[root@centos-test2 admin]# /etc/init.d/mysqld stop
Stopping mysqld: [ OK ]
# service mysqld status
mysqld (pid 20518) is running...
]# svstat /service/mysqld/
/service/mysqld/: up (pid 20518) 41 seconds
So everything looks pretty good, but when..:
# mysql -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
And ... checking folder for mysql.sock i see it is missing :
ls /var/lib/mysql
ibdata1 ib_logfile0 ib_logfile1 mysql
Actually if i restart svscan via initctl restart svscan it will be created =
,
but it is wrong approach to restart it manually every time=20
My question is what is wrong with my configuration , why daemontools wont
recreate mysql.sock?
--
View this message in context: http://cr-yp-to.996295.n3.nabble.com/mysql-un=
der-daemontools-missing-mysq-sock-tp22848.html
Sent from the cr.yp.to - misc mailing list archive at Nabble.com.