Re: emergency outage requiring database restart

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: emergency outage requiring database restart
Дата
Msg-id 20161101140545.sgcv4kiqt5wp3w66@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: emergency outage requiring database restart  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: emergency outage requiring database restart
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Improve output of BitmapAnd EXPLAIN ANALYZE