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-25 06:24:08
Message-ID: 87h9dmhczb.fsf@credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2016-05-25 07:11:18 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”
Previous Message Pavel Stehule 2016-05-25 05:04:25 Re: Does people favor to have matrix data type?