Am 24.03.21 17:09 schrieb(en) Laurenz Albe:
> > ERROR: could not attach to dynamic shared area > > LOG: background worker "parallel worker" (PID 51151) exited with exit code 1 Is that repeatable?
No, it isn't. I'm running PGSql 13 since ~4 Months (cluster upgraded from v. 10), and updated to 13.2 ~four weeks ago. The error occurred exactly /once/.
If not, it could be a race condition: a parallel query finished rather fast, but one of the parallel workers took long to start up, so when it tries to attach to the dynamic shared memory segment used to exchange data between the parallel processes, it realizes that everybody else has already left and destroyed the memory segment.
That makes sense! The triggering statement I found in the log performs a quite complex join, typically returning very few records. And the calling application (using libpq) did *not* receive any error.
In the latter case, you can ignore the error.
Good to know that! Thanks a lot for your fast help, Albrecht.
Attachment:
pgpP8D5kE8GUl.pgp
Description: PGP signature
