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

gbak -r fails in restoring all stored procedures/functions in packages [CORE4126] #4454

Closed
firebird-automations opened this issue Jun 19, 2013 · 8 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Thomas Beckmann (thbeckmann)

I'm sorry to have no neat testcase for this one, but I've an 8MB database where the problem is reproduceable.

As soon as a particular package is added, restore fails with "procedure id xxx is not defined" (xxx increasing every time I drop and recreate the package). Without he package, restore works. Commenting out the procedure in the package before backup just leads to another procedure failiing.

Using another package, I had a similar behavior, but there, a particular function would fail to restore and even crash the server, until I changed return type from user defined domain to smallint (which would work in this case).

If there's someone to investigate this bug, I'm glad to provide my testcase - it's just not suitable for this list...

Thank you, Thomas

Commits: 169a645 FirebirdSQL/fbt-repository@55934c6

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

Please send test case to me <adrianosf at http://gmail.com>

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

I just committed the fix. Please test in the next snapshot.

It requires the package recreation to fix the generated BLR.

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Thomas Beckmann (thbeckmann)

Hi Adriano, it seems to work! Thank you, Thomas

@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: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully

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