[Zope-dev] PLEASE trim cited text!

Ken Manheimer klm@digicool.com
Wed, 11 Apr 2001 13:30:24 -0400 (EDT)


I've been watching this for a few days now, holding back, but it's
**awful**!  *Please* take a few moments to extract relevant portions from
cited text, definitely do *not* include the whole thing!  (There is no
excuse for multiple copies of the footer, usually not an excuse for a
single copy.)  For those of us that read via digest mode, at least in some
interfaces, it makes increasingly hard to find messages.  I'm taking the
liberty to include one example just to demonstrate the ridiculous length
this has gone.

Ken Manheimer
klm@digicool.com

> From: "Andy McKay" <andym@ActiveState.com>
> To: "Chris McDonough" <chrism@digicool.com>,
>    "Dyon Balding" <dyon@devcoder.com.au>
> Cc: <zope-dev@zope.org>
> Subject: Re: [Zope-dev] Tracking memory leak
> Date: 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 )