Re: Redo record at high number

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема Re: Redo record at high number
Дата
Msg-id 3705826352029646A3E91C53F7189E320167B6@sectorbase2.sectorbase.com
обсуждение исходный текст
Ответ на Redo record at high number  ("Jeff Boes" <jboes@nexcerpt.com>)
Список pgsql-admin
> > We have noticed this line in our server log:
> > Redo record at (5, 4209179252); Undo record at (0, 0); Shutdown TRUE
>
> > That second number seems awfully high; should this give us cause for
> > concern?
>
> Looks fishy to me too --- the offset shouldn't exceed 24 bits AFAIR.
> Vadim, what do you think?

Log record ptr is 4 bytes for log file ID and 4 bytes for record offset.
# of segmets in log file (2^32 - 1) / 2^24 = 255
Max offset *in segment* is 2^24 , but max offset *in log file*
is 255 * 2^24 = 4278190080

Vadim

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

Предыдущее
От: "Mikheev, Vadim"
Дата:
Сообщение: Re: Redo record at high number
Следующее
От: "Jeff Boes"
Дата:
Сообщение: Wanted: way to limit logging