Build tasks stay in queue and never run
Having an issue getting build tasks to run. They queue up and never run. I am runnng TeamCity 8.1.4 on a Windows Server 2012 virtual machine. The database is on a separate server running MySQL 5.6. I have tried with repostitories on both a Hosted Team Foundation Server (Visual Studio online) and on BitBucket. I am able to get TeamCity to connect to the repositories and it says the Build agent is registered and compatible (I installed team foundation explorer on the TeamCity server). I am using MSBUILD to run a .proj file. The .proj file runs from a visual studio developer command prompt. I have looked in the logs and can't readily find any error that would indicate what the issue is. I am not sure which logs would be helpful to post. Can anyone help me troubleshoot this problem?
Please sign in to leave a comment.
Hi,
Please go to Build Queue tab. What do you see in Time to start column? Hovering the mouse cursor over the estimated time value shows a tooltip.
It says N/A (same with the tool-tip)

Please take 10 thread-dumps with an interval of 5 seconds at Administration > Diagnostics and attach them together with teamcity-server.log and teamcity-vcs.log files?
Sorry was on vacation and could not reply. Here are the logs
EDIT:
I found the issue. The MySQL database was defaulted to binlog_format=Statement. I changed it to Mixed and it is now able to run a build task.
Attachment(s):
TeamCity Logs.zip
I'm glab that the issue was resolved. I've updated the documentation.