Help: Stash postgre sql exception

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

2 answers

This widget could not be displayed.

Hi Jennifer,

Hmm, ActiveObjects doesn't look like it's migrating the Automerge plugin's tables correctly. From the stacktrace I can see that com.bolyuba.stash.plugin.AutomergeServiceImpl is still being called, which shouldn't happen if you've removed the plugin. Are there different errors in your logs from more recently?

While we can't do much to fix/support the plugin, please feel free to raise a support ticket with your logs attached if the pull request screen still isn't showing up.

Cheers,

Charles

The issue is migrating to merging pull requests. It's throwing a UI error but if you refresh the merge actually does happen. It's that same plugin. seems the uninstall didn't work. Is it safe to remove the jar from the plugins directory??

latest stack:

2014-01-24 11:05:12,652 WARN [AtlassianEvent::pool-2-thread-1] henninp 664x11300x0 11t2vol xxx.xx.x.xx "POST /rest/api/latest/projects/NXID/repos/next-gen-id-client/pull-requests/115/reopen HTTP/1.1" c.a.s.i.p.DefaultMergeRequestCheckService Merge request check com.bolyuba.stash.plugin.stash-build-status-plugin:blockPullRequestMergeCheck of type com.bolyuba.stash.plugin.WasAutomergeBuilt failed.

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

This widget could not be displayed.

The Uninstall of plugin did not work cleanly the first time. Redid uninstall of the build status plugin and all is working as expected.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Aug 10, 2018 in Bitbucket

What is your #1 piece of advice to new users getting started using Bitbucket?

Hello Community! My name is Claire Maynard, and I’m a Product Marketing Manager on the Bitbucket team. I’m interested in hearing what advice or tips you have for new users getting started on ...

243 views 14 2
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you