Fisheye logs thrown "Table 'xxx' doesn't exist" when using MySQL server
Problem
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 existCause
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'; Resolution
- Set lower_case_table_names to have the value '0' in MySQL
- Restart MySQL and Fisheye/Crucible.
- Check if the logs don't thrown the error.
Last modified on Mar 7, 2022
Powered by Confluence and Scroll Viewport.