TeamCity hangs on Project Page / Build Queue, Builds stuck in queue

Hi all,

TeamCity (4.5.4 (build 9071)) has been recently hanging on view of the project page and build queue. Most other pages work but there are several builds "stuck" in the queue and the agents won't pick them up. This seems to have started happening after the TeamCity database maintenence hung and was restarted.


My issue seems to be exactly the one shown here: http://www.jetbrains.net/devnet/message/5250092#5250092 but I have tried the mentioned solutions and they have not appeared to work.

I have located this possible root cause from the teamcity-server.log. Please advice:

[2009-11-14 02:00:33,984]   INFO -  jetbrains.buildServer.CLEANUP - Cleaning build history data from the database...
[2009-11-14 02:03:17,666]  ERROR -  jetbrains.buildServer.CLEANUP - Unexpected error occured during cleanup

org.springframework.transaction.TransactionSystemException: Could not roll back JDBC transaction; nested exception is java.sql.SQLException: Invalid state, the Connection object is closed.
        at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:279)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:800)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:777)
        at org.springframework.transaction.support.TransactionTemplate.rollbackOnException(TransactionTemplate.java:154)
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:132)
        at jetbrains.buildServer.serverSide.impl.DBFacade.compact(DBFacade.java:43)
        at jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupManagerImpl.startCleanup(ServerCleanupManagerImpl.java:96)
        at jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupManagerImpl$2.run(ServerCleanupManagerImpl.java:5)
        at java.util.TimerThread.mainLoop(Timer.java:512)
        at java.util.TimerThread.run(Timer.java:462)
Caused by: java.sql.SQLException: Invalid state, the Connection object is closed.
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1634)
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java:2027)
        at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:328)
        at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:328)
        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:312)
        at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:276)


Regards,
Ryan

1 comment
Comment actions Permalink

Ryan,

For investigating this problem, we are going to add more logging into cleanup procedures and provide you with new binaries.
We will let you know when they are ready.

0

Please sign in to leave a comment.