[Zope-dev] Tracking memory leak

Chris McDonough chrism@digicool.com
Wed, 11 Apr 2001 12:49:54 -0400


No, I think this means that caching is turned off entirely.  Back to the
drawing board.

- C

----- Original Message -----
From: "Andy McKay" <andym@ActiveState.com>
To: "Chris McDonough" <chrism@digicool.com>; "Dyon Balding"
<dyon@devcoder.com.au>
Cc: <zope-dev@zope.org>
Sent: Wednesday, April 11, 2001 12:35 PM
Subject: Re: [Zope-dev] Tracking memory leak


> 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 )
> > >
> >
>
>