[vpsFree.cz: community-list] mysql problem

[Dusan Simek]

Ahoj chlapci,
ten patecni vypadek/presun vps mi nejak rozbil mysql. Chtel bych 
poprosit o info, jak to opravit, pokud s tim mate nekdo nejakou 
zkusenost. Situace je nasledujici:

Pri nekterych requestech (je to nahodne, 10 requestu ok, 11 zfailuje) 
dojde ke bude k chybe pri pripojeni, nebo ke ztrate spojeni. V logu 
vidim nasledujici:

bud:

OperationalError: (2013, "Lost connection to MySQL server at 'reading 
initial communication packet', system error: 104")

nebo:

OperationalError: (2003, "Can't connect to MySQL server on 
'83.167.228.14' (111)")

nebo:

OperationalError: (2002, "Can't connect to local MySQL server through 
socket '/var/run/mysqld/mysqld.sock' (2)")

mysql vypada, ze bezi normalne:

netstat -tupan | grep mysql
tcp        0      0 0.0.0.0:3306            0.0.0.0:* 
LISTEN      26693/mysqld

  ps ax | grep mysql
12488 ?        S      0:04 /bin/sh /usr/bin/mysqld_safe
26869 ?        Sl     0:02 /usr/sbin/mysqld --basedir=/usr 
--datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/msa.err 
--pid-file=/var/lib/mysql/msa.pid --socket=/var/run/mysqld/mysqld.sock 
--port=3306

socket vypada ok:

ls -la /var/run/mysqld/
total 8
drwxr-xr-x  2 mysql mysql 4096 Aug  5 15:32 .
drwxr-xr-x 20 root  root  4096 Aug  5 10:46 ..
srwxrwxrwx  1 mysql mysql    0 Aug  5 15:32 mysqld.sock


Kdyz zkusim mysql restartovat, dostanu nasledujici:

/etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
msa:.../home/dsimek > ERROR 2013 (HY000) at line 1: Lost connection to 
MySQL server during query
ERROR 2002 (HY000): Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysqld.sock' (111)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysqld.sock' (2)
....

v logu pri startu vidim toto:

Aug  5 10:26:33 msa /etc/mysql/debian-start[30658]: Upgrading MySQL 
tables if necessary.
Aug  5 10:26:33 msa /etc/mysql/debian-start[30664]: 
/usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Aug  5 10:26:33 msa /etc/mysql/debian-start[30664]: Looking for 'mysql' 
as: /usr/bin/mysql
Aug  5 10:26:33 msa /etc/mysql/debian-start[30664]: Looking for 
'mysqlcheck' as: /usr/bin/mysqlcheck
Aug  5 10:26:33 msa /etc/mysql/debian-start[30664]: This installation of 
MySQL is already upgraded to 5.1.63, use --force if you still need to 
run mysql_upgrade
Aug  5 10:26:33 msa /etc/mysql/debian-start[30672]: Checking for 
insecure root accounts.
Aug  5 10:26:33 msa /etc/mysql/debian-start[30677]: Triggering 
myisam-recover for all MyISAM tables

Diky za jakykoliv tip.

Dusan