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

Roberto,
Thank you for the logs. Now it starts to get interesting. You get
several normal process terminations from instances that use PL/Java (I
see a couple of _destroyJavaVM which indicates of a normal shutdown) yet
the postmaster consider them crashed processes. I'm not sure why that
happens. You say it only happens under heavy load. Perhaps it's the Java
VM shutdown in itself that crashes somehow. I'll have to investigate
that further. A couple of questions.

1. Are you now using the latest CVS? I.e. if I provide patches, will
you be able to try them out?
2. What kind of system are you on?
3. Would it be possible for you to include a pid or session id included
in the backend trace (use a log_line_prefix with %p in it)? You use
several instances here and it's hard to tell which trace that origins
from which session.

Regards,
Thomas Hallgren

rcolmegna at tiscali.it wrote:
> As you requested I sent you other logs.
>
> Note that errors appear only under huge load.
>
> TIA
> Roberto Colmegna
>
> ---- Messaggio originale ----
> Data: Sat Oct 29 10:59:47 CEST 2005
> Da: Thomas Hallgren<thomas at tada.se>
> A: rcolmegna at tiscali.it
> Cc: pljava-dev at gborg.postgresql.org
> Ccn:
> Ogg.: Re: R: Re: [Pljava-dev] crash due to huge load?
>
> 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
>
>
>
> __________________________________________________________________
> 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/
>
>
>
>