Re: [Zope-dev] Tracking memory leak

2001-04-11 Thread Chris McDonough

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 instan

Re: [Zope-dev] Tracking memory leak

2001-04-11 Thread Andy McKay

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" [EMAIL PROTECTED]
To: "Andy McKay" [EMAIL PROTECTED]; "Dyon Balding"
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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" [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 PROTE

Re: [Zope-dev] Tracking memory leak

2001-04-11 Thread Chris McDonough

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

- C

- Original Message -
From: "Andy McKay" [EMAIL PROTECTED]
To: "Chris McDonough" [EMAIL PROTECTED]; "Dyon Balding"
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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" [EMAIL PROTECTED]
 To: "Andy McKay" [EMAIL PROTECTED]; "Dyon Balding"
 [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 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" [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: 

Re: [Zope-dev] Tracking memory leak

2001-04-11 Thread Andy McKay

Heres the graphs of Zopes memory usage, if that interests you... the drops
are the restarts.
--
  Andy McKay.

 memoryused-freebytes-day.gif


Re: [Zope-dev] Tracking memory leak

2001-04-10 Thread Andy McKay

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 )



Re: [Zope-dev] Tracking memory leak

2001-04-10 Thread Andy McKay

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 )



Re: [Zope-dev] Tracking memory leak

2001-04-10 Thread Chris McDonough

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 )



Re: [Zope-dev] Tracking memory leak

2001-04-10 Thread Chris McDonough

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 )



Re: [Zope-dev] Tracking memory leak

2001-04-10 Thread Andy McKay

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 )



Re: [Zope-dev] Tracking memory leak

2001-04-10 Thread Chris McDonough

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 

Re: [Zope-dev] Tracking memory leak

2001-04-10 Thread Andy McKay

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 )



Re: [Zope-dev] Tracking memory leak

2001-04-10 Thread Andy McKay

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

Re: [Zope-dev] Tracking memory leak

2001-04-10 Thread Chris McDonough

So you're still seeing Record and ImplicitAcquirerWrappers getting
instantiated like crazy?

- Original Message -
From: "Andy McKay" [EMAIL PROTECTED]
To: "Chris McDonough" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, April 10, 2001 1:25 PM
Subject: Re: [Zope-dev] Tracking memory leak


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

Re: [Zope-dev] Tracking memory leak

2001-04-10 Thread Dyon Balding

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

Re: [Zope-dev] Tracking memory leak

2001-04-10 Thread Andy McKay

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 painf

Re: [Zope-dev] Tracking memory leak

2001-04-09 Thread Chris McDonough

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 )



Re: [Zope-dev] Tracking memory leak

2001-04-09 Thread Andy McKay

Seems a little shoddy but ok. I'll start with my own products, assuming
stuff from DC is fine :)

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