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

Memory leak when preparing Execute Block which uses domains [CORE4145] #4472

Closed
firebird-automations opened this issue Jul 23, 2013 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: prenosil (prenosil)

Whenever you prepare any of these statements
EXECUTE BLOCK (A RDB$FILE_NAME=?) AS BEGIN END
EXECUTE BLOCK AS DECLARE A RDB$FILE_NAME; BEGIN END
EXECUTE BLOCK AS DECLARE A INTEGER; DECLARE B VARCHAR(255); BEGIN B=CAST(A AS RDB$FILE_NAME); END
you will notice memory leak (e.g. in Windows Task Manager).
(in ISQL it is enough to "execute" the statements with SET PLANONLY ON)

The same statements with type names instead of domain names are o.k., e.g.
EXECUTE BLOCK (A INTEGER=?) AS BEGIN END

Commits: c62e9cf 0b51caa FirebirdSQL/fbt-repository@3d4420a FirebirdSQL/fbt-repository@eaeb34e

@firebird-automations
Copy link
Collaborator Author

Modified by: prenosil (prenosil)

Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: prenosil (prenosil)

Just tested latest Firebird-3.0.0.30653 and its still there.
Also tested Execute Procedure instead of Execute Block, and it does not have the problem.
Sholuld I remove all domains from all my execute blocks, or is there chance to fix it soon ? (although I have most commands "permanently" prepared, those that are not easily cause memory leak of several GB during just couple of hours.)

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Version: 2.5.3 [ 10461 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.3 [ 10461 ]

Fix Version: 3.0 Alpha 2 [ 10560 ]

@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

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