circle-info
Webinar | The Great Database Exodus: Navigating Strategic Risk in the Post-Oracle MySQL Era
Register Nowarrow-up-right
search
Download MariaDBContact Us

MariaDB Error Codes 1700 to 1799

Error 1700: GRANT with IDENTIFIED WITH is illegal because the user already existschevron-rightError 1701: Cannot truncate a table referenced in a foreign key constraintchevron-rightError 1702: Plugin is force_plus_permanent and can not be unloadedchevron-rightError 1703: The requested value for the heartbeat period is less than 1 millisecondchevron-rightError 1704: The requested value for the heartbeat period exceeds the value of slave_net_timeout secochevron-rightError 1705: Multi-row statements required more than 'max_binlog_stmt_cache_size' bytes of storage; ichevron-rightError 1706: Primary key/partition key update is not allowed since the table is updated both as andchevron-rightError 1707: Table rebuild required. Please do "ALTER TABLE FORCE" or dump/reload to fix it!chevron-rightError 1708: The value of should be no less than the value ofchevron-rightError 1709: Index column size too large. The maximum column size is bytes.chevron-rightError 1710: Trigger has an error in its bodychevron-rightError 1711: Unknown trigger has an error in its bodychevron-rightError 1712: Index is corruptedchevron-rightError 1713: Undo log record is too bigchevron-rightError 1714: INSERT IGNORE... SELECT is unsafe because the order in which rows are retrieved by the Schevron-rightError 1715: INSERT... SELECT... ON DUPLICATE KEY UPDATE is unsafe because the order in which rows archevron-rightError 1716: REPLACE... SELECT is unsafe because the order in which rows are retrieved by the SELECTchevron-rightError 1717: CREATE... IGNORE SELECT is unsafe because the order in which rows are retrieved by the Schevron-rightError 1718: CREATE... REPLACE SELECT is unsafe because the order in which rows are retrieved by thechevron-rightError 1719: UPDATE IGNORE is unsafe because the order in which rows are updated determines which (ifchevron-rightError 1720: You should never see itchevron-rightError 1721: You should never see itchevron-rightError 1722: Statements writing to a table with an auto-increment column after selecting from anotherchevron-rightError 1723: CREATE TABLE... SELECT... on a table with an auto-increment column is unsafe because thechevron-rightError 1724: INSERT... ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafechevron-rightError 1725: Table is being used in foreign key check.chevron-rightError 1726: Storage engine does not support system tableschevron-rightError 1727: INSERT into autoincrement field which is not the first part in the composed primary keychevron-rightError 1728: Cannot load from. The table is probably corruptedchevron-rightError 1729: The requested value for the master delay exceeds the maximumchevron-rightError 1730: Only Format_description_log_event and row events are allowed in BINLOG statementschevron-rightError 1731: Non matching attribute between partition and tablechevron-rightError 1732: Table to exchange with partition is partitionedchevron-rightError 1733: Table to exchange with partition is temporarychevron-rightError 1734: Subpartitioned table, use subpartition instead of partitionchevron-rightError 1735: Unknown partition in tablechevron-rightError 1736: Tables have different definitionschevron-rightError 1737: Found a row that does not match the partitionchevron-rightError 1738: Option binlog_cache_size is greater than max_binlog_cache_size; setting binlog_cache_sizchevron-rightError 1739: Cannot use access on index due to type or collation conversion on fieldchevron-rightError 1740: Table to exchange with partition has foreign key referenceschevron-rightError 1741: Key value was not found in tablechevron-rightError 1742: Data for column too longchevron-rightError 1743: Replication event checksum verification failed while reading from network.chevron-rightError 1744: Replication event checksum verification failed while reading from a log filechevron-rightError 1745: Option binlog_stmt_cache_size is greater than max_binlog_stmt_cache_sizechevron-rightError 1746: Can't update table while is being createdchevron-rightError 1747: PARTITION () clause on non partitioned tablechevron-rightError 1748: Found a row not matching the given partition setchevron-rightError 1749: partition doesn't existchevron-rightError 1750: Failure while changing the type of replication repositorychevron-rightError 1751: The creation of some temporary tables could not be rolled back.chevron-rightError 1752: Some temporary tables were dropped, but these operations could not be rolled back.chevron-rightError 1753: is not supported in multi-threaded slave modechevron-rightError 1754: The number of modified databases exceeds the maximumchevron-rightError 1755: Cannot execute the current event group in the parallel modechevron-rightError 1756: %schevron-rightError 1757: FULLTEXT index is not supported for partitioned tableschevron-rightError 1758: Invalid condition numberchevron-rightError 1759: Sending passwords in plain text without SSL/TLS is extremely insecurechevron-rightError 1760: Storing MariaDB user name or password information in the master.info repository is not schevron-rightError 1761: Foreign key constraint for table, record would lead to a duplicate entry in tablechevron-rightError 1762: Foreign key constraint for table, record would lead to a duplicate entry in a child tablchevron-rightError 1763: Setting authentication options is not possible when only the Slave SQL Thread is being schevron-rightError 1764: The table does not have FULLTEXT index to support this querychevron-rightError 1765: The system variable cannot be set in stored functions or triggerschevron-rightError 1766: The system variable cannot be set when there is an ongoing transactionchevron-rightError 1767: The system variable @@SESSION.GTID_NEXT has the value which is not listed in @@SESSION.Gchevron-rightError 1768: The system variable @@SESSION.GTID_NEXT cannot change inside a transactionchevron-rightError 1769: The statement 'SET' cannot invoke a stored functionchevron-rightError 1770: The system variable @@SESSION.GTID_NEXT cannot be 'AUTOMATIC' when @@SESSION.GTID_NEXT_Lchevron-rightError 1771: Skipping transaction because it has already been executed and loggedchevron-rightError 1772: Malformed GTID set specificationchevron-rightError 1773: Malformed GTID set encodingchevron-rightError 1774: Malformed GTID specificationchevron-rightError 1775: Impossible to generate Global Transaction Identifier: the integer component reached thechevron-rightError 1776: Parameters MASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be schevron-rightError 1777: CHANGE MASTER TO MASTER_AUTO_POSITION = 1 can only be executed when @@GLOBAL.GTID_MODE =chevron-rightError 1778: Cannot execute statements with implicit commit inside a transaction when @@SESSION.GTID_chevron-rightError 1779: GTID_MODE = ON or GTID_MODE = UPGRADE_STEP_2 requires DISABLE_GTID_UNSAFE_STATEMENTS = 1chevron-rightError 1780: @@GLOBAL.GTID_MODE = ON or UPGRADE_STEP_1 or UPGRADE_STEP_2 requires --log-bin and --logchevron-rightError 1781: @@SESSION.GTID_NEXT cannot be set to UUID:NUMBER when @@GLOBAL.GTID_MODE = OFFchevron-rightError 1782: @@SESSION.GTID_NEXT cannot be set to ANONYMOUS when @@GLOBAL.GTID_MODE = ONchevron-rightError 1783: @@SESSION.GTID_NEXT_LIST cannot be set to a non-NULL value when @@GLOBAL.GTID_MODE = OFFchevron-rightError 1784: Found a Gtid_log_event or Previous_gtids_log_event when @@GLOBAL.GTID_MODE = OFFchevron-rightError 1785: When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, updates to non-transactional tables can onlychevron-rightError 1786: CREATE TABLE ... SELECT is forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1chevron-rightError 1787: When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, the statements CREATE TEMPORARY TABLE and DRchevron-rightError 1788: The value of @@GLOBAL.GTID_MODE can only change one step at a timechevron-rightError 1789: The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the masterchevron-rightError 1790: @@SESSION.GTID_NEXT cannot be changed by a client that owns a GTIDchevron-rightError 1791: Unknown EXPLAIN format namechevron-rightError 1792: Cannot execute statement in a READ ONLY transactionchevron-rightError 1793: Comment for table partition is too longchevron-rightError 1794: Slave is not configured or failed to initialize properly. You must at least set --serverchevron-rightError 1795: InnoDB presently supports one FULLTEXT index creation at a timechevron-rightError 1796: Cannot create FULLTEXT index on temporary InnoDB tablechevron-rightError 1797: Column is of wrong type for an InnoDB FULLTEXT indexchevron-rightError 1798: Index '%s' is of wrong type for an InnoDB FULLTEXT indexchevron-rightError 1799: Creating index required more than 'innodb_online_alter_log_max_size' bytes of modificatichevron-right
PreviousError 1699: SET PASSWORD has no significance for users authenticating via pluginsNextError 1700: GRANT with IDENTIFIED WITH is illegal because the user already exists

Last updated

Was this helpful?