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

Database cannot be unlocked (nbackup) if located on a raw device [CORE5264] #5543

Closed
firebird-issue-importer opened this issue Jun 7, 2016 · 9 comments

Comments

@firebird-issue-importer
Copy link

firebird-issue-importer commented Jun 7, 2016

Submitted by: Sascha Michel (datiscum1)

Alias for my db in databases.conf
KMR-DB = /dev/DS1/DB-KM

/dev/DS1/DB-KM is a ZFS block device

I have a delta file set with:
alter database add difference file '/tmp/KMR-DB.delta'

Then I set the lock with:
/opt/firebird/bin/nbackup -S -T -D off -U sysdba -P 'master' -L KMR-DB
1061504

The File i set is used.

Now I want to release the lock with:
/opt/firebird/bin/nbackup -U sysdba -P 'master' -T -N KMR-DB

No error is reported even in firebird.log File.

If I want to put a lock again, there is an error message.
/opt/firebird/bin/nbackup -S -T -D off -U sysdba -P 'master' -L KMR-DB
[
PROBLEM ON "begin backup".
unsuccessful metadata update
-ALTER DATABASE failed
-Database is already in the physical backup mode
SQLCODE:-607
]

The delta File is in use.
Since the N switch is not working, there is no way to apply the changes to the DB.

With a database file it works as it should.

Commits: 1a4b7eb bbe640a 8709dab 97afe43

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 7, 2016

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 7, 2016

Commented by: @ibaseru

well, since DE corrected me, I had a blind eye, mixed -U and -N, corrected my comment, so, only one thing left:

-D off - it is used only for -B n. It is nonsense for lock/unlock options.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 7, 2016

Commented by: @dyemanov

Dmitry, -N = uNlock, -U = User ;-)

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 7, 2016

Commented by: @AlexPeshkoff

To be precise - we should allow that switch only for -B, yes?

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 16, 2016

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 3.0.1 [ 10730 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 16, 2016

Modified by: @AlexPeshkoff

Version: 4.0 Initial [ 10621 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 8, 2016

Modified by: @dyemanov

summary: To unlock a raw device DB is not working. => Database cannot be unlocked (nbackup) if located on a raw device

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 9, 2016

Modified by: @pavel-zotov

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

QA Status: No test => Cannot be tested

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 9, 2016

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