MySQL Bugs: #4228: mysqld leaves zombie processes

Bug #4228	mysqld leaves zombie processes
Submitted:	20 Jun 2004 22:19	Modified:	27 Aug 2004 13:02
Reporter:	Michal Cichowicz	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.0.20	OS:	Linux (Linux (Debian))
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
just after starting the daemon there are 2 zombies, after several hours of working (tested only on php queries and console client) there appear e.g. 40 zombies. It doesn't disturb but makes mess when calling "ps".

How to repeat:
the easiest way is to call the mysql console client, get into a database, ask a query that produces a lot of output and break it by pressing Ctrl+C, one zombie process is guaranteed. maybe there are other ways but I don't know them. I'm an admin, not user.

Hi Michal,

I cannot repeat this by simpling using ctrl-c to terminate a running query on Debian Linux, or any OS 
for that matter.  I have seen this caused by applications using mysql in various circumstances.  Are you 
able to produce a repeatable case w/o having any external access to MySQL other than yourself?  You 
could set max_connections to 1 or use the skip-networking option.

Best Regards

No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.