public inbox for [email protected]
help / color / mirror / Atom feedFrom: Will Storey <[email protected]>
To: [email protected]
Subject: Cancelled query due to buffer deadlock with recovery
Date: Sun, 8 Dec 2024 16:42:38 -0800
Message-ID: <[email protected]> (raw)
Hello!
I am running Postgres 16.6 on a primary and several standby servers. I
recently observed 3 queries being cancelled with this error:
ERROR: canceling statement due to conflict with recovery (SQLSTATE 40P01)
There was this detail with the error:
User transaction caused buffer deadlock with recovery
The standbys have hot_standby_feedback=on and
max_standby_streaming_delay=1min.
As far as I can tell, there were no long running transactions at the time
on either the primary or the standby in question. I did not see any
replication delay according to monitoring.
The queries that were cancelled were reading catalog tables - pg_inherits
joined with pg_class. I typically expect them to complete quickly (they
have a 100ms statement timeout).
I understand that canceling due to conflicts should be expected when using
hot standbys, but I'm struggling to understand why it happened in this
case.
What do you think?
Thank you!
Will
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Cancelled query due to buffer deadlock with recovery
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox