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-22 16:08:19
Message-ID: 87a8ji6pos.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:

avoid_restricted_clause_below_gather_v1.patch
Message-ID: <CAA4eK1Ky2=HsTsT4hmfL=EAL5rv0_t59tvWzVK9HQKvN6Dovkw(at)mail(dot)gmail(dot)com>

prohibit_parallel_clause_below_rel_v1.patch
Message-ID: <CAA4eK1L-Uo=s4=0jvvVA51pj06u5WdDvSQg673yuxJ_Ja+x86Q(at)mail(dot)gmail(dot)com>

I guess these failed assertions are fallout from the workers executing
forbidden plans without the patches.

regards,
Andreas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2016-05-22 16:36:44 Re: Parallel query
Previous Message Andreas Seltenreich 2016-05-22 16:02:14 Re: [sqlsmith] Failed assertion in parallel worker (ExecInitSubPlan)