[Zope-dev] Tracking memory leak

Andy McKay andym@ActiveState.com
Tue, 10 Apr 2001 16:55:00 -0700 

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