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

Atlassian JIRA | Daniel Santos | 9 months ago
  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 | 9 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 | 9 months ago | Daniel Santos
    java.lang.RuntimeException: [Table 'bamboo.TRUSTED_KEY' doesn't exist]
  3. 0

    How to run selenium in Internet Explorer? I am able to run in firefox.

    Google Groups | 9 years ago | santosh
    java.lang.RuntimeException: sessionId <table border="1" cellspacing="0">_<tr>{code}<td colspan="3" bgcolor=" doesn't exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    PMD / Discussion / Open Discussion:java.lang.RuntimeException File doesnt exist

    sourceforge.net | 11 months ago
    java.lang.RuntimeException: File Documents doesn't exist
  6. 0

    PMD / Discussion / Open Discussion:java.lang.RuntimeException File doesnt exist

    sourceforge.net | 2 months ago
    java.lang.RuntimeException: File Documents doesn't exist

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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