>From time to time handle to restore of security3.fdb backup is not released by
>firebird.exe (using service_mgr)
---------------------------------------------------------------------------------------------------------------
Key: CORE-6082
URL: http://tracker.firebirdsql.org/browse/CORE-6082
Project: Firebird Core
Issue Type: Bug
Components: Engine, GBAK, SVCMGR
Affects Versions: 3.0.5
Environment: Windows 2008R2
WI-V3.0.5.33100 Firebird 3.0
Reporter: Karol Bieniaszewski
Attachments: FirebirdHandle.png
We have automatic backup and restore process of many databases including
security3.fdb
But from time to time - and only for "security3.fdb.restored", file handle is
not released by firebird.exe and cannot be deleted.
gbak: time delta
gbak: 0.000 0.000 opened file D:\backup\security3.bak
gbak: ERROR:database D:\restore\security3.fdb.restored already exists. To
replace it, use the -REP switch
gbak: ERROR: Exiting before completion due to errors
gbak:Exiting before completion due to errors
the process looks like this:
1. We try to delete previous files (we do not check if this process is
succesfull or not)
2. every night we run backup to "security3.bak"
we validate the succesfull by "looking" into log file for text "closing file,
committing, and finishing" if not present, we write log and also send email to
admins
3. next we run restore process and this is also validated by log like in point
2.
all was ok and next day process failed on steep 3 as in step 1
security3.fdb.restored was not deleted.
We try to delete it but it is looked by the firebird.exe and never released -
we have waited few days.
restore command looks like
"%FB_DIR%\gbak" -service 127.0.0.1:service_mgr -c -v -BUFFERS 131072
-STATISTICS TD -user SYSDBA -password XXXX %FB_BACKUP%\security3.bak
%FB_RESTORE%\security3.fdb.restored
This situation have occured 3 times - and now we report this here.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
