[Pljava-dev] out of memory

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