Smart commits failing after upgrading Fisheye
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Symptoms
Upgrading Fisheye leads to the following errors in the logs with the Using Smart Commits failing to work as expected:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
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.
Solution
Resolution
Use the Postgres alter table statement to change the table name from all uppercase to all lowercase:
1
alter table public."AO_8219D4_COMMIT_HOOK_CONFIG" rename to ao_8219d4_commit_hook_config;Was this helpful?