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

DDL operations fail after backup/restore [CORE3461] #3822

Closed
firebird-automations opened this issue May 5, 2011 · 8 comments
Closed

DDL operations fail after backup/restore [CORE3461] #3822

firebird-automations opened this issue May 5, 2011 · 8 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @samofatov

Attachments:
messup1.sql
messup2.sql
messup.cmd

Votes: 3

Certain DDL operations work correctly when performed on freshly created database, and fail after backup/restore cycle.

The reason for failure is that system generators used to produce field names do not preserve their values during backup/restore cycle.
After backup/restore generated field names are no longer unique. Scripts to reproduce are attached.

Commits: a01baa2 136463b 843dfc2 07c631f

@firebird-automations
Copy link
Collaborator Author

Commented by: @samofatov

Test case. Run messup.cmd to see the failure:
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-cannot delete
-DOMAIN RDB$1
-there are 1 dependencies
After line 17 in file messup2.sql

If you remove backup/restore step from the script it will finish without errors

@firebird-automations
Copy link
Collaborator Author

Modified by: @samofatov

Attachment: messup1.sql [ 11944 ]

Attachment: messup2.sql [ 11945 ]

Attachment: messup.cmd [ 11946 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

Version: 2.1.4 [ 10361 ]

Version: 2.0.6 [ 10303 ]

Version: 3.0 Initial [ 10301 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Existing solution can't be backported directly to B2_0.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.1 [ 10333 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 2.1.5 [ 10420 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

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