Re: Slave server sometimes locks up

Поиск
Список
Период
Сортировка
От Boris Sagadin
Тема Re: Slave server sometimes locks up
Дата
Msg-id CAEzn=HSktUN-T_o4C9+92j0U9OkFtiyQz29uDwy__Feb7jm5vw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Slave server sometimes locks up  (Thomas Munro <thomas.munro@gmail.com>)
Список pgsql-general
Hi Thomas,

thank you for your quick reply, much appreciated.

1. "dsa_area could not attach to segment": dsm.c, fixed in commit 6c0fb941.
2. "cannot unpin a segment that is not pinned": dsm.c, fixed in commit 0b55aaac.


Yes, I found both entries in our logs, each once per incident.
 
The fix will be included in the next set of releases, but in the
meantime you could consider turning off parallel query (set
max_parallel_workers_per_gather = 0).  In practice I think you could
also avoid this problem by loading a library that calls something like
srandom(getpid()) in _PG_init() (so it runs in every parallel worker
making ID collisions extremely unlikely), but that's not really a
serious recommendation since it requires writing C code.


This is very reassuring, as I was slowly starting to doubt my DBA competence here. :)
I'll try this workaround until the next release is out, will report if anything out of ordinary re-occurs.

Boris

 

В списке pgsql-general по дате отправления:

Предыдущее
От: Rory Campbell-Lange
Дата:
Сообщение: Server upgrade advice
Следующее
От: Kenneth Marshall
Дата:
Сообщение: Re: Server upgrade advice