Smart commits failing after upgrading Fisheye

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

症状

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)

 

診断

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.

原因

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

ソリューション

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;


最終更新日 2018 年 7 月 31 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.