MariaDB Error Codes 1800 to 1899
Error 1800: Unknown ALGORITHMError 1801: Unknown LOCK typeError 1802: CHANGE MASTER cannot be executed when the slave was stopped with an error or killed in MError 1803: Cannot recover after SLAVE errored out in parallel execution modeError 1804: Cannot clean up worker info tablesError 1805: Column count of is wrong. Expected, found. The table is probably corruptedError 1806: Slave must silently retry current transactionError 1807: There is a foreign key check running on tableError 1808: Schema mismatchError 1809: Table in system tablespaceError 1810: IO Read errorError 1811: IO Write errorError 1812: Tablespace is missing for tableError 1813: Tablespace for table exists. Please DISCARD the tablespace before IMPORTError 1814: Tablespace has been discarded for tableError 1815: Internal errorError 1816: ALTER TABLE IMPORT TABLESPACE failed with errorError 1817: Index corruptError 1818: YEAR(%lu) column type is deprecated. Creating YEAR(4) column instead.Error 1819: Your password does not satisfy the current policy requirementsError 1820: You must SET PASSWORD before executing this statementError 1821: Failed to add the foreign key constaint. Missing index for constraint in the foreign tabError 1822: Failed to add the foreign key constaint. Missing index for constraint in the referencedError 1823: Failed to add the foreign key constraint to system tablesError 1824: Failed to open the referenced tableError 1825: Failed to add the foreign key constraint on table. Incorrect options in FOREIGN KEY consError 1826: Duplicate foreign key constraint nameError 1827: The password hash doesn't have the expected formatError 1828: Cannot drop column: needed in a foreign key constraintError 1829: Cannot drop column: needed in a foreign key constraint of tableError 1831: Duplicate index defined on the table. This is deprecated and will be disallowed in a futError 1832: Cannot change column: used in a foreign key constraintError 1833: Cannot change column: used in a foreign key constraint of tableError 1834: Cannot delete rows from table which is parent in a foreign key constraint of tableError 1835: Malformed communication packet.Error 1836: Running in read-only modeError 1837: When GTID_NEXT is set to a GTID, you must explicitly set it again after a COMMIT or ROLLError 1838: The system variable cannot be set in stored proceduresError 1839: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ONError 1840: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is emptyError 1842: @@GLOBAL.GTID_PURGED was changed from toError 1843: @@GLOBAL.GTID_EXECUTED was changed from toError 1844: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMError 1845: is not supported for this operation. TryError 1846: is not supported. Reason: TryError 1847: COPY algorithm requires a lockError 1848: Partition specific operations do not yet support LOCK/ALGORITHMError 1849: Columns participating in a foreign key are renamedError 1850: Cannot change column type INPLACEError 1851: Adding foreign keys needs foreign_key_checks=OFFError 1852: Creating unique indexes with IGNORE requires COPY algorithm to remove duplicate rowsError 1853: Dropping a primary key is not allowed without also adding a new primary keyError 1854: Adding an auto-increment column requires a lockError 1855: Cannot replace hidden FTS_DOC_ID with a user-visible oneError 1856: Cannot drop or rename FTS_DOC_IDError 1857: Fulltext index creation requires a lockError 1858: sql_slave_skip_counter can not be set when the server is running with @@GLOBAL.GTID_MODEError 1859: Duplicate entry for keyError 1860: Long database name and identifier for object resulted in path length exceeding characterError 1861: cannot silently convert NULL values, as required in this SQL_MODEError 1862: Your password has expired. To log in you must change it using a client that supports expError 1863: Found a row in wrong partitionError 1864: Cannot schedule event, relay-log name, position to Worker thread because its size exceedError 1865: Cannot CREATE FULLTEXT INDEX WITH PARSER on InnoDB tableError 1866: The binary log file is logically corruptedError 1867: file was not purged because it was being read by thread(s), purged only out ofError 1868: file was not purged because it is the active log fileError 1869: Auto-increment value in UPDATE conflicts with internally generated valuesError 1870: Row events are not logged for statements that modify BLACKHOLE tables in row formatError 1871: Slave failed to initialize master info structure from the repositoryError 1872: Slave failed to initialize relay log info structure from the repositoryError 1873: Access denied trying to change to user (using password). Disconnecting.Error 1874: InnoDB is in read only modeError 1875: STOP SLAVE command execution is incomplete: Slave SQL thread got the stop signalError 1876: STOP SLAVE command execution is incomplete: Slave IO thread got the stop signalError 1877: Operation cannot be performed. The table is missing, corrupt or contains bad dataError 1878: Temporary file write failureError 1879: Upgrade index name failed, please use create index(alter table) algorithm copy to rebuilError 1880: "Error 1830: Column cannot be NOT NULL: needed in a foreign key constraint SET NULLError 1841: @@GLOBAL.GTID_PURGED can only be set when there are no ongoing transactions (not even in
PreviousError 1799: Creating index required more than 'innodb_online_alter_log_max_size' bytes of modificatiNextError 1800: Unknown ALGORITHM
Last updated
Was this helpful?