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

From Andreas Seltenreich
Subject Re: [sqlsmith] Parallel worker crash on seqscan
Date
Msg-id 87r3645vlv.fsf@ex.ansel.ydns.eu
Whole thread Raw
In response to Re: [sqlsmith] Parallel worker crash on seqscan  (Ashutosh Sharma <ashu.coek88@gmail.com>)
Responses Re: [sqlsmith] Parallel worker crash on seqscan
List pgsql-hackers
Hi,

Ashutosh Sharma writes:

>> the following query appears to reliably crash parallel workers on master
>> as of 0832f2d.

> As suggested, I have tried to reproduce this issue on *0832f2d* commit but
> could not reproduce it.

as Tom pointed out earlier, I had secretly set parallel_setup_cost and
parallel_tuple_cost to 0.  I assumed these were irrelevant when
force_parallel_mode is on.  I'll do less assuming and more testing on a
vanilla install on future reports.

Sorry for the inconvenience,
Andreas



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: WIP: multivariate statistics / proof of concept
Next
From: Robert Haas
Date:
Subject: Re: [sqlsmith] Parallel worker crash on seqscan