Hi, on prefect 1.x could you confirm when task run state is updated in the core prefect database. I'd like to understand if we have an agent failure/restart what would happen to "in-flight" workflows - would the agent be able to process the workflow from where it left off (re-running the last task run)

Depends on the agent. If you are using a containerized Flow, it might still be untouched and fine. If the Flow fails though, there should be checkpointing so you can just restart it

Ran some tests on checkpointing and that might be very useful 👍