Skip site navigation (1) Skip section navigation (2)

Re: server process (PID ) was terminated by signal 29

From: Milen Evtimov <milen(at)netinfo(dot)bg>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: server process (PID ) was terminated by signal 29
Date: 2008-02-22 19:25:03
Message-ID: 47BF218F.3050301@netinfo.bg (view raw or flat)
Thread:
Lists: pgsql-admin
Tom Lane wrote:
> Milen Evtimov <milen(at)netinfo(dot)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

In response to

pgsql-admin by date

Next:From: GeoffreyDate: 2008-02-22 19:26:39
Subject: Re: loading same instance of dump to two different servers simultaneously?
Previous:From: Susan RussoDate: 2008-02-22 19:24:23
Subject: Re: [PERFORM] CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group