Uploaded image for project: 'Bamboo Data Center'
  1. Bamboo Data Center
  2. BAM-706

Added two builds to the queue, canceled the 2nd one, got a hibernate exception

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • 1.0
    • 0.9.1
    • Build Queues
    • None

      org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is net.sf.hibernate.exception.GenericJDBCException: Cannot open connection
      net.sf.hibernate.exception.GenericJDBCException: Cannot open connection
      at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90)
      at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79)
      at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
      at net.sf.hibernate.impl.BatcherImpl.convert(BatcherImpl.java:328)
      at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:295)
      at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3373)
      at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3333)
      at org.springframework.orm.hibernate.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:407)
      at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:283)
      at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:226)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:89)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
      at $Proxy7.addBuildResults(Unknown Source)
      at com.atlassian.bamboo.builder.DefaultBuildExecutor.recordTheBuildCompletion(DefaultBuildExecutor.java:265)
      at com.atlassian.bamboo.builder.DefaultBuildExecutor.doTask(DefaultBuildExecutor.java:104)
      at com.atlassian.bamboo.container.BambooTask.run(BambooTask.java:33)
      at java.lang.Thread.run(Unknown Source)
      Caused by: java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException
      at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104)
      at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
      at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:62)
      at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:266)
      at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)
      at net.sf.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:33)
      at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:292)
      ... 13 more
      Caused by: java.lang.InterruptedException
      at java.lang.Object.wait(Native Method)
      at com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:968)
      at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:208)
      at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:260)
      ... 16 more

            [BAM-706] Added two builds to the queue, canceled the 2nd one, got a hibernate exception

            AntonA added a comment -

            Sabir,

            This bug has been fixed a very long time ago.

            If you are running into problems, the best thing to do is to create a support request in our support system:
            http://support.atlassian.com
            where our Support Team can help.

            Cheers,
            Anton

            AntonA added a comment - Sabir, This bug has been fixed a very long time ago. If you are running into problems, the best thing to do is to create a support request in our support system: http://support.atlassian.com where our Support Team can help. Cheers, Anton

            Hai i am getting this error in stacktrace log
            can anty body find the solution for this?

            sabir shaik added a comment - Hai i am getting this error in stacktrace log can anty body find the solution for this?

            2011-09-19 12:23:17,220 WARN [http-9090-5] net.sf.hibernate.util.JDBCExceptionReporter - SQL Error: 9002, SQLState: S1000

            2011-09-19 12:23:17,220 ERROR [http-9090-5] net.sf.hibernate.util.JDBCExceptionReporter - The transaction log for database 'OCS' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

            2011-09-19 12:23:17,220 ERROR [http-9090-5] net.sf.hibernate.impl.SessionImpl - Could not synchronize database state with session

            2011-09-19 12:23:17,220 ERROR [http-9090-5] com.mhub.core.exceptions.common.BaseException - Application Exception due to--ErrorCode:DATABASE_SAVE_FAIL; ErrorMessage:Unable to save userActivityLog : com.mhub.core.busobj.common.UserActivityLog@a4ed99;

            net.sf.hibernate.exception.GenericJDBCException: could not insert: com.mhub.core.busobj.common.UserActivityLog#5

            at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90)
            at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79)

            at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)

            at net.sf.hibernate.persister.AbstractEntityPersister.convert(AbstractEntityPersister.java:1331)

            at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:472)

            at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)

            at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)

            at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449)

            at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435)

            at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392)

            at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261)

            at com.mhub.core.dataaccess.common.UserActivityLogDAO.addUserActivityLog(UserActivityLogDAO.java:49)

            at com.mhub.core.dataaccess.common.UserActivityLogDataAccessCommand.execute(UserActivityLogDataAccessCommand.java:46)

            at com.mhub.core.ejb.common.DataPersistenceBean.executeDataAccessCommand(DataPersistenceBean.java:57)

            at com.mhub.core.common.LocalPersistenceManager.executeDataAccessCommand(LocalPersistenceManager.java:41)

            at com.mhub.core.actions.login.LogonAction.execute(LogonAction.java:270)

            at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)

            at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)

            at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)

            at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)

            at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)

            at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
            at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:843)
            at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:679)
            at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1293)
            at java.lang.Thread.run(Unknown Source)
            Caused by: java.sql.SQLException: The transaction log for database 'OCS' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
            at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
            at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
            at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
            at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
            at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
            at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
            at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:505)
            at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
            at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
            at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
            at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
            ... 29 more

            sabir shaik added a comment - 2011-09-19 12:23:17,220 WARN [http-9090-5] net.sf.hibernate.util.JDBCExceptionReporter - SQL Error: 9002, SQLState: S1000 2011-09-19 12:23:17,220 ERROR [http-9090-5] net.sf.hibernate.util.JDBCExceptionReporter - The transaction log for database 'OCS' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases 2011-09-19 12:23:17,220 ERROR [http-9090-5] net.sf.hibernate.impl.SessionImpl - Could not synchronize database state with session 2011-09-19 12:23:17,220 ERROR [http-9090-5] com.mhub.core.exceptions.common.BaseException - Application Exception due to--ErrorCode:DATABASE_SAVE_FAIL; ErrorMessage:Unable to save userActivityLog : com.mhub.core.busobj.common.UserActivityLog@a4ed99; net.sf.hibernate.exception.GenericJDBCException: could not insert: com.mhub.core.busobj.common.UserActivityLog#5 at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79) at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at net.sf.hibernate.persister.AbstractEntityPersister.convert(AbstractEntityPersister.java:1331) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:472) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261) at com.mhub.core.dataaccess.common.UserActivityLogDAO.addUserActivityLog(UserActivityLogDAO.java:49) at com.mhub.core.dataaccess.common.UserActivityLogDataAccessCommand.execute(UserActivityLogDataAccessCommand.java:46) at com.mhub.core.ejb.common.DataPersistenceBean.executeDataAccessCommand(DataPersistenceBean.java:57) at com.mhub.core.common.LocalPersistenceManager.executeDataAccessCommand(LocalPersistenceManager.java:41) at com.mhub.core.actions.login.LogonAction.execute(LogonAction.java:270) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415) at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:843) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:679) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1293) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: The transaction log for database 'OCS' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:505) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462) ... 29 more

            MarkC added a comment -

            Keith,

            This particular problem should've been fixed for 1.0

            Cheers

            Mark C

            MarkC added a comment - Keith, This particular problem should've been fixed for 1.0 Cheers Mark C

            MarkC added a comment -

            Keith,

            It looks like the timing of killing the build is an issue here. The build is being stopped after the it has finished building, but was half way towards saving the in the database.

            Thanks for the report, I try to rework a bit so this is less error prone.

            Cheers,

            Mark C

            MarkC added a comment - Keith, It looks like the timing of killing the build is an issue here. The build is being stopped after the it has finished building, but was half way towards saving the in the database. Thanks for the report, I try to rework a bit so this is less error prone. Cheers, Mark C

            Then a few seconds later, another error appeared in the log:

            java.lang.NullPointerException: attempted to update null
            at net.sf.hibernate.impl.SessionImpl.update(SessionImpl.java:1342)
            at com.atlassian.bamboo.emailer.DefaultEmailBuildResultsService.email(DefaultEmailBuildResultsService.java:127)
            at com.atlassian.bamboo.emailer.DefaultEmailBuildResultsService.onBuildComplete(DefaultEmailBuildResultsService.java:78)
            at com.atlassian.bamboo.event.DefaultBuildEventNotifier$1.run(DefaultBuildEventNotifier.java:142)
            at java.lang.Thread.run(Unknown Source)

            Keith Johnston added a comment - Then a few seconds later, another error appeared in the log: java.lang.NullPointerException: attempted to update null at net.sf.hibernate.impl.SessionImpl.update(SessionImpl.java:1342) at com.atlassian.bamboo.emailer.DefaultEmailBuildResultsService.email(DefaultEmailBuildResultsService.java:127) at com.atlassian.bamboo.emailer.DefaultEmailBuildResultsService.onBuildComplete(DefaultEmailBuildResultsService.java:78) at com.atlassian.bamboo.event.DefaultBuildEventNotifier$1.run(DefaultBuildEventNotifier.java:142) at java.lang.Thread.run(Unknown Source)

              mark@atlassian.com MarkC
              6941b66913cc Keith Johnston
              Affected customers:
              0 This affects my team
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: