List:Bugs« Previous MessageNext Message »
From:sasha Date:May 10 2000 5:21pm
Subject:Re: Problem Report: MySql deamon hangs on Suse Linux
View as plain text  
"Wittig Andreas, AXD" wrote:
> 
> 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

ulimit -c

Is your shell configured to create core files? ( What a sad question, but you
should always expect the worst :-) )

Are there any in your MySQL data directory (ls -l /var/mysql/core* )?

Can you attach to mysqld with strace or gdb ?

Is this repeatable?


-- 
Sasha Pachev

+------------------------------------------------------------------+
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sasha Pachev            |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sasha@stripped  |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Provo, Utah, USA        |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                         |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                        |
|             /*/             \*\ Developers Team                  |
+------------------------------------------------------------------+
Thread
Problem Report: MySql deamon hangs on Suse LinuxAXD Wittig Andreas10 May
  • Re: Problem Report: MySql deamon hangs on Suse Linuxsasha10 May
AW: Problem Report: MySql deamon hangs on Suse LinuxAXD Wittig Andreas10 May
  • Re: AW: Problem Report: MySql deamon hangs on Suse Linuxsasha10 May
AW: Problem Report: MySql deamon hangs on Suse LinuxAXD Wittig Andreas16 May
  • AW: Problem Report: MySql deamon hangs on Suse LinuxMichael Widenius16 May