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?  

5 comments
Comment actions Permalink

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.

0
Comment actions Permalink

It says N/A (same with the tool-tip)
Build Queue.png

0
Comment actions Permalink

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?

0
Comment actions Permalink

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
0
Comment actions Permalink

I'm glab that the issue was resolved. I've updated the documentation.

0

Please sign in to leave a comment.