On Mon, May 20, 2002 at 07:16:11PM +0530, USM Bish spoke out thus: > 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 ... I had faced same problem , But that was due to corruption of one table in mysql. So first check all the tables in mysql for any problems etc.
And look for the error logs in mysql. Regards -Yash > > 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 > -- Yashpal Nagar Systems Administrator Delhicall Centres Pvt Ltd cell: 9811499273 ------------------- _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
