Subject | RE: [firebird-support] FBKs being left open |
---|---|
Author | Graeme Edwards |
Post date | 2006-04-18T20:41:19Z |
>I have an application which is running in over 800 restaurants andNot quite sure why you need to constantly restore the backup files, apart
>uses Firebird v1.52. During backups, I use a TIBOBackupService to
>create an fbk and this fbk is stored in a zip file.
>When restoring, the first step is to delete any fbk files that exist
>before trying to restore the zip. Sometimes, this deletion fails
>because the fbk is open. If I didn't delete the file, the restore of
>the zip would fail for the same reason. The only solution we've found
>when this happens is to restart the Firebird Guardian. However, in
>the restaurants, the users don't have adequate rights to restart a
>service.
from perhaps "compacting"
the database.
If you have an application which controls the unzipping process, then you
could try extracting it to
an fbk which does not exist. Assuming you have a Delphi application using
some kind of zip components
you should be able to generate an extract filename based on whether the
filename generated currently
exists. This would at least get the apparent problem you have with open fbk
files, but wouldn't solve
the problem of why they were being left open.
>This doesn't always happen but it's generating a large number ofGraeme Edwards
>support calls. Hense, my customer is blaming Firebird and me for
>using Firebird.
>Has anyone else seen this problem? If so, how did you deal with it?
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
_____
YAHOO! GROUPS LINKS
* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.
* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.
_____
[Non-text portions of this message have been removed]