Re: apparent wraparound

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: apparent wraparound
Дата
Msg-id 8274.1163208101@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: apparent wraparound  ("George Pavlov" <gpavlov@mynewplace.com>)
Список pgsql-general
"George Pavlov" <gpavlov@mynewplace.com> writes:
>> "George Pavlov" <gpavlov@mynewplace.com> writes:
>>>>> 2006-11-08 12:38:34 PST [3739]: [3-1] LOG:  could not truncate directory
>>>>> "pg_multixact/members": apparent wraparound
>>>> During crash recovery?
>>> no crashes, just normal DB operation...
>>
>> Hmm ... what is in pg_multixact/members/ again?

> Now there is only a file named 0010 the date on which changes about
> every 4-5 minutes or so.

AFAICS this must indicate that TruncateMultiXact() computed a bogus
oldestOffset, but it's hard to see how that would happen in the middle
of an unexceptional run.  Alvaro, any ideas?  Could there be a race
condition involved in filling in the "members" entries?

            regards, tom lane

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

Предыдущее
От: "George Pavlov"
Дата:
Сообщение: Re: apparent wraparound
Следующее
От: Shane Ambler
Дата:
Сообщение: Re: Request for replication advice