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

Update of notification set fails on JBAC data

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Invalid
    • Icon: Low Low
    • 2.6 rc1, 2.6
    • None
    • None
    • None

      Trace:
      2010-05-20 11:47:30,548 WARN [BAM::Events:pool-1-thread-9] [JDBCExceptionReporter] SQL Error: 0, SQLState: 25006
      2010-05-20 11:47:30,548 ERROR [BAM::Events:pool-1-thread-9] [JDBCExceptionReporter] Batch entry 0 update NOTIFICATION_SETS set SET_TYPE='PLAN' where NOTIFICATION_SET_ID='34963459' was aborted. Call getNextException to see the cause.
      2010-05-20 11:47:30,548 WARN [BAM::Events:pool-1-thread-9] [JDBCExceptionReporter] SQL Error: 0, SQLState: 25006
      2010-05-20 11:47:30,548 ERROR [BAM::Events:pool-1-thread-9] [JDBCExceptionReporter] ERROR: transaction is read-only
      2010-05-20 11:47:30,550 ERROR [BAM::Events:pool-1-thread-9] [SessionImpl] Could not synchronize database state with session
      2010-05-20 11:47:30,552 ERROR [BAM::Events:pool-1-thread-9] [NamedThreadFactory] Uncaught exception in thread BAM::Events:pool-1-thread-9
      org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not update: com.atlassian.bamboo.notification.NotificationSetImpl#46399507; uncategorized SQLException for SQL []; SQL state [25006]; error code [0]; Batch entry 0 update NOTIFICATION_SETS set SET_TYPE='PLAN' where NOTIFICATION_SET_ID='34963459' was aborted. Call getNextException to see the cause.; nested exception is java.sql.BatchUpdateException: Batch entry 0 update NOTIFICATION_SETS set SET_TYPE='PLAN' where NOTIFICATION_SET_ID='34963459' was aborted. Call getNextException to see the cause.
      Caused by: java.sql.BatchUpdateException: Batch entry 0 update NOTIFICATION_SETS set SET_TYPE='PLAN' where NOTIFICATION_SET_ID='34963459' was aborted. Call getNextException to see the cause.
      at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2569)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1796)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2708)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
      at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
      at net.sf.hibernate.impl.BatchingBatcher.addToBatch(BatchingBatcher.java:34)
      at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:661)
      at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:621)
      at net.sf.hibernate.impl.ScheduledUpdate.execute(ScheduledUpdate.java:52)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2447)
      at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2433)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2391)
      at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2259)
      at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
      at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:510)
      at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:662)
      at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
      at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:314)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      at $Proxy18.getAllBuilds(Unknown Source)
      at com.atlassian.bamboo.plugins.maven2.events.ServerStartedEventListener.handleEvent(ServerStartedEventListener.java:44)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      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:304)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      at org.springframework.orm.hibernate.HibernateInterceptor.invoke(HibernateInterceptor.java:117)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      at $Proxy204.handleEvent(Unknown Source)
      at com.atlassian.bamboo.event.BambooEventManager$2.run(BambooEventManager.java:66)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$2.run(NamedThreadFactory.java:47)
      at java.lang.Thread.run(Thread.java:619)

            mgardias Marcin Gardias
            mgardias Marcin Gardias
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 4h 35m
                4h 35m