Re: BUG #13895: Hot Standby locked replaying auto vacuum against pg_catalog.pg_statistics

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: BUG #13895: Hot Standby locked replaying auto vacuum against pg_catalog.pg_statistics
Дата
Msg-id m2fuxhn8oc.fsf@2ndQuadrant.fr
обсуждение исходный текст
Ответ на Re: BUG #13895: Hot Standby locked replaying auto vacuum against pg_catalog.pg_statistics  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-bugs
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> replay process to take some time.  It is strange that it would be locked
> for long enough to allow for manually querying pg_locks and
> pg_stat_activity.

We restarted the standby after maybe 35 mins of application downtime due
to the incident=E2=80=A6 the diagnostic and restart did happen a tad late i=
n the
process on that ocasion, as it sometimes happens.

So the lock has been kept about that long.
--=20
Dimitri Fontaine                                        06 63 07 10 78
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #13895: Hot Standby locked replaying auto vacuum against pg_catalog.pg_statistics
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #13896: Current docs says 'worker_spi' is a contrib