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
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards 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