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

[diegosantos]

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 solution]

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-statemen...

[diegosantos]

Hi @apathetichell 

Thank you for your aswner.

Unfourtuly the database's owner ins't my organization, so i can't modify those parameters.

After several tests, i realized that where clause in the dymanic input was the problem. I don't know why, but after remove it, it worked fine. In this case i used replace string.