Internal Server Error if lower_case_table_names =1 in /etc/my.cnf

Dev One

Hi ,

I am getting the following error if i set lower_case_table_names=1 in /etc/my.cnf file. I need to share MySQL database instance with my application along with bamboo. My application requires case-insensitive behavior of MySQL.

 

Internal server error
Go to...
Site Homepage
A system error has occurred - our apologies!
Please create a problem report on our support system at http://support.atlassian.com with the following information:
a description of your problem and what you were doing at the time it occurred
cut & paste the error and system information found below
attach the atlassian-bamboo.log log file found in your application home.
We will respond as promptly as possible.
Thank you!
Version: 4.4.1
Build: 3502
Build Date: 05 Feb 2013
Request Information:
Request URL: http://10.1.112.13:8085/500.action
Scheme: http
Server: 10.1.112.13
Port: 8085
URI: /500.action
Context Path:
Servlet Path: /500.action
Path Info:
Query String:
Stack Trace:
org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not load: com.atlassian.bamboo.security.RememberMeTokenImpl#851969 ; bad SQL grammar ; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bamboo.rememberme_token' doesn't exist
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bamboo.rememberme_token' doesn't exist

 

Przemek Bruski

Just a thought, but did you install Bamboo with this setting at the default value (0) and then changed the value to 1? If you did, I assume all the table files are now in uppercase and MySQL is looking for files (tables) in lowercase. SeeMySQL manual, section starting with

"If you plan to set the lower_case_table_names system variable to 1 on Unix, you must first convert your old database and table names to lowercase before stopping mysqld and restarting it with the new variable setting."

at http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html