Duplicate tables in MySQL Bamboo database
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
There are duplicate tables in the MySQL Bamboo database some of which have names with all capital letters and there are ones with the same name but with small letters. This happens after restoring a Bamboo DB dump and running Bamboo. There might be errors stating that Bamboo cannot access some resources. For instance:
1
org.acegisecurity.acls.NotFoundException: Could not find ACLCause
MySQL case sensitivity with 'lower_case_table_names' variable is the culprit. The restored Bamboo DB dump contains tables with only lower case letters, and Bamboo adds some of the duplicate tables with upper case letters (after starting the Bamboo instance).
Resolution
Make sure that Bamboo database has been created by following the requirements.
Run 'show variables;' in your MySQL to see the value of 'lower_case_table_names' variable. If it is set to 0, then shut down your Bamboo server and stop your MySQL DB system, set 'lower_case_table_names' variable to 1 by adding "
lower_case_table_names=1" to the [mysqld] section of/etc/mysql/my.cnffile (for more info check this page).Start your MySQL DB system, drop the Bamboo DB (as it got corrupted and contains duplicate tables), restore a correct Bamboo DB backup and run Bamboo instance.
Was this helpful?