Re: [sqlsmith] PANIC: failed to add BRIN tuple - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: [sqlsmith] PANIC: failed to add BRIN tuple
Date
Msg-id 20160524231304.GA471539@alvherre.pgsql
Whole thread Raw
In response to [sqlsmith] PANIC: failed to add BRIN tuple  (Andreas Seltenreich <seltenreich@gmx.de>)
Responses Re: [sqlsmith] PANIC: failed to add BRIN tuple
List pgsql-hackers
Andreas Seltenreich wrote:
> There was one instance of this PANIC when testing with the regression db
> of master at 50e5315.
>
> ,----
> | WARNING:  specified item offset is too large
> | PANIC:  failed to add BRIN tuple
> | server closed the connection unexpectedly
> `----
>
> It is reproducible with the query below on this instance only.  I've put
> the data directory (20MB) here:
>
>     http://ansel.ydns.eu/~andreas/brincrash.tar.xz
>
> The instance was running on Debian Jessie amd64.  Query and Backtrace
> below.

How long does it take for you to reproduce this panic in the unpatched
code?  This patch fixes the immediate problem, but it'd be good if the
bug is fixed more generally.

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

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: To-Do item: skip table scan for adding column with provable check constraints
Next
From: Andreas Seltenreich
Date:
Subject: Re: [sqlsmith] PANIC: failed to add BRIN tuple