[Zope-dev] Tracking memory leak
Dyon Balding
dyon@devcoder.com.au
Wed, 11 Apr 2001 09:46:01 +1000
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>