From: rakesh at rakeshv.org (Rakesh Vidyadharan)
Date: Wed, 23 Nov 2005 07:29:26 -0600
Subject: [Pljava-dev] Solaris and -Xusealtsigs [Was: Re: Need help on
	Pljava]
In-Reply-To: <4384642B.2050508@tada.se>
References: <004201c5f028$5656bbd0$b40b010a@secfindia.com>
	<4384642B.2050508@tada.se>
Message-ID: <42632613-BF9A-4B7B-BD0D-1187DDD70ECC@rakeshv.org>

I am running PL/Java on Solaris 9 SPARC, and I have seen the issue  
before.  The fix is to just follow what the error message tells you  
to do.

With Java 5 I have the following in my postgresql.conf file:

pljava.vmoptions = '-Xms8M -Xmx8M -XX:+UseAltSigns'

It works with absolutely no issues.

On 23 Nov 2005, at 06:44, Thomas Hallgren wrote:

> Hi Param,
> I'm posting this on the pljava-dev mailing list also. PL/Java is an  
> open source community and questions are best answered in the open  
> forum. It benefits other people that might have similar problems,  
> and since it widens the audience, it also benefits you.
>
> I haven't seen this error before. Then again, I don't have access  
> to a Solaris system. The option mentioned (-Xusealtsigs) is not  
> present on a standard Java on Linux or Windows. What Java version  
> are you using?
>
> You can try and add this option in the postgresql.conf file.
>
>   pljava.vmoptions = '-Xusealtsigs'
>
> but I'm not at all sure that it will help. Another thing you could  
> try is to comment out line 632 in the file src/C/pljava/Backend.c  
> and recompile. A third option is to try and add the following line:
>
> pgsignal(SIGINT, SIG_DFL);
>
> before line 617 in the same file. I'm very keen to know what it was  
> that made the difference if you somehow succeed.
>
> This is the best I can do right now since I don't have access to  
> Solaris system. Perhaps someone else on this forum has shed some  
> more light on this?
>
> Regards,
> Thomas Hallgren
>
> param wrote:
>> Thomas,
>>
>> Thanks for your help. I really appreciate it. I have successfully  
>> installed
>> pljava. Now as I try to execute the following query :
>>
>> CREATE FUNCTION getsysprop1(VARCHAR)
>>   RETURNS VARCHAR
>>   AS 'java.lang.System.getProperty'
>>   LANGUAGE java;
>> SELECT getsysprop1('user.home');
>>
>> It gives me following error:
>>
>> INFO:  Error occurred during initialization of VM
>> INFO:  Signal chaining not allowed for VM interrupt signal,
>> try -Xusealtsigs.
>> INFO:
>> 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.
>>
>> Please advice.
>> I really appreciate it.
>>
>> Thanks
>> -param
>>
>>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev