On Sun, May 19, 2002 at 09:26:16PM +0530, linuxlist wrote:
>
> I have a pop server running on Mandrake Linux and the authentication
> of pop users is happening through mysql db. At times mysql just hangs
> and doesn't allow me to login into the db and even after killing the
> pid it shows the mysql processes running but, the status of the mes-
> sage is D and I have to restart my server to kill those processes.
> These processes are zombie processes if yes how do I kill those pro-
> cesses?
>
> [root@www /root]# killall -9 mysqld
> [root@www /root]# ps -auwx|grep mysql
> mysql 10816 0.5 0.6 36700 3160 ? D May14 37:53
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
[snipped]
---end quoted text---
Zombies are defunct processes. As per man ps :
<snip>
Processes marked <defunct> are dead processes (so-called
"zombies") that remain because their parent has not
destroyed them properly. These processes will be destroyed
by init(8) if the parent process exits.
</snip>
The solution lies in killing MySQL totally and restarting. But
this is an interim fire-fighting measure, and cannot be acc-
epted for a POP authentication database. This is the area that
needs attention ... why is mysqld getting zombied ? Look up
your log files for any clue ...
HTH
Bish
--
:
####[ Linux One Stanza Tip (LOST) ]###########################
Sub : Steps for kernel compilation LOST #087
1. #cd /usr/src/linux 2. #make mrproper 3. #make menuconfig
4. #make dep 5. #make clean 6. #make modules
7. #make install 8. #make modules_install
Change /etc/lilo.conf and than run lilo -v
For detailed explaination refer to Kernel-HOWTO.
####<[EMAIL PROTECTED]>########################################
:
_______________________________________________________________
Hundreds of nodes, one monster rendering program.
Now that's a super model! Visit http://clustering.foundries.sf.net/
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/linux-india-help
