plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https
From:
Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
To:
Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
plperl crash with Debian 6 (64 bit), pl/perlu, libwww and https
Date:
2011-08-04 13:07:37
Message-ID:
1312463257.4917.11.camel@hvost (view raw or flat )
Thread:
2011-08-04 13:07:37 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2011-08-04 13:42:31 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-08-04 13:53:40 from Hannu Krosing <hannu(at)krosing(dot)net>
2011-08-04 14:25:49 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2011-08-04 14:38:11 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-08-04 14:28:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-08-04 15:11:32 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-08-04 22:09:47 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-08-04 22:34:32 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-08-04 22:46:21 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-08-04 23:52:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-08-05 00:44:18 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-08-05 01:40:57 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-08-05 03:23:49 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-08-05 14:53:21 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-08-06 18:37:28 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-08-07 23:06:56 from Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com>
2011-08-07 23:39:11 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-08-08 07:23:08 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-08-08 09:03:55 from Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com>
2011-08-09 15:43:06 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-08-09 16:22:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-08-09 16:35:35 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-08-09 20:32:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-08-10 16:44:55 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-08-10 17:03:58 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-08-10 17:27:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-08-04 17:48:38 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2011-08-04 14:34:44 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-08-04 13:47:03 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2012-08-23 10:17:22 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-08-24 04:44:14 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-08-24 04:55:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-24 05:05:14 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-08-24 05:19:42 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-08-24 05:32:49 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-08-24 05:33:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-24 05:45:59 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-08-24 14:53:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-24 14:58:18 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-08-24 15:09:18 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-08-24 21:40:45 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-08-24 22:10:43 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-08-24 22:15:00 from Alex Hunsaker <badalex(at)gmail(dot)com>
2012-08-24 22:19:23 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-08-25 04:38:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-25 05:57:50 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-08-26 16:10:02 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-09-05 14:06:53 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-09-05 17:15:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-09-05 17:32:13 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-09-05 20:45:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-hackers
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/
Responses
pgsql-hackers by date
Next :From: Peter GeogheganDate: 2011-08-04 13:17:23Subject : Re: TRUE/FALSE vs true/falsePrevious :From : Robert HaasDate : 2011-08-04 12:57:23Subject : Re: TRUE/FALSE vs true/false
