Re: reindexdb dying with SIGPIPE on 8.2.5 - Mailing list pgsql-admin

From Torsten Luettgert
Subject Re: reindexdb dying with SIGPIPE on 8.2.5
Date
Msg-id 1218377750.3421.7.camel@murdegern.cbxnet.de
Whole thread Raw
In response to Re: reindexdb dying with SIGPIPE on 8.2.5  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Wed, 2008-08-06 at 23:37 -0400, Tom Lane wrote:

> I'm wondering if the reindexdb is being run under a restrictive ulimit
> setting, or something else that would prevent it from just sitting and
> waiting.

I checked... there's no limits defined in /etc/security/limits.conf.
There's more weirdness here: on the same machine, one day, everything
runs through fine.
Another day, one or two DBs are reindexed and vacuumed properly, then
all successive tries fail with the mentioned SIGPIPE error.

I'll have STDOUT and STDERR redirected to a file before the call of
reindexdb now. Perhaps there's something in the console output that
helps.

> Is there anything in the kernel log at the time of the failure report?

Don't see anything except postgresql messages at that time
in /var/log/messages, and nothing at all in /var/log/secure.

Regards,
Torsten



pgsql-admin by date:

Previous
From: "H. Hall"
Date:
Subject: Re: Problems with connection
Next
From: "C K"
Date:
Subject: Fwd: setting datestyle