Re: Parallel query hangs after a smart shutdown is issued

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Parallel query hangs after a smart shutdown is issued
Дата
Msg-id 398962.1597294682@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Parallel query hangs after a smart shutdown is issued  (Thomas Munro <thomas.munro@gmail.com>)
Ответы Re: Parallel query hangs after a smart shutdown is issued  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Thomas Munro <thomas.munro@gmail.com> writes:
> Makes sense.  I tested this version on a primary and a replica and
> verified that parallel workers launch, but I saw that autovacuum
> workers still can't start without something like this:

> @@ -2463,7 +2463,8 @@ canAcceptConnections(int backend_type)
>          * be returned until we have checked for too many children.
>          */
>         if (smartShutState != SMART_NORMAL_USAGE &&
> -               backend_type != BACKEND_TYPE_BGWORKER)
> +               backend_type != BACKEND_TYPE_BGWORKER &&
> +               backend_type != BACKEND_TYPE_AUTOVAC)

Hmmm ... maybe that should be more like

        if (smartShutState != SMART_NORMAL_USAGE &&
            backend_type == BACKEND_TYPE_NORMAL)

(the adjacent comment needs adjustment too of course).

            regards, tom lane



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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: Parallel query hangs after a smart shutdown is issued
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: [bug+patch] Inserting DEFAULT into generated columns from VALUES RTE