Build Agent won't work

Hey there,

my friend had installed TeamCity and a Build Agent.

The Agent is connected, authorized and enabled:
http://abload.de/img/build1tyksw.png

Problem: The agent won't run the build queue!

Check out the attached ZIP - Here are all logfiles.


How i can fix the issue?

Thanks for help.



Attachment(s):
logfiles.zip
7 comments
Comment actions Permalink

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

0
Comment actions Permalink

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

0
Comment actions Permalink

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

0
Comment actions Permalink

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.

0
Comment actions Permalink

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?

0
Comment actions Permalink

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

Unbenannt.PNG

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

0
Comment actions Permalink

You have setup database incorrectly. Please fix the exception.

0

Please sign in to leave a comment.