# MariaDB Error Codes 1800 to 1899

- [Error 1800: Unknown ALGORITHM](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1800.md)
- [Error 1801: Unknown LOCK type](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1801.md)
- [Error 1802: CHANGE MASTER cannot be executed when the slave was stopped with an error or killed in M](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1802.md)
- [Error 1803: Cannot recover after SLAVE errored out in parallel execution mode](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1803.md)
- [Error 1804: Cannot clean up worker info tables](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1804.md)
- [Error 1805: Column count of is wrong. Expected, found. The table is probably corrupted](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1805.md)
- [Error 1806: Slave must silently retry current transaction](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1806.md)
- [Error 1807: There is a foreign key check running on table](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1807.md)
- [Error 1808: Schema mismatch](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1808.md)
- [Error 1809: Table in system tablespace](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1809.md)
- [Error 1810: IO Read error](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1810.md)
- [Error 1811: IO Write error](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1811.md)
- [Error 1812: Tablespace is missing for table](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1812.md)
- [Error 1813: Tablespace for table exists. Please DISCARD the tablespace before IMPORT](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1813.md)
- [Error 1814: Tablespace has been discarded for table](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1814.md)
- [Error 1815: Internal error](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1815.md)
- [Error 1816: ALTER TABLE IMPORT TABLESPACE failed with error](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1816.md)
- [Error 1817: Index corrupt](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1817.md)
- [Error 1818: YEAR(%lu) column type is deprecated. Creating YEAR(4) column instead.](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1818.md)
- [Error 1819: Your password does not satisfy the current policy requirements](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1819.md)
- [Error 1820: You must SET PASSWORD before executing this statement](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1820.md)
- [Error 1821: Failed to add the foreign key constaint. Missing index for constraint in the foreign tab](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1821.md)
- [Error 1822: Failed to add the foreign key constaint. Missing index for constraint in the referenced](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1822.md)
- [Error 1823: Failed to add the foreign key constraint to system tables](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1823.md)
- [Error 1824: Failed to open the referenced table](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1824.md)
- [Error 1825: Failed to add the foreign key constraint on table. Incorrect options in FOREIGN KEY cons](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1825.md)
- [Error 1826: Duplicate foreign key constraint name](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1826.md)
- [Error 1827: The password hash doesn't have the expected format](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1827.md)
- [Error 1828: Cannot drop column: needed in a foreign key constraint](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1828.md)
- [Error 1829: Cannot drop column: needed in a foreign key constraint of table](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1829.md)
- [Error 1830: Column cannot be NOT NULL: needed in a foreign key constraint SET NULL](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1830.md)
- [Error 1831: Duplicate index defined on the table. This is deprecated and will be disallowed in a fut](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1831.md)
- [Error 1832: Cannot change column: used in a foreign key constraint](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1832.md)
- [Error 1833: Cannot change column: used in a foreign key constraint of table](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1833.md)
- [Error 1834: Cannot delete rows from table which is parent in a foreign key constraint of table](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1834.md)
- [Error 1835: Malformed communication packet.](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1835.md)
- [Error 1836: Running in read-only mode](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1836.md)
- [Error 1837: When GTID\_NEXT is set to a GTID, you must explicitly set it again after a COMMIT or ROLL](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1837.md)
- [Error 1838: The system variable cannot be set in stored procedures](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1838.md)
- [Error 1839: @@GLOBAL.GTID\_PURGED can only be set when @@GLOBAL.GTID\_MODE = ON](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1839.md)
- [Error 1840: @@GLOBAL.GTID\_PURGED can only be set when @@GLOBAL.GTID\_EXECUTED is empty](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1840.md)
- [Error 1841: @@GLOBAL.GTID\_PURGED can only be set when there are no ongoing transactions (not even in](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1841.md)
- [Error 1842: @@GLOBAL.GTID\_PURGED was changed from to](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1842.md)
- [Error 1843: @@GLOBAL.GTID\_EXECUTED was changed from to](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1843.md)
- [Error 1844: Cannot execute statement: impossible to write to binary log since BINLOG\_FORMAT = STATEM](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1844.md)
- [Error 1845: is not supported for this operation. Try](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1845.md)
- [Error 1846: is not supported. Reason: Try](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1846.md)
- [Error 1847: COPY algorithm requires a lock](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1847.md)
- [Error 1848: Partition specific operations do not yet support LOCK/ALGORITHM](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1848.md)
- [Error 1849: Columns participating in a foreign key are renamed](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1849.md)
- [Error 1850: Cannot change column type INPLACE](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1850.md)
- [Error 1851: Adding foreign keys needs foreign\_key\_checks=OFF](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1851.md)
- [Error 1852: Creating unique indexes with IGNORE requires COPY algorithm to remove duplicate rows](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1852.md)
- [Error 1853: Dropping a primary key is not allowed without also adding a new primary key](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1853.md)
- [Error 1854: Adding an auto-increment column requires a lock](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1854.md)
- [Error 1855: Cannot replace hidden FTS\_DOC\_ID with a user-visible one](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1855.md)
- [Error 1856: Cannot drop or rename FTS\_DOC\_ID](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1856.md)
- [Error 1857: Fulltext index creation requires a lock](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1857.md)
- [Error 1858: sql\_slave\_skip\_counter can not be set when the server is running with @@GLOBAL.GTID\_MODE](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1858.md)
- [Error 1859: Duplicate entry for key](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1859.md)
- [Error 1860: Long database name and identifier for object resulted in path length exceeding character](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1860.md)
- [Error 1861: cannot silently convert NULL values, as required in this SQL\_MODE](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1861.md)
- [Error 1862: Your password has expired. To log in you must change it using a client that supports exp](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1862.md)
- [Error 1863: Found a row in wrong partition](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1863.md)
- [Error 1864: Cannot schedule event, relay-log name, position to Worker thread because its size exceed](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1864.md)
- [Error 1865: Cannot CREATE FULLTEXT INDEX WITH PARSER on InnoDB table](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1865.md)
- [Error 1866: The binary log file is logically corrupted](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1866.md)
- [Error 1867: file was not purged because it was being read by thread(s), purged only out of](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1867.md)
- [Error 1868: file was not purged because it is the active log file](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1868.md)
- [Error 1869: Auto-increment value in UPDATE conflicts with internally generated values](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1869.md)
- [Error 1870: Row events are not logged for statements that modify BLACKHOLE tables in row format](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1870.md)
- [Error 1871: Slave failed to initialize master info structure from the repository](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1871.md)
- [Error 1872: Slave failed to initialize relay log info structure from the repository](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1872.md)
- [Error 1873: Access denied trying to change to user (using password). Disconnecting.](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1873.md)
- [Error 1874: InnoDB is in read only mode](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1874.md)
- [Error 1875: STOP SLAVE command execution is incomplete: Slave SQL thread got the stop signal](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1875.md)
- [Error 1876: STOP SLAVE command execution is incomplete: Slave IO thread got the stop signal](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1876.md)
- [Error 1877: Operation cannot be performed. The table is missing, corrupt or contains bad data](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1877.md)
- [Error 1878: Temporary file write failure](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1878.md)
- [Error 1879: Upgrade index name failed, please use create index(alter table) algorithm copy to rebuil](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1879.md)
- [Error 1880: "](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899/e1880.md)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1800-to-1899.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.