From: thomas at tada.se (Thomas Hallgren)
Date: Sat, 29 Oct 2005 10:59:47 +0200
Subject: R: Re: [Pljava-dev] crash due to huge load?
In-Reply-To: <43620B8200001FCC@mail-2.mail.tiscali.sys>
References: <43620B8200001FCC@mail-2.mail.tiscali.sys>
Message-ID: <43633A03.9090901@tada.se>

Roberto,
Some of you problems stems from the following lines:

ERROR:  XX000: java.lang.NoClassDefFoundError: 
org/postgresql/core/StartupPacket
ERROR:  XX000: java.lang.NoClassDefFoundError: 
it/robcol/distribdb/util/SQLIntrospector

You need to find the cause of these errors. You also get a warning from 
PL/Java:

WARNING:  01000: 29 Oct 05 09:35:14 
org.postgresql.pljava.jdbc.Invocation Closing 1 "forgotten" statement

this indicates that you have prepared statements that you don't close.

Please set the log_min_messages in your postgresql.conf to DEBUG1. That 
will reveal some more info.

Regards,
Thomas Hallgren

rcolmegna at tiscali.it wrote:
> I agree: my implementation isn't a "peferct" mechanism (but 2PC isn't implemented
> in PG ;) ) but is acceptable for my needs.
>
> As you request, you could find PG-log attacched.
>
> Thanks a lot for your support.
>
> Regards,
> Roberto Colmegna
>
>
>
> ---- Messaggio originale ----
> Data: Sat Oct 29 10:26:39 CEST 2005
> Da: Thomas Hallgren<thomas at tada.se>
> A: rcolmegna at tiscali.it
> Cc: pljava-dev at gborg.postgresql.org
> Ccn: 
> Ogg.: Re: [Pljava-dev] crash due to huge load?
>
> Roberto,
> You can never guarantee coherence between two databases unless you use 
> 2-phase commits.
> Think "what if I pull the plug at precisely this moment" (i.e. between 
> #1 and #2 for instance).
>
> Regarding the crash, I would really like to help you find the cause, but
>
> you will have to provide the backend log.
>
> Regards,
> Thomas Hallgren
>
>
> __________________________________________________________________
> 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/
>
>
>
>