Request a Demo
Home   >   mailing lists

Reference to - BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker - Mailing list pgsql-bugs

From Craig Milhiser
Subject Reference to - BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker
Date
Msg-id CA+wnhO1OfgXbmXgC4fv_uu=OxcDQuHvfoQ4k0DFeB0Qqd-X-rQ@mail.gmail.com
Whole thread Raw
Responses Re: Reference to - BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker
List pgsql-bugs
Tree view
Has the referenced bug in this discussion[1] been released? The discussion mentions it was fixed. I read the release notes but do not recognize this fix as documented. I do not want to hijack that thread.

I am using v16.3 - AWS Aurora. I have opened a support case with AWS also.

I have 4 queries that get this error message. The symptoms are the same - thousands of temp files are created before the error is returned. Just because I am getting the same error/symptoms does not mean it is the same problem. If the fix has been released I can check against the AWS Aurora version with their support staff.

I investigated one of the queries so far. When I turn off parallel execution this query completes.

I am working on a reproducible example to send to the community. The query is sensitive to the values in the predicates. Most of the time these queries work.  So far, I have not been able to get an MRE but still working on it.

Thanks
Craig

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18627: Regression (15 -> 16) - Join removal not performed when join condition spans multiple tables
Next
From: David Rowley
Date:
Subject: Re: BUG #18627: Regression (15 -> 16) - Join removal not performed when join condition spans multiple tables