We started to receive the below error in Stash. It appears to only be visible when your go to a Stash repository > settings > pull requests. You get a http 500 page. but the log files shows the below. Only change to the STASH environement is the install of add-on 'build status for automerge'. Which has since been unistalled. I've even restarted the STASH instance.
Help!
2014-01-23 13:50:57,429 ERROR [http-bio-7990-exec-4661] schuchj 830x358373x0 by1orb xxx.xx.x.xxx "GET /projects/TRAIN/repos/testrepository/settings/pull-requests HTTP/1.1" c.a.s.i.w.HandlerExceptionResolverImpl There was a SQL exception thrown by the Active Objects library:
Database:
- name:PostgreSQL
- version:8.4.17
- minor version:4
- major version:8
Driver:
- name:PostgreSQL Native Driver
- version:PostgreSQL 9.0 JDBC4 (build 801)
org.postgresql.util.PSQLException: ERROR: column "id" does not exist
Position: 73
com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:PostgreSQL
- version:8.4.17
- minor version:4
- major version:8
Driver:
- name:PostgreSQL Native Driver
- version:PostgreSQL 9.0 JDBC4 (build 801)
org.postgresql.util.PSQLException: ERROR: column "id" does not exist
Position: 73
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:179) ~[na:na]
at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.find(DelegatingActiveObjects.java:93) ~[na:na]
at com.sun.proxy.$Proxy1534.find(Unknown Source) ~[na:na]
at com.bolyuba.stash.plugin.AutomergeServiceImpl.getStorage(AutomergeServiceImpl.java:152) ~[na:na]
at com.bolyuba.stash.plugin.AutomergeServiceImpl.shouldCheckMerge(AutomergeServiceImpl.java:135) ~[na:na]
at com.bolyuba.stash.plugin.config.ui.CheckBuildStatusConfig.doView(CheckBuildStatusConfig.java:37) ~[na:na]
at com.atlassian.stash.internal.plugin.PluginFormFragmentsFactoryImpl$PluginFormFragmentsImpl.getViewHtml(PluginFormFragmentsFactoryImpl.java:93) ~[stash-service-impl-2.9.4.jar:na]
at com.atlassian.stash.internal.web.admin.RepositoryAdminController.getPullRequestSettings(RepositoryAdminController.java:252) ~[RepositoryAdminController.class:na]
at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:25) [applinks-plugin-4.0.5_1384226522000.jar:na]
at com.atlassian.stash.internal.spring.security.StashAuthenticationFilter.doFilter(StashAuthenticationFilter.java:87) [StashAuthenticationFilter.class:na]
at com.atlassian.stash.internal.web.auth.BeforeLoginPluginAuthenticationFilter.doInsideSpringSecurityChain(BeforeLoginPluginAuthenticationFilter.java:111) [BeforeLoginPluginAuthenticationFilter.class:na]
at com.atlassian.stash.internal.web.auth.BeforeLoginPluginAuthenticationFilter.doFilter(BeforeLoginPluginAuthenticationFilter.java:77) [BeforeLoginPluginAuthenticationFilter.class:na]
at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:100) [atlassian-trusted-apps-core-3.0.2.jar:na]
at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:61) [atlassian-oauth-service-provider-plugin-1.9.0-m3_1383994322000.jar:na]
at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:100) [atlassian-trusted-apps-core-3.0.2.jar:na]
at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:61) [atlassian-oauth-service-provider-plugin-1.9.0-m3_1383994322000.jar:na]
at com.atlassian.stash.internal.web.auth.BeforeLoginPluginAuthenticationFilter.doBeforeBeforeLoginFilters(BeforeLoginPluginAuthenticationFilter.java:89) [BeforeLoginPluginAuthenticationFilter.class:na]
at com.atlassian.stash.internal.web.auth.BeforeLoginPluginAuthenticationFilter.doFilter(BeforeLoginPluginAuthenticationFilter.java:75) [BeforeLoginPluginAuthenticationFilter.class:na]
at com.atlassian.stash.internal.request.DefaultRequestManager.doAsRequest(DefaultRequestManager.java:72) [stash-service-impl-2.9.4.jar:na]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_21]
at java.lang.Thread.run(Thread.java:722) [na:1.7.0_21]
... 212 frames trimmed
Caused by: org.postgresql.util.PSQLException: ERROR: column "id" does not exist
Position: 73
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) ~[postgresql-9.1-901.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) ~[postgresql-9.1-901.jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[postgresql-9.1-901.jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) ~[postgresql-9.1-901.jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) ~[postgresql-9.1-901.jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) ~[postgresql-9.1-901.jdbc4.jar:na]
at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at net.java.ao.EntityManager.find(EntityManager.java:788) ~[na:na]
at net.java.ao.EntityManager.find(EntityManager.java:703) ~[na:na]
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:175) ~[na:na]
... 21 common frames omitted
