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-issue-importer opened this issue May 5, 2011 · 8 comments
Closed

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

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

Comments

@firebird-issue-importer
Copy link

@firebird-issue-importer firebird-issue-importer commented May 5, 2011

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

@firebird-issue-importer firebird-issue-importer commented May 5, 2011

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

@firebird-issue-importer firebird-issue-importer commented May 5, 2011

Modified by: @samofatov

Attachment: messup1.sql [ 11944 ]

Attachment: messup2.sql [ 11945 ]

Attachment: messup.cmd [ 11946 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 5, 2011

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 1, 2011

Modified by: @AlexPeshkoff

Version: 2.1.4 [ 10361 ]

Version: 2.0.6 [ 10303 ]

Version: 3.0 Initial [ 10301 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 1, 2011

Commented by: @AlexPeshkoff

Existing solution can't be backported directly to B2_0.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 1, 2011

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

@firebird-issue-importer firebird-issue-importer commented Apr 23, 2013

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 29, 2015

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