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 Raw
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
<div dir="ltr">Hi,<br /><br />> the following query appears to reliably crash parallel workers on master<br />>
asof 0832f2d.<br />><br />> --8<---------------cut here---------------start------------->8---<br />> set
max_parallel_workers_per_gatherto 2;<br />> set force_parallel_mode to 1;<br />><br />> select subq.context
frompg_settings,<br />>     lateral (select context from pg_opclass limit 1) as subq<br />> limit 1;<br />>
--8<---------------cuthere---------------end--------------->8---<br /><br />As suggested, I have tried to
reproducethis issue on <b>0832f2d</b> commit but could not reproduce it. I also tried it on the latest commit in master
branchand could not reproduce here as well. Amit (included in this email thread) has also tried it once and he was also
notable to reproduce it. Could you please let me know if there is something more that needs to be done in order to
reproduceit other than what you have shared above. Thanks.<br /><br />With Regards,<br />Ashutosh Sharma.<br
/>EnterpriseDB:<a href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br /></div> 

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