From: thomas at tada.se (Thomas Hallgren)
Date: Fri, 28 Oct 2005 11:33:37 +0200
Subject: [Pljava-dev] PLJava + multi-thread
In-Reply-To: <4354AB8F00029A92@mail-4.mail.tiscali.sys>
References: <4354AB8F00029A92@mail-4.mail.tiscali.sys>
Message-ID: <4361F071.20308@tada.se>

Hi Roberto,
There was a bug in the 1.1.0 version of PL/Java that might cause this 
behavior. If you can, please try downloading the latest CVS and compile 
that against a 8.0.3 backend.

Also, look at the backend-log. It may say something about "stack limit 
exceeded" or similar. If that's the case, perhaps you will be fine by 
just setting the stack_max_depth variable (in postgresql.conf) to a very 
high value like 2000000000.

Regards,
Thomas Hallgren

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 .... :(
>
> Any idea? TIA
> Roberto Colmegna
>
>
> __________________________________________________________________
> TISCALI ADSL
> Solo con Tiscali Adsl navighi senza limiti e telefoni senza canone 
> Telecom a partire da 19,95 Euro/mese.
> Attivala subito, I PRIMI DUE MESI SONO GRATIS! CLICCA QUI:
> http://abbonati.tiscali.it/adsl/sa/1e25flat_tc/
>
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>