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 1700 to 1799

Error 1700: GRANT with IDENTIFIED WITH is illegal because the user already exists

Error Code
SQLSTATE
Error
Description

1700

HY000

ER_GRANT_PLUGIN_USER_EXISTS

GRANT with IDENTIFIED WITH is illegal because the user %-.*s already exists

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 1701: Cannot truncate a table referenced in a foreign key constraint

Error Code
SQLSTATE
Error
Description

1701

42000

ER_TRUNCATE_ILLEGAL_FK

Cannot truncate a table referenced in a foreign key constraint (%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 1702: Plugin is force_plus_permanent and can not be unloaded

Error Code
SQLSTATE
Error
Description

1702

HY000

ER_PLUGIN_IS_PERMANENT

Plugin '%s' is force_plus_permanent and can not be unloaded

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 1703: The requested value for the heartbeat period is less than 1 millisecond

Error Code
SQLSTATE
Error
Description

1703

HY000

ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MIN

The requested value for the heartbeat period is less than 1 millisecond. The value is reset to 0, meaning that heartbeating will effectively be disabled.

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 1704: The requested value for the heartbeat period exceeds the value of slave_net_timeout seco

Error Code
SQLSTATE
Error
Description

1704

HY000

ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MAX

The requested value for the heartbeat period exceeds the value of slave_net_timeout seconds. A sensible value for the period should be less than the timeout.

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 1705: Multi-row statements required more than 'max_binlog_stmt_cache_size' bytes of storage; i

Error Code
SQLSTATE
Error
Description

1705

HY000

ER_STMT_CACHE_FULL

Multi-row statements required more than 'max_binlog_stmt_cache_size' bytes of storage; increase this mysqld variable and try again

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 1706: Primary key/partition key update is not allowed since the table is updated both as and

Error Code
SQLSTATE
Error
Description

1706

HY000

ER_MULTI_UPDATE_KEY_CONFLICT

Primary key/partition key update is not allowed since the table is updated both as '%s' and '%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 1707: Table rebuild required. Please do "ALTER TABLE FORCE" or dump/reload to fix it!

Error Code
SQLSTATE
Error
Description

1707

HY000

ER_TABLE_NEEDS_REBUILD

Table rebuild required. Please do "ALTER TABLE %s FORCE" or dump/reload to fix 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 1708: The value of should be no less than the value of

Error Code
SQLSTATE
Error
Description

1708

HY000

WARN_OPTION_BELOW_LIMIT

The value of '%s' should be no less than the value of '%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 1709: Index column size too large. The maximum column size is bytes.

Error Code
SQLSTATE
Error
Description

1709

HY000

ER_INDEX_COLUMN_TOO_LONG

Index column size too large. The maximum column size is %lu bytes.

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 1710: Trigger has an error in its body

Error Code
SQLSTATE
Error
Description

1710

HY000

ER_ERROR_IN_TRIGGER_BODY

Trigger '%s' has an error in its body: '%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 1711: Unknown trigger has an error in its body

Error Code
SQLSTATE
Error
Description

1711

HY000

ER_ERROR_IN_UNKNOWN_TRIGGER_BODY

Unknown trigger has an error in its body: '%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 1712: Index is corrupted

Error Code
SQLSTATE
Error
Description

1712

HY000

ER_INDEX_CORRUPT

Index %s is corrupted

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 1713: Undo log record is too big

Error Code
SQLSTATE
Error
Description

1713

HY000

ER_UNDO_RECORD_TOO_BIG

Undo log record is too big.

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 1714: INSERT IGNORE... SELECT is unsafe because the order in which rows are retrieved by the S

Error Code
SQLSTATE
Error
Description

1714

HY000

ER_BINLOG_UNSAFE_INSERT_IGNORE_SELECT

INSERT IGNORE... SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and 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 1715: INSERT... SELECT... ON DUPLICATE KEY UPDATE is unsafe because the order in which rows ar

Error Code
SQLSTATE
Error
Description

1715

HY000

ER_BINLOG_UNSAFE_INSERT_SELECT_UPDATE

INSERT... SELECT... ON DUPLICATE KEY UPDATE is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are updated. This order cannot be predicted and may differ on master and 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 1716: REPLACE... SELECT is unsafe because the order in which rows are retrieved by the SELECT

Error Code
SQLSTATE
Error
Description

1716

HY000

ER_BINLOG_UNSAFE_REPLACE_SELECT

REPLACE... SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are replaced. This order cannot be predicted and may differ on master and 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 1717: CREATE... IGNORE SELECT is unsafe because the order in which rows are retrieved by the S

Error Code
SQLSTATE
Error
Description

1717

HY000

ER_BINLOG_UNSAFE_CREATE_IGNORE_SELECT

CREATE... IGNORE SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and 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 1718: CREATE... REPLACE SELECT is unsafe because the order in which rows are retrieved by the

Error Code
SQLSTATE
Error
Description

1718

HY000

ER_BINLOG_UNSAFE_CREATE_REPLACE_SELECT

CREATE... REPLACE SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are replaced. This order cannot be predicted and may differ on master and 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 1719: UPDATE IGNORE is unsafe because the order in which rows are updated determines which (if

Error Code
SQLSTATE
Error
Description

1719

HY000

ER_BINLOG_UNSAFE_UPDATE_IGNORE

UPDATE IGNORE is unsafe because the order in which rows are updated determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and 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 1720: You should never see it

Error Code
SQLSTATE
Error
Description

1720

ER_UNUSED_15

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 1721: You should never see it

Error Code
SQLSTATE
Error
Description

1721

ER_UNUSED_16

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 1722: Statements writing to a table with an auto-increment column after selecting from another

Error Code
SQLSTATE
Error
Description

1722

HY000

ER_BINLOG_UNSAFE_WRITE_AUTOINC_SELECT

Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and 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 1723: CREATE TABLE... SELECT... on a table with an auto-increment column is unsafe because the

Error Code
SQLSTATE
Error
Description

1723

HY000

ER_BINLOG_UNSAFE_CREATE_SELECT_AUTOINC

CREATE TABLE... SELECT... on a table with an auto-increment column is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are inserted. This order cannot be predicted and may differ on master and 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 1724: INSERT... ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe

Error Code
SQLSTATE
Error
Description

1724

HY000

ER_BINLOG_UNSAFE_INSERT_TWO_KEYS

INSERT... ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY 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 1725: Table is being used in foreign key check.

Error Code
SQLSTATE
Error
Description

1725

HY000

ER_TABLE_IN_FK_CHECK

Table is being used in foreign key check.

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 1726: Storage engine does not support system tables

Error Code
SQLSTATE
Error
Description

1726

HY000

ER_UNSUPPORTED_ENGINE

Storage engine '%s' does not support system tables. [%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 1727: INSERT into autoincrement field which is not the first part in the composed primary key

Error Code
SQLSTATE
Error
Description

1727

HY000

ER_BINLOG_UNSAFE_AUTOINC_NOT_FIRST

INSERT into autoincrement field which is not the first part in the composed primary key 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 1728: Cannot load from. The table is probably corrupted

Error Code
SQLSTATE
Error
Description

1728

HY000

ER_CANNOT_LOAD_FROM_TABLE_V2

Cannot load from %s.%s. The table is probably corrupted

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 1729: The requested value for the master delay exceeds the maximum

Error Code
SQLSTATE
Error
Description

1729

HY000

ER_MASTER_DELAY_VALUE_OUT_OF_RANGE

The requested value %s for the master delay exceeds the maximum %u

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 1730: Only Format_description_log_event and row events are allowed in BINLOG statements

Error Code
SQLSTATE
Error
Description

1730

HY000

ER_ONLY_FD_AND_RBR_EVENTS_ALLOWED_IN_BINLOG_STATEMENT

Only Format_description_log_event and row events are allowed in BINLOG statements (but %s was provided

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 1731: Non matching attribute between partition and table

Error Code
SQLSTATE
Error
Description

1731

HY000

ER_PARTITION_EXCHANGE_DIFFERENT_OPTION

Non matching attribute '%s' between partition and 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 1732: Table to exchange with partition is partitioned

Error Code
SQLSTATE
Error
Description

1732

HY000

ER_PARTITION_EXCHANGE_PART_TABLE

Table to exchange with partition is partitioned: '%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 1733: Table to exchange with partition is temporary

Error Code
SQLSTATE
Error
Description

1733

HY000

ER_PARTITION_EXCHANGE_TEMP_TABLE

Table to exchange with partition is temporary: '%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 1734: Subpartitioned table, use subpartition instead of partition

Error Code
SQLSTATE
Error
Description

1734

HY000

ER_PARTITION_INSTEAD_OF_SUBPARTITION

Subpartitioned table, use subpartition instead of 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 1735: Unknown partition in table

Error Code
SQLSTATE
Error
Description

1735

HY000

ER_UNKNOWN_PARTITION

Unknown partition '%s' in 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 1736: Tables have different definitions

Error Code
SQLSTATE
Error
Description

1736

HY000

ER_TABLES_DIFFERENT_METADATA

Tables have different definitions

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 1737: Found a row that does not match the partition

Error Code
SQLSTATE
Error
Description

1737

HY000

ER_ROW_DOES_NOT_MATCH_PARTITION

Found a row that does not match the 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 1738: Option binlog_cache_size is greater than max_binlog_cache_size; setting binlog_cache_siz

Error Code
SQLSTATE
Error
Description

1738

HY000

ER_BINLOG_CACHE_SIZE_GREATER_THAN_MAX

Option binlog_cache_size (%lu) is greater than max_binlog_cache_size (%lu); setting binlog_cache_size equal to max_binlog_cache_size.

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 1739: Cannot use access on index due to type or collation conversion on field

Error Code
SQLSTATE
Error
Description

1739

HY000

ER_WARN_INDEX_NOT_APPLICABLE

Cannot use %s access on index '%s' due to type or collation conversion on field '%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 1740: Table to exchange with partition has foreign key references

Error Code
SQLSTATE
Error
Description

1740

HY000

ER_PARTITION_EXCHANGE_FOREIGN_KEY

Table to exchange with partition has foreign key references: '%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 1741: Key value was not found in table

Error Code
SQLSTATE
Error
Description

1741

HY000

ER_NO_SUCH_KEY_VALUE

Key value '%s' was not found in 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 1742: Data for column too long

Error Code
SQLSTATE
Error
Description

1742

HY000

ER_RPL_INFO_DATA_TOO_LONG

Data for column '%s' 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 1743: Replication event checksum verification failed while reading from network.

Error Code
SQLSTATE
Error
Description

1743

HY000

ER_NETWORK_READ_EVENT_CHECKSUM_FAILURE

Replication event checksum verification failed while reading from network.

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 1744: Replication event checksum verification failed while reading from a log file

Error Code
SQLSTATE
Error
Description

1744

HY000

ER_BINLOG_READ_EVENT_CHECKSUM_FAILURE

Replication event checksum verification failed while reading from a log 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 1745: Option binlog_stmt_cache_size is greater than max_binlog_stmt_cache_size

Error Code
SQLSTATE
Error
Description

1745

HY000

ER_BINLOG_STMT_CACHE_SIZE_GREATER_THAN_MAX

Option binlog_stmt_cache_size (%lu) is greater than max_binlog_stmt_cache_size (%lu); setting binlog_stmt_cache_size equal to max_binlog_stmt_cache_size.

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 1746: Can't update table while is being created

Error Code
SQLSTATE
Error
Description

1746

HY000

ER_CANT_UPDATE_TABLE_IN_CREATE_TABLE_SELECT

Can't update table '%s' while '%s' is being created.

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 1747: PARTITION () clause on non partitioned table

Error Code
SQLSTATE
Error
Description

1747

HY000

ER_PARTITION_CLAUSE_ON_NONPARTITIONED

PARTITION () clause on non partitioned 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 1748: Found a row not matching the given partition set

Error Code
SQLSTATE
Error
Description

1748

HY000

ER_ROW_DOES_NOT_MATCH_GIVEN_PARTITION_SET

Found a row not matching the given partition set

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 1749: partition doesn't exist

Error Code
SQLSTATE
Error
Description

1749

HY000

ER_NO_SUCH_PARTITION_UNUSED

partition '%s' doesn't 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 1750: Failure while changing the type of replication repository

Error Code
SQLSTATE
Error
Description

1750

HY000

ER_CHANGE_RPL_INFO_REPOSITORY_FAILURE

Failure while changing the type of replication repository: %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 1751: The creation of some temporary tables could not be rolled back.

Error Code
SQLSTATE
Error
Description

1751

HY000

ER_WARNING_NOT_COMPLETE_ROLLBACK_WITH_CREATED_TEMP_TABLE

The creation of some temporary tables could not be rolled back.

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 1752: Some temporary tables were dropped, but these operations could not be rolled back.

Error Code
SQLSTATE
Error
Description

1752

HY000

ER_WARNING_NOT_COMPLETE_ROLLBACK_WITH_DROPPED_TEMP_TABLE

Some temporary tables were dropped, but these operations could not be rolled back.

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 1753: is not supported in multi-threaded slave mode

Error Code
SQLSTATE
Error
Description

1753

HY000

ER_MTS_FEATURE_IS_NOT_SUPPORTED

%s is not supported in multi-threaded slave mode. %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 1754: The number of modified databases exceeds the maximum

Error Code
SQLSTATE
Error
Description

1754

HY000

ER_MTS_UPDATED_DBS_GREATER_MAX

The number of modified databases exceeds the maximum %d; the database names will not be included in the replication event metadata.

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 1755: Cannot execute the current event group in the parallel mode

Error Code
SQLSTATE
Error
Description

1755

HY000

ER_MTS_CANT_PARALLEL

Cannot execute the current event group in the parallel mode. Encountered event %s, relay-log name %s, position %s which prevents execution of this event group in parallel mode. Reason: %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 1756: %s

Error Code
SQLSTATE
Error
Description

1756

HY000

ER_MTS_INCONSISTENT_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 1757: FULLTEXT index is not supported for partitioned tables

Error Code
SQLSTATE
Error
Description

1757

HY000

ER_FULLTEXT_NOT_SUPPORTED_WITH_PARTITIONING

FULLTEXT index is not supported for partitioned tables.

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 1758: Invalid condition number

Error Code
SQLSTATE
Error
Description

1758

35000

ER_DA_INVALID_CONDITION_NUMBER

Invalid condition number

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 1759: Sending passwords in plain text without SSL/TLS is extremely insecure

Error Code
SQLSTATE
Error
Description

1759

HY000

ER_INSECURE_PLAIN_TEXT

Sending passwords in plain text without SSL/TLS is extremely insecure.

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 1760: Storing MariaDB user name or password information in the master.info repository is not s

Error Code
SQLSTATE
Error
Description

1760

HY000

ER_INSECURE_CHANGE_MASTER

Storing MariaDB user name or password information in the master.info repository is not secure and is therefore not recommended. Please see the MariaDB Manual for more about this issue and possible alternatives

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 1761: Foreign key constraint for table, record would lead to a duplicate entry in table

Error Code
SQLSTATE
Error
Description

1761

23000

ER_FOREIGN_DUPLICATE_KEY_WITH_CHILD_INFO

Foreign key constraint for table '%s', record '%s' would lead to a duplicate entry in table '%s', key '%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 1762: Foreign key constraint for table, record would lead to a duplicate entry in a child tabl

Error Code
SQLSTATE
Error
Description

1762

23000

ER_FOREIGN_DUPLICATE_KEY_WITHOUT_CHILD_INFO

Foreign key constraint for table '%s', record '%s' would lead to a duplicate entry in a child 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 1763: Setting authentication options is not possible when only the Slave SQL Thread is being s

Error Code
SQLSTATE
Error
Description

1763

HY000

ER_SQLTHREAD_WITH_SECURE_SLAVE

Setting authentication options is not possible when only the Slave SQL Thread is being started.

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 1764: The table does not have FULLTEXT index to support this query

Error Code
SQLSTATE
Error
Description

1764

HY000

ER_TABLE_HAS_NO_FT

The table does not have FULLTEXT index to support this query

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 1765: The system variable cannot be set in stored functions or triggers

Error Code
SQLSTATE
Error
Description

1765

HY000

ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER

The system variable %s cannot be set in stored functions or triggers.

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 1766: The system variable cannot be set when there is an ongoing transaction

Error Code
SQLSTATE
Error
Description

1766

HY000

ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION

The system variable %s cannot be set when there is an ongoing 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 1767: The system variable @@SESSION.GTID_NEXT has the value which is not listed in @@SESSION.G

Error Code
SQLSTATE
Error
Description

1767

HY000

ER_GTID_NEXT_IS_NOT_IN_GTID_NEXT_LIST

The system variable @@SESSION.GTID_NEXT has the value %s, which is not listed in @@SESSION.GTID_NEXT_LIST.

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 1768: The system variable @@SESSION.GTID_NEXT cannot change inside a transaction

Error Code
SQLSTATE
Error
Description

1768

HY000

ER_CANT_CHANGE_GTID_NEXT_IN_TRANSACTION_WHEN_GTID_NEXT_LIST_IS_NULL

The system variable @@SESSION.GTID_NEXT cannot change 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 1769: The statement 'SET' cannot invoke a stored function

Error Code
SQLSTATE
Error
Description

1769

HY000

ER_SET_STATEMENT_CANNOT_INVOKE_FUNCTION

The statement 'SET %s' cannot invoke a stored function.

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 1770: The system variable @@SESSION.GTID_NEXT cannot be 'AUTOMATIC' when @@SESSION.GTID_NEXT_L

Error Code
SQLSTATE
Error
Description

1770

HY000

ER_GTID_NEXT_CANT_BE_AUTOMATIC_IF_GTID_NEXT_LIST_IS_NON_NULL

The system variable @@SESSION.GTID_NEXT cannot be 'AUTOMATIC' when @@SESSION.GTID_NEXT_LIST is non-NULL.

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 1771: Skipping transaction because it has already been executed and logged

Error Code
SQLSTATE
Error
Description

1771

HY000

ER_SKIPPING_LOGGED_TRANSACTION

Skipping transaction %s because it has already been executed and logged.

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 1772: Malformed GTID set specification

Error Code
SQLSTATE
Error
Description

1772

HY000

ER_MALFORMED_GTID_SET_SPECIFICATION

Malformed GTID set specification '%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 1773: Malformed GTID set encoding

Error Code
SQLSTATE
Error
Description

1773

HY000

ER_MALFORMED_GTID_SET_ENCODING

Malformed GTID set encoding.

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 1774: Malformed GTID specification

Error Code
SQLSTATE
Error
Description

1774

HY000

ER_MALFORMED_GTID_SPECIFICATION

Malformed GTID specification '%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 1775: Impossible to generate Global Transaction Identifier: the integer component reached the

Error Code
SQLSTATE
Error
Description

1775

HY000

ER_GNO_EXHAUSTED

Impossible to generate Global Transaction Identifier: the integer component reached the maximal value. Restart the server with a new server_uuid.

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 1776: Parameters MASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be s

Error Code
SQLSTATE
Error
Description

1776

HY000

ER_BAD_SLAVE_AUTO_POSITION

Parameters MASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be set when MASTER_AUTO_POSITION is 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 1777: CHANGE MASTER TO MASTER_AUTO_POSITION = 1 can only be executed when @@GLOBAL.GTID_MODE =

Error Code
SQLSTATE
Error
Description

1777

HY000

ER_AUTO_POSITION_REQUIRES_GTID_MODE_ON

CHANGE MASTER TO MASTER_AUTO_POSITION = 1 can only be executed when @@GLOBAL.GTID_MODE = ON.

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 1778: Cannot execute statements with implicit commit inside a transaction when @@SESSION.GTID_

Error Code
SQLSTATE
Error
Description

1778

HY000

ER_CANT_DO_IMPLICIT_COMMIT_IN_TRX_WHEN_GTID_NEXT_IS_SET

Cannot execute statements with implicit commit inside a transaction when @@SESSION.GTID_NEXT != AUTOMATIC.

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 1779: GTID_MODE = ON or GTID_MODE = UPGRADE_STEP_2 requires DISABLE_GTID_UNSAFE_STATEMENTS = 1

Error Code
SQLSTATE
Error
Description

1779

HY000

ER_GTID_MODE_2_OR_3_REQUIRES_DISABLE_GTID_UNSAFE_STATEMENTS_ON

GTID_MODE = ON or GTID_MODE = UPGRADE_STEP_2 requires DISABLE_GTID_UNSAFE_STATEMENTS = 1.

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 1780: @@GLOBAL.GTID_MODE = ON or UPGRADE_STEP_1 or UPGRADE_STEP_2 requires --log-bin and --log

Error Code
SQLSTATE
Error
Description

1780

HY000

ER_GTID_MODE_REQUIRES_BINLOG

@@GLOBAL.GTID_MODE = ON or UPGRADE_STEP_1 or UPGRADE_STEP_2 requires --log-bin and --log-slave-updates.

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 1781: @@SESSION.GTID_NEXT cannot be set to UUID:NUMBER when @@GLOBAL.GTID_MODE = OFF

Error Code
SQLSTATE
Error
Description

1781

HY000

ER_CANT_SET_GTID_NEXT_TO_GTID_WHEN_GTID_MODE_IS_OFF

@@SESSION.GTID_NEXT cannot be set to UUID:NUMBER when @@GLOBAL.GTID_MODE = OFF.

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 1782: @@SESSION.GTID_NEXT cannot be set to ANONYMOUS when @@GLOBAL.GTID_MODE = ON

Error Code
SQLSTATE
Error
Description

1782

HY000

ER_CANT_SET_GTID_NEXT_TO_ANONYMOUS_WHEN_GTID_MODE_IS_ON

@@SESSION.GTID_NEXT cannot be set to ANONYMOUS when @@GLOBAL.GTID_MODE = ON.

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 1783: @@SESSION.GTID_NEXT_LIST cannot be set to a non-NULL value when @@GLOBAL.GTID_MODE = OFF

Error Code
SQLSTATE
Error
Description

1783

HY000

ER_CANT_SET_GTID_NEXT_LIST_TO_NON_NULL_WHEN_GTID_MODE_IS_OFF

@@SESSION.GTID_NEXT_LIST cannot be set to a non-NULL value when @@GLOBAL.GTID_MODE = OFF.

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 1784: Found a Gtid_log_event or Previous_gtids_log_event when @@GLOBAL.GTID_MODE = OFF

Error Code
SQLSTATE
Error
Description

1784

HY000

ER_FOUND_GTID_EVENT_WHEN_GTID_MODE_IS_OFF

Found a Gtid_log_event or Previous_gtids_log_event when @@GLOBAL.GTID_MODE = OFF.

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 1785: When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, updates to non-transactional tables can only

Error Code
SQLSTATE
Error
Description

1785

HY000

ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE

When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.

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 1786: CREATE TABLE ... SELECT is forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1

Error Code
SQLSTATE
Error
Description

1786

HY000

ER_GTID_UNSAFE_CREATE_SELECT

CREATE TABLE ... SELECT is forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.

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 1787: When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, the statements CREATE TEMPORARY TABLE and DR

Error Code
SQLSTATE
Error
Description

1787

HY000

ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION

When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, the statements CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can be executed in a non-transactional context only, and require that AUTOCOMMIT = 1.

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 1788: The value of @@GLOBAL.GTID_MODE can only change one step at a time

Error Code
SQLSTATE
Error
Description

1788

HY000

ER_GTID_MODE_CAN_ONLY_CHANGE_ONE_STEP_AT_A_TIME

The value of @@GLOBAL.GTID_MODE can only change one step at a time: OFF <-> UPGRADE_STEP_1 <-> UPGRADE_STEP_2 <-> ON. Also note that this value must be stepped up or down simultaneously on all servers; see the Manual for instructions.

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 1789: The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master

Error Code
SQLSTATE
Error
Description

1789

HY000

ER_MASTER_HAS_PURGED_REQUIRED_GTIDS

The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the slave requires.

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 1790: @@SESSION.GTID_NEXT cannot be changed by a client that owns a GTID

Error Code
SQLSTATE
Error
Description

1790

HY000

ER_CANT_SET_GTID_NEXT_WHEN_OWNING_GTID

@@SESSION.GTID_NEXT cannot be changed by a client that owns a GTID. The client owns %s. Ownership is released on COMMIT or ROLLBACK.

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 1791: Unknown EXPLAIN format name

Error Code
SQLSTATE
Error
Description

1791

HY000

ER_UNKNOWN_EXPLAIN_FORMAT

Unknown EXPLAIN format 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 1792: Cannot execute statement in a READ ONLY transaction

Error Code
SQLSTATE
Error
Description

1792

25006

ER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION

Cannot execute statement in a READ ONLY 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 1793: Comment for table partition is too long

Error Code
SQLSTATE
Error
Description

1793

HY000

ER_TOO_LONG_TABLE_PARTITION_COMMENT

Comment for table partition '%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 1794: Slave is not configured or failed to initialize properly. You must at least set --server

Error Code
SQLSTATE
Error
Description

1794

HY000

ER_SLAVE_CONFIGURATION

Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave. Additional error messages can be found in the MariaDB error log

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 1795: InnoDB presently supports one FULLTEXT index creation at a time

Error Code
SQLSTATE
Error
Description

1795

HY000

ER_INNODB_FT_LIMIT

InnoDB presently supports one FULLTEXT index creation at a time

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 1796: Cannot create FULLTEXT index on temporary InnoDB table

Error Code
SQLSTATE
Error
Description

1796

HY000

ER_INNODB_NO_FT_TEMP_TABLE

Cannot create FULLTEXT index on temporary InnoDB 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 1797: Column is of wrong type for an InnoDB FULLTEXT index

Error Code
SQLSTATE
Error
Description

1797

HY000

ER_INNODB_FT_WRONG_DOCID_COLUMN

Column '%s' is of wrong type for an InnoDB FULLTEXT index

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 1798: Index '%s' is of wrong type for an InnoDB FULLTEXT index

Error Code
SQLSTATE
Error
Description

1798

HY000

ER_INNODB_FT_WRONG_DOCID_INDEX

Index '%s' is of wrong type for an InnoDB FULLTEXT index

Possible Causes and Solutions

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

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