Saving the day: recovering lost objects - Jarn · Plone Solutions - 1 views
-
recovering lost objects
-
entire section of his site was missing
-
someone had deleted the object
- ...26 more annotations...
-
9 days earlier
-
Undo was no longer an option
-
Truncating the Data.fs (removing all transactions since, including the offending one)
-
undesirable
-
through RelStorage
-
time traveling: zc.beforestorage
-
small additional buildout configuration file
-
beforestorage.cfg
-
[buildout]extends = buildout.cfgeggs += zc.beforestorage ZODB3 zope.proxy[versions]ZODB3 = 3.8.1zope.proxy = 3.4.2[relstorage-patch]recipe = plone.recipe.commandcommand = cd ${buildout:eggs-directory}/ZODB3-3.8.1-py2.4-linux-i686.egg/ZODB curl -s http://svn.zope.de/zope.org/relstorage/tags/1.1c1/poll-invalidation-1-zodb-3-8-0.patch | patch -N -p0 cd ${buildout:directory}update-command = ${relstorage-patch:command}[instance]zope-conf-additional += enable-product-installation False
-
enable-product-installation
-
tells Zope not to try and write product information to the ZODB
-
because zc.beforestorage puts your ZODB in read-only mode
-
edit the zope.conf
-
<zodb_db main> # Main database cache-size 650000%import zc.beforestorage%import relstorage <before> before 2008-12-08T10:29:03 <relstorage> <oracle> dsn RELSTORAGE_DSN password xxxxxxxxx user xxxxxxxx </oracle> </relstorage> </before> mount-point /</zodb_db>
-
impossible as the site stores
-
<before> before 2008-12-08T10:29:03 <relstorage> <oracle> dsn RELSTORAGE_DSN password xxxxxxxxx user xxxxxxxx </oracle> </relstorage> </before>
-
when you start the instance, you are in the past
-
found the lost object
-
Export/Import
-
save the export on the server
-
buildout with your regular buildout file
-
restart
-
import the .zexp
-
reindex the imported content
-
related data that lives outside of the object itself is gone
-
Martijn Pieters