Re: "pgstat wait timeout" warnings

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: "pgstat wait timeout" warnings
Дата
Msg-id 23623.1313073011@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: "pgstat wait timeout" warnings  (Andres Freund <andres@anarazel.de>)
Ответы Re: "pgstat wait timeout" warnings  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
>> --On 10. August 2011 21:54:06 +0300 Heikki Linnakangas
>> <heikki.linnakangas@enterprisedb.com> wrote:
>>> So my theory is that if the I/O is really busy, write() on the stats file
>>> blocks for more than 5 seconds, and you get the timeout.

> Yes, I have seen it several times as well. I can actually reproduce it
> without much problems, so if you have some idea to test...

It doesn't surprise me that it's possible to reproduce it under extreme
I/O load.  What I am wondering about is whether there's some bug/effect
that allows it to happen without that.
        regards, tom lane


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: compiling 9.2 : WinXp+mingw
Следующее
От: Robert Haas
Дата:
Сообщение: Re: "pgstat wait timeout" warnings