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" <[EMAIL PROTECTED]>
To: "Dyon Balding" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
> To: "Andy McKay" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> 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" <[EMAIL PROTECTED]>
> > > To: "Andy McKay" <[EMAIL PROTECTED]>
> > > Cc: <[EMAIL PROTECTED]>
> > > 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" <[EMAIL PROTECTED]>
> > > > To: "Andy McKay" <[EMAIL PROTECTED]>; "Chris McDonough"
> > > > <[EMAIL PROTECTED]>
> > > > Cc: <[EMAIL PROTECTED]>
> > > > 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" <[EMAIL PROTECTED]>
> > > > > To: "Chris McDonough" <[EMAIL PROTECTED]>
> > > > > Cc: <[EMAIL PROTECTED]>
> > > > > 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" <[EMAIL PROTECTED]>
> > > > > > To: "Andy McKay" <[EMAIL PROTECTED]>
> > > > > > Cc: <[EMAIL PROTECTED]>
> > > > > > Sent: Tuesday, April 10, 2001 8:37 AM
> > > > > > Subject: Re: [Zope-dev] Tracking memory leak
> > > > > >
> > > > > >
> > > > > > > That's it.
> > > > > > >
> > > > > > > ----- Original Message -----
> > > > > > > From: "Andy McKay" <[EMAIL PROTECTED]>
> > > > > > > To: "Chris McDonough" <[EMAIL PROTECTED]>
> > > > > > > Cc: <[EMAIL PROTECTED]>
> > > > > > > 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" <[EMAIL PROTECTED]>
> > > > > > > > To: "Andy McKay" <[EMAIL PROTECTED]>
> > > > > > > > Cc: <[EMAIL PROTECTED]>
> > > > > > > > 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" <[EMAIL PROTECTED]>
> > > > > > > > > To: "Chris McDonough" <[EMAIL PROTECTED]>
> > > > > > > > > Cc: <[EMAIL PROTECTED]>
> > > > > > > > > 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" <[EMAIL PROTECTED]>
> > > > > > > > > > To: "Andy McKay" <[EMAIL PROTECTED]>
> > > > > > > > > > Cc: <[EMAIL PROTECTED]>
> > > > > > > > > > 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  -  [EMAIL PROTECTED]
> > > > > > > > > > > > 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  -  [EMAIL PROTECTED]
> > > > > > > > > > > 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  -  [EMAIL PROTECTED]
> > > > > > > > > > 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  -  [EMAIL PROTECTED]
> > > > > > > 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  -  [EMAIL PROTECTED]
> > > > > > 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  -  [EMAIL PROTECTED]
> > > > 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  -  [EMAIL PROTECTED]
> > > 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 <[EMAIL PROTECTED]>
> >
>
>
> _______________________________________________
> Zope-Dev maillist  -  [EMAIL PROTECTED]
> 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  -  [EMAIL PROTECTED]
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 )

Reply via email to