Archiving skipped an xlog?

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Archiving skipped an xlog?
Дата
Msg-id CAKrjmhdRcLbTCUs5twvPsnoDMdWUdrHzdoPbc1makB8=p4Vi+Q@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
Hi,
we have weird situation today.

Pg 9.1.13, on ubuntu, on AWS.

At ~ 7am one of db servers stopped responding, and got restarted using AWS console.

After reboot everything seemed to work fine.

But later on I found that one of the segments was not archived.

Segment ...7 was written (mtime of file in pg_xlog) at 6:51 (more or less)
Segment ...8 was written at 6:57
Segment ...9 was written at 7:13

then there were more.

What's interesting - in archive_status, i see .done files for all xlogs, except for ...8. In logs the *8 xlog is not mentioned (I was looking for error message or something).

The xlog didn't make it to destination or archiving, but instead of being retried after reboot - pg moved to *9, and then continued.

I manually archived *8, and everythinh was fine afterwards, but I'm puzzled on how could it happen that an xlog gets skipped? Even in case of force-reboot.

Regards,

depesz

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

Предыдущее
От: Terry Schmitt
Дата:
Сообщение: Re: Next steps in debugging database storage problems?
Следующее
От: AlexK
Дата:
Сообщение: Missing objects in pg_dump