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-automations opened this issue Mar 22, 2017 · 4 comments
Closed

Comments

@firebird-automations
Copy link

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-automations
Copy link
Author

Modified by: @cincuranet

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

@firebird-automations
Copy link
Author

Commented by: @cincuranet

This behavior is caused by CORE5416.

@firebird-automations
Copy link
Author

Modified by: @cincuranet

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

resolution: Won't Fix [ 2 ]

@firebird-automations
Copy link
Author

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
Development

No branches or pull requests

2 participants