Re: SR standby hangs

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]);
 

Some sort of deadly embrace with the bgwriter, maybe?
        regards, tom lane