Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)
Дата
Msg-id 1834878822.5207111.1430146622134.JavaMail.yahoo@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-bugs
Robert Haas <robertmhaas@gmail.com> wrote:
> On Fri, Apr 24, 2015 at 5:34 PM, Kevin Grittner <kgrittn@ymail.com> wrote=
:
>> I think I see why I was seeing this and nobody else was
>
> Thomas said he reproduced it.  No?

I should have been more clear about what I meant by "this".  Thomas
said he reproduced the immediate errors with =C3=81lvaro's patch, but if
he said anything about files in the members subdirectory not going
away with VACUUM followed by CHECKPOINT, regardless of
configuration, I missed it.  It turns out that these steps only
"prime the pump" for the files to be deleted on subsequent access
to the members SLRU.  That doesn't contribute to database
corruption, but it sure can be confusing for someone trying to
clean things up.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)