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

From: Andreas Seltenreich <seltenreich(at)gmx(dot)de>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [sqlsmith] PANIC: failed to add BRIN tuple
Date: 2016-05-24 23:40:49
Message-ID: 87lh2zgh32.fsf@credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera writes:

> How long does it take for you to reproduce this panic in the unpatched
> code?

Very long, I'm afraid. I only observed it once, and according to the
logging database, about 4e9 random queries were generated since testing
with 9.5 code.

I could probably speed it up by creating lots of additional BRIN indexes
in the regression database, and by compiling a sqlsmith that generates
update statements only.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-05-25 00:08:27 Re: BUG #14155: bloom index error with unlogged table
Previous Message Alvaro Herrera 2016-05-24 23:13:04 Re: [sqlsmith] PANIC: failed to add BRIN tuple