Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https - Mailing list pgsql-hackers

From Andres Freund
Subject Re: plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https
Date
Msg-id 201208231217.22798.andres@2ndquadrant.com
Whole thread Raw
In response to plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https  (Hannu Krosing <hannu@2ndQuadrant.com>)
Responses Re: plperl sigfpe reset can crash the server
List pgsql-hackers
Hi,

While debugging an instance of this bug I noticed that plperlu always removes 
the SIGFPE handler and sets it to ignore:


andres@awork2:~$ psql -p 5435 -U postgres -h /var/run/postgresql test
Timing is on.
psql (9.1devel, server 9.1.5)
Type "help" for help.

test=# SELECT pg_backend_pid();pg_backend_pid 
----------------          9287

root@awork2:/home/andres# grep -E '^Sig(Cgt|Ign)' /proc/9287/status|awk 
'{print $2}'
0000000001301800
0000000180006287

test=# DO LANGUAGE plperlu $$$$;

root@awork2:/home/andres# grep -E '^Sig(Cgt|Ign)' /proc/9287/status|awk 
'{print $2}'
0000000001301880
0000000180006207

Note the 8'th bit being unset in SigCgt and set in SigIgn. Thats SIGFPE...

Not sure how relevant this really is, but it could cause errors to be 
ignored...

Greetings,

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



pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: to_timestamp() too loose?
Next
From: Magnus Hagander
Date:
Subject: Re: pg_stat_replication vs StandbyReplyMessage