Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

NBACKUP locks db file on error [CORE6319] #6560

Closed
firebird-automations opened this issue May 27, 2020 · 6 comments
Closed

NBACKUP locks db file on error [CORE6319] #6560

firebird-automations opened this issue May 27, 2020 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: prenosil (prenosil)

Jira_subtask_outward CORE6498

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)

Commits: fdf7580 c58e0ea

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

The ticker was created based on the message of Ivan Přenosil in fb-devel from 26.05.2020

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

reporter: Vlad Khorsun [ hvlad ] => prenosil [ prenosil ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0.6 [ 10889 ]

Fix Version: 4.0 RC 1 [ 10930 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants