[Pljava-dev] PLJava + multi-thread

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/

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
>

On 28 Oct 2005, at 02:18, 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 .... :(

I have had PL/Java "crash" the PostgreSQL server when doing some
complex things. I tried increasing the Xmx attribute for the JVM PL/
Java spawns, and that fixed the issue for me. It is still
unfortunate that PL/Java causes the server to crash instead of just
throwing a java.lang.OutOfMemoryException.

Rakesh,
I think this is fixed too in the latest source. It would be very helpful
if you can download, compile, and verify that it works for you.

Regards,
Thomas Hallgren

Rakesh Vidyadharan wrote:
>
> On 28 Oct 2005, at 02:18, 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 .... :(
>
> I have had PL/Java "crash" the PostgreSQL server when doing some
> complex things. I tried increasing the Xmx attribute for the JVM
> PL/Java spawns, and that fixed the issue for me. It is still
> unfortunate that PL/Java causes the server to crash instead of just
> throwing a java.lang.OutOfMemoryException.
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev

On 28 Oct 2005, at 05:50, Thomas Hallgren wrote:

> Rakesh,
> I think this is fixed too in the latest source. It would be very
> helpful if you can download, compile, and verify that it works for
> you.

I does seem to have fixed some issues with memory. I originally had
configured a max size of 32M for the JVM, and due to the crashes had
increased it to 48M. Now I have reduced it back to 32M and so far I
have had no issues (I think 32M should be plenty for what I do). I
will try reducing the head size at some point to see how much I can
trim it and still have everything working as I need.

Rakesh