Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A07EA2E00F9 for ; Fri, 22 Feb 2008 15:31:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 33961-05 for ; Fri, 22 Feb 2008 15:31:41 -0400 (AST) X-Greylist: delayed 00:06:41.295019 by SQLgrey-1.7.5 Received: from netinfo.bg (ogw.netinfo.bg [194.153.145.235]) by postgresql.org (Postfix) with SMTP id 20BB32E00C4 for ; Fri, 22 Feb 2008 15:31:43 -0400 (AST) Received: (qmail 12885 invoked by uid 0); 22 Feb 2008 19:25:19 -0000 Received: from 85-130-29-161.1697436.ddns.cablebg.net (HELO ?85.130.29.161?) (85.130.29.161) by netinfo.bg with SMTP; 22 Feb 2008 19:25:19 -0000 Message-ID: <47BF218F.3050301@netinfo.bg> Date: Fri, 22 Feb 2008 21:25:03 +0200 From: Milen Evtimov User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: Tom Lane CC: pgsql-admin@postgresql.org Subject: Re: server process (PID ) was terminated by signal 29 References: <47BE803C.7@netinfo.bg> <4921.1203699500@sss.pgh.pa.us> In-Reply-To: <4921.1203699500@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200802/286 X-Sequence-Number: 28360 Tom Lane wrote: > Milen Evtimov 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