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

1 vote

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

188 views 4 8
Read article

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