[Pljava-dev] java.lang.OutOfMemoryError

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
>