agora inbox for pljava-dev@postgresql.org  
help / color / mirror / Atom feed
[Pljava-dev] Solaris and -Xusealtsigs [Was: Re: Need help on Pljava]
2+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] Solaris and -Xusealtsigs [Was: Re: Need help on Pljava]
@ 2005-11-23 12:44 
  2005-11-23 13:29 ` [Pljava-dev] Solaris and -Xusealtsigs [Was: Re: Need help on Pljava] 
  0 siblings, 1 reply; 2+ messages in thread

From:  @ 2005-11-23 12:44 UTC (permalink / raw)

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* [Pljava-dev] Solaris and -Xusealtsigs [Was: Re: Need help on Pljava]
  2005-11-23 12:44 [Pljava-dev] Solaris and -Xusealtsigs [Was: Re: Need help on Pljava] 
@ 2005-11-23 13:29 ` 
  0 siblings, 0 replies; 2+ messages in thread

From:  @ 2005-11-23 13:29 UTC (permalink / raw)

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-11-23 13:29 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-23 12:44 [Pljava-dev] Solaris and -Xusealtsigs [Was: Re: Need help on Pljava] 
2005-11-23 13:29 ` 

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox