Uploaded image for project: 'Bamboo'
  1. Bamboo
  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. postchain2.png
          postchain2.png
          104 kB
        2. postchain.png
          postchain.png
          82 kB

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: