I've been watching this for a few days now, holding back, but it's **awful**! *Please* take a few moments to extract relevant portions from cited text, definitely do *not* include the whole thing! (There is no excuse for multiple copies of the footer, usually not an excuse for a single copy.) For those of us that read via digest mode, at least in some interfaces, it makes increasingly hard to find messages. I'm taking the liberty to include one example just to demonstrate the ridiculous length this has gone. Ken Manheimer klm@digicool.com
From: "Andy McKay" <andym@ActiveState.com> To: "Chris McDonough" <chrism@digicool.com>, "Dyon Balding" <dyon@devcoder.com.au> Cc: <zope-dev@zope.org> Subject: Re: [Zope-dev] Tracking memory leak Date: Wed, 11 Apr 2001 09:35:16 -0700
If you're talking about ZSQLMethod options then its at the default which is
Maximum results to cache 100 Maximum time (sec) to cache 0
Does that mean the first 100 results are being cached for ever? That might do it...
Cheers. -- Andy McKay.
----- Original Message ----- From: "Chris McDonough" <chrism@digicool.com> To: "Andy McKay" <andym@ActiveState.com>; "Dyon Balding" <dyon@devcoder.com.au> Cc: <zope-dev@zope.org> Sent: Wednesday, April 11, 2001 8:51 AM Subject: Re: [Zope-dev] Tracking memory leak
Andy,
Jim just brought something up... do you have database result caching turned on? If so, what is your number of max results to cache and max time?
----- Original Message ----- From: "Andy McKay" <andym@ActiveState.com> To: "Dyon Balding" <dyon@devcoder.com.au> Cc: <zope-dev@zope.org> Sent: Tuesday, April 10, 2001 7:55 PM Subject: Re: [Zope-dev] Tracking memory leak
Im not convinced its just SQLAlias though, I commented out the SQLAlias creations and I was still getting the other object refcounts shooting up...
Cheers. -- Andy McKay.
----- Original Message ----- From: "Dyon Balding" <dyon@devcoder.com.au> To: "Andy McKay" <andym@ActiveState.com> Cc: <zope-dev@zope.org> Sent: Tuesday, April 10, 2001 4:46 PM Subject: Re: [Zope-dev] Tracking memory leak
i was one of the people that ran into big problems with that previous bug. if that is the one you are coming across, then the problem occurs when you try to access the data in a column using a dtml-var with a different case to what it is stored in your database.
eg. if you have a column called ID in your database, and do a <dtml-var id>, then prior to the bug fix, you would see refcount increases for SQLAlias (and possibly some other types as well - can't remember too clearly).
hope that helps you track it down -d
On Tue, Apr 10, 2001 at 10:25:09AM -0700, Andy McKay wrote:
I have the impression its not SQLAlias thats the problem since im also getting Record.Record, Acquistion.ImplicitAcquirerWrapper and Extension class floating around. I just commented out the lines that create SQLAlias instances and that was fine but...
Sorry you're getting bugged here since you answered my first post. -- Andy McKay.
----- Original Message ----- From: "Chris McDonough" <chrism@digicool.com> To: "Andy McKay" <andym@activestate.com> Cc: <zope-dev@zope.org> Sent: Tuesday, April 10, 2001 9:59 AM Subject: Re: [Zope-dev] Tracking memory leak
I believe it handles the translation of the sql fields from upper to lower and vice versa. More than that, I'm uncertain.
----- Original Message ----- From: "Andy McKay" <andym@ActiveState.com> To: "Andy McKay" <andym@ActiveState.com>; "Chris McDonough" <chrism@digicool.com> Cc: <zope-dev@zope.org> Sent: Tuesday, April 10, 2001 1:01 PM Subject: Re: [Zope-dev] Tracking memory leak
> Any chance you could clarify what SQLAlias does, ive definitely got the case > where some sql queries (and the way they are handled / used) causes an > increase in the SQLAlias count and some dont. Id like to find the quick work > around so I can get around to testing ZmxODBC > > Cheers. > -- > Andy McKay. > > > ----- Original Message ----- > From: "Andy McKay" <andym@ActiveState.com> > To: "Chris McDonough" <chrism@digicool.com> > Cc: <zope-dev@zope.org> > Sent: Tuesday, April 10, 2001 8:55 AM > Subject: Re: [Zope-dev] Tracking memory leak > > > > As far as I can tell those changes are still in. Do I understand them? Not > > really. > > -- > > Andy McKay. > > > > > > ----- Original Message ----- > > From: "Chris McDonough" <chrism@digicool.com> > > To: "Andy McKay" <andym@activestate.com> > > Cc: <zope-dev@zope.org> > > Sent: Tuesday, April 10, 2001 8:37 AM > > Subject: Re: [Zope-dev] Tracking memory leak > > > > > > > That's it. > > > > > > ----- Original Message ----- > > > From: "Andy McKay" <andym@ActiveState.com> > > > To: "Chris McDonough" <chrism@digicool.com> > > > Cc: <zope-dev@zope.org> > > > Sent: Tuesday, April 10, 2001 11:36 AM > > > Subject: Re: [Zope-dev] Tracking memory leak > > > > > > > > > > This one? > > > > > > > > - SQLAlias objects were leaking when a database column was > > > > accessed via an aliased name. This was tracked down to a > > > > subtle bug in ExtensionClass. > > > > > > > > Cheers. > > > > -- > > > > Andy McKay. > > > > > > > > > > > > ----- Original Message ----- > > > > From: "Chris McDonough" <chrism@digicool.com> > > > > To: "Andy McKay" <andym@ActiveState.com> > > > > Cc: <zope-dev@zope.org> > > > > Sent: Tuesday, April 10, 2001 8:29 AM > > > > Subject: Re: [Zope-dev] Tracking memory leak > > > > > > > > > > > > > This sounds like a bug that was fixed in 2.3.0 or earlier... I hope > it > > > > > didn't make its way back in! > > > > > > > > > > ----- Original Message ----- > > > > > From: "Andy McKay" <andym@ActiveState.com> > > > > > To: "Chris McDonough" <chrism@digicool.com> > > > > > Cc: <zope-dev@zope.org> > > > > > Sent: Tuesday, April 10, 2001 11:18 AM > > > > > Subject: Re: [Zope-dev] Tracking memory leak > > > > > > > > > > > > > > > > Wow came in this morning to find my Zope has : > > > > > > > > > > > > 62642 instances of Shared.DC.ZRDB.RDB.SQLAlias and > > > > > > 32444 instances of Acquisition.ImplicitAcquirerWrapper > > > > > > > > > > > > According to the debug info.... I think I have a place to start. > > > > > > -- > > > > > > Andy McKay. > > > > > > > > > > > > > > > > > > ----- Original Message ----- > > > > > > From: "Chris McDonough" <chrism@digicool.com> > > > > > > To: "Andy McKay" <andym@activestate.com> > > > > > > Cc: <zope-dev@zope.org> > > > > > > Sent: Monday, April 09, 2001 7:01 PM > > > > > > Subject: Re: [Zope-dev] Tracking memory leak > > > > > > > > > > > > > > > > > > > A painful, but effective way is to get a rough idea of what > might > > be > > > > > > > leaking and then go disable code in the thing that you think is > > > > leaking > > > > > > > in large sections... I know this isn't very helpful, but it's > > true. > > > > > > > > > > > > > > Andy McKay wrote: > > > > > > > > > > > > > > > > Does anyone have advice for tracking (apparent) memory leaks > > other > > > > > than > > > > > > > > sitting watching DebugInfo? > > > > > > > > > > > > > > > > Cheers. > > > > > > > > -- > > > > > > > > Andy McKay. > > > > > > > > > > > > > > > > _______________________________________________ > > > > > > > > Zope-Dev maillist - Zope-Dev@zope.org > > > > > > > > http://lists.zope.org/mailman/listinfo/zope-dev > > > > > > > > ** No cross posts or HTML encoding! ** > > > > > > > > (Related lists - > > > > > > > > http://lists.zope.org/mailman/listinfo/zope-announce > > > > > > > > http://lists.zope.org/mailman/listinfo/zope ) > > > > > > > > > > > > > > _______________________________________________ > > > > > > > Zope-Dev maillist - Zope-Dev@zope.org > > > > > > > http://lists.zope.org/mailman/listinfo/zope-dev > > > > > > > ** No cross posts or HTML encoding! ** > > > > > > > (Related lists - > > > > > > > http://lists.zope.org/mailman/listinfo/zope-announce > > > > > > > http://lists.zope.org/mailman/listinfo/zope ) > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > > > Zope-Dev maillist - Zope-Dev@zope.org > > > > > > http://lists.zope.org/mailman/listinfo/zope-dev > > > > > > ** No cross posts or HTML encoding! ** > > > > > > (Related lists - > > > > > > http://lists.zope.org/mailman/listinfo/zope-announce > > > > > > http://lists.zope.org/mailman/listinfo/zope ) > > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > Zope-Dev maillist - Zope-Dev@zope.org > > > http://lists.zope.org/mailman/listinfo/zope-dev > > > ** No cross posts or HTML encoding! ** > > > (Related lists - > > > http://lists.zope.org/mailman/listinfo/zope-announce > > > http://lists.zope.org/mailman/listinfo/zope ) > > > > > > > > > _______________________________________________ > > Zope-Dev maillist - Zope-Dev@zope.org > > http://lists.zope.org/mailman/listinfo/zope-dev > > ** No cross posts or HTML encoding! ** > > (Related lists - > > http://lists.zope.org/mailman/listinfo/zope-announce > > http://lists.zope.org/mailman/listinfo/zope ) > > > >
_______________________________________________ Zope-Dev maillist - Zope-Dev@zope.org http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
_______________________________________________ Zope-Dev maillist - Zope-Dev@zope.org http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
-- Dyon Balding <dyon@devcoder.com.au>
_______________________________________________ Zope-Dev maillist - Zope-Dev@zope.org http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )