Issue Details (XML | Word | Printable)

Key: CORE-6319
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: prenosil
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

NBACKUP locks db file on error

Created: 27/May/20 11:12 AM   Updated: 15/Jun/20 05:05 AM
Component/s: NBACKUP
Affects Version/s: 4.0 Beta 2
Fix Version/s: 3.0.6, 4.0 RC 1

QA Status: Done successfully


 Description  « Hide
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)

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun made changes - 27/May/20 11:12 AM
Field Original Value New Value
Assignee Vlad Khorsun [ hvlad ]
Vlad Khorsun made changes - 27/May/20 11:16 AM
Reporter Vlad Khorsun [ hvlad ] prenosil [ prenosil ]
Vlad Khorsun made changes - 11/Jun/20 09:50 AM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0.6 [ 10889 ]
Fix Version/s 4.0 RC 1 [ 10930 ]
Resolution Fixed [ 1 ]
Pavel Zotov made changes - 15/Jun/20 05:04 AM
Status Resolved [ 5 ] Resolved [ 5 ]
QA Status No test Done successfully
Pavel Zotov made changes - 15/Jun/20 05:05 AM
Status Resolved [ 5 ] Closed [ 6 ]