Re: canceling statement coming in slave instance

Rohit Arora wrote:
> I occasionally encounter below error.
>
> ERROR: canceling statement due to conflict with recovery
> DETAIL: User was holding a relation lock for too long
>
> While investigating online i came to know that this issue can be handled by below configuration parameters
>
> "max_standby_archive_delay "
> "max_standby_streaming_delay"
>
> I have increased the value of both the parameters as per below.
>
> Current values:
> "max_standby_archive_delay=30s" ----> was increased it to 300s but we did not get any benefit so we rollback it to original value
> "max_standby_streaming_delay=300s"
>
> But still i occasionally encounter the mention issue.

You'd have to set max_standby_streaming_delay to -1 to avoid the
error completely. But bear in mind that it can delay replication
arbitrarily long.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com