Steve,

I wonder if the utility called "WhoLockMe" can help you to pin point
which process kept you file open. You can find it by searching
"WhoLockMe".

Give it a try. At least it will tell you whether the fbk file was
locked by the back up process, by the virus checker or by your
application. I used this little utility every now and then to speed
up problem diagnostic.

jml

--- In firebird-support@yahoogroups.com, "Rick Debay" <rdebay@...> wrote:
>
> Perhaps a background virus checker is checking the file. Or Windows
> left the file handle open. I've had that problem with Excel, where even
> killing the process leaves the "file locked by another process."
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Steve Harp
> Sent: Tuesday, April 18, 2006 6:36 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: FBKs being left open
>
> --- In firebird-support@yahoogroups.com, Helen Borrie <helebor@>
> wrote:
> >
> > At 12:55 AM 19/04/2006, you wrote:
> > >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?
> >
> > Are there specific deployment conditions at the problem sites, where
> > you are trying to run the backup from the same application space as
> > the main app and/or the main app is using a Windows local connection?
>
> I'm sorry Helen. I don't understand your question. This is basically a
> single user application and everything is on the local machine. The
> Firebird service runs locally and the application is local.
> Transactions in the application are set to AutoCommit. Out of the
> 800+ locations running this application, we're seeing about 10-15
> support calls a week related to this problem. The calls appear to be
> random and I can't tie it to any one OS or customer's setup. However,
> the culprit is always a FBK that is open when we try to delete it or
> rename it.
>
> Steve
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>