Re: [sqlsmith] Failed assertions on parallel worker shutdown

From: Andreas Seltenreich <seltenreich(at)gmx(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [sqlsmith] Failed assertions on parallel worker shutdown
Date: 2016-05-23 08:49:15
Message-ID: 87vb255fck.fsf@elite.ansel.ydns.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
plans.tar.gz application/gzip 45.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2016-05-23 09:19:09 PATCH: Batch/pipelining support for libpq
Previous Message Amit Kapila 2016-05-23 04:03:22 Re: [sqlsmith] Failed assertion in parallel worker (ExecInitSubPlan)