conflict with recovery when delay is gone

Поиск
Список
Период
Сортировка
От Radoslav Nedyalkov
Тема conflict with recovery when delay is gone
Дата
Msg-id CANhtRiaq+HPmgPiRKM6hHTzLp7kAqjP96o2+2QUZVMHP=qnqug@mail.gmail.com
обсуждение исходный текст
Ответы Re: conflict with recovery when delay is gone  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
Дерево обсуждения
Hi Forum,all
On a very busy master-standby setup which runs typical olap processing -
long living , massive writes statements,  we're getting on the standby:

 ERROR:  canceling statement due to conflict with recovery
 FATAL:  terminating connection due to conflict with recovery

The weird thing is that cancellations happen usually after standby has experienced 
some huge delay(2h), still not at the allowed maximum(3h). Even recently run statements
got cancelled when the delay is already at zero.

Sometimes the situation got relaxed after an hour or so.
Restarting the server instantly helps.

It is pg11.8, centos7, hugepages, shared_buffers 196G from 748G.

What phenomenon could we be facing?

Thank you,
Rado

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

Предыдущее
От: Dennis Jacobfeuerborn
Дата:
Сообщение: "invalid record length" after restoring pg_basebackup
Следующее
От: Jeremy Wilson
Дата:
Сообщение: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist"