BUG #4578: Not releaseing memory from PQmakeEmptyPGresult when calling PQisBusy - Mailing list pgsql-bugs

From Sven Almgren
Subject BUG #4578: Not releaseing memory from PQmakeEmptyPGresult when calling PQisBusy
Date
Msg-id 200812121353.mBCDr4FB008596@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4578: Not releaseing memory from PQmakeEmptyPGresult when calling PQisBusy  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      4578
Logged by:          Sven Almgren
Email address:      sven@blocket.se
PostgreSQL version: 8.3.5
Operating system:   CentOS release 5.2 (Final)
Description:        Not releaseing memory from PQmakeEmptyPGresult when
calling PQisBusy
Details:

==14976== 4,480 (384 direct, 4,096 indirect) bytes in 2 blocks are
definitely lost in loss record 19 of 55
==14976==    at 0x4A05809: malloc (vg_replace_malloc.c:149)
==14976==    by 0x38FC80E194: PQmakeEmptyPGresult (in
/usr/lib64/libpq.so.5.1)
==14976==    by 0x38FC814BEC: (within /usr/lib64/libpq.so.5.1)
==14976==    by 0x38FC816031: (within /usr/lib64/libpq.so.5.1)
==14976==    by 0x38FC80D5AF: PQisBusy (in /usr/lib64/libpq.so.5.1)

Without specifying too much about our system we're running an asynchronous
system which will only process SQL results when it won't block, so we're
running PQisBusy alot and we think that it has something todo with some
funktion not checking if conn->result is already set, but we're not sure..

# rpm -qa|grep postgres
postgresql-libs-8.3.5-1PGDG.rhel5
postgresql-server-8.3.5-1PGDG.rhel5
postgresql-devel-8.3.5-1PGDG.rhel5
postgresql-8.3.5-1PGDG.rhel5
compat-postgresql-libs-4-2PGDG.rhel5_x86_64

pgsql-bugs by date:

Previous
From: Michael Meskes
Date:
Subject: Re: ECPG Preprocessor throws Syntax Error [Devel Repository]
Next
From: Tom Lane
Date:
Subject: Re: BUG #4578: Not releaseing memory from PQmakeEmptyPGresult when calling PQisBusy