agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Portal object leak
Date: Fri, 12 Jan 2007 19:54:43 -0800
Message-ID: <45A85803.1070500@hyperstep.com> (raw)

I have a PL/Java trigger that leaks a large number of 
org.postgresql.pljava.internal.Portal objects. The leak occurs under 
PostgreSQL 8.1 with PL/Java 1.3.0 and under 8.2 with the version of 
PL/Java that is included with the Windows installer. I get the same 
results with multiple versions of Windows (XP and Server 2003) and with 
1.5 and 1.6 JVMs.

So far, my attempts to isolate the leak have been fruitless (the code 
path is about 500 lines). I can say that from a pure Java perspective, 
there is no obvious reason for the leak. Furthermore, the only 
references to the Portal objects are JNI global references so there is 
no chain of references from our code to these objects.

Does anyone know what could cause PL/Java to create Portal objects but 
not clean them up? At this point, I'm not even sure what I'm looking for 
and the only option I have left is to rebuild or comment out the code 
"one line at a time" until I can isolate the behavior.

I don't mind posting the code in question (it's a set of auditing 
triggers and supporting methods) but, as I mentioned, there's quite a 
bit of it.

Thanks,
-Ryan

view thread (6+ messages)  latest in thread

Message-ID: <45A85803.1070500@hyperstep.com>
Permalink:  ../45A85803.1070500@hyperstep.com/
Also on:    postgresql.org/message-id/45A85803.1070500@hyperstep.com

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] Portal object leak
  In-Reply-To: <45A85803.1070500@hyperstep.com>

* 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