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
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."
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?
It's officially Tuesday, which means it's officially time for another tip to help you better navigate this space we call the Atlassian Community. 😄 I got a great question from community member, Sa...
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!
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