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-issue-importer opened this issue May 27, 2020 · 6 comments
Closed

NBACKUP locks db file on error [CORE6319] #6560

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

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

firebird-issue-importer commented May 27, 2020

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 27, 2020

Commented by: @hvlad

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 27, 2020

Modified by: @hvlad

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 11, 2020

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 15, 2020

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 15, 2020

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