May 2001 - Zope-Dev - Zope lists

Quick Persistence Question
by Chris Withers 21 May '01

21 May '01

if self.data is a BTree and I do: obj = self.data[id] obj.revsub = obj.revsub + 1 obj's class subclasses Persistant, as does self's Do I need to let the persistence mechanism know something has changed? If so, do I do: obj._p_changed=1 ...or... self._p_changed=1 (which feels like it's gonna store much more data than it needs to...) ...or something else? cheers, Chris

1 0

ZCatalog/TextIndex: searching for the exact phrase "word1 word2"
by Erik Enge 21 May '01

21 May '01

Hiya, it basically says it in the subject. How can I search for "word1 word2" without ZCatalog/TextIndex interpreting it as "word1" or/and "word2"?

2 7

MySQL (Zope) Problem on Sun Solaris machines ?
by Holger Lehmann 21 May '01

21 May '01

Hi Andy, and all ! I was developing a little webapp under Zope. I was using the following setup: Linux 2.4.x Zope 2.3.0 MySQL 3.22.32 ZMySQLDA-2.0.6 MySQL-python-0.3.5 Everything went smooth that way. Small SQL queries and complex SQL queries, queries on empty tables and on full ones, they all went well. Now I exported the website and dumped the tables structure. I the impoerted the website and created the tables on a: Sun Solaris (don't ask me what release) - Sparc processor. Zope 2.3.0 MySQL 3.23.32 (or 3.23.33, I am not sure) ZMySQLDA-2.0.6 MySQL-python-0.3.5 And this happened: Querying MySQL like this: -- show tables; -- or -- select * from data; -- all went ok. But running this statement on *empty* tables (mark you, just no data) left no python process running, they all died: -- select a.a b.b c.c from a b c where a.fk_b = b.pk_b and a.fk_c = c.pk_c order by a.a; -- It looks to me there is an uncaught "NULL pointer exception" deep down somewhere in the code.... Anyone hints or solutions ? I am going to put some valid data into the database and try to run the queries again. I have not done this yet. - Thanks in advance, Holger -- ----------------------------------- catWorkX GmbH Dipl.-Ing. Holger Lehmann Stresemannstr. 364 22761 Hamburg Tel: +49 (0700) catWorkX Tel: +49 (40) 890 646-0 Fax: +49 (40) 890 646-66 mailto:lehmann@catworkx.de http://www.catworkx.de http://www.catbridge.de

1 0

another Zope hanging..
by cs＠comlounge.net 21 May '01

21 May '01

Hi! I also now have some problems with a hanging zope. I got something like this in my stupid logfile: 2001-05-03T13:44:39 ERROR(200) ZServer uncaptured python exception, closing channel <select-trigger (pipe) at 81d64c8> (exceptions.OSError:[Errno 11] Die Ressource ist zur Zeit nicht verf?gbar [/opt/Zope-2.3.1-src/ZServer/medusa/asyncore.py|poll|83] [/opt/Zope-2.3.1-src/ZServer/medusa/asyncore.py|handle_read_event|335] [/opt/Zope-2.3.1-src/ZServer/medusa/select_trigger.py|handle_read|77] [/opt/Zope-2.3.1-src/ZServer/medusa/asyncore.py|recv|287] [/opt/Zope-2.3.1-src/ZServer/medusa/asyncore.py|recv|475]) Now my question is simply if I can catch this exception somewhere and get some traceback etc. Actually I am quite confused from the inner workings of medusa so I dunno where to start searching. Can anyone help? (I know about the -M logging but unfortunately this does not help that much..) cheers, Christian -- COM.lounge http://comlounge.net/ communication & design info(a)comlounge.net

4 20

TAL/ZPT expand-macros on when FTP get?
by Brad Clements 19 May '01

19 May '01

One thing I'd like to see in METAL/TAL is to have it always expand macros when an FTP get is performed. I'm using HTML-KIT now to do almost all of my Zope work, and it's wonderful (too bad its only FTP based, not WebDav). Anyway, if the macros where always expanded I'd be thrilled. Just a wish for the next release Brad Clements, bkc(a)murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements

1 0

RE: [Zope-dev] RE: [Zope] xmlrpc slowness
by Jon Edwards 18 May '01

18 May '01

1 0

'None' object has no attribute 'load'
by Chris Withers 18 May '01

18 May '01

Hi, Another data point on these errors. ------ 2001-05-18T11:01:44 ERROR(200) ZODB Couldn't load state for '\000\000\000\000\00 0(\347\026' Traceback (innermost last): File E:\Zope\2379B4~1.2\lib\python\ZODB\Connection.py, line 508, in setstate AttributeError: 'None' object has no attribute 'load' I get the quite often when playing with Squishdot. I don't remember getting them ages ago, but I have no idea what could be causing it. How would I go about finding the id/path of the objects the ZODB couldn't load state for? I suspect this may not have a nice answer... cheers, Chris

2 6

Asyncore in an external method
by Matt Hamilton 18 May '01

18 May '01

Dear All, I have just written a parallel whois lookup as an external method. It uses Asyncore to handle the parallelism. It works fine from the command line, but I am now trying to use it within Zope with not much luck the request just hangs the server. I have just wondered, can this actually be done? I know Medusa uses asyncore -- can a method within Zope also use it? -Matt -- Matt Hamilton matth(a)netsight.co.uk Netsight Internet Solutions, Ltd. Business Vision on the Internet http://www.netsight.co.uk +44 (0)117 9090901 Web Hosting | Web Design | Domain Names | Co-location | DB Integration

1 0

DB(Oracle) Transactions with Zope(/ZPatterns)
by Andreas Repp 17 May '01

17 May '01

Hi *, i'm currently developing a (network information) DB web-interface using ZPatterns specialists with one specialist for every logical object. For instance i have a 'component'-specialist which handles a object<->table mapping for the tables: o component - product (n:1 foreign key) - location (n:1 foreign key) - physical port (1:n foreign key) - ... The user (provided that she/he has permission) should be able to create a new component as well as related physical ports, new product etc. 'create component' Sequence: ---------------------------- (1) call component-specialist newItem -> skin script 'WHEN OBJECT ADDED' calls SQL insert statement with default attribute parameters from ZClass ### + SQL commit (Zope/DC Oracle default behavior)! ### (2) redirect user to .../component/#newid/edit (3) user adds new physical port -> skin script 'WHEN OBJECT ADDED' calls SQL insert statement with component #newid as foreign key + default stuff from ZClass again an SQL commit-statement is appended ... (x) user clicks 'cancel'-button -> MY PROBLEM (trash in DB because of no(?) possibility to make a SQL rollback) Questions: ---------- 1. Is it possible to make sure a user stays with a specific DC Oracle thread ? (trick timeouts via http-refresh ?) 2. Provided that a user can have her/his private DB thread (kind of a private xterm with PL/SQL ;-) is it possible to wrap a bunch of SQL statements (triggered by ZPatterns) into a (Oracle) DB Transaction ? Any comments (maybe answers ;-) would be _very_ appreciated. thank u in advance Andy ---------------------------------------------------------------------- Andreas Repp andreas.repp(a)lrz-muenchen.de Leibniz Rechenzentrum Muenchen www.lrz.de Barer Str. 21 office +49 8441 4980772 D-80333 Muenchen mobile +49 172 8337010 ----------------------------------------------------------------------

1 0

ZCatalog, REQUEST, misc.
by Erik Enge 17 May '01

17 May '01

Hi. I was adding a couple of objects to my system. Turns out, it's over a million of them. I have a 1GHz Pentium with 1GB RAM and 1GB swap. After I added all the objects with a little script (that took about 12 hours), I was going to index them to the Catalog I have. (I had to uncomment the index_object method's innards in CatalogAwareness.py because of a problem I mention further down.) After using up all my RAM and swap, taking five hours and making nothing happen, I gave up trying to index the objects. (This was _with_ subtransactions enabled; set to "10000".) This is Zope 2.3.1b1, by the way. I'm changing to Zope 2.3.2b2 as we speak, but I don't think it will improve performance that much. So, to the origin of one of the problems. This is part of my script to add all these objects: """ from AccessControl.SecurityManagement import newSecurityManager from ZPublisher.Request import Request from ZPublisher.Response import Response import sys import Zope import os os.environ['SERVER_NAME'] = 'localhost' os.environ['SERVER_PORT'] = '80' response=Response() REQUEST = Request(sys.stdin, os.environ, response) applic=Zope.app() #applic.REQUEST = REQUEST uf=applic.acl_users user=uf.getUser('sysadm').__of__(uf) newSecurityManager(None, user) print applic """ Nice, that works. What happends from now on in the script is quite boring; it just adds object. Kinda like: applic['object'].manage_add_something() If I do not uncomment those things in CatalogAwareness.py I get an error on SERVER_URL. I think it is resolve_url() that tries to make a run for it. Clever as I thought I was, I added the "applic.REQUEST = REQUEST" line (which, as you can see, is now commented out) and thought that it would fix my problems. Initially, it looked good. Adding the objects (with the CatalogAwareness.py stuff not commented out) was working. However, when I tried to access any of the newly added objects, Zope died, restarted and pretended like nothing had happend. This is reproducable. What I would really like, is to avoid this after-add-reindex procedure (since I can't make it happen). Is there any way I can produce a "good enough" REQUEST for Zope? So that it doesn't do that die-repeat cycle on me? Any hints greatly appretiated! :-) (I haven't got much confidence that the Catalog will be able to respond to any queries with over a million objects indexed, but time will show I guess. I tried a 2.3.1b1 Catalog with 250.000 odd objects, and it wasn't very talkative.)

3 20