Re: could not write block & xlog flush request 3FD/0 is not satisfied

Поиск
Список
Период
Сортировка
От Yves Weißig
Тема Re: could not write block & xlog flush request 3FD/0 is not satisfied
Дата
Msg-id 006301cc0e31$23601eb0$6a205c10$@rbg.informatik.tu-darmstadt.de
обсуждение исходный текст
Ответ на Re: could not write block & xlog flush request 3FD/0 is not satisfied  (Greg Stark <gsstark@mit.edu>)
Список pgsql-hackers
All right, what would we be the best way to debug such a problem?

Yves

-----Original Message-----
From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Greg Stark
Sent: Sunday, May 08, 2011 6:36 PM
To: weissig@rbg.informatik.tu-darmstadt.de
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] could not write block & xlog flush request 3FD/0 is
not satisfied

On Sun, May 8, 2011 at 4:18 PM, Yves Weißig
<weissig@rbg.informatik.tu-darmstadt.de> wrote:
> ERROR:  xlog flush request 3FD/0 is not satisfied --- flushed only to
> 0/20E2DC4
>

That's a pretty big difference in log positions. It seems likely you've
overwritten the block header writing garbage to the LSN.

--
greg

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers



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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Process wakeups when idle and power consumption
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Process wakeups when idle and power consumption