500 Error Stash and MySQL database
Symptoms
The following appears in the atlassian-stash.log:
2013-09-23 14:02:06,776 ERROR [http-bio-7990-exec-210] 842x6582x1 1q2z3cg 10.150.55.72,0:0:0:0:0:0:0:1 "GET /mvc/error500 HTTP/1.1" c.a.s.i.web.ErrorPageController There was an unhandled exception loading [/plugins/servlet/branch-permissions/~SUMALI.CARTER/hnau-playpen-test1]
com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:MySQL
- version:5.5.33
- minor version:5
- major version:5
Driver:
- name:MySQL Connector Java
- version:mysql-connector-java-5.1.25 ( Revision: ${bzr.revision-id} )
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'stash_db.AO_6978BB_RESTRICTED_REF' doesn't exist
....
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'stash_db.AO_6978BB_RESTRICTED_REF' doesn't exist
....Diagnosis
Check if the table 'AO_6978BB_RESTRICTED_REF' exists in the database with the following command:
show tables;Cause
The MySQL database has case sensitive on table name comparison. The table exists in small letters while Stash is looking for the table in capital letters.
Resolution
Add 'lower_case_table_names=1' into MySQL my.cnf file and restart MySQL and Stash server.
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.