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 | 7 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

    Error upgrading from rancher-server 1.0.1 to 1.1.1

    GitHub | 7 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 | 10 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 | 11 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 | 1 year 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 | 11 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