Re: [BUGS] 9.6rc1 Background worker starting multiple times

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [BUGS] 9.6rc1 Background worker starting multiple times
Дата
Msg-id CAB7nPqTrRjdcV_e4gJdNRqgHSdoX15vVwMqGpukFU6AfdS8mqg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [BUGS] 9.6rc1 Background worker starting multiple times  (Keith Fiske <keith@omniti.com>)
Ответы Re: [BUGS] 9.6rc1 Background worker starting multiple times  (Keith Fiske <keith@omniti.com>)
Список pgsql-bugs
On Tue, Dec 20, 2016 at 6:47 AM, Keith Fiske <keith@omniti.com> wrote:
> I'm not quite sure exactly how to debug this further to see what is actually
> setting the latch in 9.6.

The commit you are complaining about here is likely this one:
commit: db0f6cad4884bd4c835156d3a720d9a79dbd63a9
author: Robert Haas <rhaas@postgresql.org>
date: Fri, 9 Oct 2015 14:31:04 -0400
Remove set_latch_on_sigusr1 flag.

This flag has proven to be a recipe for bugs, and it doesn't seem like
it can really buy anything in terms of performance.  So let's just
*always* set the process latch when we receive SIGUSR1 instead of
trying to do it only when needed.

So your process gets a SIGUSR1 and its latch is set, causing the loop
to repeat... I would discard that as a backend bug, because the
removal of set_latch_on_sigusr1 was a good move.
-- 
Michael


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: Keith Fiske
Дата:
Сообщение: Re: [BUGS] 9.6rc1 Background worker starting multiple times
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: [BUGS] Crash with a CUBE query on 9.6