liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE cattle.volume ADD access_mode VARCHAR(255) NULL: Can't create table 'cattle.#sql-18_7' (errno: -1)

GitHub | jmreicha | 5 months ago
  1. 0

    Error upgrading from rancher-server 1.0.1 to 1.1.1

    GitHub | 5 months ago | jmreicha
    liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE cattle.volume ADD access_mode VARCHAR(255) NULL: Can't create table 'cattle.#sql-18_7' (errno: -1)
  2. 0

    SQL error encountered when installing rancher-server

    GitHub | 7 months ago | sangeethah
    liquibase.exception.DatabaseException: Error executing SQL CREATE INDEX idx_volume_uri ON cattle.volume(uri): Index column size too large. The maximum column size is 767 bytes.
  3. 0

    create with external MySQL: Specified key was too long; max key length is 767 bytes

    GitHub | 8 months ago | xlight
    liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE rancher.config_item ADD CONSTRAINT idx_config_item__name UNIQUE (name): Specified key was too long; max key length is 767 bytes
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    enforce sql_mode=only_full_group_by in the mysql that is built into ranche-server

    GitHub | 10 months ago | dbuschman7
    org.jooq.exception.DataAccessException: SQL [select `host_0`.`id` as `host_0_id`, `host_0`.`name` as `host_0_name`, `host_0`.`account_id` as `host_0_account_id`, `host_0`.`kind` as `host_0_kind`, `host_0`.`uuid` as `host_0_uuid`, `host_0`.`description` as `host_0_description`, `host_0`.`state` as `host_0_state`, `host_0`.`created` as `host_0_created`, `host_0`.`removed` as `host_0_removed`, `host_0`.`remove_time` as `host_0_remove_time`, `host_0`.`data` as `host_0_data`, `host_0`.`uri` as `host_0_uri`, `host_0`.`compute_free` as `host_0_compute_free`, `host_0`.`compute_total` as `host_0_compute_total`, `host_0`.`agent_id` as `host_0_agent_id`, `host_0`.`zone_id` as `host_0_zone_id`, `host_0`.`physical_host_id` as `host_0_physical_host_id`, `host_0`.`is_public` as `host_0_is_public`, `host_0`.`agent_state` as `host_0_agent_state`, `ip_address_1`.`id` as `ip_address_1_id`, `ip_address_1`.`name` as `ip_address_1_name`, `ip_address_1`.`account_id` as `ip_address_1_account_id`, `ip_address_1`.`kind` as `ip_address_1_kind`, `ip_address_1`.`uuid` as `ip_address_1_uuid`, `ip_address_1`.`description` as `ip_address_1_description`, `ip_address_1`.`state` as `ip_address_1_state`, `ip_address_1`.`created` as `ip_address_1_created`, `ip_address_1`.`removed` as `ip_address_1_removed`, `ip_address_1`.`remove_time` as `ip_address_1_remove_time`, `ip_address_1`.`data` as `ip_address_1_data`, `ip_address_1`.`address` as `ip_address_1_address`, `ip_address_1`.`subnet_id` as `ip_address_1_subnet_id`, `ip_address_1`.`network_id` as `ip_address_1_network_id`, `ip_address_1`.`is_public` as `ip_address_1_is_public`, `ip_address_1`.`role` as `ip_address_1_role`, `ip_address_1`.`hostname` as `ip_address_1_hostname`, `ip_address_1`.`ip_pool_id` as `ip_address_1_ip_pool_id` from `ip_address` as `ip_address_1` join `host_ip_address_map` on `host_ip_address_map`.`ip_address_id` = `ip_address_1`.`id` join `host` as `host_0` on `host_0`.`id` = `host_ip_address_map`.`host_id` left outer join `instance_host_map` on `host_0`.`id` = `instance_host_map`.`host_id` where (`host_0`.`removed` is null and `host_0`.`state` not in (?, ?) and 1 = 1 and `ip_address_1`.`removed` is null and `host_0`.`account_id` = ?) group by `host_0`.`id`]; Expression #20 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cattle.ip_address_1.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
  6. 0

    Unknown exception running process

    GitHub | 9 months ago | jmreicha
    org.jooq.exception.DataAccessException: SQL [insert into `process_execution` (`process_instance_id`, `uuid`, `log`, `created`) values (?, ?, ?, ?)]; Unknown column 'created' in 'field list'

    1 unregistered visitors
    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. org.mariadb.jdbc.internal.util.dao.QueryException

      Can't create table 'cattle.#sql-18_7' (errno: -1)

      at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult()
    2. org.mariadb.jdbc
      AbstractQueryProtocol.executeQuery
      1. org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:475)[mariadb-java-client-1.3.4.jar:na]
      2. org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.result(AbstractQueryProtocol.java:396)[mariadb-java-client-1.3.4.jar:na]
      3. org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:378)[mariadb-java-client-1.3.4.jar:na]
      4. org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:334)[mariadb-java-client-1.3.4.jar:na]
      4 frames
    3. mariadb-java-client
      MariaDbStatement.execute
      1. org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:280)[mariadb-java-client-1.3.4.jar:na]
      1 frame
    4. org.mariadb.jdbc
      ExceptionMapper.throwException
      1. org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:136)[mariadb-java-client-1.3.4.jar:na]
      2. org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:69)[mariadb-java-client-1.3.4.jar:na]
      2 frames
    5. mariadb-java-client
      MariaDbStatement.execute
      1. org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:261)[mariadb-java-client-1.3.4.jar:na]
      2. org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:290)[mariadb-java-client-1.3.4.jar:na]
      3. org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:344)[mariadb-java-client-1.3.4.jar:na]
      3 frames
    6. Commons DBCP
      DelegatingStatement.execute
      1. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)[commons-dbcp-1.4.jar:1.4]
      2. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)[commons-dbcp-1.4.jar:1.4]
      2 frames
    7. Liquibase Core
      SpringLiquibase.afterPropertiesSet
      1. liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:294)[liquibase-core-3.1.0.jar:na]
      2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:54)[liquibase-core-3.1.0.jar:na]
      3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:61)[liquibase-core-3.1.0.jar:na]
      4. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:106)[liquibase-core-3.1.0.jar:na]
      5. liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1189)[liquibase-core-3.1.0.jar:na]
      6. liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1172)[liquibase-core-3.1.0.jar:na]
      7. liquibase.changelog.ChangeSet.execute(ChangeSet.java:352)[liquibase-core-3.1.0.jar:na]
      8. liquibase.changelog.ChangeSet.execute(ChangeSet.java:388)[liquibase-core-3.1.0.jar:na]
      9. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:40)[liquibase-core-3.1.0.jar:na]
      10. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:64)[liquibase-core-3.1.0.jar:na]
      11. liquibase.Liquibase.update(Liquibase.java:202)[liquibase-core-3.1.0.jar:na]
      12. liquibase.Liquibase.update(Liquibase.java:181)[liquibase-core-3.1.0.jar:na]
      13. liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:342)[liquibase-core-3.1.0.jar:na]
      14. liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:299)[liquibase-core-3.1.0.jar:na]
      14 frames
    8. io.cattle.platform
      Loader.afterPropertiesSet
      1. io.cattle.platform.liquibase.Loader.afterPropertiesSet(Loader.java:62)[cattle-framework-db-loader-0.5.0-SNAPSHOT.jar:na]
      1 frame
    9. Spring Beans
      AbstractAutowireCapableBeanFactory.initializeBean
      1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1571)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1509)[spring-beans-3.2.5.RELEASE.jar:3.2.5.RELEASE]
      2 frames