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 in Firebird 3 on implicit transaction [DNET743] #685

Closed
firebird-issue-importer opened this issue Mar 22, 2017 · 4 comments
Closed

Comments

@firebird-issue-importer

Submitted by: Alexander Lipatov (diverdw)

Depends on CORE5416

Implicit transactions in Firebird 3 cause a massive memory leak on the server part.
It is detected only on Firebird 3.
If transaction is performed manually the memory leak is not happened.

Example:
var connection = new FbConnection(connectionString);
connection.Open();
while (true)
{
using (var cmd = connection.CreateCommand())
{
cmd.CommandText = "SELECT * FROM TABLE_NAME";
cmd.ExecuteNonQuery();
}
}

I fixed this issue as follows:
The calls isc_commit_transaction and isc_dsql_free_statement was swapped.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 24, 2017

Modified by: @cincuranet

status: Open [ 1 ] => In Progress [ 3 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 5, 2017

Commented by: @cincuranet

This behavior is caused by CORE5416.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 5, 2017

Modified by: @cincuranet

status: In Progress [ 3 ] => Closed [ 6 ]

resolution: Won't Fix [ 2 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 5, 2017

Modified by: @cincuranet

Link: This issue depends on CORE5416 [ CORE5416 ]

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