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

XMLWordPrintable

    • 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

            Monique Khairuliana (Inactive) made changes -
            Workflow Original: Bamboo Workflow 2016 v1 - Restricted [ 1434944 ] New: JAC Bug Workflow v3 [ 3378701 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: Bamboo Workflow 2016 v1 [ 1409228 ] New: Bamboo Workflow 2016 v1 - Restricted [ 1434944 ]
            Marek Went (Inactive) made changes -
            Workflow Original: Bamboo Workflow 2014 v2 [ 615608 ] New: Bamboo Workflow 2016 v1 [ 1409228 ]
            James Dumay made changes -
            Workflow Original: Bamboo Workflow 2014 [ 601124 ] New: Bamboo Workflow 2014 v2 [ 615608 ]
            James Dumay made changes -
            Workflow Original: Bamboo Workflow 2010 [ 202232 ] New: Bamboo Workflow 2014 [ 601124 ]

            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

            sabir shaik added a comment -

            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?

            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

            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 made changes -
            Workflow Original: reviewflow [ 164931 ] New: Bamboo Workflow 2010 [ 202232 ]
            MarkC made changes -
            Workflow Original: jira [ 75206 ] New: reviewflow [ 164931 ]

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

                Created:
                Updated:
                Resolved: