agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] java.lang.OutOfMemoryError
Date: Fri, 16 Jun 2006 16:06:57 +0200
Message-ID: <4492BB01.5060205@tada.se> (raw)
In-Reply-To: <4492740D.4040302@insa-toulouse.fr>
References: <4492740D.4040302@insa-toulouse.fr>

Eric,
You limit the postmaster to use 64M memory per session. 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.

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
>   

view thread (14+ messages)  latest in thread

Message-ID: <4492BB01.5060205@tada.se>
Permalink:  ../4492BB01.5060205@tada.se/
Also on:    postgresql.org/message-id/4492BB01.5060205@tada.se

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: <4492BB01.5060205@tada.se>

* 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