[Zope-dev] Tracking memory leak

Andy McKay andym@ActiveState.com
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 )
> >
>