4 messages in com.mysql.lists.bugsFreeBSD / LinuxThreads
FromSent OnAttachments
Maciek Dobrzanski20 Nov 2001 23:08 
Heikki Tuuri20 Nov 2001 23:43 
Maciek Dobrzanski21 Nov 2001 00:45 
PETIT Sebastien21 Nov 2001 01:08 
Subject:FreeBSD / LinuxThreads
From:Maciek Dobrzanski (mac@hub.interia.pl)
Date:11/20/2001 11:08:05 PM
List:com.mysql.lists.bugs

Hi,

I have made mysql with InnoDB (just fyi) and LinuxThreads. After a time there are some threads left in the 'sleep' state (even if wait_timeout is defined). It's impossible to kill those threads.

How-to-repeat

wait_timeout = 10

| 39015 | test | 10.1.1.15 | test | Sleep | 27 | | NULL | | 39081 | test | 10.1.1.15 | test | Sleep | 26 | | NULL |

now I kill those threads

| 39015 | test | 10.1.1.15 | test | Killed | 33 | | NULL | | 39081 | test | 10.1.1.15 | test | Killed | 32 | | NULL |

Eventually most of them die, but there are some that don't.

FreeBSD 4.4 MySQL 3.23.44 LinuxThreads 2.2.3