Smart commits failing after upgrading Fisheye

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

Upgrading Fisheye leads to the following errors in the logs with the smart commits failing to work as expected:

2013-09-26 09:19:44,602 ERROR [CommitNotifier1 ] com.atlassian.event.internal.LockFreeEventPublisher$Publisher LockFreeEventPublisher$Publisher-dispatch - There was an exception thrown trying to dispatch event 'com.atlassian.fisheye.event.CommitEventImpl[source=WEBDEV]' from the invoker 'com.atlassian.event.internal.SingleParameterMethodListenerInvoker@242183a4'.
java.lang.RuntimeException: There was a SQL exception thrown by the Active Objects library:
Database:
	- name:PostgreSQL
	- version:8.4.13
	- minor version:4
	- major version:8
Driver:
	- name:PostgreSQL Native Driver
	- version:PostgreSQL 8.4 JDBC3 (build 701)

org.postgresql.util.PSQLException: ERROR: relation "ao_8219d4_commit_hook_config" does not exist
  Position: 24
	at com.atlassian.event.internal.SingleParameterMethodListenerInvoker.invoke(SingleParameterMethodListenerInvoker.java:54)

 

Diagnosis

Get a listing of all tables within the Fisheye schema and check whether the table exists. You may find that the table ao_8219d4_commit_hook_config exists though it's all in upper case,  e.g. AO_8219D4_COMMIT_HOOK_CONFIG.

Cause

For some reason the table was created in uppercase rather than the expected lowercase. This could be related to your Postgres database configuration.

Resolution

Use the Postgres alter table statement to change the table name from all uppercase to all lowercase:

alter table public."AO_8219D4_COMMIT_HOOK_CONFIG" rename to ao_8219d4_commit_hook_config;


Last modified on Jul 31, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.