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>