Re: [sqlsmith] PANIC: failed to add BRIN tuple

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [sqlsmith] PANIC: failed to add BRIN tuple
Дата
Msg-id 20160524231304.GA471539@alvherre.pgsql
обсуждение исходный текст
Ответ на [sqlsmith] PANIC: failed to add BRIN tuple  (Andreas Seltenreich <seltenreich@gmx.de>)
Ответы Re: [sqlsmith] PANIC: failed to add BRIN tuple  (Andreas Seltenreich <seltenreich@gmx.de>)
Список 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

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: To-Do item: skip table scan for adding column with provable check constraints
Следующее
От: Andreas Seltenreich
Дата:
Сообщение: Re: [sqlsmith] PANIC: failed to add BRIN tuple