[Pljava-dev] crash due to huge load?

Hi,

I'm using a recompiled last CVS-checkout of PLJAVA on PG8.0.3 and JDK1.5.0.

I build a thread-oriented trigger (make a thread which build a connection
to another
PG).

I obtain frequently this error msg:

server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

But I haven't any exception on thread-handled logs (LOG4J).

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/

Roberto,
You have to supply the backend log. This doesn't tell me anything. And
I'm not sure its such a good idea to use log4j with PL/Java. The
standard Java logger (java.util.logging) is configured to use the
backend logging utilities. Use that.

Regards,
Thomas Hallgren

rcolmegna at tiscali.it wrote:
> Hi,
>
> I'm using a recompiled last CVS-checkout of PLJAVA on PG8.0.3 and JDK1.5.0.
>
> I build a thread-oriented trigger (make a thread which build a connection
> to another
> PG).
>
> I obtain frequently this error msg:
>
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
> But I haven't any exception on thread-handled logs (LOG4J).
>
> 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
>

I'm a bit curious. Why do you create a connection to another PG inside a
trigger? That implies that you create another transaction that is not
synchronized with the one your trigger is executing in. What happens if
(when) your original transaction is rolled back?

Regards,
Thomas Hallgren

rcolmegna at tiscali.it wrote:
> Hi,
>
> I'm using a recompiled last CVS-checkout of PLJAVA on PG8.0.3 and JDK1.5.0.
>
> I build a thread-oriented trigger (make a thread which build a connection
> to another
> PG).
>
> I obtain frequently this error msg:
>
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
> But I haven't any exception on thread-handled logs (LOG4J).
>
> 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
>