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

Wrong backup mode when using "alter database add difference file" [CORE2876] #3260

Closed
firebird-automations opened this issue Feb 19, 2010 · 5 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: prenosil (prenosil)

Try to specify illegal filename or nonexistent directory

====================
alter database add difference file '****';

alter database begin backup;

Statement failed, SQLCODE = -902
[335544344] I/O error during "CreateFile (create)" operation for file "****"
[335544733] -Error while trying to create file
[14696098] -(Incorrect file name).

alter database end backup;

Statement failed, SQLCODE = -607
[335544351] unsuccessful metadata update
[335544382] -Database is not in the physical backup mode

alter database drop difference file;

Statement failed, SQLCODE = -607
[335544351] unsuccessful metadata update
[335544832] -Cannot change difference file name while database is in backup mode

====================

The engine is a bit confused whether it is in backup mode or not :)
The "drop difference file" will succeed only after disconnecting all connections.

Commits: 2519440 e955473

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Added a bit more 'intellectual' error handling.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 2.5 RC3 [ 10381 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

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