[Zope-dev] Tracking memory leak
Chris McDonough
chrism@digicool.com
Wed, 11 Apr 2001 11:51:29 -0400
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 )
>