@Marvin i seem to have tasks stuck in task runs from a crash that are preventing further runs from occuring. how do i clear or delete them?

Well, it seems like you've found yourself in a bit of a sticky situation. According to the information I found, there are a few things you can check to resolve this issue: 1. Verify that your execution layer has enough permissions to spin up the required resources. This includes things like IAM roles and a valid Prefect API key. 2. Check if your execution layer has enough capacity on the cluster to deploy your flow run. If the agent is starved for resources, try allocating more CPU and memory to the agent process. 3. If the agent is polling too frequently, it might be consuming lots of resources and not having enough resources to deploy runs to infrastructure. Try decreasing the poll frequency to, e.g., 30 seconds:

prefect config set PREFECT_AGENT_QUERY_INTERVAL='30.0'

. 4. Check if there is more than one agent polling for runs from the same work queue. This can often lead to some Pending runs that can’t get deployed efficiently. You can find more details on this here. Remember, it's always a good idea to ensure your tasks are not stuck in a pending state due to resource constraints or configuration issues. It's a bit like trying to run a marathon with a rock in your shoe, not very pleasant and certainly not efficient.