Re: [Zope-dev] RE: your mail

2001-04-10 Thread Federico Di Gregorio

Scavenging the mail folder uncovered Randall F. Kern's letter:
 Read committed is faster, but I have not done any tests to know how much
 faster.  Read committed mode doesn't support concurrent updates either,
 but fails silently.  In other words, given to concurrent queries:
 
 update foo set a = a + 1
 update foo set a = a + 2
 
 Assuming these overlap, and a starting value of 0 for "a", read
 committed mode would result in "a" either being 1 or 2; serializable
 mode (with my patch) would result in "a" getting set to 3.

this is, imho, the Right Thing (TM), so psycopg will stay serializable.
thank you again for the patch.

federico

-- 
Federico Di Gregorio
MIXAD LIVE Chief of Research  Technology  [EMAIL PROTECTED]
Debian GNU/Linux Developer  Italian Press Contact[EMAIL PROTECTED]
   God is real. Unless declared integer. -- Anonymous FORTRAN programmer

___
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] SiteAccess: virtual host monster and setServerURL issue

2001-04-10 Thread Joseph Wayne Norton


Evan and Zope Dev -

I'm using the virtual host monster with apache proxy/rewrite
mechanism.  I faced a little bit of trouble dealing with zope's
setServerURL method.

I'm using a configuration such as this on the apache side:

RewriteRule ^/(.*)$ \

http://localhost:1080/VirtualHostBase/http/%{HTTP_HOST}/vtfs/%{SERVER_NAME}/VirtualHostRoot/$1
 [P,L]

 * HTTP_HOST varies depending on how the client reaches the apache
   server.
 
 * SERVER_NAME (or really the name of the virtual host) is a constant
   defined in the apache virtual host.

The correct virtual URL is not setup properly because the setServerURL
method is always picking up the port #1080 (via oldhost,oldport) from
the mod_proxy/mod_rewrite request environment even if HTTP_HOST does
not contain a port number.  I patched this issue by simply commenting
out the lines below.

I would like to keep using the HTTP_HOST variable mechanism, because
the absolute_url() generated doesn't directly depend on the proper dns
settings of the web client.  For example, this allows apache to serve
the content properly even if ssh is being used to forward http/https
connections.

Any recommendations??

- joe n.


def setServerURL(self, protocol=None, hostname=None, port=None):
""" Set the parts of generated URLs. """
other = self.other
server_url = other.get('SERVER_URL', '')
if protocol is None and hostname is None and port is None:
return server_url
oldprotocol, oldhost = splittype(server_url)
oldhostname, oldport = splitport(oldhost[2:])
if protocol is None: protocol = oldprotocol
if hostname is None: hostname = oldhostname
#if port is None: port = oldport

#if (port is None or default_port[protocol] == port):
if (port is None):
host = hostname
else:
host = hostname + ':' + port
server_url = other['SERVER_URL'] = '%s://%s' % (protocol, host)
self._resetURLS()
return server_url




-- 

___A_R_S_e_e_D__I_n_c_.__
Joseph Norton
 C.T.O. (Chief Technology Officer)
  Tel:03-5431-5240 (Fax:5241)
Visit us! http://www.arseed.co.jp/garden/



Re: [Zope-dev] ZODBCA questions...

2001-04-10 Thread Tim McLaughlin

Andy-
We've had no probs with ZODBCDA  connected to SQL Server (7 and 2000).  What
leads you to think it's a prob with the DA?

Tim

Message: 2
From: "Andy McKay" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Mon, 9 Apr 2001 10:45:55 -0700
Subject: [Zope-dev] ZODBCA questions...

Im getting some performance issues with my sites, im connecting Zope to a
SQL Server (not using ZEO). I've got suspicion, but no proof, that its
ZODBCA that is the problem. Does anyone have experiences with this on large
sites and / or a suggestion to replace it?

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 )



RE: [Zope-dev] ZODBCA questions...

2001-04-10 Thread Schmidt, Allen J.

We too are having problems connecting to Access2000 with ZODBCDA. Seemed to
be working fine (and I guess it still does) but it is slowing our whole site
down. all our parts were playing together very well until (we think) about
the 2.3.x introduction.

Our site grinds to a halt and is very slow in every aspect; usually in the
morning but on and off throughout the day. We tried some caching in various
places which seemed to help for a while but it is slowing back down again.

Access2000 on Win2000 with ODBC connection to Zope with ZODBCDA. Could it be
the single threadedness of either the DA or Win2K ODBC driver or Access2000
itself?? We think we have narrowed it down to the database causing the
slowdown.

Considered a move to MySQL as it is installed. Would the ZODBCDA to MySQL
cause similar problems? Better to use the native My SQL DA?

Anyone else running into same problems? Have any options to try? Thanks

Allen
-Original Message-
From: Tim McLaughlin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 7:51 AM
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: Re: [Zope-dev] ZODBCA questions...


Andy-
We've had no probs with ZODBCDA  connected to SQL Server (7 and 2000).  What
leads you to think it's a prob with the DA?

Tim

Message: 2
From: "Andy McKay" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Mon, 9 Apr 2001 10:45:55 -0700
Subject: [Zope-dev] ZODBCA questions...

Im getting some performance issues with my sites, im connecting Zope to a
SQL Server (not using ZEO). I've got suspicion, but no proof, that its
ZODBCA that is the problem. Does anyone have experiences with this on large
sites and / or a suggestion to replace it?

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] ZODBCA questions...

2001-04-10 Thread Tim McLaughlin

actually, our SQL Server sites are using 2.2.X, so it could be something 2.3
related.  were there any aqueduct or other RDB changes done between those
versions?  (I don't know of any, but I haven't looked)

pertaining to MySQL, definitely use the native DA since ODBC will simply put
an unnecessary layer in between Zope and the db.

Tim

-Original Message-
From: Schmidt, Allen J. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 8:29 AM
To: 'Tim McLaughlin'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: RE: [Zope-dev] ZODBCA questions...


We too are having problems connecting to Access2000 with ZODBCDA. Seemed to
be working fine (and I guess it still does) but it is slowing our whole site
down. all our parts were playing together very well until (we think) about
the 2.3.x introduction.

Our site grinds to a halt and is very slow in every aspect; usually in the
morning but on and off throughout the day. We tried some caching in various
places which seemed to help for a while but it is slowing back down again.

Access2000 on Win2000 with ODBC connection to Zope with ZODBCDA. Could it be
the single threadedness of either the DA or Win2K ODBC driver or Access2000
itself?? We think we have narrowed it down to the database causing the
slowdown.

Considered a move to MySQL as it is installed. Would the ZODBCDA to MySQL
cause similar problems? Better to use the native My SQL DA?

Anyone else running into same problems? Have any options to try? Thanks

Allen
-Original Message-
From: Tim McLaughlin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 7:51 AM
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: Re: [Zope-dev] ZODBCA questions...


Andy-
We've had no probs with ZODBCDA  connected to SQL Server (7 and 2000).  What
leads you to think it's a prob with the DA?

Tim

Message: 2
From: "Andy McKay" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Mon, 9 Apr 2001 10:45:55 -0700
Subject: [Zope-dev] ZODBCA questions...

Im getting some performance issues with my sites, im connecting Zope to a
SQL Server (not using ZEO). I've got suspicion, but no proof, that its
ZODBCA that is the problem. Does anyone have experiences with this on large
sites and / or a suggestion to replace it?

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] Proxy Roles Problem

2001-04-10 Thread Chris Withers

Dieter Maurer wrote:
 
 Chris Withers writes:
   
   Anyway, it appears that proxy roles are [not] 'carried on'
  
   What gives? Is this how its intended?
 It is intended.
 Was changed with the big Zope 2.2 security policy shakeup.

Bah, humbug!

Chris

___
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: SiteAccess: virtual host monster and setServerURL issue

2001-04-10 Thread Evan Simpson

From: "Joseph Wayne Norton" [EMAIL PROTECTED]
 The correct virtual URL is not setup properly because the setServerURL
 method is always picking up the port #1080 (via oldhost,oldport) from
 the mod_proxy/mod_rewrite request environment even if HTTP_HOST does
 not contain a port number.

This is deliberate.  Omitting the port number means "leave it alone".  If
you want port 80 (the http default), you need to specify it.  Generated URLs
will not have ":80" in them, since it *is* the default port.

Cheers,

Evan @ digicool  4-am


___
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] ZODBCA questions...

2001-04-10 Thread Andy McKay

 Considered a move to MySQL as it is installed. Would the ZODBCDA to MySQL
 cause similar problems? Better to use the native My SQL DA?

MySQL rocks, but comes short in some of the areas we need. MSSQL is the one
constraint on this project that I cant get around.

Cheers.
--
  Andy McKay.


- Original Message -
From: "Schmidt, Allen J." [EMAIL PROTECTED]
To: "'Tim McLaughlin'" [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, April 10, 2001 5:28 AM
Subject: RE: [Zope-dev] ZODBCA questions...


 We too are having problems connecting to Access2000 with ZODBCDA. Seemed
to
 be working fine (and I guess it still does) but it is slowing our whole
site
 down. all our parts were playing together very well until (we think) about
 the 2.3.x introduction.

 Our site grinds to a halt and is very slow in every aspect; usually in the
 morning but on and off throughout the day. We tried some caching in
various
 places which seemed to help for a while but it is slowing back down again.

 Access2000 on Win2000 with ODBC connection to Zope with ZODBCDA. Could it
be
 the single threadedness of either the DA or Win2K ODBC driver or
Access2000
 itself?? We think we have narrowed it down to the database causing the
 slowdown.

 Considered a move to MySQL as it is installed. Would the ZODBCDA to MySQL
 cause similar problems? Better to use the native My SQL DA?

 Anyone else running into same problems? Have any options to try? Thanks

 Allen
 -Original Message-
 From: Tim McLaughlin [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 10, 2001 7:51 AM
 To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
 Subject: Re: [Zope-dev] ZODBCA questions...


 Andy-
 We've had no probs with ZODBCDA  connected to SQL Server (7 and 2000).
What
 leads you to think it's a prob with the DA?

 Tim

 Message: 2
 From: "Andy McKay" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Date: Mon, 9 Apr 2001 10:45:55 -0700
 Subject: [Zope-dev] ZODBCA questions...

 Im getting some performance issues with my sites, im connecting Zope to a
 SQL Server (not using ZEO). I've got suspicion, but no proof, that its
 ZODBCA that is the problem. Does anyone have experiences with this on
large
 sites and / or a suggestion to replace it?

 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] ZODBCA questions...

2001-04-10 Thread Andy McKay

Hmmm, interesting I will check the changes. Just curious if you tried the
sites under heavy load, 50 odd request per second+

Cheers.
--
  Andy McKay.


- Original Message -
From: "Tim McLaughlin" [EMAIL PROTECTED]
To: "'Schmidt, Allen J.'" [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, April 10, 2001 5:45 AM
Subject: RE: [Zope-dev] ZODBCA questions...


 actually, our SQL Server sites are using 2.2.X, so it could be something
2.3
 related.  were there any aqueduct or other RDB changes done between those
 versions?  (I don't know of any, but I haven't looked)

 pertaining to MySQL, definitely use the native DA since ODBC will simply
put
 an unnecessary layer in between Zope and the db.

 Tim

 -Original Message-
 From: Schmidt, Allen J. [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 10, 2001 8:29 AM
 To: 'Tim McLaughlin'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
 Subject: RE: [Zope-dev] ZODBCA questions...


 We too are having problems connecting to Access2000 with ZODBCDA. Seemed
to
 be working fine (and I guess it still does) but it is slowing our whole
site
 down. all our parts were playing together very well until (we think) about
 the 2.3.x introduction.

 Our site grinds to a halt and is very slow in every aspect; usually in the
 morning but on and off throughout the day. We tried some caching in
various
 places which seemed to help for a while but it is slowing back down again.

 Access2000 on Win2000 with ODBC connection to Zope with ZODBCDA. Could it
be
 the single threadedness of either the DA or Win2K ODBC driver or
Access2000
 itself?? We think we have narrowed it down to the database causing the
 slowdown.

 Considered a move to MySQL as it is installed. Would the ZODBCDA to MySQL
 cause similar problems? Better to use the native My SQL DA?

 Anyone else running into same problems? Have any options to try? Thanks

 Allen
 -Original Message-
 From: Tim McLaughlin [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 10, 2001 7:51 AM
 To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
 Subject: Re: [Zope-dev] ZODBCA questions...


 Andy-
 We've had no probs with ZODBCDA  connected to SQL Server (7 and 2000).
What
 leads you to think it's a prob with the DA?

 Tim

 Message: 2
 From: "Andy McKay" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Date: Mon, 9 Apr 2001 10:45:55 -0700
 Subject: [Zope-dev] ZODBCA questions...

 Im getting some performance issues with my sites, im connecting Zope to a
 SQL Server (not using ZEO). I've got suspicion, but no proof, that its
 ZODBCA that is the problem. Does anyone have experiences with this on
large
 sites and / or a suggestion to replace it?

 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] ZODBCA questions...

2001-04-10 Thread Andy McKay

Under heavy loads (stress testing) I get a lot of sql.errors, ive just
started logging those so I can get exact numbers. Im getting memory leaks,
but Im not sure if that is ZODBCA or not.

Cheers.
--
  Andy McKay.


- Original Message -
From: "Tim McLaughlin" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, April 10, 2001 4:50 AM
Subject: Re: [Zope-dev] ZODBCA questions...


 Andy-
 We've had no probs with ZODBCDA  connected to SQL Server (7 and 2000).
What
 leads you to think it's a prob with the DA?

 Tim

 Message: 2
 From: "Andy McKay" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Date: Mon, 9 Apr 2001 10:45:55 -0700
 Subject: [Zope-dev] ZODBCA questions...

 Im getting some performance issues with my sites, im connecting Zope to a
 SQL Server (not using ZEO). I've got suspicion, but no proof, that its
 ZODBCA that is the problem. Does anyone have experiences with this on
large
 sites and / or a suggestion to replace it?

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



[Zope-dev] memory leak

2001-04-10 Thread Marco Nova

Hello guys,

It seems that I've some memory leak problems and I want to understand where
I've to look for.

Scenario:

I've an IIS web server that generates an XML page (taking data from
SqlServer);
The Zope web server must retrieve the XML page, manage the data and render
them in HTML (I cant only apply a XSL stylesheet to XML).

The Facts:

I've written a external method that - using httplib - reads the XML page and
return a string that is the raw XML sources, than I've written another
external method that use ExpatBuilder of Products.ParsedXML.DOM to parse the
XML an generate a list of [(id - {mapping})] which will be accessed with a
dtml-in tag, so in the sequence-key I've access to the ID and with
sequence-item I can access to the mapping object.
I'm using latest version of ZOPE (2.3.1, the binary one with Python 1.5.2)
and ParsedXML.

The Problem:

It seems that every time the method retrieve the page or parse the XML I
loose a bunch of kilobytes. Because the methods are very simple (100 lines
of code in total) and because I didn't create any class for handling this
workflow I can't understand where I can loose bytes.

The Questions:

Is the list generated for the dtml-in tag freed automatically by ZOPE ?
Is there a Garbage Collector somewhere that must be activated ?
Should I avoid the use of the ExpatBuilder for XML processing ?

Thanks for listening my newbies questions.


Best Regards,

- mn

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



[Zope-dev] Re: SiteAccess: virtual host monster and setServerURL issue

2001-04-10 Thread Joseph Wayne Norton


Evan -

I agree with your statement, but the system is behaving differently.

The generated URLs should not have :80 in them and they do not
... rather they have :1080 included in the generated URLs although I
have specifed something as follows:

mod_rewrite result:
   

proxy:http://localhost:1080/VirtualHostBase/http/www.foo.com/vtfs/www.foo.com/vdmn/prd/vstg/VirtualHostRoot/
[OK]

and zope/vhm is generating URLs of the form:

   http://www.foo.com:1080/

I believe the setServerURL method is using the port number from the
environment setup from the mod_proxy/mod_rewrite request.  I'm
currently using 1080 for zope (z2.py -w 1080).

- j

p.s. One more related question  have you tried using
mod_proxy/mod_rewrite with zope's webdav source port (-W) and virtual
host monster?


At Tue, 10 Apr 2001 10:57:15 -0400,
Evan Simpson wrote:
 
 From: "Joseph Wayne Norton" [EMAIL PROTECTED]
  The correct virtual URL is not setup properly because the setServerURL
  method is always picking up the port #1080 (via oldhost,oldport) from
  the mod_proxy/mod_rewrite request environment even if HTTP_HOST does
  not contain a port number.
 
 This is deliberate.  Omitting the port number means "leave it alone".  If
 you want port 80 (the http default), you need to specify it.  Generated URLs
 will not have ":80" in them, since it *is* the default port.
 
 Cheers,
 
 Evan @ digicool  4-am
 

___
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] ZODBCA questions...

2001-04-10 Thread Andy McKay

Thanks, well the consensus was that it was level 2. We've talked to Paul
quite a bit about the database adapters for Zope and I'd always said they
work fine for me. Oops :)

Cheers.
--
  Andy McKay.


- Original Message -
From: "Mark Pratt" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, April 10, 2001 8:45 AM
Subject: Re: [Zope-dev] ZODBCA questions...


 Hi Andy,

 I would venture a guess that your ZODBC problems have to do
 with the DA being Level 1.

 visit the somewhat dated URL:

 http://www.zope.org/Members/petrilli/DARoadmap

 for details on what Level 1 through 3 represent.

 For an upcoming project we will need to work with MS SQL
 server as well so I've been discussing with Paul a bit about what
 it would take to fund a L3 DA. You might want to send him an
 email.

 Regards,

 Mark

 --
 mark pratt  (managing director)  [EMAIL PROTECTED]
 beehive elektronische medien GmbH   http://www.beehive.de
 phone: +49 30 847-82 0  fax: +49 30 847-82 299



 ___
 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: SiteAccess: virtual host monster and setServerURL issue

2001-04-10 Thread Evan Simpson

From: "Joseph Wayne Norton" [EMAIL PROTECTED]
 The generated URLs should not have :80 in them and they do not
 ... rather they have :1080 included in the generated URLs although I
 have specifed something as follows:

 mod_rewrite result:


proxy:http://localhost:1080/VirtualHostBase/http/www.foo.com/vtfs/www.foo.co
m/vdmn/prd/vstg/VirtualHostRoot/
 [OK]

Exactly.  You haven't specified the port.  You need this:


proxy:http://localhost:1080/VirtualHostBase/http/www.foo.com:80/vtfs/www.foo
.com/vdmn/prd/vstg/VirtualHostRoot/


 p.s. One more related question  have you tried using
 mod_proxy/mod_rewrite with zope's webdav source port (-W) and virtual
 host monster?

I haven't tried it, but I have no reason to expect that it wouldn't work
properly.

Cheers,

Evan @ digicool @ 4-am


___
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 maillist  -  [EMAIL PROTECTED]
  http://lists.zope.org/mailman/listinfo/zope-dev
  **  No cross posts or HTML encoding!  **
  (Related lists -
   

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] Objects, Roles and Permissions

2001-04-10 Thread Randall F. Kern

I haven't worked with this code closely in a few months, but as I recall
permissions that are acquired are stored as a list, and those that
aren't are stored as a tuple.

if type(self._View_Permission) == type(()):
# done, this permission isn't acquired above this point

Furthermore, I may be missing the point of this thread, but if you are
trying to get the list of all roles assigned to a permission (from a
python product), you could use this:

from AccessControl.PermissionRole import rolesFromPermissionOn

roles = rolesFromPermissionOn('View', ob)


-Randy


 -Original Message-
 From: Danny William Adair [mailto:[EMAIL PROTECTED]]
 Sent: Monday, April 09, 2001 7:49 PM
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: Re: [Zope-dev] Objects, Roles and Permissions
 
 
 Thank you very much, Richard! Cool!
 
 Still...
 
  ...
  Feel free to expand the method to other roles
  and the full suite of permissions.
  ...
 
 Other *roles*? Roles are what's coming back, isn't it?
 
  def viewPermissions(self, acquired=0):
  ''' walk up the acquisition path to find a 
 _View_Permission
  attribute...  possibly _only_ the acquired 
 permissions.
  '''
  chain = self.aq_chain
  if acquired:
  chain = chain[1:]
  for self in chain:
  if hasattr(self.aq_base, '_View_Permission'):
  return self._View_Permission
  return ['Manager']
 
 "possibly _only_ the acquired permissions" - oops! Your 
 snippet worked fine
 _if_ the view permission was acquired by that object. As soon 
 as I turned
 off acquisition for the view permission of the object, it 
 would still give
 me the acquired roles (that in fact were'nt acquired).  What 
 does the "if"
 statement look like that would return the object's own roles 
 for the View
 Permission if acquisition was turned off? Naive Danny who 
 doesn't know s...
 tried to put
 
 if hasattr(self.aq_base, '_View_Permission'):
 return self._View_Permission
 
 at the beginning of your code, but no effect. :-(
 
 But now I see how to access specific permissions and read 
 their content (do
 I? I'll experiment with it), thank you very much! I will put a
 string.replace on top and pass the Permission to examine by string
 parameter, and call that whole stuff "getAllowedRoles".
 
 A "getGrantedPermissions" for examining a role should work 
 similarly, right?
 
 def ac_inherited_permissions(self, all=0):
 
 set all to 1 and then... iterate through the list (tuple or 
 list? list of
 tuples?) and check every "_current_Permission" if it contains 
 the role?
 
 Thx once again,
 Danny
 
 btw: Isn't return['Manager'] at the end of your code obsolete 
 (but safe)? Or
 is there anything special going on at the root level
 (isTopLevelPrincipiaApplicationObject)?
 
 
 ___
 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 )
   
  
  
   ___
   Zope-Dev maillist  -  [EMAIL PROTECTED]
   http://lists.zope.org/mailman/listinfo/zope-dev
   **  No cross posts or HTML encoding!  **
  

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-announce
   http://lists.zope.org/mailman/listinfo/zope )

 ___
 Zope-Dev maillist  -  [EMAIL PROTECTED]
 

Re: [Zope-dev] Image Archive Project (phase 2)

2001-04-10 Thread Michael R. Bernstein

"Michael R. Bernstein" wrote:
 
 Ok, so what's next? Somehow, ArchiveImages must be made
 aware of what Renderings they have.
 
 The ArchiveImage Specialist needs a getRenderingIds() Python
 Script, which in turn calls
 container.Renderings.getRenderingIdsFor().
 
 Now I'm stuck. How do I select all the Renderings that have
 (for example) '001' in their id, and return just the second
 portion of the id (such as 'original' or 'thumbnail')? What
 do I need to put into the getRenderingIds and
 getRenderingIdsFor Python Scripts?

After some head scratching and some advice, I decided to use
a ZCatalog in the Renderings Specialist.

First I added a SkinScript with the following body:

WHEN OBJECT ADDED CALL
Catalog.catalog_object(self,
_.string.join(self.getPhysicalPath(),'/'))
WHEN OBJECT DELETED CALL
Catalog.uncatalog_object(_.string.join(self.getPhysicalPath(),'/'))
WHEN OBJECT CHANGED CALL
Catalog.uncatalog_object(_.string.join(self.getPhysicalPath(),'/')),
Catalog.catalog_object(self,
_.string.join(self.getPhysicalPath(),'/'))
WITH SELF COMPUTE
  external_id  = _.string.split(id,'_')[1],
  associated_image = _.string.split(id,'_')[0]

This ensures hat the objects will be catalogued when they
need to be, as well as establishing two computed attributes,
'external_id' and 'associated_image'.

I added both properties to the ZCatalog as FieldIndexes, and
removed all of the existing indexes except for id.

I also added 'external_id' as a meta-data field.

Now the Renderings.getRenderingIdsFor Python Script takes an
associated_image_id as a parameter, and reads as follows:

 list = []
 list =
container.Catalog({'associated_image':associated_image_id})
 list2= []
 for x in list:
 list2.append(x.external_id)

 return list2

And the main ArchiveImages Specialist has a getRenderingIds
Python Script:

 archive_image_id = context.id

 list =
container.Renderings.getRenderingIdsFor(archive_image_id)
 return list

Finally, I added the following to the index_html for the
ArchiveImages:

dtml-in getRenderingIds
 a href="dtml-var sequence-item"dtml-var
sequence-item/a
/dtml-in

So ArchiveImages now display links to their associated
Renderings.

Any comments or suggestions for improvements gladly
accepted.

Michael Bernstein.

___
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] Objects, Roles and Permissions

2001-04-10 Thread richard

"Randall F. Kern" wrote:
 I haven't worked with this code closely in a few months, but as I recall
 permissions that are acquired are stored as a list, and those that
 aren't are stored as a tuple.
 
 if type(self._View_Permission) == type(()):
 # done, this permission isn't acquired above this point
 
 Furthermore, I may be missing the point of this thread, but if you are
 trying to get the list of all roles assigned to a permission (from a
 python product), you could use this:
 
 from AccessControl.PermissionRole import rolesFromPermissionOn
 
 roles = rolesFromPermissionOn('View', ob)

Whoah! Yet another hidden Zope gem. Sometimes this is s frustrating!!!

And it's roles_For_PermissionOn, not From... it does the job though...



Richard

-- 
Richard Jones
[EMAIL PROTECTED]
Senior Software Developer, Bizar Software (www.bizarsoftware.com.au)

___
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] ActiveState / DC Collaboration

2001-04-10 Thread Eric Roby

This is to the folks at DC;

Will there be an effort to make Zope 2.3.x play with ActivePython 2.0 or is
this a longer range goal ... Zope 3.x ???  I know there are alot of other
irons in the fire but I am just trying to make some design decisions.  I am
bringing up multiple Zope sites in about six weeks.  A small part of the
effort can easily be accomplished with WEBDav clients but a significant
portion of the site has evolved over the past 6 years and it is Perl/CGI.  I
know I can go the Python 1.5.2/distutils/compile source route but would
prefer to leverage ActiveStates efforts and simply use pyppm to install
pyperl and ppm to install Hack-Names.

Any insight would be much appreciated.

Eric

___
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] [ANNOUNCE] Zope Developer's Guide Preview

2001-04-10 Thread Amos Latteier

Fellow Zopistas,

I'm proud to announce the first preview release of the Zope Developer's
Guide.

  http://www.zope.org/Documentation/ZDG

The ZDG picks up where the Zope Book leaves off. Its main focus is
teaching you how to develop Zope products.

We've finished rough drafts for five of the six planned chapters. There
are still lots of mistakes and omissions not to mentions countless
typos. However, there is a lot of technical information there and most
of it is accurate and up to date.

If you would like to be involved in the project take a look at the
project area

  http://www.zope.org/DocProjects/DevGuide

You'll find information on CVS access, background information on the
project and links for submitting bug reports.

Let us know what you think! I recommend submitting bug reports with
comments and suggestions (that way it's harder for us to loose your
comments.)

  http://sourceforge.net/tracker/?group_id=22339atid=375126

Enjoy!

-Amos

--
Amos Latteier mailto:[EMAIL PROTECTED]
Digital Creations http://www.digicool.com

___
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 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.
 
  ___
  Zope-Dev maillist  -  [EMAIL PROTECTED]
  http://lists.zope.org/mailman/listinfo/zope-dev
  **  No cross posts or HTML encoding!  **
  

Re: [Zope-dev] memory leak

2001-04-10 Thread Dyon Balding

have you checked the debug page in the control panel and noted any refcounts
increasing?

any chance that this is the same problem that andy is running into (read his
posts above)?

-d

On Tue, Apr 10, 2001 at 05:27:28PM +0200, Marco Nova wrote:
 Hello guys,
 
 It seems that I've some memory leak problems and I want to understand where
 I've to look for.
 
 Scenario:
 
 I've an IIS web server that generates an XML page (taking data from
 SqlServer);
 The Zope web server must retrieve the XML page, manage the data and render
 them in HTML (I cant only apply a XSL stylesheet to XML).
 
 The Facts:
 
 I've written a external method that - using httplib - reads the XML page and
 return a string that is the raw XML sources, than I've written another
 external method that use ExpatBuilder of Products.ParsedXML.DOM to parse the
 XML an generate a list of [(id - {mapping})] which will be accessed with a
 dtml-in tag, so in the sequence-key I've access to the ID and with
 sequence-item I can access to the mapping object.
 I'm using latest version of ZOPE (2.3.1, the binary one with Python 1.5.2)
 and ParsedXML.
 
 The Problem:
 
 It seems that every time the method retrieve the page or parse the XML I
 loose a bunch of kilobytes. Because the methods are very simple (100 lines
 of code in total) and because I didn't create any class for handling this
 workflow I can't understand where I can loose bytes.
 
 The Questions:
 
 Is the list generated for the dtml-in tag freed automatically by ZOPE ?
 Is there a Garbage Collector somewhere that must be activated ?
 Should I avoid the use of the ExpatBuilder for XML processing ?
 
 Thanks for listening my newbies questions.
 
 
 Best Regards,
 
 - mn
 
 ___
 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 )



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

Re: [Zope-dev] [ANNOUNCE] Zope Developer's Guide Preview

2001-04-10 Thread richard

Amos Latteier wrote:
 I'm proud to announce the first preview release of the Zope Developer's
 Guide.
 
   http://www.zope.org/Documentation/ZDG

woot!



Richard

-- 
Richard Jones
[EMAIL PROTECTED]
Senior Software Developer, Bizar Software (www.bizarsoftware.com.au)

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