Hi, in postgres db we are using, we are frequently...
# ask-community
a
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
Hi, can someone please help with this?