memory leak when inserting using ODBC connector #152

Closed
aleks-f opened this Issue Apr 12, 2013 · 6 comments

Comments

Projects
None yet
3 participants

@ghost ghost assigned aleks-f Apr 12, 2013

@giovani-milanez

This comment has been minimized.

Show comment
Hide comment
@giovani-milanez

giovani-milanez Apr 15, 2013

The leak happens also when updating

The leak happens also when updating

@aleks-f

This comment has been minimized.

Show comment
Hide comment
@aleks-f

aleks-f Apr 22, 2013

Member

I tracked this down to the SQLDescribeColW call in Unicode_Win32.cpp. With PostgreSQL 9.01.01.00 ODBC driver; process memory usage increases by 4k exactly on every sixth call to this ODBC API and is never released.

If anyone can shed some light on this, speak up. I was not able to find a leak in Poco::Data::ODBC.

Member

aleks-f commented Apr 22, 2013

I tracked this down to the SQLDescribeColW call in Unicode_Win32.cpp. With PostgreSQL 9.01.01.00 ODBC driver; process memory usage increases by 4k exactly on every sixth call to this ODBC API and is never released.

If anyone can shed some light on this, speak up. I was not able to find a leak in Poco::Data::ODBC.

@aleks-f

This comment has been minimized.

Show comment
Hide comment
@aleks-f

aleks-f Apr 26, 2013

Member

Discussion continued in the forum.

Member

aleks-f commented Apr 26, 2013

Discussion continued in the forum.

@aleks-f

This comment has been minimized.

Show comment
Hide comment
@aleks-f

aleks-f Apr 27, 2013

Member

Tested SQL Server and Oracle drivers on Windows, no leaks.

Member

aleks-f commented Apr 27, 2013

Tested SQL Server and Oracle drivers on Windows, no leaks.

@aleks-f

This comment has been minimized.

Show comment
Hide comment
@aleks-f

aleks-f Jun 7, 2013

Member

To the best I was able to determine, this was PostgreSQL driver leak. Closing.

Member

aleks-f commented Jun 7, 2013

To the best I was able to determine, this was PostgreSQL driver leak. Closing.

@krishnavivek

This comment has been minimized.

Show comment
Hide comment
@krishnavivek

krishnavivek Sep 26, 2015

As you mentioned above, the issue is in psqlodbc driver leak.
Following is the link for the issue:
http://www.postgresql.org/message-id/5143041A.20605@vmware.com

The fix is present in latest releases.
I have used psqlodbc-09.03.0400.tar.gz. Memory leaks are no longer detected.

Thank You

As you mentioned above, the issue is in psqlodbc driver leak.
Following is the link for the issue:
http://www.postgresql.org/message-id/5143041A.20605@vmware.com

The fix is present in latest releases.
I have used psqlodbc-09.03.0400.tar.gz. Memory leaks are no longer detected.

Thank You

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