[Zope] Corrupt ZODB on W2k

Tom Cameron tom@mooball.com
Sat, 12 Jan 2002 10:24:15 +1000


They are packing manually from the ZMI, so I dont think that is it, but you
have just reminded me that they are also backing up the ZODB nightly from a
batch script, by copying the ZODB to another location.

Perhaps this could be the problem - a conflict at the time of reading??.

Tom

=> -----Original Message-----
=> From: Chris Kratz [mailto:chris.kratz@vistashare.com]
=> Sent: Saturday, 12 January 2002 9:57 AM
=> To: tom@mooball.com
=> Subject: Re: [Zope] Corrupt ZODB on W2k
=>
=>
=> Hello Tom,
=>
=> How are you packing your database?  We had a corruption problem
=> on a regular
=> basis that happened because I had automated the packing of our
=> database by
=> using client.py in a nightly script.  I removed this call from
=> nightly script
=> and have been packing by hand since and have not had any
=> corruption problems.
=>   After having tracked it down, I was able to duplicate the problem very
=> easily by doing the pack from the python script on a backed up
=> known good
=> version of the zope file.  The next time the pack ran from a script, for
=> whatever reason, it corupted the database every time.  If I
=> packed manually
=> (from the web interface) on the backup, it ran without incident and the
=> database was not corrupted.  Our corruption tended to be folders
=> that became
=> inaccessible from the zmi due to key not found errors.
=>
=> I don't know if this is applicable to your problem or not as our
=> platforms
=> are different and the symptoms are not exactly the same, but I thought I
=> would through it in for good measure.  It might give you a good place to
=> start looking.
=>
=> Good luck,
=>
=> -Chris
=>
=> On Friday 11 January 2002 05:20 pm, you wrote:
=> > A client of mine insisted in running Zope on Win2k, so I installed Zope
=> > 2.3.4 (some time ago) on their server and also a few
=> products/sites I built
=> > for them.
=> >
=> > The machine has been running now for about 8 months. They don't change
=> > much, but it is relatively heavily loaded. They pack the ZODB
=> monthly and
=> > backup regularly.
=> >
=> > On two occasions in the past 8 months, we have noticed very peculiar
=> > permissions problems. Several months ago, all of a sudden,
=> several of the
=> > users could no longer access the ZMI. Also sections of the
=> site returned
=> > permissions errors for no reason. Sometimes specific DTML
=> methods simply
=> > refused to display with permissions errors.
=> >
=> > After many hours of investigating we found no possible logic to this. I
=> > then exported the entire ZODB and re-imported it all into a
=> fresh ZODB. All
=> > was fine again.
=> >
=> > Now, several months later the same problem has re-appeared.
=> Again they get
=> > weird permissions errors on certain objects, but no real logic
=> or pattern
=> > to the errors. Creating new users does not always work. Old users get
=> > locked out. Some DTML methods will not work.
=> >
=> > It looks very much like the ZODB simply gets corrupt over time.
=> >
=> > I can fix this by exporting-importing again, but I am
=> wondering if anybody
=> > else has any experience of a similar problem or solution?
=> >
=> > Tom
=> >
=> >
=> >
=> > _______________________________________________
=> > Zope maillist  -  Zope@zope.org
=> > http://lists.zope.org/mailman/listinfo/zope
=> > **   No cross posts or HTML encoding!  **
=> > (Related lists -
=> >  http://lists.zope.org/mailman/listinfo/zope-announce
=> >  http://lists.zope.org/mailman/listinfo/zope-dev )
=>
=> --
=> Chris Kratz
=> Systems Analyst/Programmer
=> VistaShare LLC
=> www.vistashare.com
=>