Error: column "id" does not exist

Issue #28 resolved
Олександр Вайда created an issue

Comments (5)

  1. 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
    
  2. Log in to comment