26.05.2020 18:20, Vlad Khorsun wrote:
26.05.2020 18:11, Ivan Přenosil wrote:
When I give wrong backup file to NBACKUP.exe -INPLACE, error is reported as
expected:
NBACKUP -inplace -restore localhost/3333:Z:\export\TESTF2.FDB Z:\export\x05G.nbk
Invalid incremental backup file: Z:\export\x05G.nbk
NBACKUP -inplace -restore localhost/3333:Z:\export\TESTF2.FDB Z:\export\x05G.nbk
Invalid incremental backup file: Z:\export\x05G.nbk
But when I do the same using FB Services API (isc_action_svc_nrest,
isc_spb_options+isc_spb_nbk_inplace, ...)
then after the first error the database will remain locked, and all subsequent
attempts to work with it raise:
Statement failed, SQLSTATE = HY000
Error opening database file: Z:\EXPORT\TESTF2.FDB
-The process cannot access the file because it is being used by another
process
The FB server must be restarted to unlock the file.
(tested with Firebird-4.0.0.1963-0-Beta2 and snapshot Firebird-4.0.0.1999-0_x64)
Should be fixed now, see CORE-6913.
I also wanted to test it with FBSVCMGR.exe, but FBSVCMGR does not recognize switches isc_spb_options/isc_spb_nbk_inplace (neither
of -isc_spb_options, -spb_options, -options)
It works for me, try:
fbsvcmgr.exe localhost/3333:service_mgr action_nrest nbk_inplace dbname
Z:\export\TESTF2.FDB nbk_file Z:\export\x05G.nbk
Regards,
Vlad
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel