Re: FATAL Error

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: FATAL Error
Дата
Msg-id 24365.1155001617@sss.pgh.pa.us
обсуждение исходный текст
Ответ на FATAL Error  (Matt <matthew@zeut.net>)
Ответы Re: FATAL Error
Список pgsql-general
Matt <matthew@zeut.net> writes:
> I'm getting the following error on PGSQL 8.0.8 server that I admin.  I
> don't think this is a hardware problem but I'm not sure.  Anyway in the
> logfile I'm constantly getting this:

> ERROR:  xlog flush request 2/13CEA8AC is not satisfied --- flushed only
> to 2/13634EE4
> CONTEXT:  writing block 3421 of relation 1663/9533957/9534098

This indicates that the LSN word of that block contains 2/13CEA8AC,
which is impossibly large if WAL currently extends only to 2/13634EE4.
Have you had any crashes or other odd behavior recently?
What files do you see in $PGDATA/pg_xlog/?  Can you grab a copy of
pg_filedump and look at what the block contains on-disk?

            regards, tom lane

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

Предыдущее
От: Berend Tober
Дата:
Сообщение: Re: Disabling and enabling constraints and triggers to
Следующее
От: Tom Lane
Дата:
Сообщение: Re: DROP TABLESPACE fails