All pages
Powered by GitBook
1 of 82

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

MariaDB Error Codes 1800 to 1899

Error 1801: Unknown LOCK type

Error Code
SQLSTATE
Error
Description

1801

HY000

ER_UNKNOWN_ALTER_LOCK

Unknown LOCK type '%s'

Possible Causes and Solutions

Error 1800: Unknown ALGORITHM

Error Code
SQLSTATE
Error
Description

Possible Causes and Solutions

1800

HY000

ER_UNKNOWN_ALTER_ALGORITHM

Unknown ALGORITHM '%s'

Error 1804: Cannot clean up worker info tables

Error Code
SQLSTATE
Error
Description

1804

HY000

ER_MTS_RESET_WORKERS

Cannot clean up worker info tables. Additional error messages can be found in the MariaDB error log

Possible Causes and Solutions

Error 1805: Column count of is wrong. Expected, found. The table is probably corrupted

Error Code
SQLSTATE
Error
Description

1805

HY000

ER_COL_COUNT_DOESNT_MATCH_CORRUPTED_V2

Column count of %s.%s is wrong. Expected %d, found %d. The table is probably corrupted

Possible Causes and Solutions

Error 1810: IO Read error

Error Code
SQLSTATE
Error
Description

1810

HY000

ER_IO_READ_ERROR

IO Read error: (%lu, %s) %s

Possible Causes and Solutions

Error 1811: IO Write error

Error Code
SQLSTATE
Error
Description

1811

HY000

ER_IO_WRITE_ERROR

IO Write error: (%lu, %s) %s

Possible Causes and Solutions

Error 1814: Tablespace has been discarded for table

Error Code
SQLSTATE
Error
Description

1814

HY000

ER_TABLESPACE_DISCARDED

Tablespace has been discarded for table '%s'

Possible Causes and Solutions

Error 1816: ALTER TABLE IMPORT TABLESPACE failed with error

Error Code
SQLSTATE
Error
Description

1816

HY000

ER_INNODB_IMPORT_ERROR

ALTER TABLE '%s' IMPORT TABLESPACE failed with error %lu : '%s'

Possible Causes and Solutions

Error 1817: Index corrupt

Error Code
SQLSTATE
Error
Description

1817

HY000

ER_INNODB_INDEX_CORRUPT

Index corrupt: %s

Possible Causes and Solutions

Error 1819: Your password does not satisfy the current policy requirements

Error Code
SQLSTATE
Error
Description

1819

HY000

ER_NOT_VALID_PASSWORD

Your password does not satisfy the current policy requirements

Possible Causes and Solutions

Error 1822: Failed to add the foreign key constaint. Missing index for constraint in the referenced

Error Code
SQLSTATE
Error
Description

1822

HY000

ER_FK_NO_INDEX_PARENT

Failed to add the foreign key constaint. Missing index for constraint '%s' in the referenced table '%s'

Possible Causes and Solutions

Error 1824: Failed to open the referenced table

Error Code
SQLSTATE
Error
Description

1824

HY000

ER_FK_CANNOT_OPEN_PARENT

Failed to open the referenced table '%s'

Possible Causes and Solutions

Error 1825: Failed to add the foreign key constraint on table. Incorrect options in FOREIGN KEY cons

Error Code
SQLSTATE
Error
Description

1825

HY000

ER_FK_INCORRECT_OPTION

Failed to add the foreign key constraint on table '%s'. Incorrect options in FOREIGN KEY constraint '%s'

Possible Causes and Solutions

Error 1826: Duplicate foreign key constraint name

Error Code
SQLSTATE
Error
Description

1826

HY000

ER_FK_DUP_NAME

Duplicate foreign key constraint name '%s'

Possible Causes and Solutions

Error 1829: Cannot drop column: needed in a foreign key constraint of table

Error Code
SQLSTATE
Error
Description

1829

HY000

ER_FK_COLUMN_CANNOT_DROP_CHILD

Cannot drop column '%s': needed in a foreign key constraint '%s' of table '%s'

Possible Causes and Solutions

Error 1828: Cannot drop column: needed in a foreign key constraint

Error Code
SQLSTATE
Error
Description

1828

HY000

ER_FK_COLUMN_CANNOT_DROP

Cannot drop column '%s': needed in a foreign key constraint '%s'

Possible Causes and Solutions

Error 1830: Column cannot be NOT NULL: needed in a foreign key constraint SET NULL

Error Code
SQLSTATE
Error
Description

1830

HY000

ER_FK_COLUMN_NOT_NULL

Column '%s' cannot be NOT NULL: needed in a foreign key constraint '%s' SET NULL

Possible Causes and Solutions

Error 1832: Cannot change column: used in a foreign key constraint

Error Code
SQLSTATE
Error
Description

1832

HY000

ER_FK_COLUMN_CANNOT_CHANGE

Cannot change column '%s': used in a foreign key constraint '%s'

Possible Causes and Solutions

Error 1833: Cannot change column: used in a foreign key constraint of table

Error Code
SQLSTATE
Error
Description

1833

HY000

ER_FK_COLUMN_CANNOT_CHANGE_CHILD

Cannot change column '%s': used in a foreign key constraint '%s' of table '%s'

Possible Causes and Solutions

Error 1835: Malformed communication packet.

Error Code
SQLSTATE
Error
Description

1835

HY000

ER_MALFORMED_PACKET

Malformed communication packet.

Possible Causes and Solutions

Error 1836: Running in read-only mode

Error Code
SQLSTATE
Error
Description

1836

HY000

ER_READ_ONLY_MODE

Running in read-only mode

Possible Causes and Solutions

Error 1839: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ON

Error Code
SQLSTATE
Error
Description

1839

HY000

ER_CANT_SET_GTID_PURGED_WHEN_GTID_MODE_IS_OFF

@@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ON.

Possible Causes and Solutions

Error 1840: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty

Error Code
SQLSTATE
Error
Description

1840

HY000

ER_CANT_SET_GTID_PURGED_WHEN_GTID_EXECUTED_IS_NOT_EMPTY

@@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.

Possible Causes and Solutions

Error 1842: @@GLOBAL.GTID_PURGED was changed from to

Error Code
SQLSTATE
Error
Description

1842

HY000

ER_GTID_PURGED_WAS_CHANGED

@@GLOBAL.GTID_PURGED was changed from '%s' to '%s'.

Possible Causes and Solutions

Error 1848: Partition specific operations do not yet support LOCK/ALGORITHM

Error Code
SQLSTATE
Error
Description

1848

HY000

ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_PARTITION

Partition specific operations do not yet support LOCK/ALGORITHM

Possible Causes and Solutions

Error 1850: Cannot change column type INPLACE

Error Code
SQLSTATE
Error
Description

1850

HY000

ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_COLUMN_TYPE

Cannot change column type INPLACE

Possible Causes and Solutions

Error 1854: Adding an auto-increment column requires a lock

Error Code
SQLSTATE
Error
Description

1854

HY000

ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_AUTOINC

Adding an auto-increment column requires a lock

Possible Causes and Solutions

Error 1802: CHANGE MASTER cannot be executed when the slave was stopped with an error or killed in M

Error Code
SQLSTATE
Error
Description

Error 1803: Cannot recover after SLAVE errored out in parallel execution mode

Error Code
SQLSTATE
Error
Description

Error 1806: Slave must silently retry current transaction

Error Code
SQLSTATE
Error
Description

Error 1812: Tablespace is missing for table

Error Code
SQLSTATE
Error
Description

Error 1818: YEAR(%lu) column type is deprecated. Creating YEAR(4) column instead.

Error Code
SQLSTATE
Error
Description

Error 1823: Failed to add the foreign key constraint to system tables

Error Code
SQLSTATE
Error
Description

Error 1827: The password hash doesn't have the expected format

Error Code
SQLSTATE
Error
Description

Error 1831: Duplicate index defined on the table. This is deprecated and will be disallowed in a fut

Error Code
SQLSTATE
Error
Description

Error 1837: When GTID_NEXT is set to a GTID, you must explicitly set it again after a COMMIT or ROLL

Error Code
SQLSTATE
Error
Description

Error 1838: The system variable cannot be set in stored procedures

Error Code
SQLSTATE
Error
Description

Error 1841: @@GLOBAL.GTID_PURGED can only be set when there are no ongoing transactions (not even in

Error Code
SQLSTATE
Error
Description

Error 1843: @@GLOBAL.GTID_EXECUTED was changed from to

Error Code
SQLSTATE
Error
Description

Error 1845: is not supported for this operation. Try

Error Code
SQLSTATE
Error
Description

Error 1846: is not supported. Reason: Try

Error Code
SQLSTATE
Error
Description

Error 1853: Dropping a primary key is not allowed without also adding a new primary key

Error Code
SQLSTATE
Error
Description

Error 1855: Cannot replace hidden FTS_DOC_ID with a user-visible one

Error Code
SQLSTATE
Error
Description

Error 1856: Cannot drop or rename FTS_DOC_ID

Error Code
SQLSTATE
Error
Description

Error 1867: file was not purged because it was being read by thread(s), purged only out of

Error Code
SQLSTATE
Error
Description

Error 1870: Row events are not logged for statements that modify BLACKHOLE tables in row format

Error Code
SQLSTATE
Error
Description

Error 1864: Cannot schedule event, relay-log name, position to Worker thread because its size exceed

Error Code
SQLSTATE
Error
Description

Error 1857: Fulltext index creation requires a lock

Error Code
SQLSTATE
Error
Description

Error 1851: Adding foreign keys needs foreign_key_checks=OFF

Error Code
SQLSTATE
Error
Description

Error 1852: Creating unique indexes with IGNORE requires COPY algorithm to remove duplicate rows

Error Code
SQLSTATE
Error
Description

Error 1847: COPY algorithm requires a lock

Error Code
SQLSTATE
Error
Description

Error 1858: sql_slave_skip_counter can not be set when the server is running with @@GLOBAL.GTID_MODE

Error Code
SQLSTATE
Error
Description

Error 1859: Duplicate entry for key

Error Code
SQLSTATE
Error
Description

Error 1861: cannot silently convert NULL values, as required in this SQL_MODE

Error Code
SQLSTATE
Error
Description

Error 1869: Auto-increment value in UPDATE conflicts with internally generated values

Error Code
SQLSTATE
Error
Description

Error 1865: Cannot CREATE FULLTEXT INDEX WITH PARSER on InnoDB table

Error Code
SQLSTATE
Error
Description

Error 1863: Found a row in wrong partition

Error Code
SQLSTATE
Error
Description

Error 1866: The binary log file is logically corrupted

Error Code
SQLSTATE
Error
Description

Error 1862: Your password has expired. To log in you must change it using a client that supports exp

Error Code
SQLSTATE
Error
Description

Possible Causes and Solutions

1802

HY000

ER_MTS_CHANGE_MASTER_CANT_RUN_WITH_GAPS

CHANGE MASTER cannot be executed when the slave was stopped with an error or killed in MTS mode. Consider using RESET SLAVE or START SLAVE UNTIL.

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1803

HY000

ER_MTS_RECOVERY_FAILURE

Cannot recover after SLAVE errored out in parallel execution mode. Additional error messages can be found in the MariaDB error log

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1806

HY000

ER_SLAVE_SILENT_RETRY_TRANSACTION

Slave must silently retry current transaction

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1812

HY000

ER_TABLESPACE_MISSING

Tablespace is missing for table '%s'

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1818

HY000

ER_INVALID_YEAR_COLUMN_LENGTH

YEAR(%lu) column type is deprecated. Creating YEAR(4) column instead.

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1823

HY000

ER_FK_FAIL_ADD_SYSTEM

Failed to add the foreign key constraint '%s' to system tables

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1827

HY000

ER_PASSWORD_FORMAT

The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function.

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1831

HY000

ER_DUP_INDEX

Duplicate index '%s' defined on the table '%s.%s'. This is deprecated and will be disallowed in a future release.

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1837

HY000

ER_GTID_NEXT_TYPE_UNDEFINED_GROUP

When GTID_NEXT is set to a GTID, you must explicitly set it again after a COMMIT or ROLLBACK. If you see this error message in the slave SQL thread, it means that a table in the current transaction is transactional on the master and non-transactional on the slave. In a client connection, it means that you executed SET GTID_NEXT before a transaction and forgot to set GTID_NEXT to a different identifier or to 'AUTOMATIC' after COMMIT or ROLLBACK. Current GTID_NEXT is '%s'

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1838

HY000

ER_VARIABLE_NOT_SETTABLE_IN_SP

The system variable %s cannot be set in stored procedures.

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1841

HY000

ER_CANT_SET_GTID_PURGED_WHEN_OWNED_GTIDS_IS_NOT_EMPTY

@@GLOBAL.GTID_PURGED can only be set when there are no ongoing transactions (not even in other clients).

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1843

HY000

ER_GTID_EXECUTED_WAS_CHANGED

@@GLOBAL.GTID_EXECUTED was changed from '%s' to '%s'.

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1845

0A000

ER_ALTER_OPERATION_NOT_SUPPORTED

%s is not supported for this operation. Try %s.

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1846

0A000

ER_ALTER_OPERATION_NOT_SUPPORTED_REASON

%s is not supported. Reason: %s. Try %s.

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1853

HY000

ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOPK

Dropping a primary key is not allowed without also adding a new primary key

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1855

HY000

ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_HIDDEN_FTS

Cannot replace hidden FTS_DOC_ID with a user-visible one

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1856

HY000

ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_CHANGE_FTS

Cannot drop or rename FTS_DOC_ID

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1867

HY000

ER_WARN_PURGE_LOG_IN_USE

file %s was not purged because it was being read by %d thread(s), purged only %d out of %d files.

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1870

HY000

WARN_ON_BLOCKHOLE_IN_RBR

Row events are not logged for %s statements that modify BLACKHOLE tables in row format. Table(s): '%s'

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1864

HY000

ER_MTS_EVENT_BIGGER_PENDING_JOBS_SIZE_MAX

Cannot schedule event %s, relay-log name %s, position %s to Worker thread because its size %lu exceeds %lu of slave_pending_jobs_size_max.

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1857

HY000

ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FTS

Fulltext index creation requires a lock

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1851

HY000

ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FK_CHECK

Adding foreign keys needs foreign_key_checks=OFF

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1852

HY000

ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_IGNORE

Creating unique indexes with IGNORE requires COPY algorithm to remove duplicate rows

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1847

HY000

ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_COPY

COPY algorithm requires a lock

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1858

HY000

ER_SQL_SLAVE_SKIP_COUNTER_NOT_SETTABLE_IN_GTID_MODE

sql_slave_skip_counter can not be set when the server is running with @@GLOBAL.GTID_MODE = ON. Instead, for each transaction that you want to skip, generate an empty transaction with the same GTID as the transaction

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1859

23000

ER_DUP_UNKNOWN_IN_INDEX

Duplicate entry for key '%s'

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1861

HY000

ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOT_NULL

cannot silently convert NULL values, as required in this SQL_MODE

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1869

HY000

ER_AUTO_INCREMENT_CONFLICT

Auto-increment value in UPDATE conflicts with internally generated values

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1865

HY000

ER_INNODB_NO_FT_USES_PARSER

Cannot CREATE FULLTEXT INDEX WITH PARSER on InnoDB table

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1863

HY000

ER_ROW_IN_WRONG_PARTITION

Found a row in wrong partition %s

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1866

HY000

ER_BINLOG_LOGICAL_CORRUPTION

The binary log file '%s' is logically corrupted: %s

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1862

HY000

ER_MUST_CHANGE_PASSWORD_LOGIN

Your password has expired. To log in you must change it using a client that supports expired passwords.

This article doesn't currently contain any content.

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

Error 1807: There is a foreign key check running on table

Error Code
SQLSTATE
Error
Description

1807

HY000

ER_DISCARD_FK_CHECKS_RUNNING

There is a foreign key check running on table '%s'. Cannot discard the table.

Possible Causes and Solutions

Error 1809: Table in system tablespace

Error Code
SQLSTATE
Error
Description

1809

HY000

ER_TABLE_IN_SYSTEM_TABLESPACE

Table '%s' in system tablespace

Possible Causes and Solutions

Error 1813: Tablespace for table exists. Please DISCARD the tablespace before IMPORT

Error Code
SQLSTATE
Error
Description

1813

HY000

ER_TABLESPACE_EXISTS

Tablespace for table '%s' exists. Please DISCARD the tablespace before IMPORT.

Possible Causes and Solutions

Error 1815: Internal error

Error Code
SQLSTATE
Error
Description

1815

HY000

ER_INTERNAL_ERROR

Internal error: %s

Possible Causes and Solutions

Error 1820: You must SET PASSWORD before executing this statement

Error Code
SQLSTATE
Error
Description

1820

HY000

ER_MUST_CHANGE_PASSWORD

You must SET PASSWORD before executing this statement

Possible Causes and Solutions

Error 1834: Cannot delete rows from table which is parent in a foreign key constraint of table

Error Code
SQLSTATE
Error
Description

1834

HY000

ER_FK_CANNOT_DELETE_PARENT

Cannot delete rows from table which is parent in a foreign key constraint '%s' of table '%s'

Possible Causes and Solutions

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

Error Code
SQLSTATE
Error
Description

1844

HY000

ER_BINLOG_STMT_MODE_AND_NO_REPL_TABLES

Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT, and both replicated and non replicated tables are written to.

Possible Causes and Solutions

Error 1849: Columns participating in a foreign key are renamed

Error Code
SQLSTATE
Error
Description

1849

HY000

ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FK_RENAME

Columns participating in a foreign key are renamed

Possible Causes and Solutions

Error 1871: Slave failed to initialize master info structure from the repository

Error Code
SQLSTATE
Error
Description

1871

HY000

ER_SLAVE_MI_INIT_REPOSITORY

Slave failed to initialize master info structure from the repository

Possible Causes and Solutions

Error 1860: Long database name and identifier for object resulted in path length exceeding character

Error Code
SQLSTATE
Error
Description

1860

HY000

ER_IDENT_CAUSES_TOO_LONG_PATH

Long database name and identifier for object resulted in path length exceeding %d characters. Path: '%s'.

Possible Causes and Solutions

Error 1879: Upgrade index name failed, please use create index(alter table) algorithm copy to rebuil

Error Code
SQLSTATE
Error
Description

1879

HY000

ER_INNODB_FT_AUX_NOT_HEX_ID

Upgrade index name failed, please use create index(alter table) algorithm copy to rebuild index.

Possible Causes and Solutions

Error 1875: STOP SLAVE command execution is incomplete: Slave SQL thread got the stop signal

Error Code
SQLSTATE
Error
Description

1875

HY000

ER_STOP_SLAVE_SQL_THREAD_TIMEOUT

STOP SLAVE command execution is incomplete: Slave SQL thread got the stop signal, thread is busy, SQL thread will stop once the current task is complete.

Possible Causes and Solutions

Error 1880: "

Error Code
SQLSTATE
Error
Description

Error 1878: Temporary file write failure

Error Code
SQLSTATE
Error
Description

Error 1872: Slave failed to initialize relay log info structure from the repository

Error Code
SQLSTATE
Error
Description

Error 1877: Operation cannot be performed. The table is missing, corrupt or contains bad data

Error Code
SQLSTATE
Error
Description

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1880

ER_LAST_MYSQL_ERROR_MESSAGE

"

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1878

HY000

ER_TEMP_FILE_WRITE_FAILURE

Temporary file write failure.

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1872

HY000

ER_SLAVE_RLI_INIT_REPOSITORY

Slave failed to initialize relay log info structure from the repository

This article doesn't currently contain any content.

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

Possible Causes and Solutions

1877

HY000

ER_TABLE_CORRUPT

Operation cannot be performed. The table '%s.%s' is missing, corrupt or contains bad data.

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

Error 1873: Access denied trying to change to user (using password). Disconnecting.

Error Code
SQLSTATE
Error
Description

1873

28000

ER_ACCESS_DENIED_CHANGE_USER_ERROR

Access denied trying to change to user '%s'@'%s' (using password: %s). Disconnecting.

Possible Causes and Solutions

Error 1868: file was not purged because it is the active log file

Error Code
SQLSTATE
Error
Description

1868

HY000

ER_WARN_PURGE_LOG_IS_ACTIVE

file %s was not purged because it is the active log file.

Possible Causes and Solutions

Error 1874: InnoDB is in read only mode

Error Code
SQLSTATE
Error
Description

1874

HY000

ER_INNODB_READ_ONLY

InnoDB is in read only mode.

Possible Causes and Solutions

Error 1808: Schema mismatch

Error Code
SQLSTATE
Error
Description

1808

HY000

ER_TABLE_SCHEMA_MISMATCH

Schema mismatch (%s

Possible Causes and Solutions

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

Error 1821: Failed to add the foreign key constaint. Missing index for constraint in the foreign tab

Error Code
SQLSTATE
Error
Description

1821

HY000

ER_FK_NO_INDEX_CHILD

Failed to add the foreign key constaint. Missing index for constraint '%s' in the foreign table '%s'

Possible Causes and Solutions

This article doesn't currently contain any content.

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

Error 1876: STOP SLAVE command execution is incomplete: Slave IO thread got the stop signal

Error Code
SQLSTATE
Error
Description

1876

HY000

ER_STOP_SLAVE_IO_THREAD_TIMEOUT

STOP SLAVE command execution is incomplete: Slave IO thread got the stop signal, thread is busy, IO thread will stop once the current task is complete.

Possible Causes and Solutions

This article doesn't currently contain any content.

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

You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!