- Zope-Dev - Zope lists

dupe column names not supported (Shared.DC.ZRDB) ?
by Adam Manock 17 Dec '02

17 Dec '02

Hi there, I'm currently testing (documenting, building RPM packages for) the following configuration: RedHat 8.0 python 2.1.3 postgresql 7.3 mx 2.0.3 psycopg 1.1 Zope-2.6.1b1 Having just got all the packages built and installed, I thought I'd run the database adapter, Zope and postgres through their paces starting with the SQL examples at: http://www.postgresql.org/idocs/index.php?tutorial-sql.html I ran into trouble with: http://www.postgresql.org/idocs/index.php?tutorial-join.html specifically with: SELECT W1.city, W1.temp_lo AS low, W1.temp_hi AS high, W2.city, W2.temp_lo AS low, W2.temp_hi AS high FROM weather W1, weather W2 WHERE W1.temp_lo < W2.temp_lo AND W1.temp_hi > W2.temp_hi; Error, exceptions.ValueError: Duplicate column name, city Traceback (innermost last): Module ZPublisher.Publish, line 98, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 39, in call_object Module Shared.DC.ZRDB.Connection, line 115, in manage_test Module Shared.DC.ZRDB.Results, line 52, in __init__ ValueError: Duplicate column name, city Obviously this will work if you change the query to: SELECT W1.city AS city1, W1.temp_lo AS low1, W1.temp_hi AS high1, W2.city AS city2, W2.temp_lo AS low2, W2.temp_hi AS high2 FROM weather W1, weather W2 WHERE W1.temp_lo < W2.temp_lo AND W1.temp_hi > W2.temp_hi; City1 Low1 High1 City2 Low2 High2 San Francisco 43 57 San Francisco 46 50 Hayward 37 54 San Francisco 46 50 I did a little digging to see if the above is valid SQL92 syntax, or just uses a PostgreSQL specific extension, the only things I found: In: http://www.postgresql.org/idocs/index.php?sql-select.html "In the SQL92 standard, the optional keyword AS is just noise and can be omitted without affecting the meaning. The PostgreSQL parser requires this keyword when renaming output columns because the type extensibility features lead to parsing ambiguities in this context. AS is optional in FROM items, however." And In: http://manuals.sybase.com/onlinebooks/group-as/asg1150e/mig_gde/@Generic__B… "Correlation Names ANSI requires correlation names on self-joins. The following query is now invalid: select columns from table1, table1 where clause ... This query must be rewritten as: select columns from table1 t1, table1 t2 where clause ..." Trying it without the "noise" in psql: testdb1=> SELECT W1.city, W1.temp_lo, W1.temp_hi, testdb1-> W2.city, W2.temp_lo, W2.temp_hi testdb1-> FROM weather W1, weather W2 testdb1-> WHERE W1.temp_lo < W2.temp_lo testdb1-> AND W1.temp_hi > W2.temp_hi; city | temp_lo | temp_hi | city | temp_lo | temp_hi ---------------+---------+---------+---------------+---------+--------- San Francisco | 43 | 57 | San Francisco | 46 | 50 Hayward | 37 | 54 | San Francisco | 46 | 50 (2 rows) testdb1=> The question: If the above example query is valid ANSI SQL92, do we aim to support it? Adam

3 4

Bug Day Followup
by Casey Duncan 17 Dec '02

17 Dec '02

Just wanted to thank everyone for their participation on bug day and wanted to followup with a couple of reminders: 1. Make sure CHANGES.txt got updated on the 2.6 branch if you checked in a change. Its not too late to update it now. 2. Make sure bug fixes you made on the 2.6 branch get merged into the HEAD, otherwise they are likely to reappear in 2.7. Again thanks to everyone for a great bug day! -Casey

1 0

PyCon DC 2003: Extension of Submission Deadline
by Guido van Rossum on behalf of Steve Holden 17 Dec '02

17 Dec '02

The deadline for submissions to PyCon DC 2003 appears to have been too tight for many authors. While some promised submissions have arrived, several have not even though the original deadline of 15 December has passed. Rather than exclude promising papers the organizing committee has decided to extend the deadline for submissions. Accordingly, the new schedule for proposals is as follows: Submission Deadline: January 15, 2003 Notification of Acceptance: January 31, 2003 Final Versions Due: March 10, 2003 Conference Dates: March 26-28, 2003 [unchanged] Authors who have already submitted abstracts are invited to resubmit if they feel that the original deadline had an adverse effect on the quality of their submissions. Please make any appropriate media, mailing lists and newsgroups aware of this announcement. Enquiries should be sent in the first instance to pycondc-2003(a)python.org. Information about PyCon DC 2003 is available at the following URLs: www.python.org/pycon www.python.org/cgi-bin/moinmoin/PyCon The latter URL, a Wiki page, can also be used to communicate with the conference organizers. This is *your* conference: tell us what *you* want to see in it. regards ----------------------------------------------------------------------- Steve Holden http://www.holdenweb.com/ Python Web Programming http://pydish.holdenweb.com/pwp/ Bring your musical instrument to PyCon! http://www.python.org/pycon/ -----------------------------------------------------------------------

1 0

Track modification
by Cornel Nitu 16 Dec '02

16 Dec '02

I want to track modifications of objects and I don't know when Zope changes the bobobase_modification_time. Is there a method I could overwrite for this? Thanks, Cornel

2 1

Infuriating ZClass registry Heisenbug
by Evan Simpson 16 Dec '02

16 Dec '02

This past weekend I migrated a bunch of ZClasses and the web site that uses them from a scratch Zope instance into my production instance. Both run off the same 2.6 CVS branch checkout, connecting to ZEO servers running from the same ZEO trunk checkout. For a while after starting the server, everything works fine. After an unpredictable time period ranging from minutes to hours, suddenly my ZClass instances become broken, and I start seeing this in my log, over and over: 2002-12-10T11:33:18 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x01\x1f\xc9' Traceback (innermost last): Module ZODB.Connection, line 533, in setstate ImportError: No module named */rJ6Q2CNqMJDSN4Okpwiuw== The object that fails to load state is a BTree Bucket belonging to the ZClass registry, and "/rJ6Q2CNqMJDSN4Okpwiuw==" is the GUID of one of my ZClasses. If I delete that ZClass, it complains about a different one. If I restart the server, everything works again, for a while, but I get the following in my log: 2002-12-10T11:36:49 INFO(0) ZCS:2443 Connected to storage ------ 2002-12-10T11:36:49 INFO(0) ZODB Opening database for mounting: '144865536_1012175858.273945' ------ 2002-12-10T11:36:49 INFO(0) ZODB Mounted database '144865536_1012175858.273945' at /temp_folder ------ 2002-12-10T11:36:50 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x01\x1f\xc9' Traceback (innermost last): Module ZODB.Connection, line 533, in setstate ImportError: No module named */rJ6Q2CNqMJDSN4Okpwiuw== ------ 2002-12-10T11:36:50 ERROR(200) Zope A problem was found when checking the global product registry. This is probably due to a Product being uninstalled or renamed. The traceback follows. Traceback (innermost last): Module OFS.Application, line 218, in checkGlobalRegistry Module ZODB.Connection, line 533, in setstate ImportError: No module named */rJ6Q2CNqMJDSN4Okpwiuw== ------ 2002-12-10T11:36:50 INFO(0) Zope Beginning attempt to rebuild the global ZClass registry. ------ 2002-12-10T11:36:52 INFO(0) Zope The global ZClass registry has successfully been rebuilt. ------ 2002-12-10T11:36:52 INFO(0) ZServer HTTP server started at Tue Dec 10 11:36:52 2002 Hostname: server1.shackworks.com Port: 8280 Help!

6 20

more bug day status
by Chris McDonough 16 Dec '02

16 Dec '02

26 issues closed. Only 222 more to go. ;-) Notable bugs fixed: - multiple selection unicode bug (#697) - make sure passwords aren't encrypted twice ;-) (#256) - don't fail in History tab if Historical object is stored in a non-history-supporting storage (#700) 10 people currently in the #zope-dev channel on irc.openprojects.net. - C

1 0

RE: [Zope-dev] ClientCache and Large Files
by sean.upton＠uniontrib.com 16 Dec '02

16 Dec '02

This sounds like the most appropriate solution, as long as you are careful to make sure that Squid or other forward cache is configured to cache files that large, it isn't likely going to be by default. Sean -----Original Message----- From: Casey Duncan [mailto:casey@zope.com] Sent: Monday, December 16, 2002 8:21 AM To: Guido van Rossum; Brian R Brinegar Cc: zope-dev(a)zope.org Subject: Re: [Zope-dev] ClientCache and Large Files On Monday 16 December 2002 10:53 am, Guido van Rossum wrote: > > We're running ZEO with Zope 2.5.1. We currently have a ZEO Cache > > (ClientCache) of 200 meg. Occasionally someone will download a 300 > > meg file that completely blows away the client cache. Is there a way > > to prevent this? You're best bet would be to put a proxy cache in front of Zope. Zope's not very efficient at serving big static files like this compared to Apache or squid. > I'm afraid not; this isn't a very typical use case. You could > implement a file size limit, or increase the cache size to be more > than twice the largest expected dowload (the cache is implemented as > two files, each of which is limited to half the nominal cache size). I think it would be nice to be able to control cacheability of certain objects. However it smells like a YAGNI, especially with good front end caches that can take care of it. -Casey _______________________________________________ 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 )

1 0

debugging Zope -> ImportError: ./ExtensionClass.so: undefined symbol: PyObject_Init
by Jens Wolk 16 Dec '02

16 Dec '02

Hi everybody, I tried to follow "Chapter 7: Testing and Debugging" of "The Zope Developer's Guide (Zope 2.4 edition)" http://www.zope.org/Documentation/Books/ZDG/current/TestingAndDebugging.stx However, on my Linux server I get the following error: (Zope is v2.5.1) [root@prefect Zope-2.5.1-linux2-x86-dev]# cd lib/python [root@prefect python]# python Python 1.5.2 (#1, Apr 3 2002, 18:16:26) [GCC 2.96 20000731 (Red Hat Linux 7.2 2 on linux-i386 Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam >>> import Zope, ZPublisher Traceback (innermost last): File "<stdin>", line 1, in ? File "Zope/__init__.py", line 21, in ? import ZODB, ZODB.ZApplication, imp File "ZODB/__init__.py", line 14, in ? import sys, ExtensionClass, TimeStamp, cPersistence, Persistence ImportError: ./ExtensionClass.so: undefined symbol: PyObject_Init >>> The system is a RedHat 7.2 system with the following python packages installed: [root@prefect python]# rpm -qa | grep python python-1.5.2-38 python-popt-0.8.8-7.x.2 python-xmlrpc-1.5.1-7.x.3 python2-docs-2.2-16 python2-2.2-16 python-clap-1.0.0-3 rpm-python-4.0.4-7x.18 python-docs-1.5.2-38 BTW, if I try to import ZPublisher only, the result is again an error: [root@prefect python]# python Python 1.5.2 (#1, Apr 3 2002, 18:16:26) [GCC 2.96 20000731 (Red Hat Linux 7.2 2 on linux-i386 Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam >>> import ZPublisher Traceback (innermost last): File "<stdin>", line 1, in ? File "ZPublisher/__init__.py", line 23, in ? from Publish import publish_module, Retry File "ZPublisher/Publish.py", line 19, in ? from Response import Response File "ZPublisher/Response.py", line 13, in ? import HTTPResponse File "ZPublisher/HTTPResponse.py", line 79, in ? status_codes[''.join(val.split(' ')).lower()]=key AttributeError: 'string' object has no attribute 'join' >>> It seems I missed something important. Can anybody give me hint? Yours. Jens

2 2

realtime Bug Day report
by Chris McDonough 16 Dec '02

16 Dec '02

So far the good folks participating in the bug day on irc.openprojects.net #zope-dev have resolved 13 issues in the collector. Present in the channel are 9 people. Feel free to join in. Thanks, - C

1 0

ClientCache and Large Files
by Brian R Brinegar 16 Dec '02

16 Dec '02

Hello, We're running ZEO with Zope 2.5.1. We currently have a ZEO Cache (ClientCache) of 200 meg. Occasionally someone will download a 300 meg file that completely blows away the client cache. Is there a way to prevent this? Thanks, -Brian Brinegar ECN Purdue University

3 2