Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-14310

Upgrading from 1.3.1 to 1.4-m4 makes connected DVCS accounts gone with SQL exceptions

    XMLWordPrintable

Details

    • Bug
    • Resolution: Invalid
    • Highest
    • None
    • DCON - old releases
    • DVCS Accounts

    Description

      I upgraded from 1.3.1 to 1.4-m4 and noticed that my connected DVCS accounts (except the integrated one) are gone, and the following exception was seen in UI and log:

      2013-04-02 15:25:22.328268500 2013-04-02 15:25:22,326 BitbucketConnectorExecutorServiceThread:thread-2 WARN ServiceRunner    bitbucket-accounts-reload [dvcs.sync.impl.DefaultSynchronizer] There was a SQL exception thrown by the Active Objects library:
      2013-04-02 15:25:22.328270500 Database:
      2013-04-02 15:25:22.328270500   - name:PostgreSQL
      2013-04-02 15:25:22.328270500   - version:8.4.8
      2013-04-02 15:25:22.328271500   - minor version:4
      2013-04-02 15:25:22.328271500   - major version:8
      2013-04-02 15:25:22.328271500 Driver:
      2013-04-02 15:25:22.328272500   - name:PostgreSQL Native Driver
      2013-04-02 15:25:22.328280500   - version:PostgreSQL 8.4 JDBC4 (build 702)
      2013-04-02 15:25:22.328280500 
      2013-04-02 15:25:22.328281500 org.postgresql.util.PSQLException: ERROR: cached plan must not change result type
      2013-04-02 15:25:22.328281500 com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
      2013-04-02 15:25:22.328282500 Database:
      2013-04-02 15:25:22.328282500   - name:PostgreSQL
      2013-04-02 15:25:22.328282500   - version:8.4.8
      2013-04-02 15:25:22.328284500   - minor version:4
      2013-04-02 15:25:22.328284500   - major version:8
      2013-04-02 15:25:22.328284500 Driver:
      2013-04-02 15:25:22.328285500   - name:PostgreSQL Native Driver
      2013-04-02 15:25:22.328285500   - version:PostgreSQL 8.4 JDBC4 (build 702)
      2013-04-02 15:25:22.328285500 
      2013-04-02 15:25:22.328286500 org.postgresql.util.PSQLException: ERROR: cached plan must not change result type
      2013-04-02 15:25:22.328286500   at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.get(EntityManagedActiveObjects.java:81)
      2013-04-02 15:25:22.328288500   at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.get(DelegatingActiveObjects.java:51)
      2013-04-02 15:25:22.328290500   at sun.reflect.GeneratedMethodAccessor587.invoke(Unknown Source)
      2013-04-02 15:25:22.328291500   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2013-04-02 15:25:22.328291500   at java.lang.reflect.Method.invoke(Method.java:597)
      2013-04-02 15:25:22.328292500   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2013-04-02 15:25:22.328293500   at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)
      2013-04-02 15:25:22.328294500   at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62)
      2013-04-02 15:25:22.328295500   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2013-04-02 15:25:22.328296500   at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      2013-04-02 15:25:22.328297500   at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      2013-04-02 15:25:22.328298500   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2013-04-02 15:25:22.328300500   at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56)
      2013-04-02 15:25:22.328301500   at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39)
      2013-04-02 15:25:22.328301500   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2013-04-02 15:25:22.328306500   at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59)
      2013-04-02 15:25:22.328306500   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2013-04-02 15:25:22.328307500   at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      2013-04-02 15:25:22.328309500   at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      2013-04-02 15:25:22.328309500   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2013-04-02 15:25:22.328310500   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2013-04-02 15:25:22.328312500   at $Proxy2804.get(Unknown Source)
      2013-04-02 15:25:22.328313500   at com.atlassian.jira.plugins.dvcs.dao.impl.RepositoryDaoImpl$7.doInTransaction(RepositoryDaoImpl.java:274)
      2013-04-02 15:25:22.328313500   at com.atlassian.jira.plugins.dvcs.dao.impl.RepositoryDaoImpl$7.doInTransaction(RepositoryDaoImpl.java:250)
      2013-04-02 15:25:22.328314500   at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:25)
      2013-04-02 15:25:22.328316500   at com.atlassian.jira.DefaultHostContextAccessor.doInTransaction(DefaultHostContextAccessor.java:34)
      2013-04-02 15:25:22.328316500   at sun.reflect.GeneratedMethodAccessor137.invoke(Unknown Source)
      2013-04-02 15:25:22.328317500   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2013-04-02 15:25:22.328317500   at java.lang.reflect.Method.invoke(Method.java:597)
      2013-04-02 15:25:22.328318500   at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129)
      2013-04-02 15:25:22.328319500   at $Proxy470.doInTransaction(Unknown Source)
      2013-04-02 15:25:22.328320500   at sun.reflect.GeneratedMethodAccessor137.invoke(Unknown Source)
      2013-04-02 15:25:22.328320500   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2013-04-02 15:25:22.328322500   at java.lang.reflect.Method.invoke(Method.java:597)
      2013-04-02 15:25:22.328323500   at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:154)
      2013-04-02 15:25:22.328324500   at $Proxy470.doInTransaction(Unknown Source)
      2013-04-02 15:25:22.328324500   at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:21)
      2013-04-02 15:25:22.328326500   at sun.reflect.GeneratedMethodAccessor153.invoke(Unknown Source)
      2013-04-02 15:25:22.328326500   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2013-04-02 15:25:22.328327500   at java.lang.reflect.Method.invoke(Method.java:597)
      2013-04-02 15:25:22.328327500   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2013-04-02 15:25:22.328328500   at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)
      2013-04-02 15:25:22.328329500   at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62)
      2013-04-02 15:25:22.328330500   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2013-04-02 15:25:22.328332500   at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      2013-04-02 15:25:22.328332500   at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      2013-04-02 15:25:22.328333500   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2013-04-02 15:25:22.328336500   at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56)
      2013-04-02 15:25:22.328337500   at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39)
      2013-04-02 15:25:22.328338500   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2013-04-02 15:25:22.328339500   at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59)
      2013-04-02 15:25:22.328340500   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2013-04-02 15:25:22.328341500   at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      2013-04-02 15:25:22.328343500   at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      2013-04-02 15:25:22.328344500   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2013-04-02 15:25:22.328344500   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2013-04-02 15:25:22.328346500   at $Proxy633.execute(Unknown Source)
      2013-04-02 15:25:22.328346500   at com.atlassian.activeobjects.internal.SalTransactionManager.inTransaction(SalTransactionManager.java:48)
      2013-04-02 15:25:22.328347500   at com.atlassian.activeobjects.internal.AbstractLoggingTransactionManager.doInTransaction(AbstractLoggingTransactionManager.java:19)
      2013-04-02 15:25:22.328347500   at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.executeInTransaction(EntityManagedActiveObjects.java:256)
      2013-04-02 15:25:22.328349500   at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.executeInTransaction(DelegatingActiveObjects.java:126)
      2013-04-02 15:25:22.328350500   at sun.reflect.GeneratedMethodAccessor586.invoke(Unknown Source)
      2013-04-02 15:25:22.328350500   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2013-04-02 15:25:22.328353500   at java.lang.reflect.Method.invoke(Method.java:597)
      2013-04-02 15:25:22.328353500   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2013-04-02 15:25:22.328354500   at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)
      2013-04-02 15:25:22.328354500   at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62)
      2013-04-02 15:25:22.328356500   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2013-04-02 15:25:22.328357500   at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      2013-04-02 15:25:22.328357500   at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      2013-04-02 15:25:22.328359500   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2013-04-02 15:25:22.328359500   at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56)
      2013-04-02 15:25:22.328360500   at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39)
      2013-04-02 15:25:22.328394500   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2013-04-02 15:25:22.328395500   at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59)
      2013-04-02 15:25:22.328395500   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2013-04-02 15:25:22.328397500   at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      2013-04-02 15:25:22.328398500   at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      2013-04-02 15:25:22.328399500   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2013-04-02 15:25:22.328402500   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2013-04-02 15:25:22.328402500   at $Proxy2804.executeInTransaction(Unknown Source)
      2013-04-02 15:25:22.328403500   at com.atlassian.jira.plugins.dvcs.dao.impl.RepositoryDaoImpl.save(RepositoryDaoImpl.java:248)
      2013-04-02 15:25:22.328405500   at com.atlassian.jira.plugins.dvcs.service.RepositoryServiceImpl.save(RepositoryServiceImpl.java:116)
      2013-04-02 15:25:22.328406500   at com.atlassian.jira.plugins.dvcs.sync.impl.DefaultSynchronisationOperation.synchronise(DefaultSynchronisationOperation.java:60)
      2013-04-02 15:25:22.328407500   at com.atlassian.jira.plugins.dvcs.sync.impl.DefaultSynchronizer$1.run(DefaultSynchronizer.java:79)
      2013-04-02 15:25:22.328408500   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      2013-04-02 15:25:22.328409500   at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      2013-04-02 15:25:22.328409500   at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      2013-04-02 15:25:22.328410500   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      2013-04-02 15:25:22.328411500   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      2013-04-02 15:25:22.328412500   at java.lang.Thread.run(Thread.java:662)
      2013-04-02 15:25:22.328412500 Caused by: org.postgresql.util.PSQLException: ERROR: cached plan must not change result type
      2013-04-02 15:25:22.328413500   at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2077)
      2013-04-02 15:25:22.328414500   at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1810)
      2013-04-02 15:25:22.328416500   at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
      2013-04-02 15:25:22.328417500   at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:498)
      2013-04-02 15:25:22.328417500   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
      2013-04-02 15:25:22.328418500   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
      2013-04-02 15:25:22.328419500   at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      2013-04-02 15:25:22.328420500   at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      2013-04-02 15:25:22.328421500   at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      2013-04-02 15:25:22.328422500   at net.java.ao.EntityManager.find(EntityManager.java:759)
      2013-04-02 15:25:22.328423500   at net.java.ao.EntityManager.find(EntityManager.java:687)
      2013-04-02 15:25:22.328423500   at net.java.ao.EntityManager.find(EntityManager.java:625)
      2013-04-02 15:25:22.328423500   at net.java.ao.EntityManager$2.invoke(EntityManager.java:215)
      2013-04-02 15:25:22.328424500   at net.java.ao.EntityManager$2.invoke(EntityManager.java:211)
      2013-04-02 15:25:22.328426500   at net.java.ao.EntityManager.getFromCache(EntityManager.java:254)
      2013-04-02 15:25:22.328427500   at net.java.ao.EntityManager.get(EntityManager.java:205)
      2013-04-02 15:25:22.328427500   at net.java.ao.EntityManager.get(EntityManager.java:294)
      2013-04-02 15:25:22.328427500   at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.get(EntityManagedActiveObjects.java:77)
      2013-04-02 15:25:22.328428500   ... 90 more
      

      Attachments

        1. jira.log
          2.68 MB
        2. Selection_840.png
          Selection_840.png
          87 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mandreacchio Michael Andreacchio
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: