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 | 9 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 | 9 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 | 1 year 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 | 1 year 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 | 1 year ago | jmreicha
    org.jooq.exception.DataAccessException: SQL [insert into `process_execution` (`process_instance_id`, `uuid`, `log`, `created`) values (?, ?, ?, ?)]; Unknown column 'created' in 'field list'
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