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 87h9dmhczb.fsf@credativ.de
Whole thread Raw
In response to Re: [sqlsmith] PANIC: failed to add BRIN tuple  (Andreas Seltenreich <seltenreich@gmx.de>)
Responses Re: [sqlsmith] PANIC: failed to add BRIN tuple  (Andreas Seltenreich <seltenreich@gmx.de>)
List pgsql-hackers
Tree view 
I wrote:
> Alvaro Herrera writes:
>> How long does it take for you to reproduce this panic in the unpatched
>> 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.

This actually worked.  Sqlsmith triggered the BRIN panic twice in 80e6
queries (vs. onece in 4e9 before).  I pushed the modified version on the
branch "modify-heavy".  Re-fuzzing now with your patch applied.

andreas

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Does people favor to have matrix data type?
Next
From: Amit Kapila
Date:
Subject: Re: [HACKERS] Re: [HACKERS] Re: [HACKERS] Re: [HACKERS] Windows service is not starting so there’s message in log: FATAL: "could not create shared memory segment “Global/PostgreSQL.851401618”: Permission denied”