From: Milen Evtimov <milen@netinfo.bg>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: server process (PID ) was terminated by signal 29
Date: Fri, 22 Feb 2008 21:25:03 +0200
Message-ID: <47BF218F.3050301@netinfo.bg> (raw)
In-Reply-To: <4921.1203699500@sss.pgh.pa.us>
References: <47BE803C.7@netinfo.bg>
<4921.1203699500@sss.pgh.pa.us>
Tom Lane wrote:
> Milen Evtimov <milen@netinfo.bg> writes:
>
>> After upgrading one of our database servers from 8.1.11 on SLES9 to
>> 8.2.6 on CentOS 5.1, it crashed several times with following errors:
>>
>
>
>> LOG: server process (PID ) was terminated by signal 29
>>
>
> That's pretty odd. Would you confirm what signal 29 is on your machine?
> (On my Fedora 8 box, the numbers are defined in /usr/include/bits/signum.h
> --- it's probably the same on yours.)
>
> Fedora 8 says that 29 is SIGIO a/k/a SIGPOLL, but that doesn't make any
> sense to me --- we don't use any calls that would trigger that.
>
> Is this a locally built copy of Postgres, or an RPM installation?
> If the latter, which RPM exactly?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
>
>
From /usr/include/bits/signum.h
#define SIGPOLL SIGIO /* Pollable event occurred (System V). */
#define SIGIO 29 /* I/O now possible (4.2 BSD). */
and output from kill -l 29 is IO
Postgresql is installed from RPMs taken from official postgresql.org
site - exact version is
postgresql-8.2.6-1PGDG.rhel5.x86_64.
Regards,
Milen
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: milen@netinfo.bg, tgl@sss.pgh.pa.us
Subject: Re: server process (PID ) was terminated by signal 29
In-Reply-To: <47BF218F.3050301@netinfo.bg>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox