Re: SR standby hangs

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: SR standby hangs
Дата
Msg-id 4D5EEF0E.40306@dunslane.net
обсуждение исходный текст
Ответ на Re: SR standby hangs  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers

On 02/18/2011 03:42 PM, Robert Haas wrote:
> On Fri, Feb 18, 2011 at 2:50 PM, Tom Lane<tgl@sss.pgh.pa.us>  wrote:
>> Robert Haas<robertmhaas@gmail.com>  writes:
>>> On Fri, Feb 18, 2011 at 2:35 PM, Andrew Dunstan<andrew@dunslane.net>  wrote:
>>>> It's not running HS, so there's no query to wait on.
>>> That seems to imply that recovery has leaked a buffer pin.
>> No, because then the sanity check in LockBufferForCleanup would have
>> fired:
>>
>>         /* There should be exactly one local pin */
>>         if (PrivateRefCount[buffer - 1] != 1)
>>                 elog(ERROR, "incorrect local pin count: %d",
>>                          PrivateRefCount[buffer - 1]);
> Hmm, yeah.
>
>> Some sort of deadly embrace with the bgwriter, maybe?
> Maybe.
>
> I think it'd be useful to know what the buffer header thinks the
> refcount on that buffer is, and what the startup process and the
> bgwriter each have for PrivateRefCount[buffer].


I'll see what I can find out (damn I hate driving debuggers).

cheers

andrew


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: DropRelFileNodeBuffers API change (was Re: [BUGS] BUG #5599: Vacuum fails due to index corruption issues)
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: WIP - Add ability to constrain backend temporary file space