| From: | Jonathan Rudenberg <jonathan(at)titanous(dot)com> |
|---|---|
| To: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Andreas Seltenreich <seltenreich(at)gmx(dot)de>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [sqlsmith] Unpinning error in parallel worker |
| Date: | 2018-04-17 23:01:05 |
| Message-ID: | 1524006065.2172367.1341656968.532A8113@webmail.messagingengine.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Apr 17, 2018, at 18:38, Thomas Munro wrote:
> I don't have any theories about how that could be going wrong right
> now, but I'm looking into it.
Thank you!
> > I don't have a backtrace yet, but I will provide them if/when the issue happens again.
>
> Thanks, that would be much appreciated, as would any clues about what
> workload you're running. Do you know what the query plan looks like
> for the queries that crashed?
Yep, I think I know approximately what it looked like, I've attached a lightly redacted plan. All of the hung queries were running some variant of this plan as far as I can tell.
Thanks again!
Jonathan
| Attachment | Content-Type | Size |
|---|---|---|
| dsa_hang_plan.txt | text/plain | 19.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2018-04-17 23:31:33 | Re: [sqlsmith] Unpinning error in parallel worker |
| Previous Message | Thomas Munro | 2018-04-17 22:38:14 | Re: [sqlsmith] Unpinning error in parallel worker |