Details
-
Bug
-
Resolution: Fixed
-
Highest
-
5.10.2, 5.10.1.1
Description
When installing Bamboo with MySQL the table TRUSTED_KEY is not created.
Environment
- OSX 10.11.1
- MySQL 5.6.25
- Bamboo 5.10.1.1 and 5.10.2
Steps to Reproduce
- Follow the instructions to install Bamboo with MySQL as per: Connecting Bamboo to an external database - MySQL
- After the last wizard step when the tables are created this error is thrown in the logs.
Expected Results
- The table TRUSTED_KEY is created without errors.
Actual Results
The following error is thrown in catalina.out:
2016-03-03 14:13:09,880 ERROR [performSetupDatabaseConnectionBackgroundThread] [SchemaExport] Unsuccessful: create table TRUSTED_KEY (id bigint not null, HOST varchar(255) not null, SSH_KEY varchar(4000) not null, APPROVED bit not null, primary key (id), unique (HOST, SSH_KEY))
If you are importing a file into one of these releases of Bamboo you will get:
Import failed. Please contact Atlassian at https://support.atlassian.com/ and attach your export file. <br /> java.lang.RuntimeException: [Table 'bamboo.TRUSTED_KEY' doesn't exist] at com.atlassian.bamboo.migration.XmlMigrator.setNextHiValue(XmlMigrator.java:251) at com.atlassian.bamboo.migration.XmlMigrator.importXml(XmlMigrator.java:217) at com.atlassian.bamboo.migration.XmlMigrator$$FastClassBySpringCGLIB$$b6578fc7.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:708) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
Notes
This table is correctly created when Bamboo is connected to Postgres.
The Bamboo installation is completed without UI errors but other problems may occur. This was first noticed when trying to import a Bamboo backup that was running on PostgreSQL since the table exists there, but was not created when installing Bamboo using MySQL, so it failed to import the data from that table into the new Bamboo instance.
Workaround
Install Bamboo 5.10.1.1 and then upgrade to 5.10.2
Important
During 5.10.2 installation there will be warning that index can't be created, it doesn't affect installation nor functionality
Attachments
Issue Links
- is cloned as
-
BDEV-11285 Loading...