Re: BRIN index bug due to WAL refactoring - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: BRIN index bug due to WAL refactoring
Date
Msg-id 20150626183524.GS3289@postgresql.org
Whole thread Raw
In response to BRIN index bug due to WAL refactoring  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: BRIN index bug due to WAL refactoring  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
Jeff Janes wrote:

> On replica:
>
> set enable_seqscan TO off;
> explain (analyze) select count(*) from foobar ;
> ERROR:  corrupted BRIN index: inconsistent range map

Nice.  As I understand it, the problem is that the replay is using the
block number of the revmap page as target blkno of the revmap entry,
when it should be using the block number of the data page.  This should
fix it.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: PANIC in GIN code
Next
From: Fabien COELHO
Date:
Subject: Re: Re: Let PostgreSQL's On Schedule checkpoint write buffer smooth spread cycle by tuning IsCheckpointOnSchedule?