Backing up Zope's database?
Hi there, We're running Zope on an NT server here and the backup system (Arcserve) apparently gives an error when it tries to backup Zope's 'var' directory. I would like to have this succeed (and end up with a non corrupted database, of course :), so here are some questions: * is this perhaps fixed by Zope 1.10? I read something about Zope 1.9 not doing proper file locking on NT yet, so there is some difference here. * Is copying a database while Zope is running a good strategy? (probably not) * What other options are there? For instance, NT seems to be able to copy the var dir just fine, so perhaps a copy could be made that Arcserve could backup. Still, that database would be backuped while Zope is running, so perhaps this isn't a good idea. Thanks in advance, Martijn
On 24 Feb 99, at 11:21, Martijn Faassen wrote: I do a manage_ExportHack from the root folder once a day. This produces an export.bbe file which is essentially the same thing as your database (only it is already compressed). Now, if I could get that to be automated.. Perhaps in ZServer.. Interesting thought..
We're running Zope on an NT server here and the backup system (Arcserve) apparently gives an error when it tries to backup Zope's 'var' directory. I would like to have this succeed (and end up with a non corrupted database, of course :), so here are some questions:
* is this perhaps fixed by Zope 1.10? I read something about Zope 1.9 not doing proper file locking on NT yet, so there is some difference here.
* Is copying a database while Zope is running a good strategy? (probably not)
* What other options are there? For instance, NT seems to be able to copy the var dir just fine, so perhaps a copy could be made that Arcserve could backup. Still, that database would be backuped while Zope is running, so perhaps this isn't a good idea.
Thanks in advance,
Martijn
_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope
Brad Clements, bkc@murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com ICQ: 14856937
Martijn Faassen wrote:
Hi there,
We're running Zope on an NT server here and the backup system (Arcserve) apparently gives an error when it tries to backup Zope's 'var' directory.
What is the error?
I would like to have this succeed (and end up with a non corrupted database, of course :), so here are some questions:
* is this perhaps fixed by Zope 1.10?
Without knowing the error, it's hard to say. :)
I read something about Zope 1.9 not doing proper file locking on NT yet, so there is some difference here.
Right. Zope 1.9 does not lock the file on NT. Zope 1.10 does. I don't think that this should interfere with backing the file up. It doesn't interfere with copying.
* Is copying a database while Zope is running a good strategy? (probably not)
In 1.10 and later, yes. If the database is being written while the file is being copied, then the Zope may discard the last transaction when reading the copy, if the last record is incomplete. Zope 1.9 reported a corrupted database if the last record was incomplete.
* What other options are there? For instance, NT seems to be able to copy the var dir just fine, so perhaps a copy could be made that Arcserve could backup. Still, that database would be backuped while Zope is running, so perhaps this isn't a good idea.
With Zope 1.10, that should be fine. Jim -- Jim Fulton mailto:jim@digicool.com Technical Director (888) 344-4332 Python Powered! Digital Creations http://www.digicool.com http://www.python.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.
Jim Fulton wrote:
Martijn Faassen wrote:
Hi there,
We're running Zope on an NT server here and the backup system (Arcserve) apparently gives an error when it tries to backup Zope's 'var' directory.
What is the error?
I'm not sure yet, but Ronald Offerman's post on arcserve is quite enlightening:
BTW, arcserve HATES doing backups of open files even when files are opened > O_RDONLY.
I suspect it's this then.
I would like to have this succeed (and end up with a non corrupted database, of course :), so here are some questions:
* is this perhaps fixed by Zope 1.10?
Without knowing the error, it's hard to say. :)
Well, one never knows. :) [snip]
* Is copying a database while Zope is running a good strategy? (probably not)
In 1.10 and later, yes. If the database is being written while the file is being copied, then the Zope may discard the last transaction when reading the copy, if the last record is incomplete. Zope 1.9 reported a corrupted database if the last record was incomplete.
Okay, I'll just make a copy then, and try to get arcserve to do a backup of that. As arcserve apparently has good scripting capabilities this shouldn't be a problem. Thanks! Martijn
participants (3)
-
Brad Clements -
Jim Fulton -
Martijn Faassen