From: rcolmegna at tiscali.it (rcolmegna at tiscali.it)
Date: Fri, 28 Oct 2005 12:14:07 +0200
Subject: I: Re: [Pljava-dev] PLJava + multi-thread {53D1X@freemind.it}
In-Reply-To: <3392486.1130494252817.JavaMail.root@k900>
Message-ID: <435653A9000233F1@mail-1.mail.tiscali.sys>

Thanks for your reply. I have already tried a big "stack_max_depth" but PG

impose me not more than 2Mbyte (otherwise it refuse to start).

About the recompile option I doesn't have the compiler so I can't try it
...  :(

TIA
Roberto Colmegna

>---- Messaggio originale ----
>Data: Fri Oct 28 11:33:37 CEST 2005
>Da: Thomas Hallgren<thomas at tada.se>
>A: rcolmegna at tiscali.it
>Cc: Pljava-Dev at Gborg.Postgresql.Org<pljava-dev at gborg.postgresql.org>
>Ccn: 
>Ogg.: Re: [Pljava-dev] PLJava + multi-thread
>
>Hi Roberto,
>There was a bug in the 1.1.0 version of PL/Java that might cause this 
>behavior. If you can, please try downloading the latest CVS and compile

>that against a 8.0.3 backend.
>
>Also, look at the backend-log. It may say something about "stack limit 
>exceeded" or similar. If that's the case, perhaps you will be fine by 
>just setting the stack_max_depth variable (in postgresql.conf) to a very
>
>high value like 2000000000.
>
>Regards,
>Thomas Hallgren
>
>rcolmegna at tiscali.it wrote:
>> Hi,
>>
>> I used PLJava on PG 8.0.3 for build a trigger which send, via queue+thread,
>> the inserted
>> record to another PG instance.
>>
>> It works, but after every INSERT executed on PGSQL I obtain this error:
>>
>> javatest=# insert into x(info) values(now());
>> server closed the connection unexpectedly
>>         This probably means the server terminated abnormally
>>         before or while processing the request.
>> The connection to the server was lost. Attempting reset: Succeeded.
>>
>>
>> Note that the java-code doesn't  raise any exception .... :(
>>
>> Any idea? 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
>>   
>


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