From: marek at lewczuk.com (Marek Lewczuk) Date: Tue, 11 Apr 2006 16:58:08 +0200 Subject: [Pljava-dev] out of memory In-Reply-To: <443B63F0.4050803@tada.se> References: <443B63F0.4050803@tada.se> Message-ID: <443BC400.4030806@lewczuk.com> 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