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

Build responsibility does not work on Oracle

    XMLWordPrintable

Details

    Description

      This is a bug that am not able to reproduce locally but about three users reported this issue recently where Bamboo throws some PostChainAction error whenever a build fails. The symptoms are all same where the issue is replicated upon upgrade to Bamboo 4.2.x with Oracle database. The following appears in the logs:

      System Error Details
      Build MAR DataProduction - CartridgeMaker v13 CI 200 : PostChainAction
      (java.lang.reflect.UndeclaredThrowableException : )
      
      Occurrences: 6
      First Occurred: 27 Jul 2012, 3:08:13 AM
      Last Occurred: 30 Jul 2012, 5:07:17 PM
      java.lang.reflect.UndeclaredThrowableException
      at $Proxy652.prepareStatement(Unknown Source)
      at sun.reflect.GeneratedMethodAccessor2312.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at net.java.ao.DelegateConnectionHandler.delegate(DelegateConnectionHandler.java:94)
      at net.java.ao.DelegateConnectionHandler.invoke(DelegateConnectionHandler.java:62)
      at $Proxy653.prepareStatement(Unknown Source)
      at net.java.ao.db.OracleDatabaseProvider.executeInsertReturningKey(OracleDatabaseProvider.java:270)
      at net.java.ao.DatabaseProvider.insertReturningKey(DatabaseProvider.java:1916)
      at net.java.ao.EntityManager.create(EntityManager.java:460)
      at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:89)
      at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.create(DelegatingActiveObjects.java:56)
      at sun.reflect.GeneratedMethodAccessor2311.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)
      at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56)
      at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      at 
      
      Caused by: java.lang.reflect.InvocationTargetException
      at sun.reflect.GeneratedMethodAccessor2313.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at com.atlassian.activeobjects.spi.ConnectionHandler.delegate(ConnectionHandler.java:42)
      at com.atlassian.activeobjects.spi.ConnectionHandler.invoke(ConnectionHandler.java:37)
      ... 159 more
      Caused by: java.sql.SQLException: Unsupported feature
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
      at oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException(DatabaseError.java:537)
      at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3091)
      at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:155)
      

      This seems similar to the Greenhopper bug report which was traced back to AO. The workaround at the moment is to disable the Broken Build Responsibility Tracker, the only plugin that uses the active object framework for persisting data

      Attachments

        1. postchain.png
          postchain.png
          82 kB
        2. postchain2.png
          postchain2.png
          104 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              smaiyaki Sultan Maiyaki (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: