From: thomas at tada.se (Thomas Hallgren)
Date: Tue, 16 Jan 2007 20:57:33 +0100
Subject: [Pljava-dev] Portal object leak
In-Reply-To: <4508612D-5A18-4C25-B97A-3FF9DCCAD26B@hyperstep.com>
References: <45A85803.1070500@hyperstep.com>
	<4508612D-5A18-4C25-B97A-3FF9DCCAD26B@hyperstep.com>
Message-ID: <45AD2E2D.4080507@tada.se>

Hi Ryan,
Sorry for late reply. I find myself constantly tied up in other activities these days. If 
you have the time to create a patch for this I'd be happy to review it.

Kind Regards,
Thomas Hallgren



Ryan Holmes wrote:
> Found one source of the problem. Filed as http://gborg.postgresql.org/ 
> project/pljava/bugs/bugupdate.php?1624
> 
> -Ryan
> 
> On Jan 12, 2007, at 7:54 PM, Ryan Holmes wrote:
> 
>> 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
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at gborg.postgresql.org
>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev