Problem Packing Zope Database
Oh Nooo!! I am in the process of creating a Zope based web site. I just now encountered a problem where if I "Pack" my database from "Database Management at /Control_Panel / Database", I cannot restart the database. The error message that I receive is as follows: I can restore a relatively recent copy of the DB and restart it, but as soon as I pack it, it gets hosed again. I guess that's the last time I pack my database without first backing it up. But who wants a db that they can't pack. Bummer!!!! Do I start over with Zope again or do I change my server engine???? This was going so well :-( Running Zope-2.1.2 on RedHat 6.1. ________________________________________ [root@www5 Zope-2.1.2-linux2-x86]# ./stop [root@www5 Zope-2.1.2-linux2-x86]# ./start [root@www5 Zope-2.1.2-linux2-x86]# Traceback (innermost last): File "/opt/zope/Zope-2.1.2-linux2-x86/z2.py", line 436, in ? exec "import "+MODULE in {} File "<string>", line 1, in ? File "/opt/zope/Zope-2.1.2-linux2-x86/lib/python/Zope/__init__.py", line 130, in ? OFS.Application.initialize(c) File "/opt/zope/Zope-2.1.2-linux2-x86/lib/python/OFS/Application.py", line 306 , in initialize app.Control_Panel.initialize_cache() File "/opt/zope/Zope-2.1.2-linux2-x86/lib/python/ZODB/Connection.py", line 391 , in setstate p, serial = self._storage.load(oid, self._version) File "/opt/zope/Zope-2.1.2-linux2-x86/lib/python/ZODB/FileStorage.py", line 58 4, in load try: return self._load(oid, version, self._index, self._file) File "/opt/zope/Zope-2.1.2-linux2-x86/lib/python/ZODB/FileStorage.py", line 56 0, in _load pos=_index[oid] KeyError: [root@www5 Zope-2.1.2-linux2-x86]# Thanks in advance for any help provided. -Mark
"Shaw, Mark" wrote:
Oh Nooo!!
I am in the process of creating a Zope based web site. I just now encountered a problem where if I "Pack" my database from "Database Management at /Control_Panel / Database", I cannot restart the database. The error message that I receive is as follows:
I can restore a relatively recent copy of the DB and restart it, but as soon as I pack it, it gets hosed again. I guess that's the last time I pack my database without first backing it up. But who wants a db that they can't pack. Bummer!!!!
Note that when you pack your database, it keeps the old database around in Data.fs.old.
Do I start over with Zope again or do I change my server engine???? This was going so well :-(
Hey, you have your database, so why start over. You just can't pack until we resolve this problem. Please send me (via private mail) your database file so I can look into this problem. If the file is too big to mail, then put it up somewhere that I can FTP it. Don't forget to gzip or zip it. Jim -- Jim Fulton mailto:jim@digicool.com Python Powered! Technical Director (888) 344-4332 http://www.python.org Digital Creations http://www.digicool.com http://www.zope.org Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats.
"Shaw, Mark" wrote:
Oh Nooo!!
I am in the process of creating a Zope based web site. I just now encountered a problem where if I "Pack" my database from "Database Management at /Control_Panel / Database", I cannot restart the database. The error message that I receive is as follows:
I can restore a relatively recent copy of the DB and restart it, but as soon as I pack it, it gets hosed again. I guess that's the last time I pack my database without first backing it up. But who wants a db that they can't pack. Bummer!!!!
Do I start over with Zope again or do I change my server engine???? This was going so well :-(
Running Zope-2.1.2 on RedHat 6.1.
________________________________________
[root@www5 Zope-2.1.2-linux2-x86]# ./stop [root@www5 Zope-2.1.2-linux2-x86]# ./start [root@www5 Zope-2.1.2-linux2-x86]# Traceback (innermost last): File "/opt/zope/Zope-2.1.2-linux2-x86/z2.py", line 436, in ? exec "import "+MODULE in {} File "<string>", line 1, in ? File "/opt/zope/Zope-2.1.2-linux2-x86/lib/python/Zope/__init__.py", line 130, in ? OFS.Application.initialize(c) File "/opt/zope/Zope-2.1.2-linux2-x86/lib/python/OFS/Application.py", line 306 , in initialize app.Control_Panel.initialize_cache() File "/opt/zope/Zope-2.1.2-linux2-x86/lib/python/ZODB/Connection.py", line 391 , in setstate p, serial = self._storage.load(oid, self._version) File "/opt/zope/Zope-2.1.2-linux2-x86/lib/python/ZODB/FileStorage.py", line 58 4, in load try: return self._load(oid, version, self._index, self._file) File "/opt/zope/Zope-2.1.2-linux2-x86/lib/python/ZODB/FileStorage.py", line 56 0, in _load pos=_index[oid] KeyError:
[root@www5 Zope-2.1.2-linux2-x86]#
Thanks in advance for any help provided.
-Mark
Just to add: I'm running Zope 2.1.2 on RedHat 6.0 and gets the same error :-( I started using the database with one the last betas before 2.0.0 (b3 if I remember correctly) and has been upgraded with most releases. A few packs with different time threshold made my Data.fs go from 11MB to around 350KB. Most my site was gone totally and it wouldn't restart. Fortunately I had an good backup from the night before. <CUT> -- Best regards / Mvh., Steen Suder, sysadm kollegie6400.dk -|- OpenSource --- Sign of the time Scan-Aqua ADVARSEL WARNING http://www.uk.k64.dk/sfs/Scan-Aqua/
Steen Suder wrote:
"Shaw, Mark" wrote:
Oh Nooo!!
I am in the process of creating a Zope based web site. I just now encountered a problem where if I "Pack" my database from "Database Management at /Control_Panel / Database", I cannot restart the database. The error message that I receive is as follows:
I can restore a relatively recent copy of the DB and restart it, but as soon as I pack it, it gets hosed again. I guess that's the last time I pack my database without first backing it up. But who wants a db that they can't pack. Bummer!!!!
Do I start over with Zope again or do I change my server engine???? This was going so well :-(
Running Zope-2.1.2 on RedHat 6.1.
________________________________________
[root@www5 Zope-2.1.2-linux2-x86]# ./stop [root@www5 Zope-2.1.2-linux2-x86]# ./start [root@www5 Zope-2.1.2-linux2-x86]# Traceback (innermost last): File "/opt/zope/Zope-2.1.2-linux2-x86/z2.py", line 436, in ? exec "import "+MODULE in {} File "<string>", line 1, in ? File "/opt/zope/Zope-2.1.2-linux2-x86/lib/python/Zope/__init__.py", line 130, in ? OFS.Application.initialize(c) File "/opt/zope/Zope-2.1.2-linux2-x86/lib/python/OFS/Application.py", line 306 , in initialize app.Control_Panel.initialize_cache() File "/opt/zope/Zope-2.1.2-linux2-x86/lib/python/ZODB/Connection.py", line 391 , in setstate p, serial = self._storage.load(oid, self._version) File "/opt/zope/Zope-2.1.2-linux2-x86/lib/python/ZODB/FileStorage.py", line 58 4, in load try: return self._load(oid, version, self._index, self._file) File "/opt/zope/Zope-2.1.2-linux2-x86/lib/python/ZODB/FileStorage.py", line 56 0, in _load pos=_index[oid] KeyError:
[root@www5 Zope-2.1.2-linux2-x86]#
Thanks in advance for any help provided.
-Mark
Just to add:
I'm running Zope 2.1.2 on RedHat 6.0 and gets the same error :-( I started using the database with one the last betas before 2.0.0 (b3 if I remember correctly) and has been upgraded with most releases.
A few packs with different time threshold made my Data.fs go from 11MB to around 350KB. Most my site was gone totally and it wouldn't restart.
Fortunately I had an good backup from the night before.
I can confirm the same experience w/ RH6.1 & Zope2.1.1 (Data.fs truncated) Fortunately `pack' makes a copy before doing stupid things so you can get the same state before packing. -- CIMPOESU Teodor, Web Programmer @ DIGICOM S.A. Bucharest, Romania @ Internet, site development @ teo@digiro.net , +(401)-330.47.28 official home page ~ http://www.digiro.net/ Internet web page ~ http://internet.digiro.net/
participants (4)
-
Jim Fulton -
Shaw, Mark -
Steen Suder -
Teodor Cimpoesu