Re: BRIN indexes - TRAP: BadArgument

On Sun, Nov 9, 2014 at 10:30 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> On Sat, Nov 8, 2014 at 4:56 AM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> wrote:
>>
>> I just pushed this, after some more minor tweaks.
>
> Nice!
>
>> Thanks, and please do continue testing!
>
> I got the following PANIC error in the standby server when I set up
> the replication servers and ran "make installcheck". Note that I was
> repeating the manual CHECKPOINT every second while "installcheck"
> was running. Without the checkpoints, I could not reproduce the
> problem. I'm not sure if CHECKPOINT really triggers this problem, though.
> Anyway BRIN seems to have a problem around its WAL replay.
>
> 2014-11-09 22:19:42 JST sby1 WARNING: page 547 of relation
> base/16384/30878 does not exist
> 2014-11-09 22:19:42 JST sby1 CONTEXT: xlog redo BRIN/UPDATE: rel
> 1663/16384/30878 heapBlk 6 revmapBlk 1 pagesPerRange 1 old TID (3,2)
> TID (547,2)
> 2014-11-09 22:19:42 JST sby1 PANIC: WAL contains references to invalid pages
> 2014-11-09 22:19:42 JST sby1 CONTEXT: xlog redo BRIN/UPDATE: rel
> 1663/16384/30878 heapBlk 6 revmapBlk 1 pagesPerRange 1 old TID (3,2)
> TID (547,2)
> 2014-11-09 22:19:47 JST sby1 LOG: startup process (PID 15230) was
> terminated by signal 6: Abort trap
> 2014-11-09 22:19:47 JST sby1 LOG: terminating any other active server processes
>

I could reproduce this using the same steps. It's the same page 547
here too if that's any helpful.

Thanks,
Amit