java.lang.RuntimeException: [Table 'bamboo.TRUSTED_KEY' doesn't exist]

Atlassian JIRA | Daniel Santos | 12 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    When installing Bamboo with MySQL the table TRUSTED_KEY is not created. h3. Environment * OSX 10.11.1 * MySQL 5.6.25 * Bamboo 5.10.1.1 and 5.10.2 h3. Steps to Reproduce # Follow the instructions to install Bamboo with MySQL as per: [Connecting Bamboo to an external database - MySQL|https://confluence.atlassian.com/bamboo/mysql-289276817.html] # After the last wizard step when the tables are created this error is thrown in the logs. h3. Expected Results # The table TRUSTED_KEY is created without errors. h3. Actual Results The following error is thrown in catalina.out: {noformat} 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)) {noformat} If you are importing a file into one of these releases of Bamboo you will get: {noformat} 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) {noformat} h3. 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. h3. Workaround Install Bamboo 5.10.1.1 and then upgrade to 5.10.2 {panel} (i) *Important* During 5.10.2 installation there will be warning that index can't be created, it doesn't affect installation nor functionality {panel}

    Atlassian JIRA | 12 months ago | Daniel Pinheiro dos Santos
    java.lang.RuntimeException: [Table 'bamboo.TRUSTED_KEY' doesn't exist]
  2. 0

    When installing Bamboo with MySQL the table TRUSTED_KEY is not created. h3. Environment * OSX 10.11.1 * MySQL 5.6.25 * Bamboo 5.10.1.1 and 5.10.2 h3. Steps to Reproduce # Follow the instructions to install Bamboo with MySQL as per: [Connecting Bamboo to an external database - MySQL|https://confluence.atlassian.com/bamboo/mysql-289276817.html] # After the last wizard step when the tables are created this error is thrown in the logs. h3. Expected Results # The table TRUSTED_KEY is created without errors. h3. Actual Results The following error is thrown in catalina.out: {noformat} 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)) {noformat} If you are importing a file into one of these releases of Bamboo you will get: {noformat} 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) {noformat} h3. 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. h3. Workaround Install Bamboo 5.10.1.1 and then upgrade to 5.10.2 {panel} (i) *Important* During 5.10.2 installation there will be warning that index can't be created, it doesn't affect installation nor functionality {panel}

    Atlassian JIRA | 12 months ago | Daniel Santos
    java.lang.RuntimeException: [Table 'bamboo.TRUSTED_KEY' doesn't exist]

    Root Cause Analysis

    1. java.lang.RuntimeException

      [Table 'bamboo.TRUSTED_KEY' doesn't exist]

      at com.atlassian.bamboo.migration.XmlMigrator.setNextHiValue()
    2. com.atlassian.bamboo
      XmlMigrator$$FastClassBySpringCGLIB$$b6578fc7.invoke
      1. com.atlassian.bamboo.migration.XmlMigrator.setNextHiValue(XmlMigrator.java:251)
      2. com.atlassian.bamboo.migration.XmlMigrator.importXml(XmlMigrator.java:217)
      3. com.atlassian.bamboo.migration.XmlMigrator$$FastClassBySpringCGLIB$$b6578fc7.invoke(<generated>)
      3 frames
    3. Spring Core
      MethodProxy.invoke
      1. org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
      1 frame
    4. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:708)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
      2 frames
    5. Spring Tx
      TransactionInterceptor$1.proceedWithInvocation
      1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
      1 frame