Re: BUG #7670: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #7670: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"
Дата
Msg-id 4024.1353262722@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #7670: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: BUG #7670: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"  (Igor <igorya.inscriptio@gmail.com>)
Re: BUG #7670: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"  (Peter Geoghegan <peter@2ndquadrant.com>)
Re: BUG #7670: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-bugs
Andres Freund <andres@2ndquadrant.com> writes:
> On 2012-11-18 12:44:55 -0500, Tom Lane wrote:
>> I'm inclined to propose limiting both of these to the equivalent of 15
>> days.  Alternatively we could try to rejigger things to prevent asking
>> WaitLatch to wait for more than 2^31 msec, but it's not real clear to
>> me that it's worth the trouble.

> In general I have no problem imposing lower limits, but it seems to be a
> ugly to get errors for an invalid configuration file after a minor
> version upgrade. While the wal_sender_timeout isn't really likely to be
> that high I don't think the log_rotation_age one is unlikely to be set
> to something in the month range, thats not an unreasonable value.

Well, we have two reports of people trying such values (assuming that
#7545 actually is the same thing), and it didn't work for either of
them.  I don't think it's a problem to restrict the value to something
that will work rather than fail.

If you're worried that there's somebody out there using 20 or 21 days
as log_rotation_age, I guess we could limit to INT_MAX/1000 seconds or
something just less than that.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Phil Sorber
Дата:
Сообщение: Re: Prepared Statement Name Truncation
Следующее
От: Igor
Дата:
Сообщение: Re: BUG #7670: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"