Re: MySQL 4.0.23a defunct

2005-08-05 Thread Arek H
Gleb Paharenko wrote: Hello. Are there any error messages and stack trace before 'Memory status' line in the error log? This is what it shows Status information: Current dir: /var/lib/mysql/ Running threads: 0 Stack size: 196608 Current locks: key_cache status: blocks used:

Re: MySQL 4.0.23a defunct

2005-08-05 Thread Arek H
Nuno Pereira wrote: You don't have any MySQL process in this case. Try to replicate the case when you got the defunct processes, and post the output like this, in tree, so we can see how lost hist child. Ok managed to capture it. 0 1 0 0 ? -1 S0 0:04 in

Re: MySQL 4.0.23a defunct

2005-08-05 Thread Arek H
Nuno Pereira wrote: Post here the result of a ps ajxf, but it seems to me that you didn't started properly mysql. You should start MySQL with mysqld_safe, not with mysqld. Here it is PPID PID PGID SID TTY TPGID STAT UID TIME COMMAND 0 1 0 0 ? -1 S

MySQL 4.0.23a defunct

2005-08-04 Thread Arek H
Hi Im running a stock install of Slackware 10.1 with the default setup of mysql. Whats happening is when I hit the reload button several times on a page that uses php and accesses mysql I get defunct and zombies start showing when viewing top. I also get this when I run a web based apache be