Re: ERROR: could not attach to dynamic shared area

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: could not attach to dynamic shared area
Дата
Msg-id 1100686.1616602368@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ERROR: could not attach to dynamic shared area  (Albrecht Dreß <albrecht.dress@netcologne.de>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: No enough privileges for autovacuum worker
Следующее
От: Carlos Montenegro
Дата:
Сообщение: Hello - About how to install PgAdmin4 on Debian 10