- Zope-Dev - Zope lists

Re: [Zope-dev] SQLAlias Memory Leak?
by Jon Prettyman 08 Dec '00

08 Dec '00

I've seen this as well under DCOracle. -jon Dyon Balding <dyon(a)devcoder.com.au> writes: > OK, I've had more of a hack at this, and I've narrowed the problem > down a little. > > It appears that any access to an SQLAlias object causes it to not > be correctly released. The SQLAlias objects means that you can > access column names using a different case to how they are stored > in the database. > > For example, we store users in a users table in the database, with > column names like USERNAME, but they are accessed with: > <dtml-var username>, this causes the SQLAlias objects to stick around. > > One solution to our problem is to just do a <dtml-var USERNAME> > instead. However that doesn't solve the problem with this > "feature" of being able to call it with a different case. > > This is a fairly easy bug to reproduce, on my setup at least :). > I have tested it with ZSQLRelay and ZODBDA both talking to SQLServer, > and with ZPyGreSQLDA talking to PostgreSQL. > > I would appreciate it if someone else can reproduce the bug, > and I'll put it in the Collector I guess. > > thanks > -d > > On Wed, Dec 06, 2000 at 09:06:47AM +1100, Dyon Balding wrote: > > Hi, > > > > I have an application that stores state data in a > > SQLServer database. The Zope and database servers > > run on different windows machines, using the ZODBCDA > > product to connect Zope to the ODBC machinery. > > > > What I have been observing is that the Zope client's > > memory usage increases consistently when ZSQL methods > > are being called. In the Debug screens, the > > culprit appears to be Shared.DC.ZRDB.RDB.SQLAlias. > > > > Here's a dump of the first few lines after hitting > > a ZSQL method a few hundred times using ab. The > > SQLAlias figures never seem to go down. > > > > Class > > December 5, 2000 > > 1:58 pm > > December 5, 2000 > > 2:01 pm > > Delta > > Shared.DC.ZRDB.RDB.SQLAlias > > 1048 > > 4068 > > +3020 > > ZClasses.ZClass.ZClass > > 73 > > 108 > > +35 > > OFS.DTMLMethod.DTMLMethod > > 63 > > 94 > > +31 > > > > In fact most of our servers run out of memory and need > > to be restarted every couple of days when they get > > sufficient use. > > > > I've done a bit of a search of the mailing lists, and noone > > else appears to be having the same problem. So does > > anyone have an idea of what we might be doing differently > > to everyone else? We appear to have the latest versions > > installed. > > > > I've had a bit of a look through the code, and it appears > > that SQLAlias is used to case desensitize the column names > > of the returned data? > > > > Any pointers would be appreciated. > > > > thanks, d > > > > -- > > | Dyon Balding dyon(a)devcoder.com.au | > > > > _______________________________________________ > > Zope-Dev maillist - Zope-Dev(a)zope.org > > http://lists.zope.org/mailman/listinfo/zope-dev > > ** No cross posts or HTML encoding! ** > > (Related lists - > > http://lists.zope.org/mailman/listinfo/zope-announce > > http://lists.zope.org/mailman/listinfo/zope ) > > -- > Dyon Balding <dyon(a)devcoder.com.au> > > _______________________________________________ > Zope-Dev maillist - Zope-Dev(a)zope.org > http://lists.zope.org/mailman/listinfo/zope-dev > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope )

3 2

Re: [Zope-dev] Significance of the ZODB split?
by Simon Michael 08 Dec '00

08 Dec '00

Michel Pelletier <michel(a)digicool.com> writes: > I am, in particular, barely not lazy enough to check stuff into > branches, much less whole other repositories. ;) Nicely put. Posted on zwiki.org so I can use it later. :) -Simon

1 0

A few corrupt files in Public CVS discovered and corrected
by Ken Manheimer 08 Dec '00

08 Dec '00

Recently (yesterday and today) we found a few files in the CVS repository to be corrupt - different than the internal CVS files from which they were mirrored. We've run a check to track down all such files, and have corrected them all. However, we don't know at this point whether or not the mirroring process, itself, is corrupt - we don't know whether this is a one-time or an ongoing problem. Here's a list of the files that have turned up - they should all be ok now, and an update of your checkouts should get the fixed versions - at least for the trunk. For branches, you should probably move aside your existing copies of these files (preserving changes) and do an update to refresh them from the rectified repository files. They are: zpasswd.py wo_pcgi.py z2.py inst/binary_install.py doc/FAQ.txt I've done a quick recursive diff of an internal and public checkout to determine that this is all of them, at least at the moment. Assuming my check was accurate, we'll know that we have a continuing problem if new ones show up - hopefully not, but keep a lookout, and let me know if you discover any more. (Thanks to shane and dyon balding for pointing out the problem.) Ken klm(a)digicool.com

1 0

(was Flat Database/ZPatterns api, performance ?)
by Simon Michael 08 Dec '00

08 Dec '00

Itamar Shtull-Trauring <itamar(a)maxnm.com> writes: > Simon Michael wrote: > > Flat Database (was ListMate) is just what I need to whip up an > > interface for non-technical administrators - thanks. So I migrated two > > data tables ("workshops" & "registrations") from gadfly to flatdb > > instances using the CSV import feature, and the admin interface is > > working fine. > > I wrote flat database because I wanted some features ListMate didn't have > and didn't want ZClasses. I basically copied the structure from ListMate, > so it's probably not the best design possible for ZPatterns. So (1) may not > be possible with the current code. Itamar, thanks for your suggestions on this. I never got it working. Frustrated by a period of intense Zope Developer Pain I fell back on.. you've guessed it.. my favorite hammer. For this application I found that a zwiki page containing a CSV table makes a micro-db that's relatively easy to administer & work with (and it's almost editable with MS Excel). I made a support method for doing queries: http://zwiki.org/QueryCsv Question for the list: is this nuts ? I somehow doubt it would pass the ACID test, but zope's transactions help and at least for this app (small data, low load, mostly appending) it seems to have worked well. -Simon

1 0

FYI: calling doctest from ZUnit
by Simon Michael 08 Dec '00

08 Dec '00

I added some ZUnit tests which invoke Tim Peters' doctest testing framework in the zope environment. More at http://zwiki.org/DocTest regards, -Simon

1 0

Linux Zope <-> Win2K SQL Server?
by jimbo 07 Dec '00

07 Dec '00

I'm still trying to figure out what the missing pieces are... if anyone else has gotten a Linux Zope talking to a Win2K SQL Server 2000, I would appreciate some guidance. >It seems I would have to write my own Product from scratch to do this, >no >matter what. None of the ODBC Products seem to be available for Unix, >and >ODBC from Unix <-> Windows will require additional software like >EasySoft's >ODBC Bridge anyway. Or I could just not use ODBC at all and make some >Product customized to MS SQL Server. A while back I had to do a job where I needed ODBC from Windows <-> Linux. I tried a product called iODBC and some other open-source ODBC data manager. Never could get the data manager configured. I would suggest sticking with ODBC. Here is a earlier post on the subject that might help. http://zope.nipltd.com/public/lists/dev-archive.nsf/ByKey/11309A0077896561 >Some may suggest using ActiveState's Perl Methods for Zope and >DBD::Proxy. >:) It's a possibility, but I'd like to see if more conventional >solutionsexist. Sounds painful :-0 -Jimbo

1 0

virtual domains
by Josh Zeidner 07 Dec '00

07 Dec '00

Hello, Is it possible to configure zope for "virtual domains"? For instance, can I have one zope installation serve several domains? How do I configure this? -josh zeidner http://www.brooklynmedialabs.com _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com

2 1

CVS emergency_user bug
by Robin Becker 07 Dec '00

07 Dec '00

z2.py makes references to AccessControl.User.emergency_user which causes an exception. Is it ok to use SpecialUsers.super instead? -- Robin Becker

2 3

file references
by Dan Sashko 07 Dec '00

07 Dec '00

~~~sorry for double post if you get it twice... I think I sent it first from the wrong email address is there a way in zope to reference a document on a server without having it to be in the zope database??? if I want to display say a microsoft document, with content type of application/msword so that the Internet explorer displays it as formated word document and so that it can be saved back to server??? or is there other ways of accomplishing the same thing? thank you for any help Dan S.

2 1

Re: [Geeks] Re: Interface Meta Data proposal
by Guido van Rossum 07 Dec '00

07 Dec '00

> I notice you mention post/pre conditions (something that UML obviously talks > about). I wonder if we want to do a bit of research on Eiffle and it's > contractual description. The only thing I wonder is if some of this is > actually useful programatically, if that makes sense? It's great info, but > is it useful at runtime? In Eiffel (I've never heard of Eiffle :-), pre- and post-conditions are turned into run-time checks, just like assertions. There are separate flags to turn code generation for pre- and post-conditions off. This is useful, as follows: while debugging your code, turn both on. When you've fully debugged an application, you turn both off. When you've fully debugged a library module, you create two versions: one with both turned off, for use in fully debugged applications, and one with pre-conditions on and post-conditions off, for use by other code that is still in need of debugging. I've heard that this works very well, and in Python 3000 (when we have optional static typing) I would love to add this to Python. If it's not feature bloat. --Guido van Rossum (home page: http://www.python.org/~guido/)

3 2