Re: 9.4 checksum errors in recovery with gin index

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: 9.4 checksum errors in recovery with gin index
Дата
Msg-id 20140507074856.GD22053@awork2.anarazel.de
обсуждение исходный текст
Ответ на 9.4 checksum errors in recovery with gin index  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: 9.4 checksum errors in recovery with gin index
Список pgsql-hackers
Hi,

On 2014-05-07 00:35:35 -0700, Jeff Janes wrote:
> When recovering from a crash (with injection of a partial page write at
> time of crash) against 7c7b1f4ae5ea3b1b113682d4d I get a checksum
> verification failure.
> 
> 16396 is a gin index.

Over which type? What was the load? make check?

> If I have it ignore checksum failures, there is no apparent misbehavior.
>  I'm trying to bisect it, but it could take a while and I thought someone
> might have some theories based on the log:

If you have the WAL a pg_xlogdump grepping for everything referring to
that block would be helpful.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: 9.4 checksum errors in recovery with gin index
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: postgresql.auto.conf read from wrong directory