Fisheye logs thrown "Table 'xxx' doesn't exist" when using MySQL server

お困りですか?

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

コミュニティに質問

問題

The following error appear in atlassian-fisheye-<date>.log even though the table exists in the database:

2012-09-05 10:12:30,728 ERROR [btpool0-472 ] fisheye.app TotalityFilter-logExceptionDetails - Exception "com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'fecru.AO_B434B9_WEB_HOOK' doesn't exist" (net.java.ao.sql.ActiveObjectSqlException) while processing "/plugins/servlet/webhooks/list" (Referer:"https://fisheye.bln.native-instruments.de/admin/viewServerSettings.do")
net.java.ao.sql.ActiveObjectSqlException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'fecru.AO_B434B9_WEB_HOOK' doesn't exist
	at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:114)
	at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.find(DelegatingActiveObjects.java:71)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
...
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'fecru.AO_B434B9_WEB_HOOK' doesn't exist

原因

MySQL is using case-sensitive table names comparison setting for lower_case_table_names. However, Fisheye has inconsistencies in the table names: see  FE-4276 - Getting issue details... STATUS .

You can confirm the current MySQL setting with the following query:

show variables like 'lower_case_table_names'; 

ソリューション

  1. Set lower_case_table_names to have the value '0' in MySQL
  2. Restart MySQL and Fisheye/Crucible.
  3. Check if the logs don't thrown the error.

Last modified on Mar 7, 2022

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

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