Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've a weird problem. I've mysql 5.1 installed on my ubuntu 9.04.

I've used it a long time (say 3 month) and everything was going right. Until i faced this really weird problem.

When i want to connect to a random database i get this message:

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: test_cake

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
ERROR: 
Can't connect to the server

It only happens with some databases, while others are totally usefull and healthy. After that, if i try to restart the server i get this.

shell> /etc/init.d/mysql restart
 * Stopping MySQL database server mysqld                                        cat: /var/run/mysqld/mysqld.pid: Permiso denegado
                                                                         [fail]
 * Starting MySQL database server mysqld                                        cat: /var/run/mysqld/mysqld.pid: Permiso denegado
cat: /var/run/mysqld/mysqld.pid: Permiso denegado
cat: /var/run/mysqld/mysqld.pid: Permiso denegado
cat: /var/run/mysqld/mysqld.pid: Permiso denegado
cat: /var/run/mysqld/mysqld.pid: Permiso denegado
cat: /var/run/mysqld/mysqld.pid: Permiso denegado
cat: /var/run/mysqld/mysqld.pid: Permiso denegado
cat: /var/run/mysqld/mysqld.pid: Permiso denegado
cat: /var/run/mysqld/mysqld.pid: Permiso denegado
cat: /var/run/mysqld/mysqld.pid: Permiso denegado
cat: /var/run/mysqld/mysqld.pid: Permiso denegado
cat: /var/run/mysqld/mysqld.pid: Permiso denegado
cat: /var/run/mysqld/mysqld.pid: Permiso denegado
cat: /var/run/mysqld/mysqld.pid: Permiso denegado
cat: /var/run/mysqld/mysqld.pid: Permiso denegado
cat: /var/run/mysqld/mysqld.pid: Permiso denegado
                                                                         [fail]
("permiso denegado" is "permission denied").

I don't know what to do. I change the /var/run/mysqld/mysqld.pid attributes but still not working.

Can anybody help me ?

share|improve this question
add comment

1 Answer

hello do u have other instance of mysql on the same server ? Mysqld is run as what user ? who is the owner of /var/run/mysqld/mysqld.pid ?

-- Regards, Robert

share|improve this answer
    
Hi Robert, thanks for your answer. I've just one instance of mysql running on my PC. It's a Ubuntu 9.04. The owner is "root" and the owner of /var/run/mysqld/mysqld.pid is "mysql" I'll print the ls -l output for you: santiago@santiago-desktop:~$ ls -la /var/run/mysqld/ drwxr-xr-x 2 mysql root 80 2009-11-18 11:26 . drwxr-xr-x 19 root root 940 2009-11-18 14:40 .. -rw-rw---- 1 mysql mysql 5 2009-11-18 11:26 mysqld.pid srwxrwxrwx 1 mysql mysql 0 2009-11-18 11:26 mysqld.sock –  santiago.basulto Nov 18 '09 at 17:47
1  
hello sorry for a huge postpone :D. If this issue is still valid please add at the beginning of /etc/init.d/mysql (mysql start-up script) "#!/bin/bash -x " as a replacement for "#!/bin/bash" I think that line "if [ -f "$pidfile" ] && ps cat $pidfile >/dev/null 2>&1; then ps_alive=1; fi" produce errors. -x is a debug option for bash it will show you what the script is actually doing and it will give some clue where the problem is. -- Regards, Robert –  Robert Nov 29 '09 at 17:31
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.