Re: BUG #16104: Invalid DSA Memory Alloc Request in Parallel Hash

Tomas Vondra <tomas.vondra@2ndquadrant.com>

From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>, Andres Freund <andres@anarazel.de>, James Coleman <jtc331@gmail.com>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Date: 2019-12-14T13:39:12Z
Lists: pgsql-bugs
On Sat, Dec 14, 2019 at 05:01:05PM +1300, Thomas Munro wrote:
>On Wed, Dec 11, 2019 at 6:32 AM Tomas Vondra
><tomas.vondra@2ndquadrant.com> wrote:
>> The annoying thing is that it's the workers that crash, and the leader
>> failed to notice that, so it was waiting in WaitForParallelWorkersToExit
>> forever. Not sure what the issue is.
>
>That's bad.  Some edge case in
>WaitForBackgroundWorkerShutdown()/GetBackgroundWorkerPid() that is
>b0rked perhaps?  Can you reproduce it, and tell us what the stack
>looks like, maybe on a new thread?

Sure. I'll try reproducing it and get this extra info. I was planning to
do that, but then I lost the data for the report because of a silly
mistake. Early next week, hopefully.

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services 



Commits

  1. Rotate instead of shifting hash join batch number.