Error: column "id" does not exist

[Олександр Вайда]

Please see - https://support.atlassian.com/servicedesk/customer/ssp/problem-report-4796

[Georgy Bolyuba]

:) which version is this?

[Georgy Bolyuba]

I cannot really see that support request

[Jeff Thomas]

Hi @bolyuba, here is some more information about this error.

• Stash 3.5.0
• Build status for automerge 0.2.4

Steps to reproduce

Navigate to repository > Settings > Pull requests

The following error appears in the web interface:

There was a SQL exception thrown by the Active Objects library: Database: - name:PostgreSQL - version:9.3.5 - minor version:3 - major version:9 Driver: - name:PostgreSQL Native Driver - version:PostgreSQL 9.3 JDBC4.1 (build 1102) org.postgresql.util.PSQLException: ERROR: column "id" does not exist Position: 73
Please see your system administrator.

In atlassian-stash.log:

2014-12-31 14:27:30,539 ERROR [http-nio-7990-exec-2] admin @Q9EW02x867x12492x0 w3bfzz 0:0:0:0:0:0:0:1 "GET /projects/TEST/repos/changes/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:9.3.5
    - minor version:3
    - major version:9
Driver:
    - name:PostgreSQL Native Driver
    - version:PostgreSQL 9.3 JDBC4.1 (build 1102)

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:9.3.5
    - minor version:3
    - major version:9
Driver:
    - name:PostgreSQL Native Driver
    - version:PostgreSQL 9.3 JDBC4.1 (build 1102)

org.postgresql.util.PSQLException: ERROR: column "id" does not exist
  Position: 73
    at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:185) ~[na:na]
    at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.find(TenantAwareActiveObjects.java:335) ~[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:114) ~[PluginFormFragmentsFactoryImpl$PluginFormFragmentsImpl.class:na]
    at com.atlassian.stash.internal.web.admin.RepositoryAdminController.getPullRequestSettings(RepositoryAdminController.java:257) ~[RepositoryAdminController.class:na]
    at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:25) [applinks-plugin-4.3.5_1414649180000.jar:na]
    at com.atlassian.stash.internal.spring.security.StashAuthenticationFilter.doFilter(StashAuthenticationFilter.java:86) [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) [TrustedApplicationsFilter.class:na]
    at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:79) [atlassian-oauth-service-provider-plugin-1.9.9_1415961802000.jar:na]
    at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:100) [TrustedApplicationsFilter.class:na]
    at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:79) [atlassian-oauth-service-provider-plugin-1.9.9_1415961802000.jar:na]
    at com.atlassian.analytics.client.filter.DefaultAnalyticsFilter.doFilter(DefaultAnalyticsFilter.java:32) [analytics-client-3.53_1414739696000.jar:na]
    at com.atlassian.analytics.client.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32) [analytics-client-3.53_1414739696000.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:82) [DefaultRequestManager.class:na]
    at com.atlassian.stash.internal.hazelcast.ConfigurableWebFilter.doFilter(ConfigurableWebFilter.java:38) [ConfigurableWebFilter.class:na]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_55]
    at java.lang.Thread.run(Thread.java:745) [na:1.7.0_55]
    ... 249 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:2198) ~[postgresql-9.3-1102-jdbc41.jar:na]
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) ~[postgresql-9.3-1102-jdbc41.jar:na]
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[postgresql-9.3-1102-jdbc41.jar:na]
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) ~[postgresql-9.3-1102-jdbc41.jar:na]
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) ~[postgresql-9.3-1102-jdbc41.jar:na]
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304) ~[postgresql-9.3-1102-jdbc41.jar:na]
    at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172) ~[PreparedStatementHandle.class:0.7.1.RELEASE]
    at net.java.ao.EntityManager.find(EntityManager.java:765) ~[na:na]
    at net.java.ao.EntityManager.find(EntityManager.java:675) ~[na:na]
    at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:181) ~[na:na]
    ... 23 common frames omitted

[Georgy Bolyuba]

Fixed in 3.6.0.x version. Please upgrade :).