agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] out of memory
Date: Tue, 11 Apr 2006 16:58:08 +0200
Message-ID: <443BC400.4030806@lewczuk.com> (raw)
In-Reply-To: <443B63F0.4050803@tada.se>
References: <e1fn29$od1$1@sea.gmane.org>
	<443B63F0.4050803@tada.se>

Thomas Hallgren napisa?(a):
> Hi Marek,
> The memory consumption shown in the serverlog doesn't seem to be very 
> high. How much memory is the process consuming all in all?
If it isn't high, so why pljava hangs - it doesn't throw any error, 
postgresql process is working but pljava function do nothing (I need to 
kill process manually in order unlock postgresql resources). I will try 
to execute it again and see how much memory it consumes.

> Which version of PL/Java are you running? There is a known memory leak 
> in 1.2 that has been fixed. So if you're using that, perhaps you could 
> try the latest from cvs?
Latest, stable release - 1.2. My pljava function doesn't return a set, 
so I don't think that this will fix my problem.

> You create nested statements that you close. Any chance you leave a 
> ResultSet open somewhere (should be closed when it's statement is 
> closed, I'm just trying to eliminate possibilities)?
I close every statement and this should close automatically all 
ResultSet related to the statement.

Best regards,
ML

 

view thread (12+ messages)  latest in thread

Message-ID: <443BC400.4030806@lewczuk.com>
Permalink:  ../443BC400.4030806@lewczuk.com/
Also on:    postgresql.org/message-id/443BC400.4030806@lewczuk.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] out of memory
  In-Reply-To: <443BC400.4030806@lewczuk.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