- Zope - Zope lists

Help!!! Zope won't start -- StorageSystemError
by Dan Gaibel 28 Aug '05

28 Aug '05

Hi folks, This is my first post to this list and I'm desperate for help. I'm running Zope 2.6.1 with Python 2.1.3. My Zope instance died today and won't come back. When I try to start it, I get: 2005-08-27T20:58:15 PANIC(300) z2 Startup exception Traceback (innermost last): File /home/lrc/z2.py, line 497, in ? File <string>, line 1, in ? File /home/lrc/lib/python/Zope/__init__.py, line 37, in ? File /home/lrc/lib/python/ZODB/FileStorage.py, line 213, in __init__ File /home/lrc/lib/python/ZODB/lock_file.py, line 33, in lock_file StorageSystemError: Could not lock the database file. There must be another process that has opened the file. <p> ------ 2005-08-27T20:58:15 PROBLEM(100) zdaemon zdaemon: Sat Aug 27 16:58:15 2005: The kid, 1657, died on me. At first I deleted Data.fs.lock and cannot find any process that would suggest zope is running. I've also played with renaming various .pid files in hopes of an answer. I'm stumped and in very hot water right now. Any help or guidance would be very appreciated. Thanks, Dan

3 4

Data.fs Windows to Linux?
by Marc Schnapp 27 Aug '05

27 Aug '05

I thought that I would back up my data.fs by copyting the entire Linux /var directory to a Windows machine with spare disk space and then creating a ZIP file on the Windows machine. There was a problem on the Linux machine, so I figured there'd be no problem by simply copying the data.fs (via a Samba share) back from Windows -> Linux. It seems that when Zope starts back up, it keeps attempting to deal with the "alien" database and then shuts down. The Same Database File Works Perfectly With A Windows Plone/Zope Installation ------------------------------------------------------------------------------------------------- I installed a Windows version of Plone (with Zope of course) and that same data.fs file works just fine in the Windows environment. Questions: ------------ 1) Am I without hope of ever running the database under Linux again? 2) What is the reason that the database goes from Linux -> Windows OK but not in the other direction? 3) MOST IMPORTANT: Is there a technique I can use to tweak the database file or recover it so that it is Linux-friendly?

3 2

lines around images as links
by michael 27 Aug '05

27 Aug '05

how can i get rid of borders around images? as in: <a href="/app/staff/contacts"><dtml-var pen></a> it's been driving me mad! ta mike

4 4

ZASync method calls
by Jan-Ole Esleben 27 Aug '05

27 Aug '05

Hi! I'm having a really complicated problem that I don't know how to put into words properly, because I'm really vague on what's causing it and the setup is highly involved; I would be _really_ glad if someone could help me out with this: I have a ZOPE instance (connected to a ZEO server) running a custom method call wrapper that decides (based on the method's arguments) to run a method asynchronously using zasync (as well as some other stuff that I think isn't important in the context of my problem). All this has been tested. For various reasons, the method call's path is approximately as follows: 0. Method call using a generic Python method 1. Python code - resolves the method's location and name using ZOPE methods 2. Method dispatcher (called via ZOPE): dispatches synchronously or asynchronously, using zasync, zope_exec and putSessionCall; the method called is again a ZOPE method that calls the final method as another ZOPE method The apparent massive indirection cannot be avoided (for rather complicated reasons). Everything is supposed to be highly generic. My problem is this: if I use a test method that dispatches such an asynchronous method that is supposed to change an instance variable (the class is persistent) and run for ten seconds, then wait for fourteen seconds and see if the method has run (check the instance variable) synchronously (while the asynchronous method is supposed to work in the background), I find the variable unchanged; further checks (using print statements) confirm that the asynchronous method indeed doesn't run until my assertion fails, even if I give it a lot of time. If I disconnect both - run the long running method asynchronously, then run (via ZOPE directly, not from within the same method call) a synchronous method that waits for fourteen seconds and checks the variable, the asynchronous call works just fine (even though both run alongsinde for a time). It isn't the number of threads available to the zserver, I've increased that and nothing has changed. Manual tests of asynchronous methods also don't show anything wrong with my zasync setup. I can only assume that the asynchronous method is _started_ only _after_ the caller has finished. Is there a reason for that, and can I circumvent it? Or am I completely wrong and something else isn't working? I'm on Windows XP SP2, ZOPE 2.7.6, Python 2.3.5 with Twisted installed. TIA, Ole

2 2

OOP and Zope.
by Fernando Lujan 26 Aug '05

26 Aug '05

Hi, I try to find information about programming in Zope with the OO paradigm. I didn't find many documentation... For instance, how can I define classes and instances once I just work with dtml-methods and dtml-documents? Thanks. Fernando Lujan

5 9

Re: [Zope] SQL Problem
by Philip Beardmore 26 Aug '05

26 Aug '05

Hi JCC, That is exactly what I was looking for - Assigning a default value works great! I previously tried to do this using the syntax provided by zope help: title:string="default value" but had no luck. Thanks :-> Phil ----- Original Message ----- From: J Cameron Cooper <zope-l(a)jcameroncooper.com> Date: Thursday, August 25, 2005 10:35 pm Subject: Re: [Zope] SQL Problem > Philip Beardmore wrote: > > I'm having a really annoying SQL problem which I think (or hope) can > > easily be sorted but I'm not sure how to do it. > > > > I have a ZPT which is collecting data in a form - Both text boxes > and> checkboxes. The form then passes the variables on to a DTML > Method> which does a few bits of error checking then calls an Z SQL > Method to > > insert the data. > > > > If all of the data is completed (i.e. each textbox and checkbox is > > ticked) then the form inserts the data exactly as it should. If > not all > > checkboxes are ticked the page returns an error - This is due to > the SQL > > Method trying to insert data which hasnt been passed to it. > > You can provide default values to the parameters of your Z SQL > Method. > Alternately, I believe the DTML sqlvar tags can also be given a > default > behavior. > > --jcc > -- > "Building Websites with Plone" > http://plonebook.packtpub.com >

2 1

Random Module
by Sam Boggess 26 Aug '05

26 Aug '05

Why won't Zope let me call the random module? It's really annoying to have to write an external method to call such a simple tool. Is there a way around this? Thanks.

3 3

Re: Stepper
by Chris Withers 26 Aug '05

26 Aug '05

Hi Gary, Gary Poster wrote: > For our use case, the (quite frequent) cron kick could get to be very, > very painful with long running tasks that may overlap (think *lots* of > ConflictErrors). Ah well, if they're doing the same thing, just kicked off frequently, and you're worried about one run not finishing before another, I'd just put in some locking in Stepper that wouldn't run a chain/step if it was already running elsewhere, optionally logging this as an error... > the pain carefully. I'm reasonably confident that Stepper would need > to become a long running process with a queue in order to get there. I don't think it needs to be a long running process, and I think the queue could live elsewhere... > Stepper is currently arguably better if you only have tasks like the > ones you list, as long as you only start Stepper at a slow enough > frequency that you have no chance for overlap (once a day sounds > reasonable, though who knows). If you might overlap, zasync is safer ATM. The "locking prevents overlap" thing has worked really well for me in the past... > zasync ended up being *very* careful, because we discovered we needed > to be. Maybe a simpler, second gen design would need less care. I tend to prefer logging errors and failing as much as possible. Anything else means Stepper wouldhave to do guesswork and that would be bad... > On the other hand, if you are interested in zasync's through-the- > browser use case, maybe Stepper can grow a next-gen through-the-web API > also. Nope, Stepper will never grow that. It's use case is much closer to that of "zopectl run" on steroids, but I think it could work well with a more light-weight zasync... cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk

1 0

Locking MySQL tables via Z MySQL Database Connections
by Sean Dunn 25 Aug '05

25 Aug '05

I'm confused as to what the thread "scope rules" are between Zope and MySQL. I would like to be able to emulate transaction control in MySQL in a Python script in Zope, but I'm unclear as to how the Z MySQL DB Connection works, and what defines a "thread" for it? I need to be able to LOCK tables, INSERT, SELECT, INSERT, and then UNLOCK the tables. But, if I put each of these commands in separate Z SQL queries, and call them each from a Python script, are they guaranteed to be in the same SQL thread, so that their locking context will be the same, or will they all be executed on different MySQL threads? Or...on the other extreme, does every query from a Zope server use the same connection thread? And does that thread simply exist until the connection times out and it has to reconnect? Thank you, Sean

1 0

SQL Problem
by Philip Beardmore 25 Aug '05

25 Aug '05

I'm having a really annoying SQL problem which I think (or hope) can easily be sorted but I'm not sure how to do it. I have a ZPT which is collecting data in a form - Both text boxes and checkboxes. The form then passes the variables on to a DTML Method which does a few bits of error checking then calls an Z SQL Method to insert the data. If all of the data is completed (i.e. each textbox and checkbox is ticked) then the form inserts the data exactly as it should. If not all checkboxes are ticked the page returns an error - This is due to the SQL Method trying to insert data which hasnt been passed to it. Below is my SQL Method: INSERT choices (userid, datetime, course, name, core1, core2, core3, core4, core5, choice1, choice2, choice3, choice4) VALUES ( <dtml-sqlvar userid type=string>, <dtml-sqlvar datetime type=string>, <dtml-sqlvar course type=string>, <dtml-sqlvar name type=string>, <dtml-sqlvar core1 type=string>, <dtml-sqlvar core2 type=string>, <dtml-sqlvar core3 type=string>, <dtml-sqlvar core4 type=string>, <dtml-sqlvar core5 type=string>, <dtml-sqlvar choice1 type=string optional>, <dtml-sqlvar choice2 type=string optional>, <dtml-sqlvar choice3 type=string optional>, <dtml-sqlvar choice4 type=string optional> ) Arguments are: userid datetime course name core1 core2 core3 core4 core5 choice1 choice2 choice3 choice4 Note: Choice1-4 are checkboxes and every other item is a textbox. Please help - Its doing my head in! Cheers and all the best Phil

2 1