Subject RE: [firebird-support] FBKs being left open
Author Alan McDonald
> Hi All,
>
> I have an application which is running in over 800 restaurants and
> 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.
>
> This doesn't always happen but it's generating a large number of
> 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?
>
> Thanks,
> Steve

sounds to me like your backup process is never completing - I'd be looking
at this code first.
Then, and anyway, I'd probably switch to a backup service which backs up to
unique backup filenames - there are plenty around
Alan