agora inbox for pljava-dev@postgresql.org  
help / color / mirror / Atom feed
Subject: [Pljava-dev] crash due to huge load?
Date: Fri, 28 Oct 2005 20:44:32 +0200
Message-ID: <43627190.5020701@tada.se> (raw)
In-Reply-To: <43621BAB00001769@mail-7.mail.tiscali.sys>
References: <43621BAB00001769@mail-7.mail.tiscali.sys>

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
>   





view thread (5+ messages)  latest in thread

Message-ID: <43627190.5020701@tada.se>
Permalink:  ../43627190.5020701@tada.se/
Also on:    postgresql.org/message-id/43627190.5020701@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] crash due to huge load?
  In-Reply-To: <43627190.5020701@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