agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] out of memory
Date: Wed, 12 Apr 2006 08:08:15 +0200
Message-ID: <443C994F.6060308@lewczuk.com> (raw)
In-Reply-To: <443BCC32.2090306@tada.se>
References: <e1fn29$od1$1@sea.gmane.org>
<443B63F0.4050803@tada.se>
<443BC400.4030806@lewczuk.com>
<443BCC32.2090306@tada.se>
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
view thread (12+ messages) latest in thread
Message-ID: <443C994F.6060308@lewczuk.com>
Permalink: ../443C994F.6060308@lewczuk.com/
Also on: postgresql.org/message-id/443C994F.6060308@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: <443C994F.6060308@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