Postgres Pro
Downloads
Home   >   mailing lists

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

From Andreas Seltenreich
Subject Re: [sqlsmith] PANIC: failed to add BRIN tuple
Date
Msg-id 87lh2zgh32.fsf@credativ.de
Whole thread Raw
In response to Re: [sqlsmith] PANIC: failed to add BRIN tuple  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: [sqlsmith] PANIC: failed to add BRIN tuple  (Andreas Seltenreich <seltenreich@gmx.de>)
List pgsql-hackers
Tree view 
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.

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [sqlsmith] PANIC: failed to add BRIN tuple
Next
From: Robert Haas
Date:
Subject: Re: new tests post-feature freeze (was pgsql: Add TAP tests for pg_dump)