Hi again, Sorry for being a pain here, but; If I select any other ODBC source (of about 10 that I have) including SQL Server, access, Informix, etc... it doesn't leak. Shouldn't it leak there as well then? It is only with MyODBC driver it happens. Comments? / Jens
-----Original Message----- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 3 januari 2002 18:38 To: Jens Collin Cc: [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, > -----Original Message----- > From: Jens Collin [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 02, 2002 11:44 PM > To: '[EMAIL PROTECTED]' > Cc: [EMAIL PROTECTED] > Subject: RE: MyODBC leaking handles... > > > Hi again, > > From what I can see, when the driver is unloaded (I guess when my > application is shut down) it releases all handles again. But the init > shouldn't take 800.000 handles over time right? :) > There was a leak in the server and some part of driver in 2.50.39 w.r.t. loading and unloading. The server side got the fixes from 4.0.1 or 3.23.48 versions, and driver will have from 2.50.40 or 3.51.01 onwards. The 3.51 driver will be released shortly. Keep tuned to [EMAIL PROTECTED] for the release announcement. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com > > -----Original Message----- > From: Venu [mailto:[EMAIL PROTECTED]] > Sent: den 19 december 2001 20:01 > To: Jens Collin; [EMAIL PROTECTED] > Subject: RE: MyODBC leaking handles... > > > Hi, > > > -----Original Message----- > > From: Jens Collin [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, December 19, 2001 3:05 AM > > To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] > > Subject: RE: MyODBC leaking handles... > > > > > > Hi again, > > > > Some more information; > > OS: Windows 2000 Professional, SP2a + all patches > > mySQL 3.32.46 (windows version) > > myODBC 2.50.37 > > > > I open then database, do a select, close the recordset and finally close > the > > database. > > This results in 2 handles increase. (Notised in windows task manager) > > If I loop this test, the handles counter just goes through the roof. over > > 800.000 handles over one night! > > I have done the exact same test with MS SQL Server 7.0 and 2000, no > missing > > handles. > > This works for oracle's drivers as well. > > > > I guess that a trace can be useful? However, I should upload it to your > FTP > > right? (If I read the manual right :)) > > I'll be happy to assist you with any data needed, just let me know what to > > send. > > > > Thanks for the feedback. I will look into it immediately. When > I tested with PURIFY, I couldn't find any leaks. Let me do a > cross check again. > > Another small note, might be useful. There are some open > resources allocated for the driver during the initialization, > and will be freed only upon termination or unloading of > driver from memory. So, does this happen even after > terminating the application in the proper sequence of > calls ? > > No need of any trace right now, if needed I will ask you. > > Regards, Venu > -- > For technical support contracts, go to https://order.mysql.com > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer > /_/ /_/\_, /___/\___\_\___/ California, USA > <___/ www.mysql.com > > > > > > > > > > > -----Original Message----- > > From: Venu [mailto:[EMAIL PROTECTED]] > > Sent: den 18 december 2001 19:38 > > To: Jens Collin; [EMAIL PROTECTED] > > Subject: RE: MyODBC leaking handles... > > > > > > Hi, > > > > > -----Original Message----- > > > From: Jens Collin [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, December 18, 2001 4:22 AM > > > To: '[EMAIL PROTECTED]' > > > Subject: MyODBC leaking handles... > > > > > > > > > Hi all, > > > > > > This is my first post in this forum. I've tried to find something in the > > > documentation but failed. > > > I cannot find out why the ODBC driver is leaking 1 handle for each > request > > > that I do! > > > It doesn't matter if I close it or whatever I do. > > > Anyone that knows what to do? > > > Any hints or tips? > > > > Recently we found the leaks in the initialization > > towards UNIX, and fixed them from driver and server, > > but we didn't find any thing from Windows (The Unix > > fixes will be there for 2.50.40 and 3.51.01) > > > > > > > > Windows 2000 Professional > > > MySQL 3.23 > > > MyODBC 2.50.39 > > > > Can you be more specific on this, please ? If you can send the > > leaks statistics, it will be a great help. > > > > Regards, Venu > > -- > > For technical support contracts, go to https://order.mysql.com > > __ ___ ___ ____ __ > > / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> > > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer > > /_/ /_/\_, /___/\___\_\___/ California, USA > > <___/ www.mysql.com > > > > > > > > > > Regards, > > > ___________________________________ > > > > > > Jens A. Collin > > > Envox Technical System Developer > > > > > > Envox Group > > > Söder Mälarstrand 43 > > > 118 25 Stockholm > > > Sweden > > > > > > Office: +46 (0)8 56 256 000 > > > Fax : +46 (0)8 56 256 050 > > > > > > [EMAIL PROTECTED] > > > http://www.envox.com > > > ___________________________________ > > > > > > > > > --------------------------------------------------------------------- > > > Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
