MySQL Server Error Codes and Messages 1650 - 1699

Error: 1650 SQLSTATE: HY000 (ER_SLAVE_IGNORE_SERVER_IDS)

Message: The requested server id %d clashes with the slave startup option --replicate-same-server-id

Error: 1651 SQLSTATE: HY000 (ER_QUERY_CACHE_DISABLED)

Message: Query cache is disabled; restart the server with query_cache_type=1 to enable it

Error: 1652 SQLSTATE: HY000 (ER_SAME_NAME_PARTITION_FIELD)

Message: Duplicate partition field name '%s'

Error: 1653 SQLSTATE: HY000 (ER_PARTITION_COLUMN_LIST_ERROR)

Message: Inconsistency in usage of column lists for partitioning

Error: 1654 SQLSTATE: HY000 (ER_WRONG_TYPE_COLUMN_VALUE_ERROR)

Message: Partition column values of incorrect type

Error: 1655 SQLSTATE: HY000 (ER_TOO_MANY_PARTITION_FUNC_FIELDS_ERROR)

Message: Too many fields in '%s'

Error: 1656 SQLSTATE: HY000 (ER_MAXVALUE_IN_VALUES_IN)

Message: Cannot use MAXVALUE as value in VALUES IN

Error: 1657 SQLSTATE: HY000 (ER_TOO_MANY_VALUES_ERROR)

Message: Cannot have more than one value for this type of %s partitioning

Error: 1658 SQLSTATE: HY000 (ER_ROW_SINGLE_PARTITION_FIELD_ERROR)

Message: Row expressions in VALUES IN only allowed for multi-field column partitioning

Error: 1659 SQLSTATE: HY000 (ER_FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELD)

Message: Field '%s' is of a not allowed type for this type of partitioning

Error: 1660 SQLSTATE: HY000 (ER_PARTITION_FIELDS_TOO_LONG)

Message: The total length of the partitioning fields is too large

Error: 1661 SQLSTATE: HY000 (ER_BINLOG_ROW_ENGINE_AND_STMT_ENGINE)

Message: Cannot execute statement: impossible to write to binary log since both row-incapable engines and statement-incapable engines are involved.

Error: 1662 SQLSTATE: HY000 (ER_BINLOG_ROW_MODE_AND_STMT_ENGINE)

Message: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = ROW and at least one table uses a storage engine limited to statement-based logging.

Error: 1663 SQLSTATE: HY000 (ER_BINLOG_UNSAFE_AND_STMT_ENGINE)

Message: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. %s

Error: 1664 SQLSTATE: HY000 (ER_BINLOG_ROW_INJECTION_AND_STMT_ENGINE)

Message: Cannot execute statement: impossible to write to binary log since statement is in row format and at least one table uses a storage engine limited to statement-based logging.

Error: 1665 SQLSTATE: HY000 (ER_BINLOG_STMT_MODE_AND_ROW_ENGINE)

Message: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging.%s

Error: 1666 SQLSTATE: HY000 (ER_BINLOG_ROW_INJECTION_AND_STMT_MODE)

Message: Cannot execute statement: impossible to write to binary log since statement is in row format and BINLOG_FORMAT = STATEMENT.

Error: 1667 SQLSTATE: HY000 (ER_BINLOG_MULTIPLE_ENGINES_AND_SELF_LOGGING_ENGINE)

Message: Cannot execute statement: impossible to write to binary log since more than one engine is involved and at least one engine is self-logging.

Error: 1668 SQLSTATE: HY000 (ER_BINLOG_UNSAFE_LIMIT)

Message: The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.

Error: 1669 SQLSTATE: HY000 (ER_BINLOG_UNSAFE_INSERT_DELAYED)

Message: The statement is unsafe because it uses INSERT DELAYED. This is unsafe because the times when rows are inserted cannot be predicted.

Error: 1670 SQLSTATE: HY000 (ER_BINLOG_UNSAFE_SYSTEM_TABLE)

Message: The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves.

Error: 1671 SQLSTATE: HY000 (ER_BINLOG_UNSAFE_AUTOINC_COLUMNS)

Message: Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly.

Error: 1672 SQLSTATE: HY000 (ER_BINLOG_UNSAFE_UDF)

Message: Statement is unsafe because it uses a UDF which may not return the same value on the slave.

Error: 1673 SQLSTATE: HY000 (ER_BINLOG_UNSAFE_SYSTEM_VARIABLE)

Message: Statement is unsafe because it uses a system variable that may have a different value on the slave.

Error: 1674 SQLSTATE: HY000 (ER_BINLOG_UNSAFE_SYSTEM_FUNCTION)

Message: Statement is unsafe because it uses a system function that may return a different value on the slave.

Error: 1675 SQLSTATE: HY000 (ER_BINLOG_UNSAFE_NONTRANS_AFTER_TRANS)

Message: Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction.

Error: 1676 SQLSTATE: HY000 (ER_MESSAGE_AND_STATEMENT)

Message: %s Statement: %s

Error: 1677 SQLSTATE: HY000 (ER_SLAVE_CONVERSION_FAILED)

Message: Column %d of table '%s.%s' cannot be converted from type '%s' to type '%s'

Error: 1678 SQLSTATE: HY000 (ER_SLAVE_CANT_CREATE_CONVERSION)

Message: Can't create conversion table for table '%s.%s'

Error: 1679 SQLSTATE: HY000 (ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_BINLOG_FORMAT)

Message: Cannot modify @@session.binlog_format inside a transaction

Error: 1680 SQLSTATE: HY000 (ER_PATH_LENGTH)

Message: The path specified for %s is too long.

Error: 1681 SQLSTATE: HY000 (ER_WARN_DEPRECATED_SYNTAX_NO_REPLACEMENT)

Message: The syntax '%s' is deprecated and will be removed in MySQL %s.

Error: 1682 SQLSTATE: HY000 (ER_WRONG_NATIVE_TABLE_STRUCTURE)

Message: Native table '%s'.'%s' has the wrong structure

Error: 1683 SQLSTATE: HY000 (ER_WRONG_PERFSCHEMA_USAGE)

Message: Invalid performance_schema usage.

Error: 1684 SQLSTATE: HY000 (ER_WARN_I_S_SKIPPED_TABLE)

Message: Table '%s'.'%s' was skipped since its definition is being modified by concurrent DDL statement

Error: 1685 SQLSTATE: HY000 (ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_BINLOG_DIRECT)

Message: Cannot modify @@session.binlog_direct_non_transactional_updates inside a transaction

Error: 1686 SQLSTATE: HY000 (ER_STORED_FUNCTION_PREVENTS_SWITCH_BINLOG_DIRECT)

Message: Cannot change the binlog direct flag inside a stored function or trigger

Error: 1687 SQLSTATE: 42000 (ER_SPATIAL_MUST_HAVE_GEOM_COL)

Message: A SPATIAL index may only contain a geometrical type column

Error: 1688 SQLSTATE: HY000 (ER_TOO_LONG_INDEX_COMMENT)

Message: Comment for index '%s' is too long (max = %lu)

Error: 1689 SQLSTATE: HY000 (ER_LOCK_ABORTED)

Message: Wait on a lock was aborted due to a pending exclusive lock

Error: 1690 SQLSTATE: 22003 (ER_DATA_OUT_OF_RANGE)

Message: %s value is out of range in '%s'

Error: 1691 SQLSTATE: HY000 (ER_WRONG_SPVAR_TYPE_IN_LIMIT)

Message: A variable of a non-integer type in LIMIT clause

Error: 1692 SQLSTATE: HY000 (ER_BINLOG_UNSAFE_MULTIPLE_ENGINES_AND_SELF_LOGGING_ENGINE)

Message: Mixing self-logging and non-self-logging engines in a statement is unsafe.

Error: 1693 SQLSTATE: HY000 (ER_BINLOG_UNSAFE_MIXED_STATEMENT)

Message: Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them.

Error: 1694 SQLSTATE: HY000 (ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_SQL_LOG_BIN)

Message: Cannot modify @@session.sql_log_bin inside a transaction

Error: 1695 SQLSTATE: HY000 (ER_STORED_FUNCTION_PREVENTS_SWITCH_SQL_LOG_BIN)

Message: Cannot change the sql_log_bin inside a stored function or trigger

Error: 1696 SQLSTATE: HY000 (ER_FAILED_READ_FROM_PAR_FILE)

Message: Failed to read from the .par file

Error: 1697 SQLSTATE: HY000 (ER_VALUES_IS_NOT_INT_TYPE_ERROR)

Message: VALUES value for partition '%s' must have type INT

Error: 1698 SQLSTATE: 28000 (ER_ACCESS_DENIED_NO_PASSWORD_ERROR)

Message: Access denied for user '%s'@'%s'

Error: 1699 SQLSTATE: HY000 (ER_SET_PASSWORD_AUTH_PLUGIN)

Message: SET PASSWORD has no significance for users authenticating via plugins