On Wed, Feb 13, 2008 at 08:39:57AM -0500, Christopher H. Laco wrote: > Emmanuel Quevillon wrote: > >Emmanuel Quevillon wrote: > >>Matt S Trout wrote: > >>>On Mon, Feb 04, 2008 at 12:45:08PM +0100, Emmanuel Quevillon wrote: > >>>>Matt S Trout a écrit : > >>>>>On Thu, Jan 31, 2008 at 04:01:27PM +0530, Rajesh Pethe wrote: > >>>>>>Matt S Trout wrote: > >>>>>>>On Wed, Jan 30, 2008 at 09:31:27PM +0530, Rajesh Pethe wrote: > >>>>>>> > >>>>>>>>I have also faced this problem with newer version of DBIx > >>>>>>>>(0.08008). > >>>>>>>>Old version works fine. > >>>>>>>> > >>>>>>>Then provide us with enough information to debug the problem. > >>>>>>> > >>>>>>>All you've done so far is asserted it's broken in your set up > >>>>>>>with no > >>>>>>>details at all about it. > >>>>>>> > >>>>>>>How are we supposed to fix it if you won't tell us anything even > >>>>>>>when I > >>>>>>>ask you for more info? > >>>>>>> > >>>>>>> > >>>>>>I have not done anything special, the applications were running fine > >>>>>>with version 0.07002 of DBIx. After we upgraded it to 0.08008, we got > >>>>>>this issue. > >>>>>> > >>>>>>Multiple connections are opened and never closed till the lifetime of > >>>>>>the program. > >>>>>Every other report of this was either (a) a bug fixed by 08004 or > >>>>>so or > >>>>>(b) user error. > >>>>> > >>>>>I asked you for additional information in a reply to your original > >>>>>report. Please go back, read that message and provide the > >>>>>information I > >>>>>asked for. "I have not done anything special" is not helpful, and > >>>>>without > >>>>>more information my best guess is that you've done something silly > >>>>>somewhere - but without seeing your code I can't tell that either. > >>>>> > >>>>>Can you please either > >>>>> > >>>>>(1) provide the information we asked for > >>>>> > >>>>>or > >>>>> > >>>>>(2) debug this issue more closely to find where the dbh is leaked > >>>>> > >>>> > >>>>Hi Matt, > >>>>I already sent you some code in one of my previous email. Did you > >>>>get it? > >>>>I can send it back again if needed. > >>> > >>>There's no such e-mail in the list archives from you. > >>> > >>>Could you re-send, and start it as a new thread as well? This thread is > >>>no basically useless because we're five messages deep and nobody's > >>>posted > >>>any debugging info to it :) > >>> > >> > >>Hi Matt, > >> > >>Did you get my last email with code included? > >>I tried to install new version of DBIx::Class 0.08009 but the problem > >>persists even the built-in server provided by Catalyst. > >>Do you have any clue of what's going on? > >>Cheers > >>Emmanuel > >> > >We (Matt and me) solved this problem. > >It looks like that DBD::Sybase cache statment by default. That's why > >each time a request is done, the connection is kept open.
Not quite. It seems to open one connection -per- -sth- you have around. Which makes no sense to me and is probably a DBD::Sybase bug unless that's actually how the protocl works (which seems ... unlikely) > >Do avoid it, just add option { disable_sth_caching => 1 } in the > >connect() sub. > >That's all. > > > >cheers > > > > Dare I ask. Should that be turned off by default for the Sybase storage > in DBIC...to avoid this very thread again because Sybase won't close > connections, but others will? We could. I'd rather we found out if it's a bug and add a warning re a buggy DBD once a fixed version's out. Would love a doc patch for the mean time ... -- Matt S Trout Need help with your Catalyst or DBIx::Class project? Technical Director http://www.shadowcat.co.uk/catalyst/ Shadowcat Systems Ltd. Want a managed development or deployment platform? http://chainsawblues.vox.com/ http://www.shadowcat.co.uk/servers/ _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]