agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] ResultSetHandle and TupleDesc reference leak?
Date: Fri, 1 Feb 2008 02:27:26 -0500 (EST)
Message-ID: <Pine.BSO.4.64.0802010201430.26244@leary.csoft.net> (raw)
In-Reply-To: <E7B8DAEA-F046-4272-9C84-BBCB05BE373F@mcsnw.com>
References: <E7B8DAEA-F046-4272-9C84-BBCB05BE373F@mcsnw.com>



On Sat, 5 Jan 2008, Lucas Madar wrote:

> I have a program using ResultSetHandle and the first time a new session uses 
> the function, a warning pops up:
>
> WARNING:  TupleDesc reference leak: TupleDesc 0x750bcb0 (10307,-1) still 
> referenced
>

I've applied your fix for this.


> Also, I've run into an issue using setSavePoint()... after the function 
> ends and the savepoint has been released, the results returned in the 
> resultsethandle cannot be used in anything except a simple select. Using 
> them as a select into or inside another function fails, saying 'ERROR: 
> buffer xxx is not owned by resource owner TopTransaction.' If I don't 
> use savepoints, I don't run into this issue. My workaround has been to 
> wrap the java function in a plsql function and use commit/rollback 
> there.
>

I'm not so sure about this fix and I've left some further comments in the 
tracker.  I'll try and take a look at this next week, but with the 8.3 
server release coming out this weekend we've got to push the 1.4 pljava 
release out now.

Kris Jurka

view thread (3+ messages)

Message-ID: <Pine.BSO.4.64.0802010201430.26244@leary.csoft.net>
Permalink:  ../Pine.BSO.4.64.0802010201430.26244@leary.csoft.net/
Also on:    postgresql.org/message-id/Pine.BSO.4.64.0802010201430.26244@leary.csoft.net

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] ResultSetHandle and TupleDesc reference leak?
  In-Reply-To: <Pine.BSO.4.64.0802010201430.26244@leary.csoft.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox