Re: emergency outage requiring database restart - Mailing list pgsql-hackers

From Andres Freund
Subject Re: emergency outage requiring database restart
Date
Msg-id 20161101140545.sgcv4kiqt5wp3w66@alap3.anarazel.de
Whole thread Raw
In response to Re: emergency outage requiring database restart  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2016-11-01 09:56:45 -0400, Tom Lane wrote:
> The real problem with Oskari's theory is that it requires not merely
> busted, but positively brain-dead error handling in the shell and/or
> sqsh, ie ignoring open() failures altogether.  That seems kind of
> unlikely.  Still, I suspect he might be onto something --- there must
> be some reason you can reproduce the issue in production and not in
> your test bed, and number-of-open-files is as good a theory as I've
> heard.

I've seen shell code akin to
exec >16 somefile # assume fd 16 is unused
more than one :(



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: emergency outage requiring database restart
Next
From: Robert Haas
Date:
Subject: Re: Improve output of BitmapAnd EXPLAIN ANALYZE