public inbox for [email protected]  

help / color / mirror / Atom feed

From: Abhishek Prakash <[email protected]>
To: [email protected] <[email protected]>
To: [email protected] <[email protected]>
To: [email protected] <[email protected]>
Subject: ***Conflict with recovery error***
Date: Fri, 20 Jan 2023 08:56:49 +0000
Message-ID: <SI2PR02MB5490F6959EF4B92A9CC41C2681C59@SI2PR02MB5490.apcprd02.prod.outlook.com> (raw)

Hi Team,

Hope you guys are doing good.

We are facing below issue with read replica we did work arounds by setting hot_standby_feedback, max_standby_streaming_delay and max_standby_archive_delay, which indeed caused adverse effects on primary DB and storage. As our DB is nearly 6 TB which runs as AWS Postgres RDS.

Even the below error occurs on tables where vacuum is disabled and no DML operations are permitted. Will there be any chances to see row versions being changed even if vacuum is disabled.
Please advise.

2023-01-13 07:20:12 UTC:10.64.103.75(61096):ubpreplica@ubprdb01:[17707]:ERROR:  canceling statement due to conflict with recovery
2023-01-13 07:20:12 UTC:10.64.103.75(61096):ubpreplica@ubprdb01:[17707]:DETAIL:  User query might have needed to see row versions that must be removed.

Thanks & Regards,
Abhishek P

view thread (2+ messages)

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], [email protected], [email protected]
  Subject: Re: ***Conflict with recovery error***
  In-Reply-To: <SI2PR02MB5490F6959EF4B92A9CC41C2681C59@SI2PR02MB5490.apcprd02.prod.outlook.com>

* 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