Build Agent won't work

When i try to restart the agent, the complete server goes down!

This is because the agent is installed on the same machine as server. The link says "Reboot the agent machine"

If you go to build queue on the top, you can see how many agents can run the build. I guess in your sutuation it will be no agents.

Following the link, you'll see the reason why agent can't run the build. You can read more about build type and agent compatibility at http://confluence.jetbrains.com/display/TCD8/Agent+Requirements

It also makes sese to get familiar with concepts: http://confluence.jetbrains.com/display/TCD8/Concepts

Hello Sergey,

thanks for your answer.

But i misunderstand that, here a little points for the misunderstanding:

• The agent is enabled, actiaved and connected
• Under the project, the agent will be listen as "available/compatible"
• TeamCity and the Agent has been installed as described in the documentation
• no errors or informations in the logs why the build is not started

We need to build a java project from Git with an ANT script. the JDK/SDK is already installed.

If you go to build queue, for every build you should see information how many agents this particular queued build can be run on. What is displayed there?

As I wrote already: The agent is assigned to the project - 1 Agent, see the Screenshot



Edit
Have installed TC on my root. Here the same problems. I've found SQL-Exceptions in the Logfiles - And that with an default installation. How i can fix that?

SQL exception: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838)
     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334)
     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262)
     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246)
     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
     at jetbrains.buildServer.serverSide.db.queries.GenericQuery$5.action(GenericQuery.java:215)
     at jetbrains.buildServer.serverSide.db.queries.GenericQuery$5.action(GenericQuery.java:212)
     at jetbrains.buildServer.serverSide.db.queries.GenericQuery.underPreparedStatement(GenericQuery.java:451)
     at jetbrains.buildServer.serverSide.db.queries.GenericQuery.executeUpdate(GenericQuery.java:154)
     at jetbrains.buildServer.serverSide.db.queries.GenericQuery$3.run(GenericQuery.java:138)
     at jetbrains.buildServer.serverSide.db.queries.GenericQuery$3.run(GenericQuery.java:136)
     at jetbrains.buildServer.serverSide.db.DBFacade.withDB(DBFacade.java:278)
     at jetbrains.buildServer.serverSide.db.queries.GenericQuery.executeUpdate(GenericQuery.java:136)
     at jetbrains.buildServer.serverSide.impl.BuildQueueImpl$13$1.doInTransactionWithoutResult(BuildQueueImpl.java:4)
     at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
     at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
     at jetbrains.buildServer.serverSide.impl.BuildQueueImpl$13.run(BuildQueueImpl.java:14)
     at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl$2.run(SecurityContextImpl.java)
     at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAs(SecurityContextImpl.java:1)
     at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAs(SecurityContextImpl.java:17)
     at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAsSystem(SecurityContextImpl.java:11)
     at jetbrains.buildServer.serverSide.impl.BuildQueueImpl.persistQueue(BuildQueueImpl.java:700)
     at jetbrains.buildServer.serverSide.impl.BuildQueueImpl.access$1500(BuildQueueImpl.java:433)
     at jetbrains.buildServer.serverSide.impl.BuildQueueImpl$3$1.run(BuildQueueImpl.java:7)
     at jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupManagerImpl.executeWithInactiveCleanup(ServerCleanupManagerImpl.java:170)
     at jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupManagerImpl$$FastClassByCGLIB$$ba2c8525.invoke(<generated>)
     at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
     at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
     at jetbrains.buildServer.serverSide.impl.auth.TeamCityMethodSecurityInterceptor.invoke(TeamCityMethodSecurityInterceptor.java:21)
     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
     at org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:572)
     at jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupManagerImpl$$EnhancerByCGLIB$$563453e4.executeWithInactiveCleanup(<generated>)
     at jetbrains.buildServer.serverSide.impl.BuildQueueImpl$3.run(BuildQueueImpl.java:1)
     at jetbrains.buildServer.serverSide.impl.BuildQueueImpl$6.run(BuildQueueImpl.java:1)
     at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl$2.run(SecurityContextImpl.java)
     at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAs(SecurityContextImpl.java:1)
     at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAs(SecurityContextImpl.java:17)
     at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAsSystem(SecurityContextImpl.java:11)
     at jetbrains.buildServer.serverSide.impl.BuildQueueImpl.runAsSystem(BuildQueueImpl.java:695)
     at jetbrains.buildServer.serverSide.impl.BuildQueueImpl.addToQueue(BuildQueueImpl.java:254)
     at jetbrains.buildServer.serverSide.impl.BuildQueueImpl.processTasks(BuildQueueImpl.java:275)
     at jetbrains.buildServer.serverSide.impl.auth.SecuredBuildQueue.processTasks(SecuredBuildQueue.java:77)
     at jetbrains.buildServer.controllers.actions.AddToQueueProcessor.processRequest(AddToQueueProcessor.java:48)
     at jetbrains.buildServer.controllers.actions.AddToQueueAction.doProcess(AddToQueueAction.java:29)
     at jetbrains.buildServer.controllers.OneParamAction.process(OneParamAction.java:4)
     at jetbrains.buildServer.controllers.BaseActionController.doAction(BaseActionController.java:51)
     at jetbrains.buildServer.controllers.BaseAjaxActionController$1.handleRequest(BaseAjaxActionController.java:46)
     at jetbrains.buildServer.controllers.AjaxRequestProcessor.processRequest(AjaxRequestProcessor.java:45)
     at jetbrains.buildServer.controllers.BaseAjaxActionController.doHandle(BaseAjaxActionController.java:44)
     at jetbrains.buildServer.controllers.BaseController.handleRequestInternal(BaseController.java:75)
     at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
     at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
     at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
     at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
     at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
     at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
     at jetbrains.buildServer.maintenance.TeamCityDispatcherServlet.service(TeamCityDispatcherServlet.java:37)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
     at jetbrains.buildServer.web.ParametersProviderCalculationContextFilter.doFilter(ParametersProviderCalculationContextFilter.java:6)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
     at jetbrains.buildServer.web.DisableSessionIdFromUrlFilter.doFilter(DisableSessionIdFromUrlFilter.java:3)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
     at jetbrains.buildServer.web.DiagnosticFilter.doFilter(DiagnosticFilter.java:26)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
     at jetbrains.buildServer.web.ResponseFragmentFilter.doFilter(ResponseFragmentFilter.java:11)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
     at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
     at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
     at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1686)
     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
     at java.lang.Thread.run(Thread.java:744)
Caused by: java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
     ... 94 more

You have setup database incorrectly. Please fix the exception.