After migrating to Azure DevOps Server 2019, I got stuck when trying to reconfigure a XAML build controller. Instead of replacing an existing build controller I got an error explaining that the build controller I was using had still a build in progress.
Time to dig into the Azure DevOps database to found out what build I should cancel…
The ‘go to’ table is tbl_BuildQueue. Every build in the queue has a status.
Here are all the statuses for tbl_BuildQueue
- 0 – None
- 1 – In progress
- 2 – Queued
- 4- Postponed
- 8 – Completed
- 16 – Cancelled
Create an update query that set all ‘In progress’ builds to Canceled:
UPDATE tbl_BuildQueue SET [Status]=16 where [Status]=1
If this doesn’t help you can also check the tbl_Build table.
Here are all the statuses for tbl_Build:
- 1 – In progress
- 2 – Succeeded
- 4- Partially Succeeded
- 8 – Failed
- 16 – Stopped
Let’s update the builds here as well:
UPDATE tbl_Build SET [BuildStatus]=16 where [Status]=1