>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