Deal with Postgresql Error -canceling statement due to conflict with recovery

Question

Hi guys,

I'm using a Dynamic Input with CTE (Common Table Expression), and i'm getting this error:

I noticed there are 3 execution of Dynamic input, the first 2 with same quantity of record and the last one with 1  plus record. First off all i don't know why the tool is executed 3 times, and the last one with one plus record.

Is there something that i can do to avoid this error? Someone can help me?

apathetichell · Accepted Answer

Google says modify this:

max_standby_streaming_delay/max_standby_archive_delay:

in your driver config

https://stackoverflow.com/questions/59842917/how-i-can-manually-trigger-the-error-canceling-statement-due-to-conflict-with-r