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

ISQL issues warning: "Bad debug info format" when connect to database with stored function after it's restoring [CORE4480] #4800

Closed
firebird-automations opened this issue Jul 2, 2014 · 4 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

1. Create new database and run the following DDL:

set term ^;
create or alter function fn_a returns varchar(10) as
begin
return 'tratata';
end
^
create or alter procedure sp_a as
declare s varchar(10);
begin
s=fn_a();
end
^
set term ;^
commit;
QUIT;

2. Create .fbk from this database and restore it (e.g. into: tmptest_bad_debug_info.restored.fdb ) .

3. Make connect to restored database:

$ /opt/fb30trnk/bin/isql /var/db/fb30/tmptest_bad_debug_info.restored.fdb
Database: /var/db/fb30/tmptest_bad_debug_info.restored.fdb
SQL> execute procedure sp_a;
Bad debug info format

PS. Reproduced on:
LI-T3.0.0.31204
WI-T3.0.0.31202

Commits: 306c404 FirebirdSQL/fbt-repository@bee6da8

====== Test Details ======

1) Restoring in WI-T3.0.0.30809 finishes with:
gbak: WARNING:function FN_A is not defined
gbak: WARNING: module name or entrypoint could not be found
gbak: WARNING:function FN_A is not defined
gbak: WARNING: module name or entrypoint could not be found

2) Attempt `execute procedure sp_a;` - leads to:
Statement failed, SQLSTATE = 39000
invalid request BLR at offset 29
-function FN_A is not defined
-module name or entrypoint could not be found
-Error while parsing procedure SP_A's BLR

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

Test Details: 1) Restoring in WI-T3.0.0.30809 finishes with:
gbak: WARNING:function FN_A is not defined
gbak: WARNING: module name or entrypoint could not be found
gbak: WARNING:function FN_A is not defined
gbak: WARNING: module name or entrypoint could not be found

2) Attempt `execute procedure sp_a;` - leads to:
Statement failed, SQLSTATE = 39000
invalid request BLR at offset 29
-function FN_A is not defined
-module name or entrypoint could not be found
-Error while parsing procedure SP_A's BLR

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

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