Build Project agent dedication is not unassigned when the build project is DELETED

When a Build Project is deleted in Bamboo and the build project is dedicated to an agent, the agent remains in dedicated state and does not get unassigned. This prevents the agent not able to take up any more build or deployment jobs.

The issue happens only with build project dedication.

NOTE: Dedication set for build plans, build jobs, deployment projects and deployment environment are not impacted where the agent dedication is unassigned when the above resources are deleted in bamboo instance.

Steps to Reproduce:

1. Create a build project in bamboo.
2. Dedicate the build project to an agent.
3. Delete the build project.
4. The agent remains dedicated state.

In the database, the assignment entry does not get removed from the 'agent_assignment' table. However, the 'project_id' it refers to in the 'project' table is removed.

In the agent audit logs we do not see any 'unassigned' event which can be seen in similar scenario with build jobs, build plans, deployment environment and deployment projects. Navigate to Bamboo Administration > Agents > select the problematic agent > click on Audit logs.

Expectation:

The assignment entry should be removed from the 'agent_assignment' table once the dedicated project is deleted in bamboo.

Workaround:

Delete the agent and create a new agent.

OR

Delete the entry from the 'agent_assignment' table.