Home:ALL Converter>PostgreSQL: canceling statement due to conflict with recovery

PostgreSQL: canceling statement due to conflict with recovery

Ask Time:2018-10-24T15:12:14         Author:Ketan Modi

Json Formatter

I fetch this error in my code , and my database is on AWS RDS instance.

OperationalError: canceling statement due to conflict with recovery DETAIL: User was holding shared buffer pin for too long.

and i found solution to change value of

max_standby_archive_delay = -1
max_standby_streaming_delay = -1  

But AWS is not allow me to change those values . is there any other way to solve this error.

enter image description here

Author:Ketan Modi,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/52962936/postgresql-canceling-statement-due-to-conflict-with-recovery
yy