Re: plperl sigfpe reset can crash the server

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: plperl sigfpe reset can crash the server
Дата
Msg-id
201208261810.02800.andres@2ndquadrant.com
Ответ на
Список
Дерево обсуждения
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>
On Saturday, August 25, 2012 06:38:09 AM Tom Lane wrote:
> Andres Freund  writes:
> > Doing a pqsignal(SIGFPE, FloatExceptionHandler) after PERL_SYS_INIT3
> > seems to work. Is that acceptable?
> 
> Surely that's breaking perl's expectations, to more or less the same
> degree they're breaking ours?
In the referenced bug they agree that this is the way forward.

There is the issue of corrupting the perl environment if you manage to 
generate a SIGFPE - I couldn't so far - but I see no way other than of 
teaching the sigfpe handler to really ignore the error as perl wants.
Not sure if adding such ugliness is acceptable.

The issue that the handler does a longjmp out of external code is a general 
problem btw. While pg will probably never create a sigfpe while in anything 
critical the same cannot be said about external code.
So anything external with persistent state probably can be made to crash or 
similar.

Not sure if there is any real way out of this but making the handler FATAL if 
non pg code is running.

Greetings,

Andres Freund
-- 
Andres Freund		http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


В списке pgsql-hackers по дате отправления
От: Bruce Momjian
Дата:
От: Tomas Vondra
Дата:
FAQ