Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https

On Thu, 2011-08-04 at 15:07 +0200, Hannu Krosing wrote:
> Hi
> 
> I have been helping some people to debug a SIGALARM related crash
> induced by using pl/perlu http get functionality
> 
> I have been so far able to repeat the crash only on Debian 64 bit
> computers. DB create script and instructions for reproducing the crash
> attached

Resending - the previous one was in pre-edit stage with
instructions/comments in estonian :(

> The crash is related to something leaving begind a bad SIGALARM handler,
> as it can be (kind of) fixed by resetting sigalarm to nothing using perl
> function 
> 
> REATE OR REPLACE FUNCTION reset_sigalarm() RETURNS VOID
>     LANGUAGE plperlu
> AS $_X$
>    $SIG{ALRM} = 'IGNORE';
> $_X$;
> 
> ( unfortunately this hoses deadlock detection and statement_timeout )
> 
> Environment where this crash does happen:
> 
> Debian GNU/Linux 6.0  - x86-64
> openssl                 0.9.8o-4squeeze1
> postgresql-9.0          9.0.4-1~bpo60+1 
> postgresql-plperl-9.0   9.0.4-1~bpo60+1 
> libwww-perl             5.836-1      
> 
> Postgresql is installed from backports
> 
> It does not happen on 32 bit ubuntu
> 
> 

-- 
-------
Hannu Krosing
PostgreSQL Infinite Scalability and Performance Consultant
PG Admin Book: http://www.2ndQuadrant.com/books/