Re: pg_dumpall failure - could not access status of transaction

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dumpall failure - could not access status of transaction
Дата
Msg-id 26856.1170473322@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dumpall failure - could not access status of transaction  ("Robert Leftwich" <pg@rtl.fmailbox.com>)
Ответы Re: pg_dumpall failure - could not access status of transaction  ("Robert Leftwich" <pg@rtl.fmailbox.com>)
Список pgsql-admin
"Robert Leftwich" <pg@rtl.fmailbox.com> writes:
> On Fri, 02 Feb 2007 21:21:47 -0500, "Tom Lane" <tgl@sss.pgh.pa.us> said:
>> Also, can you show us the pg_filedump output for the page of
>> pg_description you think is trashed?  I find "-i -f" options give
>> the most useful output usually.

> [ dump snipped ]

Yeah, the last part of that page has been trashed --- mostly zeroes, but
there's a bit with an odd data pattern that doesn't make much sense to
me:

>   1a3c: d09b3000 b89b3000 a09b3000 889b3000  ..0...0...0...0.
>   1a4c: 709b3000 589b3000 409b3000 289b3000  p.0.X.0.@.0.(.0.
>   1a5c: 109b3000 f89a3000 e09a3000 c89a3000  ..0...0...0...0.
>   1a6c: b09a3000 989a3000 809a3000 689a3000  ..0...0...0.h.0.

This seems like it could indicate either a hardware or operating-system
flake-out.  Have you tried running hardware diagnostic tests on the
machine?

            regards, tom lane

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

Предыдущее
От: "Robert Leftwich"
Дата:
Сообщение: Re: pg_dumpall failure - could not access status of transaction
Следующее
От: "Robert Leftwich"
Дата:
Сообщение: Re: pg_dumpall failure - could not access status of transaction