Dependency Build Triggering not working

I am seeing this in the teamcity-server.log file when a build triggered by the completion of another build attempts to start. Could this be related to the size of the 'requestor' column in the database? Perhaps the width of this column is too small?

INFO - serverSide.impl.DBBuildHistory - Start creating history entry for CDQ Nightly Builds (HEAD) :: Big Daddy Jumbo Nightly Build (HEAD) 2450, date: 1208153712000
INFO - serverSide.impl.DBBuildHistory - End creating history entry for CDQ Nightly Builds (HEAD) :: Big Daddy Jumbo Nightly Build (HEAD) 2450
INFO - jetbrains.buildServer.SERVER - Finished 2450
INFO - tbrains.buildServer.ACTIVITIES - Configuration added to queue; name=CDQ Nightly Builds (HEAD) :: Automated Testing - Windows; requestor=CDQ Nightly Builds (HEAD) :: Big Daddy Jumbo Nightly Build (HEAD)
WARN - ildServer.util.EventDispatcher - org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; uncategorized SQLException for SQL []; SQL state ; error code ; Data truncation: Data too long for column 'REQUESTOR' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'REQUESTOR' at row 1
org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; uncategorized SQLException for SQL []; SQL state ; error code ; Data truncation: Data too long for column 'REQUESTOR' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'REQUESTOR' at row 1
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:121)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:324)
at jetbrains.buildServer.serverSide.impl.DBFacade._runSql(DBFacade.java:51)
at jetbrains.buildServer.serverSide.impl.DBFacade.runSql(DBFacade.java:91)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery.execute(GenericQuery.java:27)
at jetbrains.buildServer.serverSide.impl.BuildQueuePersister$2.doInTransaction(BuildQueuePersister.java:3)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
at jetbrains.buildServer.serverSide.impl.BuildQueuePersister.persistQueue(BuildQueuePersister.java:11)
at jetbrains.buildServer.serverSide.impl.BuildQueuePersister.buildTypeAddedToQueue(BuildQueuePersister.java:12)
at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at jetbrains.buildServer.util.EventDispatcher.dispatch(EventDispatcher.java:24)
at jetbrains.buildServer.serverSide.ServerSideEventDispatcher.access$000(ServerSideEventDispatcher.java:3)
at jetbrains.buildServer.serverSide.ServerSideEventDispatcher$1$1.run(ServerSideEventDispatcher.java)
at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAsSystem(SecurityContextImpl.java:4)
at jetbrains.buildServer.serverSide.ServerSideEventDispatcher$1.invoke(ServerSideEventDispatcher.java)
at $Proxy1.buildTypeAddedToQueue(Unknown Source)
at jetbrains.buildServer.serverSide.impl.BuildQueueImpl.add(BuildQueueImpl.java:20)
at jetbrains.buildServer.serverSide.impl.auth.SecuredBuildQueue.add(SecuredBuildQueue.java:41)
at jetbrains.buildServer.serverSide.impl.BuildServerImpl.addToQueue(BuildServerImpl.java:471)
at jetbrains.buildServer.serverSide.impl.BuildServerImpl.addToQueue(BuildServerImpl.java:389)
at jetbrains.buildServer.serverSide.impl.BuildTypeImpl.addToQueue(BuildTypeImpl.java:239)
at jetbrains.buildServer.serverSide.impl.BuildTypeImpl$2.changeOccured(BuildTypeImpl.java:1)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at jetbrains.buildServer.util.EventDispatcher.dispatch(EventDispatcher.java:24)
at jetbrains.buildServer.util.EventDispatcher$1.invoke(EventDispatcher.java)
at $Proxy3.changeOccured(Unknown Source)
at jetbrains.buildServer.configuration.ChangeObserver.checkForModifications(ChangeObserver.java:35)
at jetbrains.buildServer.serverSide.impl.BuildTypeImpl.addToQueueIfShouldBeTriggered(BuildTypeImpl.java:207)
at jetbrains.buildServer.serverSide.impl.BuildTypeImpl$$FastClassByCGLIB$$a84db719.invoke() at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:696) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at jetbrains.buildServer.serverSide.impl.auth.TeamCityMethodSecurityInterceptor.invoke(TeamCityMethodSecurityInterceptor.java:2) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:578) at jetbrains.buildServer.serverSide.impl.BuildTypeImpl$$EnhancerByCGLIB$$13624e42.addToQueueIfShouldBeTriggered(]]>)
at jetbrains.buildServer.serverSide.impl.VcsModificationChecker.checkConfigurationsForAllRootsChecked(VcsModificationChecker.java:38)
at jetbrains.buildServer.serverSide.impl.VcsModificationChecker.access$300(VcsModificationChecker.java:18)
at jetbrains.buildServer.serverSide.impl.VcsModificationChecker$2.run(VcsModificationChecker.java:9)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'REQUESTOR' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2983)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:882)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery.doExecuteQuery(GenericQuery.java:49)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery.access$100(GenericQuery.java:39)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery$3.run(GenericQuery.java)
at jetbrains.buildServer.serverSide.impl.DBFacade$3.doInConnection(DBFacade.java)
at jetbrains.buildServer.serverSide.impl.DBFacade$4.doInConnection(DBFacade.java:2)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:317)
... 48 more
INFO - tbrains.buildServer.ACTIVITIES - Build started; name=CDQ Nightly Builds (HEAD) :: Automated Testing - Windows, personal=false, buildId=2451
INFO - tbrains.buildServer.ACTIVITIES - Configuration removed from queue; name=CDQ Nightly Builds (HEAD) :: Automated Testing - Windows, requestor=CDQ Nightly Builds (HEAD) :: Big Daddy Jumbo Nightly Build (HEAD), comment=null, user=null

Rick Cole

2 comments

This is a bug, to workaround it you can either shorten the build configuration and project names so that string "Nightly Builds (HEAD) :: Big Daddy Jumbo Nightly Build (HEAD)" does not exceed 64 characters. Or you can configure MySQL JDBC driver in database.properties file to truncate such values automatically (I think this is safe enough). To do this modify connection URL to the MySQL server:
connectionUrl=jdbc:mysql://localhost/buildserver?jdbcCompliantTruncation=false


--
Pavel Sher

0

Please sign in to leave a comment.