Bug #3140 Mysql can't auto close the timeout connections after a long time
Submitted: 11 Mar 2004 1:47 Modified: 12 Mar 2004 15:00
Reporter: kang hongjiu Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:mysql-4.0.18 (Source distribution) OS:Linux (Linux e2p 2.4.22-1.2115.nptl #1)
Assigned to: Dean Ellis CPU Architecture:Any

[11 Mar 2004 1:47] kang hongjiu
I have set wait_timeout and interactive_timeout to 30 in the section mysqld of  file /etc/my.cnf .And I also use the phpmyadmin show the mysql Variables,I can see the wait_timeout and interactive_timeout success to set the new value 30.
        After a long time(about one day) ,I use the phpmyqdmin to show the mysql Processes, I found it have many connections with  Time>30 .But I use the phpmyadmin to kill one processes then the mysql will close all the connections with Time>30 .I am sure it is not the phpmyadmin bug.
Some other msg:
>C compiler:    gcc (GCC) 3.3.2 20031022 (Red Hat Linux 3.3.2-1)
>C++ compiler:  g++ (GCC) 3.3.2 20031022 (Red Hat Linux 3.3.2-1)
        <machine, os, target, libraries (multiple lines)>
System: Linux e2p 2.4.22-1.2115.nptl #1 Wed Oct 29 15:42:51 EST 2003 i686 i686 i386 GNU/Linux
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.3.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --host=i386-redhat-linux
Thread model: posix
Configure command: ./configure '--without-innodb' '--prefix=/usr/local/mysql' '--with-charset=gb2312'

How to repeat:
After a long time(about one day).
[11 Mar 2004 1:52] kang hongjiu
sorry I put a error place.:)
[12 Mar 2004 15:00] Dean Ellis
I cannot repeat this with 4.0.19.  Unless the connection explicitly changes its own session-level timeout, the connection is terminated once it exceeds the system-level timeout.  You might have whatever you are using to connect check its  timeouts to see if they are being overridden.