Uploaded image for project: 'Atlassian Cloud'
  1. Atlassian Cloud
  2. CLOUD-3012

Bamboo "UncategorizedSQLException" errors when saving build results

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: High High
    • Bamboo
    • None

      Studio 2.3 shipped with Bamboo 2.6.2 (up from 2.5.1). Customers using the default AMI or a custom AMI with an updated Elastic Agent Assembly are seeing builds run successfully, but Bamboo is reporting errors similar to the following when trying to save the results:

      org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute JDBC batch update; uncategorized SQLException for SQL []; SQL state [25006]; error code [0]; Batch entry 0 update BUILD set CREATED_DATE='2010-04-16 14:43:48.745000 +07:00:00', UPDATED_DATE='2010-09-27 10:59:49.720000 +07:00:00', FULL_KEY='MYPROJ-MYPROJ', BUILDKEY='MYPROJ', TITLE='My Project Epic', DESCRIPTION=NULL, REVISION_KEY='1740', FIRST_BUILD_NUMBER='1', LATEST_BUILD_NUMBER='452', NEXT_BUILD_NUMBER='453', SUSPENDED_FROM_BUILDING='0', MARKED_FOR_DELETION='0', PROJECT_ID='688131', NOTIFICATION_SET='786437', REQUIREMENT_SET='851973' where BUILD_ID='753669' was aborted.  Call getNextException to see the cause.; nested exception is java.sql.BatchUpdateException: Batch entry 0 update BUILD set CREATED_DATE='2010-04-16 14:43:48.745000 +07:00:00', UPDATED_DATE='2010-09-27 10:59:49.720000 +07:00:00', FULL_KEY='MYPROJ-MYPROJ', BUILDKEY='MYPROJ', TITLE='My Project Epic', DESCRIPTION=NULL, REVISION_KEY='1740', FIRST_BUILD_NUMBER='1', LATEST_BUILD_NUMBER='452', NEXT_BUILD_NUMBER='453', SUSPENDED_FROM_BUILDING='0', MARKED_FOR_DELETION='0', PROJECT_ID='688131', NOTIFICATION_SET='786437', REQUIREMENT_SET='851973' where BUILD_ID='753669' was aborted.  Call getNextException to see the cause.
      Caused by: java.sql.BatchUpdateException: Batch entry 0 update BUILD set CREATED_DATE='2010-04-16 14:43:48.745000 +07:00:00', UPDATED_DATE='2010-09-27 10:59:49.720000 +07:00:00', FULL_KEY='MYPROJ-MYPROJ', BUILDKEY='MYPROJ', TITLE='My Project Epic', DESCRIPTION=NULL, REVISION_KEY='1740', FIRST_BUILD_NUMBER='1', LATEST_BUILD_NUMBER='452', NEXT_BUILD_NUMBER='453', SUSPENDED_FROM_BUILDING='0', MARKED_FOR_DELETION='0', PROJECT_ID='688131', NOTIFICATION_SET='786437', REQUIREMENT_SET='851973' where BUILD_ID='753669' was aborted.  Call getNextException to see the cause.
      	at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2586)
      	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1811)
      	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
      	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2725)
      	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.BatcherImpl.executeBatch(BatcherImpl.java:128)
      	at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2436)
      	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 $Proxy46.getBandanaItem(Unknown Source)
      	at com.atlassian.bamboo.bandana.DefaultBandanaPersister.retrieve(DefaultBandanaPersister.java:32)
      	at com.atlassian.bandana.DefaultBandanaManager.getValue(DefaultBandanaManager.java:32)
      	at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      	at java.lang.reflect.Method.invoke(Method.java:597)
      	at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129)
      	at $Proxy90.getValue(Unknown Source)
      	at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      	at java.lang.reflect.Method.invoke(Method.java:597)
      	at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:150)
      	at $Proxy90.getValue(Unknown Source)
      	at com.atlassian.sal.bamboo.pluginsettings.BambooPluginSettings.get(BambooPluginSettings.java:43)
      	at com.atlassian.studio.bamboo.applinks.StudioPlugins2BridgeImpl.getPluginSettingsValue(StudioPlugins2BridgeImpl.java:52)
      	at com.atlassian.bamboo.studio.scm.AppLinksSvnRepository.getBambooSvnPassword(AppLinksSvnRepository.java:155)
      	at com.atlassian.bamboo.studio.scm.AppLinksSvnRepository.getEncryptedBambooSvnPassword(AppLinksSvnRepository.java:169)
      	at com.atlassian.bamboo.studio.scm.AppLinksSvnRepository.toConfiguration(AppLinksSvnRepository.java:61)
      	at com.atlassian.bamboo.fieldvalue.BuildDefinitionConverter.fromObject(BuildDefinitionConverter.java:89)
      	at com.atlassian.bamboo.build.DefaultBuildDefinitionManager$1.run(DefaultBuildDefinitionManager.java:95)
      	at com.atlassian.bamboo.schedule.PlanSchedulerCallback.run(PlanSchedulerCallback.java:24)
      	at com.atlassian.bamboo.schedule.DefaultPlanScheduler$3.run(DefaultPlanScheduler.java:64)
      	at com.atlassian.util.concurrent.ManagedLocks$ManagedLockImpl.withLock(ManagedLocks.java:322)
      	at com.atlassian.bamboo.schedule.DefaultPlanScheduler.executeWithoutPlanSchdules(DefaultPlanScheduler.java:57)
      	at com.atlassian.bamboo.build.DefaultBuildDefinitionManager.savePlanAndDefinition(DefaultBuildDefinitionManager.java:89)
      	at com.atlassian.bamboo.build.pipeline.tasks.SaveBuildTask.updateVcsBuildDefinition(SaveBuildTask.java:145)
      	at com.atlassian.bamboo.build.pipeline.tasks.SaveBuildTask.call(SaveBuildTask.java:69)
      	at sun.reflect.GeneratedMethodAccessor647.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: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.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 $Proxy344.call(Unknown Source)
      	at com.atlassian.bamboo.v2.build.agent.LocalBuildResultProcessor.processBuildResult(LocalBuildResultProcessor.java:150)
      	at com.atlassian.bamboo.v2.build.agent.messages.ProcessBuildResult.deliver(ProcessBuildResult.java:27)
      	at com.atlassian.bamboo.v2.build.agent.messages.BatchRemoteBambooMessage.deliver(BatchRemoteBambooMessage.java:39)
      	at com.atlassian.bamboo.v2.build.agent.BambooAgentMessageDeliverer.deliverObject(BambooAgentMessageDeliverer.java:20)
      	at com.atlassian.bamboo.v2.build.agent.BambooAgentMessageListener.onMessage(BambooAgentMessageListener.java:34)
      	at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:510)
      	at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:445)
      	at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:414)
      	at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:309)
      	at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:254)
      	at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:870)
      	at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:810)
      	at java.lang.Thread.run(Thread.java:619)
      

              shaldane Sam Haldane (Inactive)
              mknight@atlassian.com Michael Knight
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: