Hail Jeremy!! my kernel is new as releng5_0 (release + security patches). I saw your Yahoo! patch in the source with 4.0.13.
My tomcat clients and windows ODBC are all ancient (still 3.XX) Thanks for your help! PS: thnaks for being our guru in mysql/freebsd... Your blogs saved our asses many times :) ----- Original Message ----- From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Gustavo A. Baratto" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, June 05, 2003 8:06 PM Subject: Re: threads not being killed > On Thu, Jun 05, 2003 at 10:01:23AM +0000, Gustavo A. Baratto wrote: > > Greetings, > > > > we running mysql 4.0.13 compiled statically with linuxthreads on > > freebsd 5.0 (SMP). > > > > The problem is that a few connections are not dying after the > > wait_timeout and interactive_timeout expired. > > > > The only pattern we can see here is that mysql clients like > > jakarta-tomcat (jdbc), and windows (obdc) are the ones not that are not > > dying. Another thing is that these are the only clients based on 3.XX > > libmysqlclient... We are not having problem so far with php and perl > > clients compiled with 4.XX libs. > > > > I searched the manual for answers and nothing... The manual does say > > that we shouldn't have any problem with old 3.XX clients except for > > using the new privileges provided by 4.XX. > > > > I don't really know if this is a freebsd problem as described in > > http://jeremy.zawodny.com/blog/archives/000697.html or the old mysql client. > > > > Any ideas? > > Sounds like the same bug to me. > > How recent is your 5.0 kernel? I don't recall exactly when the patch > went in. > > 4.0.13 should have an adjustment in vio/vio.c that looks like this: > > fcntl(sd, F_SETFL, vio->fcntl_mode); /* Yahoo! FreeBSD patch */ > > That works around the problem to. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.13: up 2 days, processed 96,077,464 queries (391/sec. avg) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
