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)

Atlassian JIRA | Michael Andreacchio | 4 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    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|^jira.log]: {noformat} 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 {noformat}

    Atlassian JIRA | 4 years ago | Michael Andreacchio
    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)
  2. 0

    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|^jira.log]: {noformat} 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 {noformat}

    Atlassian JIRA | 4 years ago | Michael Andreacchio
    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)

    Root Cause Analysis

    1. 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)

      at net.java.ao.EntityManager.get()
    2. net.java.ao
      EntityManager.get
      1. net.java.ao.EntityManager.get(EntityManager.java:205)
      2. net.java.ao.EntityManager.get(EntityManager.java:294)
      2 frames
    3. com.atlassian.activeobjects
      EntityManagedActiveObjects.get
      1. com.atlassian.activeobjects.internal.EntityManagedActiveObjects.get(EntityManagedActiveObjects.java:77)
      1 frame