R: Re: [Pljava-dev] crash due to huge load?

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/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgresql-Sat.log
Type: application/octet-stream
Size: 23121 bytes
Desc: not available
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20051029/63afb032/attachment.obj>

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/
>
>
>
>