agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] java.lang.OutOfMemoryError
Date: Mon, 19 Jun 2006 09:51:16 +0200
Message-ID: <44965774.7050203@insa-toulouse.fr> (raw)
In-Reply-To: <4492BB01.5060205@tada.se>
References: <4492740D.4040302@insa-toulouse.fr>
<4492BB01.5060205@tada.se>
Thomas Hallgren a ?crit :
>Eric,
>You limit the postmaster to use 64M memory per session.
>
A session is a the trigger ?
> That might be a
>problem but it doesn't have to be. It all depends on what your server is
>doing. I'm sure it's not the garbage collector (the first thing a JVM
>does when it runs short of memory is to collect available garbage).
>
>You have to provide more information. The server log is generally far
>more useful then the output from the client that you provided here. The
>exact version of the PL/Java, PostgreSQL, and Java VM might be helpful
>too. And of course, some hint of what you do when the error occurs.
>
>Common errors include storing tuple data in collections (and thereby
>preventing them from being garbage collected). PL/Java 1.2 had a memory
>leak that occured when you had functions that returned huge result sets.
>
>
We use :
Postgres 8.1
Pljava 1.2.0
jdk 1.4
Our server launch trigger which launch trigger, etc ...
The treatment is long sometimes ...
The java code is a big application which have to manage informations for
an information system
Eric
>Regards,
>Thomas Hallgren
>
>
>Eric BOYER wrote:
>
>
>>Hello
>>
>>We use pl java to launch an application
>>
>>org.postgresql.util.PSQLException: ERREUR: java.lang.OutOfMemoryError
>> at
>>org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
>> at
>>org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
>> at
>>org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>> at
>>org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:437)
>> at
>>org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:339)
>> at
>>org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:331)
>>
>>We have a long treatment in a loop and the memory grow gradually up to a
>>java.lang.OutOfMemoryError.
>>
>>What could be the problem ?
>>
>>- garbage collector ?
>>- vmoptions ? : pljava.vmoptions = '-Xmx64M'
>>
>>Our serveur have 1Go RAM and postmaster start with a low consumption of
>>RAM and grow up to ~300M ...
>>
>>Thanks for your help
>>
>>Eric
>>
>>_______________________________________________
>>Pljava-dev mailing list
>>Pljava-dev at gborg.postgresql.org
>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>
>>
>>
>
>_______________________________________________
>Pljava-dev mailing list
>Pljava-dev at gborg.postgresql.org
>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>
>
view thread (14+ messages) latest in thread
Message-ID: <44965774.7050203@insa-toulouse.fr>
Permalink: ../44965774.7050203@insa-toulouse.fr/
Also on: postgresql.org/message-id/44965774.7050203@insa-toulouse.fr
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] java.lang.OutOfMemoryError
In-Reply-To: <44965774.7050203@insa-toulouse.fr>
* 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