Bugzilla – Bug 626297
MySQL warning: /var/run/mysql/mysql.sock didn't appear within 30 seconds
Last modified: 2013-07-26 08:21:44 UTC
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.10) Gecko/20100506 SUSE/2.0.5-1.4 SeaMonkey/2.0.5 # /etc/init.d/mysql start Starting service MySQL warning: /var/run/mysql/mysql.sock didn't appear within 30 seconds chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory failed Reproducible: Always Steps to Reproduce: 1.Start mysql - # /etc/init.d/mysql start Actual Results: Returns message - /etc/init.d/mysql start Starting service MySQL warning: /var/run/mysql/mysql.sock didn't appear within 30 seconds chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory Expected Results: mysql starts ok sequence of events # /etc/init.d/mysql start Starting service MySQL warning: /var/run/mysql/mysql.sock didn't appear within 30 seconds chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory failed # rpm -qa | grep mysql| sort libmysqlclient16-5.1.46-2.18.x86_64 libmysqlclient_r16-5.1.46-2.18.x86_64 libmysqld0-5.1.46-2.18.x86_64 libqt4-sql-mysql-4.6.3-1.3.x86_64 mysql-community-server-5.1.46-2.18.x86_64 mysql-community-server-client-5.1.46-2.18.x86_64 php5-mysql-5.3.2-1.31.x86_64 # ll /var/run/mysql total 4 -rw-r--r-- 1 root root 22 Jul 28 23:00 tmpdir
I have similar error after removing mysql-bin.0xxx while mysql status is running. Solved by also removing mysql-bin.index on /var/lib/mysql. Off course, backup is a must.
Additional Info : # rpm -qa | grep mysql| sort libmysqlclient16-5.1.36-6.8.8.i586 libmysqlclient_r16-5.1.36-6.8.8.i586 libqt4-sql-mysql-4.5.3-3.4.1.i586 mysql-5.1.36-6.8.8.i586 mysql-client-5.1.36-6.8.8.i586 php5-mysql-5.3.2-1.1.1.i586 # cat /etc/SuSE-release openSUSE 11.2 (i586) VERSION = 11.2
To get past the error I manually started these serices /etc/init.d/apache2 restart service mysql start The result is: # ./allow-cacti-logon.sh Syntax OK Shutting down httpd2 (waiting for all children to terminate) done Starting httpd2 (prefork) done Starting service MySQL Question: how does one start automatically on pc startup - apache2 and mysql
i suffered of the same problem today on my 11.4 installation... ideas?
Hi, to answer all questions... Error message: "Starting service MySQL warning: /var/run/mysql/mysql.sock didn't appear within 30 seconds" actauly means that for some reason, mysql refused to start and you should check your log. In newer openSUSE it is located in /var/log/mysql/mysqld.log It will tell you what is wrong with your setup. Depending on that, you should be able to find the solution. Looks like I should make it more obvious, hmmm As the other question goes, enabling MySQL to start during the boot is possible using for example YaST runlevel editor.
Not relevant anymore