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-issue-importer opened this issue Jul 23, 2013 · 7 comments

Comments

@firebird-issue-importer

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

@firebird-issue-importer firebird-issue-importer commented Aug 11, 2013

Modified by: prenosil (prenosil)

Version: 3.0 Alpha 1 [ 10331 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 18, 2013

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

@firebird-issue-importer firebird-issue-importer commented Sep 24, 2013

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 26, 2013

Modified by: @asfernandes

Version: 2.5.3 [ 10461 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 26, 2013

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

@firebird-issue-importer firebird-issue-importer commented Sep 22, 2015

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 18, 2016

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
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants