From: marek at lewczuk.com (Marek Lewczuk) Date: Wed, 12 Apr 2006 08:08:15 +0200 Subject: [Pljava-dev] out of memory In-Reply-To: <443BCC32.2090306@tada.se> References: <443B63F0.4050803@tada.se> <443BC400.4030806@lewczuk.com> <443BCC32.2090306@tada.se> Message-ID: <443C994F.6060308@lewczuk.com> Thomas Hallgren napisa?(a): > I don't know why it hangs. An out-of-memory would typically cause a > termination, not a hanging. Which JVM are you using and on which > platform? What is the behavior of your hung process? Is it consuming > lots of CPU cycles or none at all? This "top" was taken after start: ------------- top - 07:46:50 up 73 days, 14:31, 1 user, load average: 1.39, 0.67, 0.24 Tasks: 98 total, 5 running, 93 sleeping, 0 stopped, 0 zombie Cpu(s): 47.3% user, 5.7% system, 0.0% nice, 47.0% idle Mem: 904848k total, 898940k used, 5908k free, 608k buffers Swap: 2048276k total, 348036k used, 1700240k free, 29460k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 29590 postgres 17 0 1133m 806m 18m R 95.0 91.2 2:58.75 postmaster ------------ After couple of minutes pljava stops (but no error is returned) and postgresl process is still working: ------------ top - 07:55:38 up 73 days, 14:40, 1 user, load average: 1.23, 1.42, 0.83 Tasks: 105 total, 1 running, 104 sleeping, 0 stopped, 0 zombie Cpu(s): 0.5% user, 4.4% system, 0.0% nice, 95.2% idle Mem: 904848k total, 898668k used, 6180k free, 1068k buffers Swap: 2048276k total, 1794380k used, 253896k free, 50136k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 29590 postgres 10 0 2472m 752m 34m D 0.6 85.2 8:55.40 postmaster ------------ > Well, if you have a chance, please try out the new stuff. The fix > regarding set returning functions is not the only change since 1.2 and > I'd hate to spend time on something that's not an issue in the new code. I did that - but it doesn't affect the behavior of my function. > OK, to rephrase my question - Do you rely on that ResultSets are closed > by the Statement close Yes >or do you close them too explicitly? No... should I do it ? ML