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

[Mibex_Software]

I can confirm that after renaming all tables manually from mixed-case to lower-case and then setting lower_case_table_names to 1, Bamboo 5.13 (which now enforces this setting) works again. But the caveat is that all the other applications on this MySQL instance (Bitbucket Server, Confluence, ....) do not work anymore. There is no option to set this on a database-level, only instance-wide. What is the proposed solution in this case?

[Martin Widemann]

I have made the same experience and I wonder how you can be so stupid, to demand different requirements on a server-wide setting for different products from the same vendor.

Great work, Atlassian. Not.

[ABRAMS Connect]

Same here. And btw your description of converting the table is either complete nor sane. I'm lucky to have several backups to recover from.

[Ross_Golder]

Same issue here. There is no way I'll be adding the ridiculous 'lower_case_table_names' option to our database cluster just so I can upgrade Bamboo from 5.12 to 5.13 - wtf were you thinking, Atlassian?!

[Przemek Bruski]

We will drop this requirement and change it into a recommendation. The fix will be included in 5.14, currently scheduled to be released later this month.