Re: [sqlsmith] Failed assertions on parallel worker shutdown - Mailing list pgsql-hackers

From Andreas Seltenreich
Subject Re: [sqlsmith] Failed assertions on parallel worker shutdown
Date
Msg-id 87vb255fck.fsf@elite.ansel.ydns.eu
Whole thread Raw
In response to Re: [sqlsmith] Failed assertions on parallel worker shutdown  (Andreas Seltenreich <seltenreich@gmx.de>)
Responses Re: [sqlsmith] Failed assertions on parallel worker shutdown  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
I wrote:
>> There's another class of parallel worker core dumps when testing master
>> with sqlsmith.  In these cases, the following assertion fails for all
>> workers simulataneously:
>>
>> TRAP: FailedAssertion("!(mqh->mqh_partial_bytes <= nbytes)", File: "shm_mq.c", Line: 386)
>
> I no longer observe these after applying these two patches by Amit
> Kapila

I spoke too soon: These still occur with the patches applied, but with
much lower probability. (one core dump per 20e6 random queries instead
of 1e6).

Most of the collected plans look inconspicuous to me now, except for one
that again had a subplan below a gather node (plan6).  Tarball of all
collected plans attached.

regards,
Andreas


Attachment

pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: new tests post-feature freeze (was pgsql: Add TAP tests for pg_dump)
Next
From: Craig Ringer
Date:
Subject: PATCH: Batch/pipelining support for libpq