[Pljava-dev] PLJava + multi-thread

On 28 Oct 2005, at 02:18, rcolmegna at tiscali.it wrote:

> Hi,
>
> I used PLJava on PG 8.0.3 for build a trigger which send, via queue
> +thread,
> the inserted
> record to another PG instance.
>
> It works, but after every INSERT executed on PGSQL I obtain this
> error:
>
> javatest=# insert into x(info) values(now());
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Succeeded.
>
>
> Note that the java-code doesn't raise any exception .... :(

I have had PL/Java "crash" the PostgreSQL server when doing some
complex things. I tried increasing the Xmx attribute for the JVM PL/
Java spawns, and that fixed the issue for me. It is still
unfortunate that PL/Java causes the server to crash instead of just
throwing a java.lang.OutOfMemoryException.