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 se
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/Virt
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 so
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
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
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
___
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
> 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.
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]>;
<[EMA
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: <[EMAI
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" <[EM
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 Mc
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]
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 dat
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 onl
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
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]
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://localhos
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]>; <[EM
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
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:
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.
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
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 a
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
"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
"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
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 si
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
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
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 le
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 PRO
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)
> have you checked the debug page in the control panel and
> noted any refcounts
> increasing?
Class April 10, 2001 9:17 am April 11, 2001 8:34 am
Products.ParsedXML.DOM.Core.Text 3241 27318 +24077
Products.ParsedXML.DOM.Core.Element 1777 14493 +12716
Pr
Hi Marco,
This looks like a potential bug in either ParsedXML or the code you're using
to manipulate the components within ParsedXML.
We'd like to find out! ;-) Do you think you can file a collector report
with enough information in it to reproduce this behavior?
Many thanks,
- C
- Orig
35 matches
Mail list logo