After using succesfully zope for some time I decided to cut a bit the database size. So I went to Control Panel/Database and clicked "Pack" for objects older than 10 days. At first everything seemed to work (I returned to the management screen seeing new - smaller - Data.fs size), but when I tried to preview my pages, terrible things happened - most pages turned to be not available, instead of seeing them I saw zope errors with useless descriptions like 'Zope error: error' etc (restarting browser and zope did not helped). Happily, during the process, the Data.fs.old file was created - stopping Zope, removing all Data.fs.<sth> and overwritting Data.fs with Data.fs.old returned zope instance to the previous state. So I will not click 'Pack' anymore. Has anyone notified similar problems? What could be going on? I use binary zope 2.2.0 distribution for Linux. The database has been created and always used with this distribution (just a few weeks ago) and has never been packed. The time on the machine seem to be correct (although IIRC there happened a moment a few weeks ago when it was for the short time incorrect). I use some custom ZClasses installed as a product developed within 'this' Control Panel/Products. By the way: to decrease database size I consider: - creating new Data.fs served via another (temporary) Zope instance (via just copying Data.fs.in) - exporting everything important from my current instance - importing those files into new instance - copying new Data.fs over the old one (of course each Data.fs copying is performed while both Zope's are shut down). Will it work as expected? Will I loose anything apart bobobase_modification_time? -- Serwis dla programistów z kącikiem mieszkaniowym: http://www.mk.w.pl | | You have the right to change your mind, to substitute functionality, | and to change priorities. (Ken Beck's Third Customer Right) |
Marcin Kasperski wrote:
After using succesfully zope for some time I decided to cut a bit the database size. So I went to Control Panel/Database and clicked "Pack" for objects older than 10 days. At first everything seemed to work (I returned to the management screen seeing new - smaller - Data.fs size), but when I tried to preview my pages, terrible things happened - most pages turned to be not available, instead of seeing them I saw zope errors with useless descriptions like 'Zope error: error' etc (restarting browser and zope did not helped).
Happily, during the process, the Data.fs.old file was created - stopping Zope, removing all Data.fs.<sth> and overwritting Data.fs with Data.fs.old returned zope instance to the previous state. So I will not click 'Pack' anymore.
Has anyone notified similar problems? What could be going on?
I looked into this and reproduced the problem you had with the data file you sent to Brian. Thanks. Sadly, the bug was a bug that was fixed in Zope 2.1, but which didn't make it into the main CVS trunck and wasn't included in 2.2. :( The fix will be included in Zope 2.2.1. The bug happens when you pack the database and there were some undone transactions after the pack time and before some version commits. The fix for this has been reapplied to the 2.2 branch and the main trunk and I've verified that it fixes the problem you saw. 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.
participants (2)
-
Jim Fulton -
Marcin Kasperski