Deepak Kumar Mishra, Support Engineer, EMEA TFS team brings this known issue in TFS 2015 Update 1 with the v-next build system. Details follow:
When we enable or disable Auto-Provision Queues in Default agent pool in TFS 2015 Update 1, we get the following error. I created a new Agent pool and also a new agent and tried the same and that works fine.
It is an issue with Default agent pool only.
500:The update statement conflicted with the CHECK constraint "CK_Task_tbl_AgentPool_Provisioned". The conflict occurred in database "TFS_Configuration", table "Task.tbl_AgentPool", column "Provisioned".
This issue has been identified as a bug in TFS 2015 Update 1 by our product group and would be resolved in the next update of TFS.The work around here will be to create a new agent pool and new agents in it and it works absolutely fine for builds. The Auto-provision option also works well in this case.
Written by: Deepak Kumar Mishra, Support Engineer
Reviewed by: Nitish Nagpal, Support Escalation Engineer