Problem summary:
----------------
The mysqld seams to hang. It's shown in the processlist; but there are
no connections to mysqld possible: for example 'mysqladmin status' isn't
responding in any way. The mysqladmin zombie can only be killed via
'kill -9'
I couldn't identify the problem within the "Chapter 19: Problems an
common errors" of the MySQL reference manual.
Problem detail:
---------------
The MySql Version is 3.22.32. OS is Suse Linux 6.4 out of the box.
Installed RPM's are
MySQL-3.22.32.-1.i386,
MySQL-client-3.22.32.-1.i386
MySQL-devel-3.22.32.-1.i386
MySQL-shared-3.22.32.-1.i386
I installed Suse RPM's as well as RedHat RPM's direct from
www.mysql.org.
The defect is the same.
A "ps ax | grep mysql" on the console delivers:
------------------------------------------------------------------------
----------
209 ? S 0:00 sh /usr/bin/safe_mysqld --user=mysql
--pid-file=/var/mysql/pv.pid --datadir=/var/mysql
227 ? SN 0:00 /usr/sbin/mysqld --basedir=/usr
--datadir=/var/mysql --skip-locking --user=mysql
--pid-file=/var/mysql/pv.pid --datadir=/var/mysql
242 ? SN 0:00 /usr/sbin/mysqld --basedir=/usr
--datadir=/var/mysql --skip-locking --user=mysql
--pid-file=/var/mysql/pv.pid --datadir=/var/mysql
243 ? SN 0:00 /usr/sbin/mysqld --basedir=/usr
--datadir=/var/mysql --skip-locking --user=mysql
--pid-file=/var/mysql/pv.pid --datadir=/var/mysql
471 tty1 S 0:00 grep -i mysql
------------------------------------------------------------------------
----------
Any "mysqladmin" - command (for example mysqladmin version) dies.
A call of "mysql" dies; this call is interruptable by Ctrl+C.
/var/mysql/[hostname].err has the messages:
Number of processes running now: 0
mysld restarted on Wed Apr 26 ....
There are no messages, warnings etc. on the console or in a file.
A telnet connection "telnet 194.233.153.15 3306" delivers no result; it
hangs.
The socket exists in /var/lib/mysql/mysql.sock and is configured in
/etc/my.cnf.
The mysqld is started via safe_mysqld.
"mysqladmin --socket=/var/lib/mysql/mysql.sock" has no effect.
The same is true for "safe_mysqld --socket=/var/lib/mysql/mysql.sock"
There's no problem with the /tmp-Space.
I have no idea how to procede or what I should do aditionally.
Thank you for any comments or suggestions.
Greetings from Germany
Andreas Wittig
