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.

Prefect Community

Hi <@ULVA73B9P>
We are using prefect version 3.2.0
We have prefect tables in postgrasql database,
in postgrasql database I can see lot of deadlock on table task_run.
I drop the constraint fk_task_run__state_id__task_run_state, after droping I can see the error in database log
2025-08-22 09:20:32 UTC:10.8.3.12(52642):water_admin@prefect:[17776]:ERROR: insert or update on table "task_run" violates foreign key constraint "fk_task_run__flow_run_id__flow_run"
I drop this fk also.
But still I can see the dead lock we have 109721702 records in task_run table.
what is the solution for this.
Slack Conversation

This was fixed in <https://github.com/PrefectHQ/prefect/pull/18302>

Which is included in Prefect 3.4.7. You will need to upgrade your server from 3.2.0 to 3.4.7 to have this fix applied.