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
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
