mysqld dead but subsys locked
I have a dedicated server, which went down without any reason. I am runing a couple of phpBB databases there. Now when I try to access the phpBB from browser, I get the following message. Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Using Shell, I logged in ran the command 'service mysqld status' it showed: 'mysql dead but subsys locked' tried to 'restart' it, Stopping -> [FAILED], Starting -> [OK] Tried to reboot the server a couple of times, but no gains, the problem still stands there. Searched the net for possible solutions, and I have tried the following solutions till now without any outcome. 1- Try chowning /var/lib/mysql to chown -R mysql.mysql /var/lib/mysql 2- You may want also to remove the lock file from '/var/lock/subsys/' which is 'mysqld'.After this, restart the mysql daemon, and run mysql. I tried and removed mysql file there many times, without any outcome. 3- killall -9 mysqld ---> may take a couple of attempts then... /etc/rc.d/init.d/mysqld restart mysql should turn over and run fine again. Tried it and got : mysqld: no processes killed - Can anyone help me as what to do next? Thanks in advance for any help as I am desperately looking for some solution. Thanks, Sara.
Re: Mysqld Dead But Subsys Locked
>
>When I attempted to change the MySQL root user with the command "mysqladmin
>-u root -p password 'new-password' " I received the following error:
>"Can't connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock '(2)' check that mysqld is running and that the
>socket; '/var/lib/mysql/mysql.sock' exists!"
>I checked the directory stated for the mysql.sock and it does exist, but
>when checking the status of mysqld using 'service mysqld status' I received
>the following: "mysqld dead but subsys locked."
- delete the lock file (as root)
- restart mysql
- look at the logs (mysql.err)
- make sure the directory /var/lib/mysql/ has the right permissions!!
("chmod o+rx /var/lib/mysql/").
hgs
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysqld Dead But Subsys Locked
The confusion probably lies in the message saying the file should exist. There were 2 conditions to that statement, and the first (make sure that mysqld is running) hadn't been met. The file is SUPPOSED to be evidence that mysqld is running, and a socket connection is possible. However, in your case, mysqld is not running, and the .sock file remains. There are 2 ways to fix this. 1) delete the .sock file. 2) /etc/rc.d/init.d/mysqld stop I would suggest the latter. Mills, Wallace wrote: >I have perused the archive lists (on Geocrawler) for a solution to my >problem but have been unable to find an answer, so I am putting the question >forward and hoping that some kind soul will be able to give me some advice. > >Scenario: RedHat 7.1 on a celeron 900 box, installed MySQL and its >components via RPM. >When I attempted to change the MySQL root user with the command "mysqladmin >-u root -p password 'new-password' " I received the following error: >"Can't connect to local MySQL server through socket >'/var/lib/mysql/mysql.sock '(2)' check that mysqld is running and that the >socket; '/var/lib/mysql/mysql.sock' exists!" >I checked the directory stated for the mysql.sock and it does exist, but >when checking the status of mysqld using 'service mysqld status' I received >the following: "mysqld dead but subsys locked." >My limited knowledge of MySQL (I am in the newbie class with MySQL) does not >allow me to resolve this issue. In attempting to solve this problem I have >uninstalled MySQL and its components and then reinstalled same but this did >not have the desired results. >I would certainly appreciate any help on this one. >Thank you in advance. > >Additional question: In the archives there was mention of a log for MySQL, >where would one find this on a RedHat 7.1 system when MySQL was installed >via rpm. > >Wallace Mills > > >DISCLAIMER >The information contained in the above e-mail message or messages >(which includes any attachments) is confidential and may be legally >privileged. It is intended only for the use of the person or entity >to which it is addressed. If you are not the addressee any form of >disclosure, copying, modification, distribution or any action taken >or omitted in reliance on the information is unauthorised. Opinions >contained in the message(s) do not necessarily reflect the opinions >of the Queensland Government and its authorities. If you received >this communication in error, please notify the sender immediately and >delete it from your computer system network. > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysqld Dead But Subsys Locked
I have perused the archive lists (on Geocrawler) for a solution to my problem but have been unable to find an answer, so I am putting the question forward and hoping that some kind soul will be able to give me some advice. Scenario: RedHat 7.1 on a celeron 900 box, installed MySQL and its components via RPM. When I attempted to change the MySQL root user with the command "mysqladmin -u root -p password 'new-password' " I received the following error: "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock '(2)' check that mysqld is running and that the socket; '/var/lib/mysql/mysql.sock' exists!" I checked the directory stated for the mysql.sock and it does exist, but when checking the status of mysqld using 'service mysqld status' I received the following: "mysqld dead but subsys locked." My limited knowledge of MySQL (I am in the newbie class with MySQL) does not allow me to resolve this issue. In attempting to solve this problem I have uninstalled MySQL and its components and then reinstalled same but this did not have the desired results. I would certainly appreciate any help on this one. Thank you in advance. Additional question: In the archives there was mention of a log for MySQL, where would one find this on a RedHat 7.1 system when MySQL was installed via rpm. Wallace Mills DISCLAIMER The information contained in the above e-mail message or messages (which includes any attachments) is confidential and may be legally privileged. It is intended only for the use of the person or entity to which it is addressed. If you are not the addressee any form of disclosure, copying, modification, distribution or any action taken or omitted in reliance on the information is unauthorised. Opinions contained in the message(s) do not necessarily reflect the opinions of the Queensland Government and its authorities. If you received this communication in error, please notify the sender immediately and delete it from your computer system network. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysqld Dead But Subsys Locked
I have perused the archive lists (on Geocrawler) for a solution to my problem but have been unable to find an answer, so I am putting the question forward and hoping that some kind soul will be able to give me some advice. Scenario: RedHat 7.1 on a celeron 900 box, installed MySQL and its components via RPM. When I attempted to change the MySQL root user with the command "mysqladmin -u root -p password 'new-password' " I received the following error: "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock '(2)' check that mysqld is running and that the socket; '/var/lib/mysql/mysql.sock' exists!" I checked the directory stated for the mysql.sock and it does exist, but when checking the status of mysqld using 'service mysqld status' I received the following: "mysqld dead but subsys locked." My limited knowledge of MySQL (I am in the newbie class with MySQL) does not allow me to resolve this issue. In attempting to solve this problem I have uninstalled MySQL and its components and then reinstalled same but this did not have the desired results. I would certainly appreciate any help on this one. Thank you in advance. Additional question: In the archives there was mention of a log for MySQL, where would one find this on a RedHat 7.1 system when MySQL was installed via rpm. Wallace Mills DISCLAIMER The information contained in the above e-mail message or messages (which includes any attachments) is confidential and may be legally privileged. It is intended only for the use of the person or entity to which it is addressed. If you are not the addressee any form of disclosure, copying, modification, distribution or any action taken or omitted in reliance on the information is unauthorised. Opinions contained in the message(s) do not necessarily reflect the opinions of the Queensland Government and its authorities. If you received this communication in error, please notify the sender immediately and delete it from your computer system network. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
