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

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

 

 

1 answer

This widget could not be displayed.

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

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?

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.

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.

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?!

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.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted 5 hours ago in Statuspage

What are your best incident management tips and stories? #HugOps

 👋Community members! Downtime happens. And great incident response takes a village. Teams like Support, Dev, SRE, Ops, IT, and Marketing have to come together to resolve the problem while keep...

23 views 0 2
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you