Hi, in postgres db we are using, we are frequently getting issue with table locks with such queries. Can someone help what might be reason?
Prefect version 2.8.4
Copy code
UPDATE task_run SET updated=CURRENT_TIMESTAMP, state_type=$1, state_name=$2::varchar, state_timestamp=$3::timestamp with time zone, end_time=$4::timestamp with time zone, total_run_time=$5::interval, state_id=$6::uuid WHERE task_run.id = $7::uuid RETURNING task_run.updated
Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.