All pages
Powered by GitBook
Couldn't generate the PDF for 101 pages, generation stopped at 100.
Extend with 50 more pages.
1 of 100

MariaDB Error Codes 1600 to 1699

Error 1600: Creation context of view is invalid

Error Code
SQLSTATE
Error
Description

1600

HY000

ER_VIEW_INVALID_CREATION_CTX

Creation context of view %s.`%s' is invalid

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1601: Creation context of stored routine is invalid

Error Code
SQLSTATE
Error
Description

1601

HY000

ER_SR_INVALID_CREATION_CTX

Creation context of stored routine %s.%s is invalid

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1602: Corrupted TRG file for table

Error Code
SQLSTATE
Error
Description

1602

HY000

ER_TRG_CORRUPTED_FILE

Corrupted TRG file for table %s.%s

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1603: Triggers for table have no creation context

Error Code
SQLSTATE
Error
Description

1603

HY000

ER_TRG_NO_CREATION_CTX

Triggers for table %s.%s have no creation context

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1604: Trigger creation context of table is invalid

Error Code
SQLSTATE
Error
Description

1604

HY000

ER_TRG_INVALID_CREATION_CTX

Trigger creation context of table %s.%s is invalid

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1605: Creation context of event is invalid

Error Code
SQLSTATE
Error
Description

1605

HY000

ER_EVENT_INVALID_CREATION_CTX

Creation context of event %s.%s is invalid

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1606: Cannot open table for trigger

Error Code
SQLSTATE
Error
Description

1606

HY000

ER_TRG_CANT_OPEN_TABLE

Cannot open table for trigger %s.%s

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1607: Cannot create stored routine. Check warnings

Error Code
SQLSTATE
Error
Description

1607

HY000

ER_CANT_CREATE_SROUTINE

Cannot create stored routine %s. Check warnings

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1608: You should never see it

Error Code
SQLSTATE
Error
Description

1608

ER_UNUSED_11

You should never see it

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1609: The BINLOG statement of type was not preceded by a format description BINLOG statement.

Error Code
SQLSTATE
Error
Description

1609

HY000

ER_NO_FORMAT_DESCRIPTION_EVENT _BEFORE_BINLOG_STATEMENT

The BINLOG statement of type %s was not preceded by a format description BINLOG statement.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1610: Corrupted replication event was detected

Error Code
SQLSTATE
Error
Description

1610

HY000

ER_SLAVE_CORRUPT_EVENT

Corrupted replication event was detected

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1611: Invalid column reference in LOAD DATA

Error Code
SQLSTATE
Error
Description

1611

HY000

ER_LOAD_DATA_INVALID_COLUMN

Invalid column reference (%s) in LOAD DATA

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1612: Being purged log was not found

Error Code
SQLSTATE
Error
Description

1612

HY000

ER_LOG_PURGE_NO_FILE

Being purged log %s was not found

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1613: XA_RBTIMEOUT: Transaction branch was rolled back: took too long

Error Code
SQLSTATE
Error
Description

1613

XA106

ER_XA_RBTIMEOUT

XA_RBTIMEOUT: Transaction branch was rolled back: took too long

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1614: XA_RBDEADLOCK: Transaction branch was rolled back: deadlock was detected

Error Code
SQLSTATE
Error
Description

1614

XA102

ER_XA_RBDEADLOCK

XA_RBDEADLOCK: Transaction branch was rolled back: deadlock was detected

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1615: Prepared statement needs to be re-prepared

Error Code
SQLSTATE
Error
Description

1615

HY000

ER_NEED_REPREPARE

Prepared statement needs to be re-prepared

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1616: DELAYED option not supported for table

Error Code
SQLSTATE
Error
Description

1616

HY000

ER_DELAYED_NOT_SUPPORTED

DELAYED option not supported for table '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1617: The master info structure does not exist

Error Code
SQLSTATE
Error
Description

1617

HY000

WARN_NO_MASTER_INF

The master info structure does not exist

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1618: option ignored

Error Code
SQLSTATE
Error
Description

1618

HY000

WARN_OPTION_IGNORED

<%s> option ignored

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1619: Built-in plugins cannot be deleted

Error Code
SQLSTATE
Error
Description

1619

HY000

WARN_PLUGIN_DELETE_BUILTIN

Built-in plugins cannot be deleted

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1620: Plugin is busy and will be uninstalled on shutdown

Error Code
SQLSTATE
Error
Description

1620

HY000

WARN_PLUGIN_BUSY

Plugin is busy and will be uninstalled on shutdown

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1621: variable is read-only. Use SET to assign the value

Error Code
SQLSTATE
Error
Description

1621

HY000

ER_VARIABLE_IS_READONLY

%s variable '%s' is read-only. Use SET %s to assign the value

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1622: Storage engine does not support rollback for this statement

Error Code
SQLSTATE
Error
Description

1622

HY000

ER_WARN_ENGINE_TRANSACTION_ROLLBACK

Storage engine %s does not support rollback for this statement. Transaction rolled back and must be restarted

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1623: Unexpected master's heartbeat data

Error Code
SQLSTATE
Error
Description

1623

HY000

ER_SLAVE_HEARTBEAT_FAILURE

Unexpected master's heartbeat data: %s

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1624: The requested value for the heartbeat period is either negative or exceeds the maximum a

Error Code
SQLSTATE
Error
Description

1624

HY000

ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE

The requested value for the heartbeat period is either negative or exceeds the maximum allowed (%s seconds).

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1625: You should never see it

Error Code
SQLSTATE
Error
Description

1625

ER_UNUSED_14

You should never see it

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1626: Error in parsing conflict function

Error Code
SQLSTATE
Error
Description

1626

HY000

ER_CONFLICT_FN_PARSE_ERROR

Error in parsing conflict function. Message: %s

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1627: Write to exceptions table failed

Error Code
SQLSTATE
Error
Description

1627

HY000

ER_EXCEPTIONS_WRITE_ERROR

Write to exceptions table failed. Message: %s"

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1628: Comment for table is too long

Error Code
SQLSTATE
Error
Description

1628

HY000

ER_TOO_LONG_TABLE_COMMENT

Comment for table '%s' is too long (max = %lu)

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1629: Comment for field is too long

Error Code
SQLSTATE
Error
Description

1629

HY000

ER_TOO_LONG_FIELD_COMMENT

Comment for field '%s' is too long (max = %lu)

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1630: FUNCTION does not exist. Check the 'Function Name Parsing and Resolution' section in the

Error Code
SQLSTATE
Error
Description

1630

42000

ER_FUNC_INEXISTENT_NAME_COLLISION

FUNCTION %s does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1631: Database

Error Code
SQLSTATE
Error
Description

1631

HY000

ER_DATABASE_NAME

Database

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1632: Table

Error Code
SQLSTATE
Error
Description

1632

HY000

ER_TABLE_NAME

Table

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1633: Partition

Error Code
SQLSTATE
Error
Description

1633

HY000

ER_PARTITION_NAME

Partition

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1634: Subpartition

Error Code
SQLSTATE
Error
Description

1634

HY000

ER_SUBPARTITION_NAME

Subpartition

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1635: Temporary

Error Code
SQLSTATE
Error
Description

1635

HY000

ER_TEMPORARY_NAME

Temporary

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1636: Renamed

Error Code
SQLSTATE
Error
Description

1636

HY000

ER_RENAMED_NAME

Renamed

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1637: Too many active concurrent transactions

Error Code
SQLSTATE
Error
Description

1637

HY000

ER_TOO_MANY_CONCURRENT_TRXS

Too many active concurrent transactions

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1638: Non-ASCII separator arguments are not fully supported

Error Code
SQLSTATE
Error
Description

1638

HY000

WARN_NON_ASCII_SEPARATOR_NOT_IMPLEMENTED

Non-ASCII separator arguments are not fully supported

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1639: debug sync point wait timed out

Error Code
SQLSTATE
Error
Description

1639

HY000

ER_DEBUG_SYNC_TIMEOUT

debug sync point wait timed out

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1640: debug sync point hit limit reached

Error Code
SQLSTATE
Error
Description

1640

HY000

ER_DEBUG_SYNC_HIT_LIMIT

debug sync point hit limit reached

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1641: Duplicate condition information item

Error Code
SQLSTATE
Error
Description

1641

42000

ER_DUP_SIGNAL_SET

Duplicate condition information item '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1642: Unhandled user-defined warning condition

Error Code
SQLSTATE
Error
Description

1642

01000

ER_SIGNAL_WARN

Unhandled user-defined warning condition

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1643: Unhandled user-defined not found condition

Error Code
SQLSTATE
Error
Description

1643

02000

ER_SIGNAL_NOT_FOUND

Unhandled user-defined not found condition

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1644: Unhandled user-defined exception condition

Error Code
SQLSTATE
Error
Description

1644

HY000

ER_SIGNAL_EXCEPTION

Unhandled user-defined exception condition

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1645: RESIGNAL when handler not active

Error Code
SQLSTATE
Error
Description

1645

0K000

ER_RESIGNAL_WITHOUT_ACTIVE_HANDLER

RESIGNAL when handler not active

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1646: SIGNAL/RESIGNAL can only use a CONDITION defined with SQLSTATE

Error Code
SQLSTATE
Error
Description

1646

HY000

ER_SIGNAL_BAD_CONDITION_TYPE

SIGNAL/RESIGNAL can only use a CONDITION defined with SQLSTATE

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1647: Data truncated for condition item

Error Code
SQLSTATE
Error
Description

1647

HY000

WARN_COND_ITEM_TRUNCATED

Data truncated for condition item '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1648: Data too long for condition item

Error Code
SQLSTATE
Error
Description

1648

HY000

ER_COND_ITEM_TOO_LONG

Data too long for condition item '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1649: Unknown locale

Error Code
SQLSTATE
Error
Description

1649

HY000

ER_UNKNOWN_LOCALE

Unknown locale: '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1650: The requested server id clashes with the slave startup option --replicate-same-server-id

Error Code
SQLSTATE
Error
Description

1650

HY000

ER_SLAVE_IGNORE_SERVER_IDS

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

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

Error Code
SQLSTATE
Error
Description

1651

HY000

ER_QUERY_CACHE_DISABLED

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1652: Duplicate partition field name

Error Code
SQLSTATE
Error
Description

1652

HY000

ER_SAME_NAME_PARTITION_FIELD

Duplicate partition field name '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1653: Inconsistency in usage of column lists for partitioning

Error Code
SQLSTATE
Error
Description

1653

HY000

ER_PARTITION_COLUMN_LIST_ERROR

Inconsistency in usage of column lists for partitioning

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1654: Partition column values of incorrect type

Error Code
SQLSTATE
Error
Description

1654

HY000

ER_WRONG_TYPE_COLUMN_VALUE_ERROR

Partition column values of incorrect type

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1655: Too many fields

Error Code
SQLSTATE
Error
Description

1655

HY000

ER_TOO_MANY_PARTITION_FUNC_FIELDS_ERROR

Too many fields in '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1656: Cannot use MAXVALUE as value in VALUES IN

Error Code
SQLSTATE
Error
Description

1656

HY000

ER_MAXVALUE_IN_VALUES_IN

Cannot use MAXVALUE as value in VALUES IN

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1657: Cannot have more than one value for this type of partitioning

Error Code
SQLSTATE
Error
Description

1657

HY000

ER_TOO_MANY_VALUES_ERROR

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

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

Error Code
SQLSTATE
Error
Description

1658

HY000

ER_ROW_SINGLE_PARTITION_FIELD_ERROR

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1659: Field is of a not allowed type for this type of partitioning

Error Code
SQLSTATE
Error
Description

1659

HY000

ER_FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELD

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1660: The total length of the partitioning fields is too large

Error Code
SQLSTATE
Error
Description

1660

HY000

ER_PARTITION_FIELDS_TOO_LONG

The total length of the partitioning fields is too large

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1661: Cannot execute statement: impossible to write to binary log since both row-incapable eng

Error Code
SQLSTATE
Error
Description

1661

HY000

ER_BINLOG_ROW_ENGINE_AND_STMT_ENGINE

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1662: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = ROW an

Error Code
SQLSTATE
Error
Description

1662

HY000

ER_BINLOG_ROW_MODE_AND_STMT_ENGINE

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.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1663: Cannot execute statement: impossible to write to binary log since statement is unsafe, s

Error Code
SQLSTATE
Error
Description

1663

HY000

ER_BINLOG_UNSAFE_AND_STMT_ENGINE

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1664: Cannot execute statement: impossible to write to binary log since statement is in row fo

Error Code
SQLSTATE
Error
Description

1664

HY000

ER_BINLOG_ROW_INJECTION_AND_STMT_ENGINE

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.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1665: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEM

Error Code
SQLSTATE
Error
Description

1665

HY000

ER_BINLOG_STMT_MODE_AND_ROW_ENGINE

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1666: Cannot execute statement: impossible to write to binary log since statement is in row fo

Error Code
SQLSTATE
Error
Description

1666

HY000

ER_BINLOG_ROW_INJECTION_AND_STMT_MODE

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1667: Cannot execute statement: impossible to write to binary log since more than one engine i

Error Code
SQLSTATE
Error
Description

1667

HY000

ER_BINLOG_MULTIPLE_ENGINES _AND_SELF_LOGGING_ENGINE

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1668: The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set o

Error Code
SQLSTATE
Error
Description

1668

HY000

ER_BINLOG_UNSAFE_LIMIT

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1669: The statement is unsafe because it uses INSERT DELAYED. This is unsafe because the times

Error Code
SQLSTATE
Error
Description

1669

HY000

ER_BINLOG_UNSAFE_INSERT_DELAYED

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1670: The statement is unsafe because it uses the general log, slow query log, or performance_

Error Code
SQLSTATE
Error
Description

1670

HY000

ER_BINLOG_UNSAFE_SYSTEM_TABLE

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.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1671: Statement is unsafe because it invokes a trigger or a stored function that inserts into

Error Code
SQLSTATE
Error
Description

1671

HY000

ER_BINLOG_UNSAFE_AUTOINC_COLUMNS

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.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1672: Statement is unsafe because it uses a UDF which may not return the same value on the sla

Error Code
SQLSTATE
Error
Description

1672

HY000

ER_BINLOG_UNSAFE_UDF

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1673: Statement is unsafe because it uses a system variable that may have a different value on

Error Code
SQLSTATE
Error
Description

1673

HY000

ER_BINLOG_UNSAFE_SYSTEM_VARIABLE

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1674: Statement is unsafe because it uses a system function that may return a different value

Error Code
SQLSTATE
Error
Description

1674

HY000

ER_BINLOG_UNSAFE_SYSTEM_FUNCTION

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1675: Statement is unsafe because it accesses a non-transactional table after accessing a tran

Error Code
SQLSTATE
Error
Description

1675

HY000

ER_BINLOG_UNSAFE_NONTRANS_AFTER_TRANS

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1676: Statement

Error Code
SQLSTATE
Error
Description

1676

HY000

ER_MESSAGE_AND_STATEMENT

%s Statement: %s

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1677: Column of table cannot be converted from type to type

Error Code
SQLSTATE
Error
Description

1677

HY000

ER_SLAVE_CONVERSION_FAILED

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1678: Can't create conversion table for table

Error Code
SQLSTATE
Error
Description

1678

HY000

ER_SLAVE_CANT_CREATE_CONVERSION

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1679: Cannot modify @@session.binlog_format inside a transaction

Error Code
SQLSTATE
Error
Description

1679

HY000

ER_INSIDE_TRANSACTION _PREVENTS_SWITCH_BINLOG_FORMAT

Cannot modify @@session.binlog_format inside a transaction

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1680: The path specified is too long

Error Code
SQLSTATE
Error
Description

1680

HY000

ER_PATH_LENGTH

The path specified for %s is too long.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1681: is deprecated and will be removed in a future release.

Error Code
SQLSTATE
Error
Description

1681

HY000

ER_WARN_DEPRECATED_SYNTAX_NO_REPLACEMENT

'%s' is deprecated and will be removed in a future release.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1682: Native table has the wrong structure

Error Code
SQLSTATE
Error
Description

1682

HY000

ER_WRONG_NATIVE_TABLE_STRUCTURE

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1683: Invalid performance_schema usage

Error Code
SQLSTATE
Error
Description

1683

HY000

ER_WRONG_PERFSCHEMA_USAGE

Invalid performance_schema usage.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1684: Table was skipped since its definition is being modified by concurrent DDL statement

Error Code
SQLSTATE
Error
Description

1684

HY000

ER_WARN_I_S_SKIPPED_TABLE

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1685: Cannot modify @@session.binlog_direct_non_transactional_updates inside a transaction

Error Code
SQLSTATE
Error
Description

1685

HY000

ER_INSIDE_TRANSACTION _PREVENTS_SWITCH_BINLOG_DIRECT

Cannot modify @@session.binlog_direct_non_transactional_updates inside a transaction

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

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

Error Code
SQLSTATE
Error
Description

1686

HY000

ER_STORED_FUNCTION_PREVENTS _SWITCH_BINLOG_DIRECT

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1687: A SPATIAL index may only contain a geometrical type column

Error Code
SQLSTATE
Error
Description

1687

42000

ER_SPATIAL_MUST_HAVE_GEOM_COL

A SPATIAL index may only contain a geometrical type column

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1688: Comment for index is too long

Error Code
SQLSTATE
Error
Description

1688

HY000

ER_TOO_LONG_INDEX_COMMENT

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1689: Wait on a lock was aborted due to a pending exclusive lock

Error Code
SQLSTATE
Error
Description

1689

HY000

ER_LOCK_ABORTED

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1690: value is out of range in

Error Code
SQLSTATE
Error
Description

1690

22003

ER_DATA_OUT_OF_RANGE

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1691: A variable of a non-integer based type in LIMIT clause

Error Code
SQLSTATE
Error
Description

1691

HY000

ER_WRONG_SPVAR_TYPE_IN_LIMIT

A variable of a non-integer based type in LIMIT clause

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

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

Error Code
SQLSTATE
Error
Description

1692

HY000

ER_BINLOG_UNSAFE_MULTIPLE_ENGINES _AND_SELF_LOGGING_ENGINE

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1693: Statement accesses nontransactional table as well as transactional or temporary table, a

Error Code
SQLSTATE
Error
Description

1693

HY000

ER_BINLOG_UNSAFE_MIXED_STATEMENT

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1694: Cannot modify @@session.sql_log_bin inside a transaction

Error Code
SQLSTATE
Error
Description

1694

HY000

ER_INSIDE_TRANSACTION_ PREVENTS_SWITCH_SQL_LOG_BIN

Cannot modify @@session.sql_log_bin inside a transaction

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1695: Cannot change the sql_log_bin inside a stored function or trigger

Error Code
SQLSTATE
Error
Description

1695

HY000

ER_STORED_FUNCTION_ PREVENTS_SWITCH_SQL_LOG_BIN

Cannot change the sql_log_bin inside a stored function or trigger

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1696: Failed to read from the .par file

Error Code
SQLSTATE
Error
Description

1696

HY000

ER_FAILED_READ_FROM_PAR_FILE

Failed to read from the .par file

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1697: VALUES value for partition must have type INT

Error Code
SQLSTATE
Error
Description

1697

HY000

ER_VALUES_IS_NOT_INT_TYPE_ERROR

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

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1698: Access denied for user

Error Code
SQLSTATE
Error
Description

1698

28000

ER_ACCESS_DENIED_NO_PASSWORD_ERROR

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

Possible Causes and Solutions

The user/password combination may not exist.

There are a number of common problems that can occur when connecting to MariaDB. See Troubleshooting Connection Issues.

See Also

  • When access_denied_errors status variable is incremented

This page is licensed: CC BY-SA / Gnu FDL