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

Поиск
Список
Период
Сортировка
Искать
От
Hannu Krosing
Тема
plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https
Дата
Msg-id
1312463257.4917.11.camel@hvost
Список
Дерево обсуждения
plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Hannu Krosing <hannu@2ndQuadrant.com>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Hannu Krosing <hannu@2ndQuadrant.com>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Andres Freund <andres@2ndquadrant.com>
Re: plperl sigfpe reset can crash the server Andres Freund <andres@2ndquadrant.com>
Re: plperl sigfpe reset can crash the server Tom Lane <tgl@sss.pgh.pa.us>
Re: plperl sigfpe reset can crash the server Andres Freund <andres@2ndquadrant.com>
Re: plperl sigfpe reset can crash the server Andres Freund <andres@2ndquadrant.com>
Re: plperl sigfpe reset can crash the server Tom Lane <tgl@sss.pgh.pa.us>
Re: plperl sigfpe reset can crash the server Andres Freund <andres@2ndquadrant.com>
Re: plperl sigfpe reset can crash the server Tom Lane <tgl@sss.pgh.pa.us>
Re: plperl sigfpe reset can crash the server Andres Freund <andres@2ndquadrant.com>
Re: plperl sigfpe reset can crash the server Andrew Dunstan <andrew@dunslane.net>
Re: plperl sigfpe reset can crash the server Andres Freund <andres@2ndquadrant.com>
Re: plperl sigfpe reset can crash the server Andres Freund <andres@2ndquadrant.com>
Re: plperl sigfpe reset can crash the server Tom Lane <tgl@sss.pgh.pa.us>
Re: plperl sigfpe reset can crash the server Andres Freund <andres@2ndquadrant.com>
Re: plperl sigfpe reset can crash the server Andres Freund <andres@2ndquadrant.com>
Re: plperl sigfpe reset can crash the server Andres Freund <andres@2ndquadrant.com>
Re: plperl sigfpe reset can crash the server Tom Lane <tgl@sss.pgh.pa.us>
Re: plperl sigfpe reset can crash the server Andres Freund <andres@2ndquadrant.com>
Re: plperl sigfpe reset can crash the server Tom Lane <tgl@sss.pgh.pa.us>
Re: plperl sigfpe reset can crash the server Alex Hunsaker <badalex@gmail.com>
Re: plperl sigfpe reset can crash the server Andres Freund <andres@2ndquadrant.com>
Re: plperl sigfpe reset can crash the server Andres Freund <andres@2ndquadrant.com>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Andrew Dunstan <andrew@dunslane.net>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Hannu Krosing <hannu@krosing.net>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Alvaro Herrera <alvherre@commandprompt.com>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Alexey Klyukin <alexk@commandprompt.com>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Andrew Dunstan <andrew@dunslane.net>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Tom Lane <tgl@sss.pgh.pa.us>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Hannu Krosing <hannu@2ndQuadrant.com>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Andrew Dunstan <andrew@dunslane.net>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Alex Hunsaker <badalex@gmail.com>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https "David E. Wheeler" <david@kineticode.com>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Alex Hunsaker <badalex@gmail.com>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Tom Lane <tgl@sss.pgh.pa.us>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Alex Hunsaker <badalex@gmail.com>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Andrew Dunstan <andrew@dunslane.net>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Alex Hunsaker <badalex@gmail.com>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Andrew Dunstan <andrew@dunslane.net>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Alex Hunsaker <badalex@gmail.com>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Tim Bunce <Tim.Bunce@pobox.com>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Andrew Dunstan <andrew@dunslane.net>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Alex Hunsaker <badalex@gmail.com>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Tim Bunce <Tim.Bunce@pobox.com>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Andrew Dunstan <andrew@dunslane.net>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Tom Lane <tgl@sss.pgh.pa.us>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Andrew Dunstan <andrew@dunslane.net>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Tom Lane <tgl@sss.pgh.pa.us>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Andrew Dunstan <andrew@dunslane.net>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https Tom Lane <tgl@sss.pgh.pa.us>
Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https "David E. Wheeler" <david@kineticode.com>
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

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/
В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
Сообщение: Re: TRUE/FALSE vs true/false
От: Peter Geoghegan
Дата:
Сообщение: Re: TRUE/FALSE vs true/false
FAQ