Re: ERROR: could not attach to dynamic shared area - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: could not attach to dynamic shared area
Date
Msg-id 1100686.1616602368@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: could not attach to dynamic shared area  (Albrecht Dreß <albrecht.dress@netcologne.de>)
List pgsql-general
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> On Wed, 2021-03-24 at 09:01 +0100, Albrecht Dreß wrote:
>> in the logs of my database server, I found the following message:
>>> ERROR: could not attach to dynamic shared area
>>> LOG: background worker "parallel worker" (PID 51151) exited with exit code 1

> ... 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.

If the error only appeared in the log, and wasn't reported to the
client, then this theory seems pretty plausible.

            regards, tom lane



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: No enough privileges for autovacuum worker
Next
From: Carlos Montenegro
Date:
Subject: Hello - About how to install PgAdmin4 on Debian 10