Re: [sqlsmith] Parallel worker crash on seqscan - Mailing list pgsql-hackers

From Ashutosh Sharma
Subject Re: [sqlsmith] Parallel worker crash on seqscan
Date
Msg-id CAE9k0PnquYymw6cx0wEtJ0ULzzXuUUtn+sYWh_4eimg+TUsEVg@mail.gmail.com
Whole thread
In response to [sqlsmith] Parallel worker crash on seqscan  (Andreas Seltenreich <seltenreich@gmx.de>)
Responses Re: [sqlsmith] Parallel worker crash on seqscan
List pgsql-hackers
Hi,

> the following query appears to reliably crash parallel workers on master
> as of 0832f2d.
>
> --8<---------------cut here---------------start------------->8---
> set max_parallel_workers_per_gather to 2;
> set force_parallel_mode to 1;
>
> select subq.context from pg_settings,
>     lateral (select context from pg_opclass limit 1) as subq
> limit 1;
> --8<---------------cut here---------------end--------------->8---

As suggested, I have tried to reproduce this issue on 0832f2d commit but could not reproduce it. I also tried it on the latest commit in master branch and could not reproduce here as well. Amit (included in this email thread) has also tried it once and he was also not able to reproduce it. Could you please let me know if there is something more that needs to be done in order to reproduce it other than what you have shared above. Thanks.

With Regards,
Ashutosh Sharma.
EnterpriseDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: condition variables
Next
From: Etsuro Fujita
Date:
Subject: Re: Push down more full joins in postgres_fdw