The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-14. For the latest, interactive version please visit https://mariadb.com/kb/.

Codici di errore di MariaDB

MariaDB condivide i codici di errore di MySQL, ma ve ne sono altri specifici.

Un esempio di errore:

MariaDB [(none)]> SELECT * FROM x;
ERROR 1046 (3D000): No database selected

Contents

  1. Codici di errore di MariaDB e MySQL
  2. Codici di errore specifici di MariaDB

In un errore vi sono tre informazioni:

  • Un codice di errore numerico, in questo caso 1046. I codici di errore da 1900 in su sono specifici di MariaDB, mentre gli errori da 1000 a 1800 appartengono sia a MySQL sia a MariaDB.
  • Un valore SQLSTATE, formato da cinque caratteri, in questo caso 3D000. Questi codici sono standard ODBC e ANSI SQL. Quando MariaDB non è in grado di allocare un codice SQLSTATE standard, viene utilizzato HY000, detto anche errore generale.
  • Una stringa che descrive l'errore, in questo caso No database selected.

Con l'aggiunta di nuove funzionalità, vengono continuamente aggiunti nuovi codici di errore. Per conoscere la lista completa, si veda il file sql/share/errmsg-utf8.txt

Codici di errore di MariaDB e MySQL

Codice di erroreSQLSTATEErroreSpiegazione
1000HY000ER_HASHCHKhashchk
1001HY000ER_NISAMCHKisamchk
1002HY000ER_NONO
1003HY000ER_YESYES
1004HY000ER_CANT_CREATE_FILECan't create file '%s' (errno: %d)
1005HY000ER_CANT_CREATE_TABLECan't create table '%s' (errno: %d)
1006HY000ER_CANT_CREATE_DBCan't create database '%s' (errno: %d
1007HY000ER_DB_CREATE_EXISTSCan't create database '%s'; database exists
1008HY000ER_DB_DROP_EXISTSCan't drop database '%s'; database doesn't exist
1009HY000ER_DB_DROP_DELETEError dropping database (can't delete '%s', errno: %d)
1010HY000ER_DB_DROP_RMDIRError dropping database (can't rmdir '%s', errno: %d)
1011HY000ER_CANT_DELETE_FILEError on delete of '%s' (errno: %d)
1012HY000ER_CANT_FIND_SYSTEM_RECCan't read record in system table
1013HY000ER_CANT_GET_STATCan't get status of '%s' (errno: %d)
1014HY000ER_CANT_GET_WDCan't get working directory (errno: %d)
1015HY000ER_CANT_LOCKCan't lock file (errno: %d)
1016HY000ER_CANT_OPEN_FILECan't open file: '%s' (errno: %d)
1017HY000ER_FILE_NOT_FOUNDCan't find file: '%s' (errno: %d)
1018HY000ER_CANT_READ_DIRCan't read dir of '%s' (errno: %d)
1019HY000ER_CANT_SET_WDCan't change dir to '%s' (errno: %d)
1020HY000ER_CHECKREADRecord has changed since last read in table '%s'
1021HY000ER_DISK_FULLDisk full (%s); waiting for someone to free some space...
102223000ER_DUP_KEYCan't write; duplicate key in table '%s'
1023HY000ER_ERROR_ON_CLOSEError on close of '%s' (errno: %d)
1024HY000ER_ERROR_ON_READError reading file '%s' (errno: %d)
1025HY000ER_ERROR_ON_RENAMEError on rename of '%s' to '%s' (errno: %d)
1026HY000ER_ERROR_ON_WRITEError writing file '%s' (errno: %d)
1027HY000ER_FILE_USED'%s' is locked against change
1028HY000ER_FILSORT_ABORTSort aborted
1029HY000ER_FORM_NOT_FOUNDView '%s' doesn't exist for '%s'
1030HY000ER_GET_ERRNGot error %d from storage engine
1031HY000ER_ILLEGAL_HATable storage engine for '%s' doesn't have this option
1032HY000ER_KEY_NOT_FOUNDCan't find record in '%s'
1033HY000ER_NOT_FORM_FILEIncorrect information in file: '%s'
1034HY000ER_NOT_KEYFILEIncorrect key file for table '%s'; try to repair it
1035HY000ER_OLD_KEYFILEOld key file for table '%s'; repair it!
1036HY000ER_OPEN_AS_READONLYTable '%s' is read only
1037HY001ER_OUTOFMEMORYOut of memory; restart server and try again (needed %d bytes)
1038HY001ER_OUT_OF_SORTMEMORYOut of sort memory, consider increasing server sort buffer size
1039HY000ER_UNEXPECTED_EOFUnexpected EOF found when reading file '%s' (Errno: %d)
104008004ER_CON_COUNT_ERRORToo many connections
1041HY000ER_OUT_OF_RESOURCESOut of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
104208S01ER_BAD_HOST_ERRORCan't get hostname for your address
104308S01ER_HANDSHAKE_ERRORBad handshake
104442000ER_DBACCESS_DENIED_ERRORAccess denied for user '%s'@'%s' to database '%s'
104528000ER_ACCESS_DENIED_ERRORAccess denied for user '%s'@'%s' (using password: %s)
10463D000ER_NO_DB_ERRORNo database selected
104708S01ER_UNKNOWN_COM_ERRORUnknown command
104823000ER_BAD_NULL_ERRORColumn '%s' cannot be null
104942000ER_BAD_DB_ERRORUnknown database '%s'
105042S01ER_TABLE_EXISTS_ERRORTable '%s' already exists
105142S02ER_BAD_TABLE_ERRORUnknown table '%s'
105223000ER_NON_UNIQ_ERRORColumn '%s' in %s is ambiguous
105308S01ER_SERVER_SHUTDOWNServer shutdown in progress
105442S22ER_BAD_FIELD_ERRORUnknown column '%s' in '%s'
105542000ER_WRONG_FIELD_WITH_GROUP'%s' isn't in GROUP BY
105642000ER_WRONG_GROUP_FIELDCan't group on '%s'
105742000ER_WRONG_SUM_SELECTStatement has sum functions and columns in same statement
105821S01ER_WRONG_VALUE_COUNTColumn count doesn't match value count
105942000ER_TOO_LONG_IDENTIdentifier name '%s' is too long
106042S21ER_DUP_FIELDNAMEDuplicate column name '%s'
106142000ER_DUP_KEYNAMEDuplicate key name '%s'
106223000ER_DUP_ENTRYDuplicate entry '%s' for key %d The message returned with this error uses the format string for ER_DUP_ENTRY_WITH_KEY_NAME.
106342000ER_WRONG_FIELD_SPECIncorrect column specifier for column '%s'
106442000ER_PARSE_ERROR%s near '%s' at line %d
106542000ER_EMPTY_QUERYQuery was empty
106642000ER_NONUNIQ_TABLENot unique table/alias: '%s'
106742000ER_INVALID_DEFAULTInvalid default value for '%s'
106842000ER_MULTIPLE_PRI_KEYMultiple primary key defined
106942000ER_TOO_MANY_KEYSToo many keys specified; max %d keys allowed
107042000ER_TOO_MANY_KEY_PARTSToo many key parts specified; max %d parts allowed
107142000ER_TOO_LONG_KEYSpecified key was too long; max key length is %d bytes
107242000ER_KEY_COLUMN_DOES_NOT_EXITSKey column '%s' doesn't exist in table
107342000ER_BLOB_USED_AS_KEYBLOB column '%s' can't be used in key specification with the used table type
107442000ER_TOO_BIG_FIELDLENGTHColumn length too big for column '%s' (max = %lu); use BLOB or TEXT instead
107542000ER_WRONG_AUTO_KEYIncorrect table definition; there can be only one auto column and it must be defined as a key
1076HY000ER_READY%s: ready for connections. Version: '%s' socket: '%s' port: %d
1077HY000ER_NORMAL_SHUTDOWN%s: Normal shutdown
1078HY000ER_GOT_SIGNAL%s: Got signal %d. Aborting!
1079HY000ER_SHUTDOWN_COMPLETE%s: Shutdown complete
108008S01ER_FORCING_CLOSE%s: Forcing close of thread %ld user: '%s'
108108S01ER_IPSOCK_ERRORCan't create IP socket
108242S12ER_NO_SUCH_INDEXTable '%s' has no index like the one used in CREATE INDEX; recreate the table
108342000ER_WRONG_FIELD_TERMINATORSField separator argument is not what is expected; check the manual
108442000ER_BLOBS_AND_NO_TERMINATEDYou can't use fixed rowlength with BLOBs; please use 'fields terminated by'
1085HY000ER_TEXTFILE_NOT_READABLEThe file '%s' must be in the database directory or be readable by all
1086HY000ER_FILE_EXISTS_ERRORFile '%s' already exists
1087HY000ER_LOAD_INFRecords: %ld Deleted: %ld Skipped: %ld Warnings: %ld
1088HY000ER_ALTER_INFRecords: %ld Duplicates: %ld
1089HY000ER_WRONG_SUB_KEYIncorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys
109042000ER_CANT_REMOVE_ALL_FIELDSYou can't delete all columns with ALTER TABLE; use DROP TABLE instead
109142000ER_CANT_DROP_FIELD_OR_KEYCan't DROP '%s'; check that column/key exists
1092HY000ER_INSERT_INFRecords: %ld Duplicates: %ld Warnings: %ld
1093HY000ER_UPDATE_TABLE_USEDYou can't specify target table '%s' for update in FROM clause
1094HY000ER_NO_SUCH_THREADUnknown thread id: %lu
1095HY000ER_KILL_DENIED_ERRORYou are not owner of thread %lu
1096HY000ER_NO_TABLES_USEDNo tables used
1097HY000ER_TOO_BIG_SETToo many strings for column %s and SET
1098HY000ER_NO_UNIQUE_LOGFILECan't generate a unique log-filename %s.(1-999)
1099HY000ER_TABLE_NOT_LOCKED_FOR_WRITETable '%s' was locked with a READ lock and can't be updated
1100HY000ER_TABLE_NOT_LOCKEDTable '%s' was not locked with LOCK TABLES
110142000ER_BLOB_CANT_HAVE_DEFAULTBLOB/TEXT column '%s' can't have a default value
110242000ER_WRONG_DB_NAMEIncorrect database name '%s'
110342000ER_WRONG_TABLE_NAMEIncorrect table name '%s'
110442000ER_TOO_BIG_SELECTThe SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
1105HY000ER_UNKNOWN_ERRORUnknown error
110642000ER_UNKNOWN_PROCEDUREUnknown procedure '%s'
110742000ER_WRONG_PARAMCOUNT_TO_PROCEDUREIncorrect parameter count to procedure '%s'
1108HY000ER_WRONG_PARAMETERS_TO_PROCEDUREIncorrect parameters to procedure '%s'
110942S02ER_UNKNOWN_TABLEUnknown table '%s' in %s
111042000ER_FIELD_SPECIFIED_TWICEColumn '%s' specified twice
1111HY000ER_INVALID_GROUP_FUNC_USEInvalid use of group function
111242000ER_UNSUPPORTED_EXTENSIONTable '%s' uses an extension that doesn't exist in this MariaDB version
111342000ER_TABLE_MUST_HAVE_COLUMNSA table must have at least 1 column
1114HY000ER_RECORD_FILE_FULLThe table '%s' is full
111542000ER_UNKNOWN_CHARACTER_SETUnknown character set: '%s'
1116HY000ER_TOO_MANY_TABLESToo many tables; MariaDB can only use %d tables in a join
1117HY000ER_TOO_MANY_FIELDSToo many columns
111842000ER_TOO_BIG_ROWSIZERow size too large. The maximum row size for the used table type, not counting BLOBs, is %ld. You have to change some columns to TEXT or BLOBs
1119HY000ER_STACK_OVERRUNThread stack overrun: Used: %ld of a %ld stack. Use 'mysqld --thread_stack=#' to specify a bigger stack if needed
112042000ER_WRONG_OUTER_JOINCross dependency found in OUTER JOIN; examine your ON conditions
112142000ER_NULL_COLUMN_IN_INDEXTable handler doesn't support NULL in given index. Please change column '%s' to be NOT NULL or use another handler
1122HY000ER_CANT_FIND_UDFCan't load function '%s'
1123HY000ER_CANT_INITIALIZE_UDFCan't initialize function '%s'; %s
1124HY000ER_UDF_NO_PATHSNo paths allowed for shared library
1125HY000ER_UDF_EXISTSFunction '%s' already exists
1126HY000ER_CANT_OPEN_LIBRARYCan't open shared library '%s' (Errno: %d %s)
1127HY000ER_CANT_FIND_DL_ENTRYCan't find symbol '%s' in library
1128HY000ER_FUNCTION_NOT_DEFINEDFunction '%s' is not defined
1129HY000ER_HOST_IS_BLOCKEDHost '%s' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
1130HY000ER_HOST_NOT_PRIVILEGEDHost '%s' is not allowed to connect to this MariaDB server
113142000ER_PASSWORD_ANONYMOUS_USERYou are using MariaDB as an anonymous user and anonymous users are not allowed to change passwords
113242000ER_PASSWORD_NOT_ALLOWEDYou must have privileges to update tables in the mysql database to be able to change passwords for others
113342000ER_PASSWORD_NO_MATCHCan't find any matching row in the user table
1134HY000ER_UPDATE_INFRows matched: %ld Changed: %ld Warnings: %ld
1135HY000ER_CANT_CREATE_THREADCan't create a new thread (Errno %d); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
113621S01ER_WRONG_VALUE_COUNT_ON_ROWColumn count doesn't match value count at row %ld
1137HY000ER_CANT_REOPEN_TABLECan't reopen table: '%s'
113822004ER_INVALID_USE_OF_NULLInvalid use of NULL value
113942000ER_REGEXP_ERRORGot error '%s' from regexp
114042000ER_MIX_OF_GROUP_FUNC_AND_FIELDSMixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
114142000ER_NONEXISTING_GRANTThere is no such grant defined for user '%s' on host '%s'
114242000ER_TABLEACCESS_DENIED_ERROR%s command denied to user '%s'@'%s' for table '%s'
114342000ER_COLUMNACCESS_DENIED_ERROR%s command denied to user '%s'@'%s' for column '%s' in table '%s'
114442000ER_ILLEGAL_GRANT_FOR_TABLEIllegal GRANT/REVOKE command; please consult the manual to see which privileges can be used
114542000ER_GRANT_WRONG_HOST_OR_USERThe host or user argument to GRANT is too long
114642S02ER_NO_SUCH_TABLETable '%s.%s' doesn't exist
114742000ER_NONEXISTING_TABLE_GRANTThere is no such grant defined for user '%s' on host '%s' on table '%s'
114842000ER_NOT_ALLOWED_COMMANDThe used command is not allowed with this MariaDB version
114942000ER_SYNTAX_ERRORYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use
1150HY000ER_DELAYED_CANT_CHANGE_LOCKDelayed insert thread couldn't get requested lock for table %s
1151HY000ER_TOO_MANY_DELAYED_THREADSToo many delayed threads in use
115208S01ER_ABORTING_CONNECTIONAborted connection %ld to db: '%s' user: '%s' (%s)
115308S01ER_NET_PACKET_TOO_LARGEGot a packet bigger than 'max_allowed_packet' bytes
115408S01ER_NET_READ_ERROR_FROM_PIPEGot a read error from the connection pipe
115508S01ER_NET_FCNTL_ERRORGot an error from fcntl()
115608S01ER_NET_PACKETS_OUT_OF_ORDERGot packets out of order
115708S01ER_NET_UNCOMPRESS_ERRORCouldn't uncompress communication packet
115808S01ER_NET_READ_ERRORGot an error reading communication packets
115908S01ER_NET_READ_INTERRUPTEDGot timeout reading communication packets
116008S01ER_NET_ERROR_ON_WRITEGot an error writing communication packets
116108S01ER_NET_WRITE_INTERRUPTEDGot timeout writing communication packets
116242000ER_TOO_LONG_STRINGResult string is longer than 'max_allowed_packet' bytes
116342000ER_TABLE_CANT_HANDLE_BLOBThe used table type doesn't support BLOB/TEXT columns
116442000ER_TABLE_CANT_HANDLE_AUTO_INCREMENTThe used table type doesn't support AUTO_INCREMENT columns
1165HY000ER_DELAYED_INSERT_TABLE_LOCKEDINSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES
116642000ER_WRONG_COLUMN_NAMEIncorrect column name '%s'
116742000ER_WRONG_KEY_COLUMNThe used storage engine can't index column '%s'
1168HY000ER_WRONG_MRG_TABLEUnable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist
116923000ER_DUP_UNIQUECan't write, because of unique constraint, to table '%s'
117042000ER_BLOB_KEY_WITHOUT_LENGTHBLOB/TEXT column '%s' used in key specification without a key length
117142000ER_PRIMARY_CANT_HAVE_NULLAll parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
117242000ER_TOO_MANY_ROWSResult consisted of more than one row
117342000ER_REQUIRES_PRIMARY_KEYThis table type requires a primary key
1174HY000ER_NO_RAID_COMPILEDThis version of MariaDB is not compiled with RAID support
1175HY000ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODEYou are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
117642000ER_KEY_DOES_NOT_EXITSKey '%s' doesn't exist in table '%s'
117742000ER_CHECK_NO_SUCH_TABLECan't open table
117842000ER_CHECK_NOT_IMPLEMENTEDThe storage engine for the table doesn't support %s
117925000ER_CANT_DO_THIS_DURING_AN_TRANSACTIONYou are not allowed to execute this command in a transaction
1180HY000ER_ERROR_DURING_COMMITGot error %d during COMMIT
1181HY000ER_ERROR_DURING_ROLLBACKGot error %d during ROLLBACK
1182HY000ER_ERROR_DURING_FLUSH_LOGSGot error %d during FLUSH_LOGS
1183HY000ER_ERROR_DURING_CHECKPOINTGot error %d during CHECKPOINT
118408S01ER_NEW_ABORTING_CONNECTIONAborted connection %ld to db: '%s' user: '%s' host: '%s' (%s)
1185HY000ER_DUMP_NOT_IMPLEMENTEDThe storage engine for the table does not support binary table dump
1186HY000ER_FLUSH_MASTER_BINLOG_CLOSEDBinlog closed, cannot RESET MASTER
1187HY000ER_INDEX_REBUILDFailed rebuilding the index of dumped table '%s'
1188HY000ER_MASTERError from master: '%s'
118908S01ER_MASTER_NET_READNet error reading from master
119008S01ER_MASTER_NET_WRITENet error writing to master
1191HY000ER_FT_MATCHING_KEY_NOT_FOUNDCan't find FULLTEXT index matching the column list
1192HY000ER_LOCK_OR_ACTIVE_TRANSACTIONCan't execute the given command because you have active locked tables or an active transaction
1193HY000ER_UNKNOWN_SYSTEM_VARIABLEUnknown system variable '%s'
1194HY000ER_CRASHED_ON_USAGETable '%s' is marked as crashed and should be repaired
1195HY000ER_CRASHED_ON_REPAIRTable '%s' is marked as crashed and last (automatic?) repair failed
1196HY000ER_WARNING_NOT_COMPLETE_ROLLBACKSome non-transactional changed tables couldn't be rolled back
1197HY000ER_TRANS_CACHE_FULLMulti-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again
1198HY000ER_SLAVE_MUST_STOPThis operation cannot be performed with a running slave; run STOP SLAVE first
1199HY000ER_SLAVE_NOT_RUNNINGThis operation requires a running slave; configure slave and do START SLAVE
1200HY000ER_BAD_SLAVEThe server is not configured as slave; fix in config file or with CHANGE MASTER TO
1201HY000ER_MASTER_INFCould not initialize master info structure; more error messages can be found in the MariaDB error log
1202HY000ER_SLAVE_THREADCould not create slave thread; check system resources
120342000ER_TOO_MANY_USER_CONNECTIONSUser %s already has more than 'max_user_connections' active connections
1204HY000ER_SET_CONSTANTS_ONLYYou may only use constant expressions with SET
1205HY000ER_LOCK_WAIT_TIMEOUTLock wait timeout exceeded; try restarting transaction
1206HY000ER_LOCK_TABLE_FULLThe total number of locks exceeds the lock table size
120725000ER_READ_ONLY_TRANSACTIONUpdate locks cannot be acquired during a READ UNCOMMITTED transaction
1208HY000ER_DROP_DB_WITH_READ_LOCKDROP DATABASE not allowed while thread is holding global read lock
1209HY000ER_CREATE_DB_WITH_READ_LOCKCREATE DATABASE not allowed while thread is holding global read lock
1210HY000ER_WRONG_ARGUMENTSIncorrect arguments to %s
121142000ER_NO_PERMISSION_TO_CREATE_USER'%s'@'%s' is not allowed to create new users
1212HY000ER_UNION_TABLES_IN_DIFFERENT_DIRIncorrect table definition; all MERGE tables must be in the same database
121340001ER_LOCK_DEADLOCKDeadlock found when trying to get lock; try restarting transaction
1214HY000ER_TABLE_CANT_HANDLE_FTThe used table type doesn't support FULLTEXT indexes
1215HY000ER_CANNOT_ADD_FOREIGNCannot add foreign key constraint
121623000ER_NO_REFERENCED_ROWCannot add or update a child row: a foreign key constraint fails
121723000ER_ROW_IS_REFERENCEDCannot delete or update a parent row: a foreign key constraint fails
121808S01ER_CONNECT_TO_MASTERError connecting to master: %s
1219HY000ER_QUERY_ON_MASTERError running query on master: %s
1220HY000ER_ERROR_WHEN_EXECUTING_COMMANDError when executing command %s: %s
1221HY000ER_WRONG_USAGEIncorrect usage of %s and %s
122221000ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECTThe used SELECT statements have a different number of columns
1223HY000ER_CANT_UPDATE_WITH_READLOCKCan't execute the query because you have a conflicting read lock
1224HY000ER_MIXING_NOT_ALLOWEDMixing of transactional and non-transactional tables is disabled
1225HY000ER_DUP_ARGUMENTOption '%s' used twice in statement
122642000ER_USER_LIMIT_REACHEDUser '%s' has exceeded the '%s' resource (current value: %ld)
122742000ER_SPECIFIC_ACCESS_DENIED_ERRORAccess denied; you need (at least one of) the %s privilege(s) for this operation
1228HY000ER_LOCAL_VARIABLEVariable '%s' is a SESSION variable and can't be used with SET GLOBAL
1229HY000ER_GLOBAL_VARIABLEVariable '%s' is a GLOBAL variable and should be set with SET GLOBAL
123042000ER_NO_DEFAULTVariable '%s' doesn't have a default value
123142000ER_WRONG_VALUE_FOR_VARVariable '%s' can't be set to the value of '%s'
123242000ER_WRONG_TYPE_FOR_VARIncorrect argument type to variable '%s'
1233HY000ER_VAR_CANT_BE_READVariable '%s' can only be set, not read
123442000ER_CANT_USE_OPTION_HEREIncorrect usage/placement of '%s'
123542000ER_NOT_SUPPORTED_YETThis version of MariaDB doesn't yet support '%s'
1236HY000ER_MASTER_FATAL_ERROR_READING_BINLOGGot fatal error %d from master when reading data from binary log: '%s'
1237HY000ER_SLAVE_IGNORED_TABLESlave SQL thread ignored the query because of replicate-*-table rules
1238HY000ER_INCORRECT_GLOBAL_LOCAL_VARVariable '%s' is a %s variable
123942000ER_WRONG_FK_DEFIncorrect foreign key definition for '%s': %s
1240HY000ER_KEY_REF_DO_NOT_MATCH_TABLE_REFKey reference and table reference don't match
124121000ER_OPERAND_COLUMNSOperand should contain %d column(s)
124221000ER_SUBQUERY_NO_1_ROWSubquery returns more than 1 row
1243HY000ER_UNKNOWN_STMT_HANDLERUnknown prepared statement handler (%.*s) given to %s
1244HY000ER_CORRUPT_HELP_DBHelp database is corrupt or does not exist
1245HY000ER_CYCLIC_REFERENCECyclic reference on subqueries
1246HY000ER_AUTO_CONVERTConverting column '%s' from %s to %s
124742S22ER_ILLEGAL_REFERENCEReference '%s' not supported (%s)
124842000ER_DERIVED_MUST_HAVE_ALIASEvery derived table must have its own alias
124901000ER_SELECT_REDUCEDSelect %u was reduced during optimization
125042000ER_TABLENAME_NOT_ALLOWED_HERETable '%s' from one of the SELECTs cannot be used in %s
125108004ER_NOT_SUPPORTED_AUTH_MODEClient does not support authentication protocol requested by server; consider upgrading MariaDB client
125242000ER_SPATIAL_CANT_HAVE_NULLAll parts of a SPATIAL index must be NOT NULL
125342000ER_COLLATION_CHARSET_MISMATCHCOLLATION '%s' is not valid for CHARACTER SET '%s'
1254HY000ER_SLAVE_WAS_RUNNINGSlave is already running
1255HY000ER_SLAVE_WAS_NOT_RUNNINGSlave already has been stopped
1256HY000ER_TOO_BIG_FOR_UNCOMPRESSUncompressed data size too large; the maximum size is %d (probably, length of uncompressed data was corrupted)
1257HY000ER_ZLIB_Z_MEM_ERRORZLIB: Not enough memory
1258HY000ER_ZLIB_Z_BUF_ERRORZLIB: Not enough room in the output buffer (probably, length of uncompressed data was corrupted)
1259HY000ER_ZLIB_Z_DATA_ERRORZLIB: Input data corrupted
1260HY000ER_CUT_VALUE_GROUP_CONCATRow %u was cut by GROUP_CONCAT()
126101000ER_WARN_TOO_FEW_RECORDSRow %ld doesn't contain data for all columns
126201000ER_WARN_TOO_MANY_RECORDSRow %ld was truncated; it contained more data than there were input columns
126322004ER_WARN_NULL_TO_NOTNULLColumn set to default value; NULL supplied to NOT NULL column '%s' at row %ld
126422003ER_WARN_DATA_OUT_OF_RANGEOut of range value for column '%s' at row %ld
126501000WARN_DATA_TRUNCATEDData truncated for column '%s' at row %ld
1266HY000ER_WARN_USING_OTHER_HANDLERUsing storage engine %s for table '%s'
1267HY000ER_CANT_AGGREGATE_2COLLATIONSIllegal mix of collations (%s,%s) and (%s,%s) for operation '%s'
1268HY000ER_DROP_USERCannot drop one or more of the requested users
1269HY000ER_REVOKE_GRANTSCan't revoke all privileges for one or more of the requested users
1270HY000ER_CANT_AGGREGATE_3COLLATIONSIllegal mix of collations (%s,%s), (%s,%s), (%s,%s) for operation '%s'
1271HY000ER_CANT_AGGREGATE_NCOLLATIONSIllegal mix of collations for operation '%s'
1272HY000ER_VARIABLE_IS_NOT_STRUCTVariable '%s' is not a variable component (can't be used as XXXX.variable_name)
1273HY000ER_UNKNOWN_COLLATIONUnknown collation: '%s'
1274HY000ER_SLAVE_IGNORED_SSL_PARAMSSSL parameters in CHANGE MASTER are ignored because this MariaDB slave was compiled without SSL support; they can be used later if MariaDB slave with SSL is started
1275HY000ER_SERVER_IS_IN_SECURE_AUTH_MODEServer is running in --secure-auth mode, but '%s'@'%s' has a password in the old format; please change the password to the new format
1276HY000ER_WARN_FIELD_RESOLVEDField or reference '%s%s%s%s%s' of SELECT #%d was resolved in SELECT #%d
1277HY000ER_BAD_SLAVE_UNTIL_CONDIncorrect parameter or combination of parameters for START SLAVE UNTIL
1278HY000ER_MISSING_SKIP_SLAVEIt is recommended to use --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you will get problems if you get an unexpected slave's mysqld restart
1279HY000ER_UNTIL_COND_IGNOREDSQL thread is not to be started so UNTIL options are ignored
128042000ER_WRONG_NAME_FOR_INDEXIncorrect index name '%s'
128142000ER_WRONG_NAME_FOR_CATALOGIncorrect catalog name '%s'
1282HY000ER_WARN_QC_RESIZEQuery cache failed to set size %lu; new query cache size is %lu
1283HY000ER_BAD_FT_COLUMNColumn '%s' cannot be part of FULLTEXT index
1284HY000ER_UNKNOWN_KEY_CACHEUnknown key cache '%s'
1285HY000ER_WARN_HOSTNAME_WONT_WORKMariaDB is started in --skip-name-resolve mode; you must restart it without this switch for this grant to work
128642000ER_UNKNOWN_STORAGE_ENGINEUnknown storage engine '%s'
1287HY000ER_WARN_DEPRECATED_SYNTAX'%s' is deprecated and will be removed in a future release. Please use %s instead
1288HY000ER_NON_UPDATABLE_TABLEThe target table %s of the %s is not updatable
1289HY000ER_FEATURE_DISABLEDThe '%s' feature is disabled; you need MariaDB built with '%s' to have it working
1290HY000ER_OPTION_PREVENTS_STATEMENTThe MariaDB server is running with the %s option so it cannot execute this statement
1291HY000ER_DUPLICATED_VALUE_IN_TYPEColumn '%s' has duplicated value '%s' in %s
129222007ER_TRUNCATED_WRONG_VALUETruncated incorrect %s value: '%s'
1293HY000ER_TOO_MUCH_AUTO_TIMESTAMP_COLSIncorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
1294HY000ER_INVALID_ON_UPDATEInvalid ON UPDATE clause for '%s' column
1295HY000ER_UNSUPPORTED_PSThis command is not supported in the prepared statement protocol yet
1296HY000ER_GET_ERRMSGGot error %d '%s' from %s
1297HY000ER_GET_TEMPORARY_ERRMSGGot temporary error %d '%s' from %s
1298HY000ER_UNKNOWN_TIME_ZONEUnknown or incorrect time zone: '%s'
1299HY000ER_WARN_INVALID_TIMESTAMPInvalid TIMESTAMP value in column '%s' at row %ld
1300HY000ER_INVALID_CHARACTER_STRINGInvalid %s character string: '%s'
1301HY000ER_WARN_ALLOWED_PACKET_OVERFLOWEDResult of %s() was larger than max_allowed_packet (%ld) - truncated
1302HY000ER_CONFLICTING_DECLARATIONSConflicting declarations: '%s%s' and '%s%s'
13032F003ER_SP_NO_RECURSIVE_CREATECan't create a %s from within another stored routine
130442000ER_SP_ALREADY_EXISTS%s %s already exists
130542000ER_SP_DOES_NOT_EXIST%s %s does not exist
1306HY000ER_SP_DROP_FAILEDFailed to DROP %s %s
1307HY000ER_SP_STORE_FAILEDFailed to CREATE %s %s
130842000ER_SP_LILABEL_MISMATCH%s with no matching label: %s
130942000ER_SP_LABEL_REDEFINERedefining label %s
131042000ER_SP_LABEL_MISMATCHEnd-label %s without match
131101000ER_SP_UNINIT_VARReferring to uninitialized variable %s
13120A000ER_SP_BADSELECTPROCEDURE %s can't return a result set in the given context
131342000ER_SP_BADRETURNRETURN is only allowed in a FUNCTION
13140A000ER_SP_BADSTATEMENT%s is not allowed in stored procedures
131542000ER_UPDATE_LOG_DEPRECATED_IGNOREDThe update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored. This option will be removed in MariaDB 5.6.
131642000ER_UPDATE_LOG_DEPRECATED_TRANSLATEDThe update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been translated to SET SQL_LOG_BIN. This option will be removed in MariaDB 5.6.
131770100ER_QUERY_INTERRUPTEDQuery execution was interrupted
131842000ER_SP_WRONG_NO_OF_ARGSIncorrect number of arguments for %s %s; expected %u, got %u
131942000ER_SP_COND_MISMATCHUndefined CONDITION: %s
132042000ER_SP_NORETURNNo RETURN found in FUNCTION %s
13212F005ER_SP_NORETURNENDFUNCTION %s ended without RETURN
132242000ER_SP_BAD_CURSOR_QUERYCursor statement must be a SELECT
132342000ER_SP_BAD_CURSOR_SELECTCursor SELECT must not have INTO
132442000ER_SP_CURSOR_MISMATCHUndefined CURSOR: %s
132524000ER_SP_CURSOR_ALREADY_OPENCursor is already open
132624000ER_SP_CURSOR_NOT_OPENCursor is not open
132742000ER_SP_UNDECLARED_VARUndeclared variable: %s
1328HY000ER_SP_WRONG_NO_OF_FETCH_ARGSIncorrect number of FETCH variables
132902000ER_SP_FETCH_NO_DATANo data - zero rows fetched, selected, or processed
133042000ER_SP_DUP_PARAMDuplicate parameter: %s
133142000ER_SP_DUP_VARDuplicate variable: %s
133242000ER_SP_DUP_CONDDuplicate condition: %s
133342000ER_SP_DUP_CURSDuplicate cursor: %s
1334HY000ER_SP_CANT_ALTERFailed to ALTER %s %s
13350A000ER_SP_SUBSELECT_NYISubquery value not supported
13360A000ER_STMT_NOT_ALLOWED_IN_SF_OR_TRG%s is not allowed in stored function or trigger
133742000ER_SP_VARCOND_AFTER_CURSHNDLRVariable or condition declaration after cursor or handler declaration
133842000ER_SP_CURSOR_AFTER_HANDLERCursor declaration after handler declaration
133920000ER_SP_CASE_NOT_FOUNDCase not found for CASE statement
1340HY000ER_FPARSER_TOO_BIG_FILEConfiguration file '%s' is too big
1341HY000ER_FPARSER_BAD_HEADERMalformed file type header in file '%s'
1342HY000ER_FPARSER_EOF_IN_COMMENTUnexpected end of file while parsing comment '%s'
1343HY000ER_FPARSER_ERROR_IN_PARAMETERError while parsing parameter '%s' (line: '%s')
1344HY000ER_FPARSER_EOF_IN_UNKNOWN_PARAMETERUnexpected end of file while skipping unknown parameter '%s'
1345HY000ER_VIEW_NO_EXPLAINEXPLAIN/SHOW can not be issued; lacking privileges for underlying table
1346HY000ER_FRM_UNKNOWN_TYPEFile '%s' has unknown type '%s' in its header
1347HY000ER_WRONG_OBJECT'%s.%s' is not %s
1348HY000ER_NONUPDATEABLE_COLUMNColumn '%s' is not updatable
1349HY000ER_VIEW_SELECT_DERIVEDView's SELECT contains a subquery in the FROM clause
1350HY000ER_VIEW_SELECT_CLAUSEView's SELECT contains a '%s' clause
1351HY000ER_VIEW_SELECT_VARIABLEView's SELECT contains a variable or parameter
1352HY000ER_VIEW_SELECT_TMPTABLEView's SELECT refers to a temporary table '%s'
1353HY000ER_VIEW_WRONG_LISTView's SELECT and view's field list have different column counts
1354HY000ER_WARN_VIEW_MERGEView merge algorithm can't be used here for now (assumed undefined algorithm)
1355HY000ER_WARN_VIEW_WITHOUT_KEYView being updated does not have complete key of underlying table in it
1356HY000ER_VIEW_INVALIDView '%s.%s' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
1357HY000ER_SP_NO_DROP_SPCan't drop or alter a %s from within another stored routine
1358HY000ER_SP_GOTO_IN_HNDLRGOTO is not allowed in a stored procedure handler
1359HY000ER_TRG_ALREADY_EXISTSTrigger already exists
1360HY000ER_TRG_DOES_NOT_EXISTTrigger does not exist
1361HY000ER_TRG_ON_VIEW_OR_TEMP_TABLETrigger's '%s' is view or temporary table
1362HY000ER_TRG_CANT_CHANGE_ROWUpdating of %s row is not allowed in %strigger
1363HY000ER_TRG_NO_SUCH_ROW_IN_TRGThere is no %s row in %s trigger
1364HY000ER_NO_DEFAULT_FOR_FIELDField '%s' doesn't have a default value
136522012ER_DIVISION_BY_ZERDivision by 0
1366HY000ER_TRUNCATED_WRONG_VALUE_FOR_FIELDIncorrect %s value: '%s' for column '%s' at row %ld
136722007ER_ILLEGAL_VALUE_FOR_TYPEIllegal %s '%s' value found during parsing
1368HY000ER_VIEW_NONUPD_CHECKCHECK OPTION on non-updatable view '%s.%s'
1369HY000ER_VIEW_CHECK_FAILEDCHECK OPTION failed '%s.%s'
137042000ER_PROCACCESS_DENIED_ERROR%s command denied to user '%s'@'%s' for routine '%s'
1371HY000ER_RELAY_LOG_FAILFailed purging old relay logs: %s
1372HY000ER_PASSWD_LENGTHPassword hash should be a %d-digit hexadecimal number
1373HY000ER_UNKNOWN_TARGET_BINLOGTarget log not found in binlog index
1374HY000ER_IO_ERR_LOG_INDEX_READI/O error reading log index file
1375HY000ER_BINLOG_PURGE_PROHIBITEDServer configuration does not permit binlog purge
1376HY000ER_FSEEK_FAILFailed on fseek()
1377HY000ER_BINLOG_PURGE_FATAL_ERRFatal error during log purge
1378HY000ER_LOG_IN_USEA purgeable log is in use, will not purge
1379HY000ER_LOG_PURGE_UNKNOWN_ERRUnknown error during log purge
1380HY000ER_RELAY_LOG_INITFailed initializing relay log position: %s
1381HY000ER_NO_BINARY_LOGGINGYou are not using binary logging
1382HY000ER_RESERVED_SYNTAXThe '%s' syntax is reserved for purposes internal to the MariaDB server
1383HY000ER_WSAS_FAILEDWSAStartup Failed
1384HY000ER_DIFF_GROUPS_PROCCan't handle procedures with different groups yet
1385HY000ER_NO_GROUP_FOR_PROCSelect must have a group with this procedure
1386HY000ER_ORDER_WITH_PROCCan't use ORDER clause with this procedure
1387HY000ER_LOGGING_PROHIBIT_CHANGING_OFBinary logging and replication forbid changing the global server %s
1388HY000ER_NO_FILE_MAPPINGCan't map file: %s, errno: %d
1389HY000ER_WRONG_MAGICWrong magic in %s
1390HY000ER_PS_MANY_PARAMPrepared statement contains too many placeholders
1391HY000ER_KEY_PART_0Key part '%s' length cannot be 0
1392HY000ER_VIEW_CHECKSUMView text checksum failed
1393HY000ER_VIEW_MULTIUPDATECan not modify more than one base table through a join view '%s.%s'
1394HY000ER_VIEW_NO_INSERT_FIELD_LISTCan not insert into join view '%s.%s' without fields list
1395HY000ER_VIEW_DELETE_MERGE_VIEWCan not delete from join view '%s.%s'
1396HY000ER_CANNOT_USEROperation %s failed for %s
1397XAE04ER_XAER_NOTAXAER_NOTA: Unknown XID
1398XAE05ER_XAER_INVALXAER_INVAL: Invalid arguments (or unsupported command)
1399XAE07ER_XAER_RMFAILXAER_RMFAIL: The command cannot be executed when global transaction is in the %s state
1400XAE09ER_XAER_OUTSIDEXAER_OUTSIDE: Some work is done outside global transaction
1401XAE03ER_XAER_RMERRXAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
1402XA100ER_XA_RBROLLBACKXA_RBROLLBACK: Transaction branch was rolled back
140342000ER_NONEXISTING_PROC_GRANTThere is no such grant defined for user '%s' on host '%s' on routine '%s'
1404HY000ER_PROC_AUTO_GRANT_FAILFailed to grant EXECUTE and ALTER ROUTINE privileges
1405HY000ER_PROC_AUTO_REVOKE_FAILFailed to revoke all privileges to dropped routine
140622001ER_DATA_TOO_LONGData too long for column '%s' at row %ld
140742000ER_SP_BAD_SQLSTATEBad SQLSTATE: '%s'
1408HY000ER_STARTUP%s: ready for connections. Version: '%s' socket: '%s' port: %d %s
1409HY000ER_LOAD_FROM_FIXED_SIZE_ROWS_TO_VARCan't load value from file with fixed size rows to variable
141042000ER_CANT_CREATE_USER_WITH_GRANTYou are not allowed to create a user with GRANT
1411HY000ER_WRONG_VALUE_FOR_TYPEIncorrect %s value: '%s' for function %s
1412HY000ER_TABLE_DEF_CHANGEDTable definition has changed, please retry transaction
141342000ER_SP_DUP_HANDLERDuplicate handler declared in the same block
141442000ER_SP_NOT_VAR_ARGOUT or INOUT argument %d for routine %s is not a variable or NEW pseudo-variable in BEFORE trigger
14150A000ER_SP_NO_RETSETNot allowed to return a result set from a %s
141622003ER_CANT_CREATE_GEOMETRY_OBJECTCannot get geometry object from data you send to the GEOMETRY field
1417HY000ER_FAILED_ROUTINE_BREAK_BINLOGA routine failed and has neither NO SQL nor READS SQL DATA in its declaration and binary logging is enabled; if non-transactional tables were updated, the binary log will miss their changes
1418HY000ER_BINLOG_UNSAFE_ROUTINEThis function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
1419HY000ER_BINLOG_CREATE_ROUTINE_NEED_SUPERYou do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
1420HY000ER_EXEC_STMT_WITH_OPEN_CURSORYou can't execute a prepared statement which has an open cursor associated with it. Reset the statement to re-execute it.
1421HY000ER_STMT_HAS_NO_OPEN_CURSORThe statement (%lu) has no open cursor.
1422HY000ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRGExplicit or implicit commit is not allowed in stored function or trigger.
1423HY000ER_NO_DEFAULT_FOR_VIEW_FIELDField of view '%s.%s' underlying table doesn't have a default value
1424HY000ER_SP_NO_RECURSIONRecursive stored functions and triggers are not allowed.
142542000ER_TOO_BIG_SCALEToo big scale %d specified for column '%s'. Maximum is %lu.
142642000ER_TOO_BIG_PRECISIONToo big precision %d specified for column '%s'. Maximum is %lu.
142742000ER_M_BIGGER_THAN_DFor float(M,D, double(M,D or decimal(M,D, M must be >= D (column '%s').
1428HY000ER_WRONG_LOCK_OF_SYSTEM_TABLEYou can't combine write-locking of system tables with other tables or lock types
1429HY000ER_CONNECT_TO_FOREIGN_DATA_SOURCEUnable to connect to foreign data source: %s
1430HY000ER_QUERY_ON_FOREIGN_DATA_SOURCEThere was a problem processing the query on the foreign data source. Data source error: %s
1431HY000ER_FOREIGN_DATA_SOURCE_DOESNT_EXISTThe foreign data source you are trying to reference does not exist. Data source error: %s
1432HY000ER_FOREIGN_DATA_STRING_INVALID_CANT_CREATECan't create federated table. The data source connection string '%s' is not in the correct format
1433HY000ER_FOREIGN_DATA_STRING_INVALIDThe data source connection string '%s' is not in the correct format
1434HY000ER_CANT_CREATE_FEDERATED_TABLECan't create federated table. Foreign data src error: %s
1435HY000ER_TRG_IN_WRONG_SCHEMATrigger in wrong schema
1436HY000ER_STACK_OVERRUN_NEED_MOREThread stack overrun: %ld bytes used of a %ld byte stack, and %ld bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.
143742000ER_TOO_LONG_BODYRoutine body for '%s' is too long
1438HY000ER_WARN_CANT_DROP_DEFAULT_KEYCACHECannot drop default keycache
143942000ER_TOO_BIG_DISPLAYWIDTHDisplay width out of range for column '%s' (max = %lu)
1440XAE08ER_XAER_DUPIDXAER_DUPID: The XID already exists
144122008ER_DATETIME_FUNCTION_OVERFLOWDatetime function: %s field overflow
1442HY000ER_CANT_UPDATE_USED_TABLE_IN_SF_OR_TRGCan't update table '%s' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
1443HY000ER_VIEW_PREVENT_UPDATEThe definition of table '%s' prevents operation %s on table '%s'.
1444HY000ER_PS_NO_RECURSIONThe prepared statement contains a stored routine call that refers to that same statement. It's not allowed to execute a prepared statement in such a recursive manner
1445HY000ER_SP_CANT_SET_AUTOCOMMITNot allowed to set autocommit from a stored function or trigger
1446HY000ER_MALFORMED_DEFINERDefiner is not fully qualified
1447HY000ER_VIEW_FRM_NO_USERView '%s'.'%s' has no definer information (old table format). Current user is used as definer. Please recreate the view!
1448HY000ER_VIEW_OTHER_USERYou need the SUPER privilege for creation view with '%s'@'%s' definer
1449HY000ER_NO_SUCH_USERThe user specified as a definer ('%s'@'%s') does not exist
1450HY000ER_FORBID_SCHEMA_CHANGEChanging schema from '%s' to '%s' is not allowed.
145123000ER_ROW_IS_REFERENCED_2Cannot delete or update a parent row: a foreign key constraint fails (%s)
145223000ER_NO_REFERENCED_ROW_2Cannot add or update a child row: a foreign key constraint fails (%s)
145342000ER_SP_BAD_VAR_SHADOWVariable '%s' must be quoted with `...`, or renamed
1454HY000ER_TRG_NO_DEFINERNo definer attribute for trigger '%s'.'%s'. The trigger will be activated under the authorization of the invoker, which may have insufficient privileges. Please recreate the trigger.
1455HY000ER_OLD_FILE_FORMAT'%s' has an old format, you should re-create the '%s' object(s)
1456HY000ER_SP_RECURSION_LIMITRecursive limit %d (as set by the max_sp_recursion_depth variable) was exceeded for routine %s
1457HY000ER_SP_PROC_TABLE_CORRUPTFailed to load routine %s. The table mysql.proc is missing, corrupt, or contains bad data (internal code %d)
145842000ER_SP_WRONG_NAMEIncorrect routine name '%s'
1459HY000ER_TABLE_NEEDS_UPGRADETable upgrade required. Please do "REPAIR TABLE `%s`" or dump/reload to fix it!
146042000ER_SP_NO_AGGREGATEAGGREGATE is not supported for stored functions
146142000ER_MAX_PREPARED_STMT_COUNT_REACHEDCan't create more than max_prepared_stmt_count statements (current value: %lu)
1462HY000ER_VIEW_RECURSIVE`%s`.`%s` contains view recursion
146342000ER_NON_GROUPING_FIELD_USEDNon-grouping field '%s' is used in %s clause
1464HY000ER_TABLE_CANT_HANDLE_SPKEYSThe used table type doesn't support SPATIAL indexes
1465HY000ER_NO_TRIGGERS_ON_SYSTEM_SCHEMATriggers can not be created on system tables
1466HY000ER_REMOVED_SPACESLeading spaces are removed from name '%s'
1467HY000ER_AUTOINC_READ_FAILEDFailed to read auto-increment value from storage engine
1468HY000ER_USERNAMEuser name
1469HY000ER_HOSTNAMEhost name
1470HY000ER_WRONG_STRING_LENGTHString '%s' is too long for %s (should be no longer than %d)
1471HY000ER_NON_INSERTABLE_TABLEThe target table %s of the %s is not insertable-into
1472HY000ER_ADMIN_WRONG_MRG_TABLETable '%s' is differently defined or of non-MyISAM type or doesn't exist
1473HY000ER_TOO_HIGH_LEVEL_OF_NESTING_FOR_SELECTToo high level of nesting for select
1474HY000ER_NAME_BECOMES_EMPTYName '%s' has become ''
1475HY000ER_AMBIGUOUS_FIELD_TERMFirst character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY
1476HY000ER_FOREIGN_SERVER_EXISTSThe foreign server, %s, you are trying to create already exists.
1477HY000ER_FOREIGN_SERVER_DOESNT_EXISTThe foreign server name you are trying to reference does not exist. Data source error: %s
1478HY000ER_ILLEGAL_HA_CREATE_OPTIONTable storage engine '%s' does not support the create option '%s'
1479HY000ER_PARTITION_REQUIRES_VALUES_ERRORSyntax error: %s PARTITIONING requires definition of VALUES %s for each partition
1480HY000ER_PARTITION_WRONG_VALUES_ERROROnly %s PARTITIONING can use VALUES %s in partition definition
1481HY000ER_PARTITION_MAXVALUE_ERRORMAXVALUE can only be used in last partition definition
1482HY000ER_PARTITION_SUBPARTITION_ERRORSubpartitions can only be hash partitions and by key
1483HY000ER_PARTITION_SUBPART_MIX_ERRORMust define subpartitions on all partitions if on one partition
1484HY000ER_PARTITION_WRONG_NO_PART_ERRORWrong number of partitions defined, mismatch with previous setting
1485HY000ER_PARTITION_WRONG_NO_SUBPART_ERRORWrong number of subpartitions defined, mismatch with previous setting
1486HY000ER_CONST_EXPR_IN_PARTITION_FUNC_ERRORConstant/Random expression in (sub)partitioning function is not allowed Note: Removed after 5.5.0, renamed to ER_WRONG_EXPR_IN_PARTITION_FUNC_ERROR in 5.5.1
1486HY000ER_WRONG_EXPR_IN_PARTITION_FUNC_ERRORConstant, random or timezone-dependent expressions in (sub)partitioning function are not allowed Note: Introduced in 5.5.1, renamed from ER_CONST_EXPR_IN_PARTITION_FUNC_ERROR
1487HY000ER_NO_CONST_EXPR_IN_RANGE_OR_LIST_ERRORExpression in RANGE/LIST VALUES must be constant
1488HY000ER_FIELD_NOT_FOUND_PART_ERRORField in list of fields for partition function not found in table
1489HY000ER_LIST_OF_FIELDS_ONLY_IN_HASH_ERRORList of fields is only allowed in KEY partitions
1490HY000ER_INCONSISTENT_PARTITION_INFO_ERRORThe partition info in the frm file is not consistent with what can be written into the frm file
1491HY000ER_PARTITION_FUNC_NOT_ALLOWED_ERRORThe %s function returns the wrong type
1492HY000ER_PARTITIONS_MUST_BE_DEFINED_ERRORFor %s partitions each partition must be defined
1493HY000ER_RANGE_NOT_INCREASING_ERRORVALUES LESS THAN value must be strictly increasing for each partition
1494HY000ER_INCONSISTENT_TYPE_OF_FUNCTIONS_ERRORVALUES value must be of same type as partition function
1495HY000ER_MULTIPLE_DEF_CONST_IN_LIST_PART_ERRORMultiple definition of same constant in list partitioning
1496HY000ER_PARTITION_ENTRY_ERRORPartitioning can not be used stand-alone in query
1497HY000ER_MIX_HANDLER_ERRORThe mix of handlers in the partitions is not allowed in this version of MariaDB
1498HY000ER_PARTITION_NOT_DEFINED_ERRORFor the partitioned engine it is necessary to define all %s
1499HY000ER_TOO_MANY_PARTITIONS_ERRORToo many partitions (including subpartitions) were defined
1500HY000ER_SUBPARTITION_ERRORIt is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
1501HY000ER_CANT_CREATE_HANDLER_FILEFailed to create specific handler file
1502HY000ER_BLOB_FIELD_IN_PART_FUNC_ERRORA BLOB field is not allowed in partition function
1503HY000ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PFA %s must include all columns in the table's partitioning function
1504HY000ER_NO_PARTS_ERRORNumber of %s = 0 is not an allowed value
1505HY000ER_PARTITION_MGMT_ON_NONPARTITIONEDPartition management on a not partitioned table is not possible
1506HY000ER_FOREIGN_KEY_ON_PARTITIONEDForeign key clause is not yet supported in conjunction with partitioning
1507HY000ER_DROP_PARTITION_NON_EXISTENTError in list of partitions to %s
1508HY000ER_DROP_LAST_PARTITIONCannot remove all partitions, use DROP TABLE instead
1509HY000ER_COALESCE_ONLY_ON_HASH_PARTITIONCOALESCE PARTITION can only be used on HASH/KEY partitions
1510HY000ER_REORG_HASH_ONLY_ON_SAME_NREORGANIZE PARTITION can only be used to reorganize partitions not to change their numbers
1511HY000ER_REORG_NO_PARAM_ERRORREORGANIZE PARTITION without parameters can only be used on auto-partitioned tables using HASH PARTITIONs
1512HY000ER_ONLY_ON_RANGE_LIST_PARTITION%s PARTITION can only be used on RANGE/LIST partitions
1513HY000ER_ADD_PARTITION_SUBPART_ERRORTrying to Add partition(s) with wrong number of subpartitions
1514HY000ER_ADD_PARTITION_NO_NEW_PARTITIONAt least one partition must be added
1515HY000ER_COALESCE_PARTITION_NO_PARTITIONAt least one partition must be coalesced
1516HY000ER_REORG_PARTITION_NOT_EXISTMore partitions to reorganize than there are partitions
1517HY000ER_SAME_NAME_PARTITIONDuplicate partition name %s
1518HY000ER_NO_BINLOG_ERRORIt is not allowed to shut off binlog on this command
1519HY000ER_CONSECUTIVE_REORG_PARTITIONSWhen reorganizing a set of partitions they must be in consecutive order
1520HY000ER_REORG_OUTSIDE_RANGEReorganize of range partitions cannot change total ranges except for last partition where it can extend the range
1521HY000ER_PARTITION_FUNCTION_FAILUREPartition function not supported in this version for this handler
1522HY000ER_PART_STATE_ERRORPartition state cannot be defined from CREATE/ALTER TABLE
1523HY000ER_LIMITED_PART_RANGEThe %s handler only supports 32 bit integers in VALUES
1524HY000ER_PLUGIN_IS_NOT_LOADEDPlugin '%s' is not loaded
1525HY000ER_WRONG_VALUEIncorrect %s value: '%s'
1526HY000ER_NO_PARTITION_FOR_GIVEN_VALUETable has no partition for value %s
1527HY000ER_FILEGROUP_OPTION_ONLY_ONCEIt is not allowed to specify %s more than once
1528HY000ER_CREATE_FILEGROUP_FAILEDFailed to create %s
1529HY000ER_DROP_FILEGROUP_FAILEDFailed to drop %s
1530HY000ER_TABLESPACE_AUTO_EXTEND_ERRORThe handler doesn't support autoextend of tablespaces
1531HY000ER_WRONG_SIZE_NUMBERA size parameter was incorrectly specified, either number or on the form 10M
1532HY000ER_SIZE_OVERFLOW_ERRORThe size number was correct but we don't allow the digit part to be more than 2 billion
1533HY000ER_ALTER_FILEGROUP_FAILEDFailed to alter: %s
1534HY000ER_BINLOG_ROW_LOGGING_FAILEDWriting one row to the row-based binary log failed
1535HY000ER_BINLOG_ROW_WRONG_TABLE_DEFTable definition on master and slave does not match: %s
1536HY000ER_BINLOG_ROW_RBR_TO_SBRSlave running with --log-slave-updates must use row-based binary logging to be able to replicate row-based binary log events
1537HY000ER_EVENT_ALREADY_EXISTSEvent '%s' already exists
1538HY000ER_EVENT_STORE_FAILEDFailed to store event %s. Error code %d from storage engine.
1539HY000ER_EVENT_DOES_NOT_EXISTUnknown event '%s'
1540HY000ER_EVENT_CANT_ALTERFailed to alter event '%s'
1541HY000ER_EVENT_DROP_FAILEDFailed to drop %s
1542HY000ER_EVENT_INTERVAL_NOT_POSITIVE_OR_TOO_BIGINTERVAL is either not positive or too big
1543HY000ER_EVENT_ENDS_BEFORE_STARTSENDS is either invalid or before STARTS
1544HY000ER_EVENT_EXEC_TIME_IN_THE_PASTEvent execution time is in the past. Event has been disabled
1545HY000ER_EVENT_OPEN_TABLE_FAILEDFailed to open mysql.event
1546HY000ER_EVENT_NEITHER_M_EXPR_NOR_M_ATNo datetime expression provided
1547HY000ER_COL_COUNT_DOESNT_MATCH_CORRUPTEDColumn count of mysql.%s is wrong. Expected %d, found %d. The table is probably corrupted
1548HY000ER_CANNOT_LOAD_FROM_TABLECannot load from mysql.%s. The table is probably corrupted
1549HY000ER_EVENT_CANNOT_DELETEFailed to delete the event from mysql.event
1550HY000ER_EVENT_COMPILE_ERRORError during compilation of event's body
1551HY000ER_EVENT_SAME_NAMESame old and new event name
1552HY000ER_EVENT_DATA_TOO_LONGData for column '%s' too long
1553HY000ER_DROP_INDEX_FKCannot drop index '%s': needed in a foreign key constraint
1554HY000ER_WARN_DEPRECATED_SYNTAX_WITH_VERThe syntax '%s' is deprecated and will be removed in MariaDB %s. Please use %s instead
1555HY000ER_CANT_WRITE_LOCK_LOG_TABLEYou can't write-lock a log table. Only read access is possible
1556HY000ER_CANT_LOCK_LOG_TABLEYou can't use locks with log tables.
155723000ER_FOREIGN_DUPLICATE_KEYUpholding foreign key constraints for table '%s', entry '%s', key %d would lead to a duplicate entry
1558HY000ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATEColumn count of mysql.%s is wrong. Expected %d, found %d. Created with MariaDB %d, now running %d. Please use mysql_upgrade to fix this error.
1559HY000ER_TEMP_TABLE_PREVENTS_SWITCH_OUT_OF_RBRCannot switch out of the row-based binary log format when the session has open temporary tables
1560HY000ER_STORED_FUNCTION_ PREVENTS_SWITCH_BINLOG_FORMATCannot change the binary logging format inside a stored function or trigger
1561HY000ER_NDB_CANT_SWITCH_BINLOG_FORMATThe NDB cluster engine does not support changing the binlog format on the fly yet
1562HY000ER_PARTITION_NO_TEMPORARYCannot create temporary table with partitions
1563HY000ER_PARTITION_CONST_DOMAIN_ERRORPartition constant is out of partition function domain
1564HY000ER_PARTITION_FUNCTION_IS_NOT_ALLOWEDThis partition function is not allowed
1565HY000ER_DDL_LOG_ERRORError in DDL log
1566HY000ER_NULL_IN_VALUES_LESS_THANNot allowed to use NULL value in VALUES LESS THAN
1567HY000ER_WRONG_PARTITION_NAMEIncorrect partition name
156825001ER_CANT_CHANGE_TX_ISOLATIONTransaction isolation level can't be changed while a transaction is in progress
1569HY000ER_DUP_ENTRY_AUTOINCREMENT_CASEALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '%s' for key '%s'
1570HY000ER_EVENT_MODIFY_QUEUE_ERRORInternal scheduler error %d
1571HY000ER_EVENT_SET_VAR_ERRORError during starting/stopping of the scheduler. Error code %u
1572HY000ER_PARTITION_MERGE_ERROREngine cannot be used in partitioned tables
1573HY000ER_CANT_ACTIVATE_LOGCannot activate '%s' log
1574HY000ER_RBR_NOT_AVAILABLEThe server was not built with row-based replication
1575HY000ER_BASE64_DECODE_ERRORDecoding of base64 string failed
1576HY000ER_EVENT_RECURSION_FORBIDDENRecursion of EVENT DDL statements is forbidden when body is present
1577HY000ER_EVENTS_DB_ERRORCannot proceed because system tables used by Event Scheduler were found damaged at server start
1578HY000ER_ONLY_INTEGERS_ALLOWEDOnly integers allowed as number here
1579HY000ER_UNSUPORTED_LOG_ENGINEThis storage engine cannot be used for log tables"
1580HY000ER_BAD_LOG_STATEMENTYou cannot '%s' a log table if logging is enabled
1581HY000ER_CANT_RENAME_LOG_TABLECannot rename '%s'. When logging enabled, rename to/from log table must rename two tables: the log table to an archive table and another table back to '%s'
158242000ER_WRONG_PARAMCOUNT_TO_NATIVE_FCTIncorrect parameter count in the call to native function '%s'
158342000ER_WRONG_PARAMETERS_TO_NATIVE_FCTIncorrect parameters in the call to native function '%s'
158442000ER_WRONG_PARAMETERS_TO_STORED_FCTIncorrect parameters in the call to stored function '%s'
1585HY000ER_NATIVE_FCT_NAME_COLLISIONThis function '%s' has the same name as a native function
158623000ER_DUP_ENTRY_WITH_KEY_NAMEDuplicate entry '%s' for key '%s' Note: This error string is also used with ER_DUP_ENTRY.
1587HY000ER_BINLOG_PURGE_EMFILEToo many files opened, please execute the command again
1588HY000ER_EVENT_CANNOT_CREATE_IN_THE_PASTEvent execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.
1589HY000ER_EVENT_CANNOT_ALTER_IN_THE_PASTEvent execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.
1590HY000ER_SLAVE_INCIDENTThe incident %s occured on the master. Message: %s
1591HY000ER_NO_PARTITION_FOR_GIVEN_VALUE_SILENTTable has no partition for some existing values
1592HY000ER_BINLOG_UNSAFE_STATEMENTUnsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. %s
1593HY000ER_SLAVE_FATAL_ERRORFatal error: %s
1594HY000ER_SLAVE_RELAY_LOG_READ_FAILURERelay log read failure: %s
1595HY000ER_SLAVE_RELAY_LOG_WRITE_FAILURERelay log write failure: %s
1596HY000ER_SLAVE_CREATE_EVENT_FAILUREFailed to create %s
1597HY000ER_SLAVE_MASTER_COM_FAILUREMaster command %s failed: %s
1598HY000ER_BINLOG_LOGGING_IMPOSSIBLEBinary logging not possible. Message: %s
1599HY000ER_VIEW_NO_CREATION_CTXView `%s`.`%s` has no creation context
1600HY000ER_VIEW_INVALID_CREATION_CTXCreation context of view `%s`.`%s' is invalid
1601HY000ER_SR_INVALID_CREATION_CTXCreation context of stored routine `%s`.`%s` is invalid
1602HY000ER_TRG_CORRUPTED_FILECorrupted TRG file for table `%s`.`%s`
1603HY000ER_TRG_NO_CREATION_CTXTriggers for table `%s`.`%s` have no creation context
1604HY000ER_TRG_INVALID_CREATION_CTXTrigger creation context of table `%s`.`%s` is invalid
1605HY000ER_EVENT_INVALID_CREATION_CTXCreation context of event `%s`.`%s` is invalid
1606HY000ER_TRG_CANT_OPEN_TABLECannot open table for trigger `%s`.`%s`
1607HY000ER_CANT_CREATE_SROUTINECannot create stored routine `%s`. Check warnings
1608HY000ER_SLAVE_AMBIGOUS_EXEC_MODEAmbiguous slave modes combination. %s Note: Removed after 5.5.2 and renamed to ER_NEVER_USED in 5.5.3.
1608HY000ER_NEVER_USEDAmbiguous slave modes combination. %s Note: Introduced in 5.5.3, renamed from ER_SLAVE_AMBIGOUS_EXEC_MODE.
1609HY000ER_NO_FORMAT_DESCRIPTION_EVENT _BEFORE_BINLOG_STATEMENTThe BINLOG statement of type `%s` was not preceded by a format description BINLOG statement.
1610HY000ER_SLAVE_CORRUPT_EVENTCorrupted replication event was detected
1611HY000ER_LOAD_DATA_INVALID_COLUMNInvalid column reference (%s) in LOAD DATA
1612HY000ER_LOG_PURGE_NO_FILEBeing purged log %s was not found
1613XA106ER_XA_RBTIMEOUTXA_RBTIMEOUT: Transaction branch was rolled back: took too long
1614XA102ER_XA_RBDEADLOCKXA_RBDEADLOCK: Transaction branch was rolled back: deadlock was detected
1615HY000ER_NEED_REPREPAREPrepared statement needs to be re-prepared
1616HY000ER_DELAYED_NOT_SUPPORTEDDELAYED option not supported for table '%s'
1617HY000WARN_NO_MASTER_INFThe master info structure does not exist
1618HY000WARN_OPTION_IGNORED<%s> option ignored
1619HY000WARN_PLUGIN_DELETE_BUILTINBuilt-in plugins cannot be deleted
1620HY000WARN_PLUGIN_BUSYPlugin is busy and will be uninstalled on shutdown
1621HY000ER_VARIABLE_IS_READONLY%s variable '%s' is read-only. Use SET %s to assign the value
1622HY000ER_WARN_ENGINE_TRANSACTION_ROLLBACKStorage engine %s does not support rollback for this statement. Transaction rolled back and must be restarted
1623HY000ER_SLAVE_HEARTBEAT_FAILUREUnexpected master's heartbeat data: %s
1624HY000ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGEThe requested value for the heartbeat period is either negative or exceeds the maximum allowed (%s seconds).
1625HY000ER_NDB_REPLICATION_SCHEMA_ERRORBad schema for mysql.ndb_replication table. Message: %s
1626HY000ER_CONFLICT_FN_PARSE_ERRORError in parsing conflict function. Message: %s
1627HY000ER_EXCEPTIONS_WRITE_ERRORWrite to exceptions table failed. Message: %s"
1628HY000ER_TOO_LONG_TABLE_COMMENTComment for table '%s' is too long (max = %lu)
1629HY000ER_TOO_LONG_FIELD_COMMENTComment for field '%s' is too long (max = %lu)
163042000ER_FUNC_INEXISTENT_NAME_COLLISIONFUNCTION %s does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
1631HY000ER_DATABASE_NAMEDatabase
1632HY000ER_TABLE_NAMETable
1633HY000ER_PARTITION_NAMEPartition
1634HY000ER_SUBPARTITION_NAMESubpartition
1635HY000ER_TEMPORARY_NAMETemporary
1636HY000ER_RENAMED_NAMERenamed
1637HY000ER_TOO_MANY_CONCURRENT_TRXSToo many active concurrent transactions
1638HY000WARN_NON_ASCII_SEPARATOR_NOT_IMPLEMENTEDNon-ASCII separator arguments are not fully supported
1639HY000ER_DEBUG_SYNC_TIMEOUTdebug sync point wait timed out
1640HY000ER_DEBUG_SYNC_HIT_LIMITdebug sync point hit limit reached
164142000ER_DUP_SIGNAL_SETDuplicate condition information item '%s'
164201000ER_SIGNAL_WARNUnhandled user-defined warning condition
164302000ER_SIGNAL_NOT_FOUNDUnhandled user-defined not found condition
1644HY000ER_SIGNAL_EXCEPTIONUnhandled user-defined exception condition
16450K000ER_RESIGNAL_WITHOUT_ACTIVE_HANDLERRESIGNAL when handler not active
1646HY000ER_SIGNAL_BAD_CONDITION_TYPESIGNAL/RESIGNAL can only use a CONDITION defined with SQLSTATE
1647HY000WARN_COND_ITEM_TRUNCATEDData truncated for condition item '%s'
1648HY000ER_COND_ITEM_TOO_LONGData too long for condition item '%s'
1649HY000ER_UNKNOWN_LOCALEUnknown locale: '%s'
1650HY000ER_SLAVE_IGNORE_SERVER_IDSThe requested server id %d clashes with the slave startup option --replicate-same-server-id
1651HY000ER_QUERY_CACHE_DISABLEDQuery cache is disabled; restart the server with query_cache_type=1 to enable it
1652HY000ER_SAME_NAME_PARTITION_FIELDDuplicate partition field name '%s'
1653HY000ER_PARTITION_COLUMN_LIST_ERRORInconsistency in usage of column lists for partitioning
1654HY000ER_WRONG_TYPE_COLUMN_VALUE_ERRORPartition column values of incorrect type
1655HY000ER_TOO_MANY_PARTITION_FUNC_FIELDS_ERRORToo many fields in '%s'
1656HY000ER_MAXVALUE_IN_VALUES_INCannot use MAXVALUE as value in VALUES IN
1657HY000ER_TOO_MANY_VALUES_ERRORCannot have more than one value for this type of %s partitioning
1658HY000ER_ROW_SINGLE_PARTITION_FIELD_ERRORRow expressions in VALUES IN only allowed for multi-field column partitioning
1659HY000ER_FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELDField '%s' is of a not allowed type for this type of partitioning
1660HY000ER_PARTITION_FIELDS_TOO_LONGThe total length of the partitioning fields is too large
1661HY000ER_BINLOG_ROW_ENGINE_AND_STMT_ENGINECannot execute statement: impossible to write to binary log since both row-incapable engines and statement-incapable engines are involved. Note: Introduced in 5.5.3.
1662HY000ER_BINLOG_ROW_MODE_AND_STMT_ENGINECannot execute statement: impossible to write to binary log since BINLOG_FORMAT = ROW and at least one table uses a storage engine limited to statement-based logging. Note: Introduced in 5.5.3.
1663HY000ER_BINLOG_UNSAFE_AND_STMT_ENGINECannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. %s Note: Introduced in 5.5.3.
1664HY000ER_BINLOG_ROW_INJECTION_AND_STMT_ENGINECannot execute statement: impossible to write to binary log since statement is in row format and at least one table uses a storage engine limited to statement-based logging. Note: Introduced in 5.5.3.
1665HY000ER_BINLOG_STMT_MODE_AND_ROW_ENGINECannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging.%s Note: Introduced in 5.5.3.
1666HY000ER_BINLOG_ROW_INJECTION_AND_STMT_MODECannot execute statement: impossible to write to binary log since statement is in row format and BINLOG_FORMAT = STATEMENT. Note: Introduced in 5.5.3.
1667HY000ER_BINLOG_MULTIPLE_ENGINES _AND_SELF_LOGGING_ENGINECannot execute statement: impossible to write to binary log since more than one engine is involved and at least one engine is self-logging. Note: Introduced in 5.5.3.
1668HY000ER_BINLOG_UNSAFE_LIMITThe statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted. Note: Introduced in 5.5.3.
1669HY000ER_BINLOG_UNSAFE_INSERT_DELAYEDThe statement is unsafe because it uses INSERT DELAYED. This is unsafe because the times when rows are inserted cannot be predicted. Note: Introduced in 5.5.3.
1670HY000ER_BINLOG_UNSAFE_SYSTEM_TABLEThe statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). This is unsafe because system tables may differ on slaves. Note: Introduced in 5.5.3.
1671HY000ER_BINLOG_UNSAFE_AUTOINC_COLUMNSStatement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly. Note: Introduced in 5.5.3.
1672HY000ER_BINLOG_UNSAFE_UDFStatement is unsafe because it uses a UDF which may not return the same value on the slave. Note: Introduced in 5.5.3.
1673HY000ER_BINLOG_UNSAFE_SYSTEM_VARIABLEStatement is unsafe because it uses a system variable that may have a different value on the slave. Note: Introduced in 5.5.3.
1674HY000ER_BINLOG_UNSAFE_SYSTEM_FUNCTIONStatement is unsafe because it uses a system function that may return a different value on the slave. Note: Introduced in 5.5.3.
1675HY000ER_BINLOG_UNSAFE_NONTRANS_AFTER_TRANSStatement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction. Note: ER_BINLOG_UNSAFE_NONTRANS_AFTER_TRANS was introduced in 5.5.3.
1676HY000ER_MESSAGE_AND_STATEMENT%s Statement: %s Note: Introduced in 5.5.3.
1677HY000ER_SLAVE_CONVERSION_FAILEDColumn %d of table '%s.%s' cannot be converted from type '%s' to type '%s' Note: Introduced in 5.5.3.
1678HY000ER_SLAVE_CANT_CREATE_CONVERSIONCan't create conversion table for table '%s.%s' Note: Introduced in 5.5.3.
1679HY000ER_INSIDE_TRANSACTION _PREVENTS_SWITCH_BINLOG_FORMATCannot modify @@session.binlog_format inside a transaction Note: Introduced in 5.5.3.
1680HY000ER_PATH_LENGTHThe path specified for %s is too long. Note: Introduced in 5.5.3.
1681HY000ER_WARN_DEPRECATED_SYNTAX_NO_REPLACEMENT'%s' is deprecated and will be removed in a future release. Note: Introduced in 5.5.3.
1682HY000ER_WRONG_NATIVE_TABLE_STRUCTURENative table '%s'.'%s' has the wrong structure Note: Introduced in 5.5.3.
1683HY000ER_WRONG_PERFSCHEMA_USAGEInvalid performance_schema usage. Note: Introduced in 5.5.3.
1684HY000ER_WARN_I_S_SKIPPED_TABLETable '%s'.'%s' was skipped since its definition is being modified by concurrent DDL statement Note: Introduced in 5.5.3.
1685HY000ER_INSIDE_TRANSACTION _PREVENTS_SWITCH_BINLOG_DIRECTCannot modify @@session.binlog_direct_non_transactional_updates inside a transaction Note: Introduced in 5.5.3.
1686HY000ER_STORED_FUNCTION_PREVENTS _SWITCH_BINLOG_DIRECTCannot change the binlog direct flag inside a stored function or trigger Note: Introduced in 5.5.3.
168742000ER_SPATIAL_MUST_HAVE_GEOM_COLA SPATIAL index may only contain a geometrical type column Note: Introduced in 5.5.2.
1688HY000ER_TOO_LONG_INDEX_COMMENTComment for index '%s' is too long (max = %lu) Note: Introduced in 5.5.3.
1689HY000ER_LOCK_ABORTEDWait on a lock was aborted due to a pending exclusive lock Note: Introduced in 5.5.4.
169022003ER_DATA_OUT_OF_RANGE%s value is out of range in '%s' Note: Introduced in 5.5.5.
1691HY000ER_WRONG_SPVAR_TYPE_IN_LIMITA variable of a non-integer based type in LIMIT clause Note: Introduced in 5.5.5.
1692HY000ER_BINLOG_UNSAFE_MULTIPLE_ENGINES _AND_SELF_LOGGING_ENGINEMixing self-logging and non-self-logging engines in a statement is unsafe. Note: Introduced in 5.5.5.
1693HY000ER_BINLOG_UNSAFE_MIXED_STATEMENTStatement accesses nontransactional table as well as transactional or temporary table, and writes to any of them. Note: Introduced in 5.5.5.
1694HY000ER_INSIDE_TRANSACTION_ PREVENTS_SWITCH_SQL_LOG_BINCannot modify @@session.sql_log_bin inside a transaction Note: Introduced in 5.5.5.
1695HY000ER_STORED_FUNCTION_ PREVENTS_SWITCH_SQL_LOG_BINCannot change the sql_log_bin inside a stored function or trigger Note: Introduced in 5.5.5.
1696HY000ER_FAILED_READ_FROM_PAR_FILEFailed to read from the .par file Note: Introduced in 5.5.5.
1697HY000ER_VALUES_IS_NOT_INT_TYPE_ERRORVALUES value for partition '%s' must have type INT Note: Introduced in 5.5.7.
169828000ER_ACCESS_DENIED_NO_PASSWORD_ERRORAccess denied for user '%s'@'%s' Note: Introduced in 5.5.7.
1699HY000ER_SET_PASSWORD_AUTH_PLUGINSET PASSWORD has no significance for users authenticating via plugins Note: Introduced in 5.5.7.
1700HY000ER_GRANT_PLUGIN_USER_EXISTSGRANT with IDENTIFIED WITH is illegal because the user %-.*s already exists Note: Introduced in 5.5.7.
170142000ER_TRUNCATE_ILLEGAL_FKCannot truncate a table referenced in a foreign key constraint (%s) Note: Introduced in 5.5.7.
1702HY000ER_PLUGIN_IS_PERMANENTPlugin '%s' is force_plus_permanent and can not be unloaded Note: Introduced in 5.5.7.
1703HY000ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MINThe requested value for the heartbeat period is less than 1 millisecond. The value is reset to 0, meaning that heartbeating will effectively be disabled. Note: Introduced in 5.5.7.
1704HY000ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MAXThe 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. Note: Introduced in 5.5.7.
1705HY000ER_STMT_CACHE_FULLMulti-row statements required more than 'max_binlog_stmt_cache_size' bytes of storage; increase this mysqld variable and try again Note: Introduced in 5.5.9.
1706HY000ER_MULTI_UPDATE_KEY_CONFLICTPrimary key/partition key update is not allowed since the table is updated both as '%s' and '%s'. Note: Introduced in 5.5.11.
1707HY000ER_TABLE_NEEDS_REBUILDTable rebuild required. Please do "ALTER TABLE `%s` FORCE" or dump/reload to fix it! Note: Introduced in 5.5.11.
1708HY000WARN_OPTION_BELOW_LIMITThe value of '%s' should be no less than the value of '%s' Note: Introduced in 5.5.12.
1709HY000ER_INDEX_COLUMN_TOO_LONGIndex column size too large. The maximum column size is %lu bytes. Note: Introduced in 5.5.14.
1710HY000ER_ERROR_IN_TRIGGER_BODYTrigger '%s' has an error in its body: '%s' Note: Introduced in 5.5.15.
1711HY000ER_ERROR_IN_UNKNOWN_TRIGGER_BODYUnknown trigger has an error in its body: '%s' Note: Introduced in 5.5.15.
1712HY000ER_INDEX_CORRUPTIndex %s is corrupted Note: Introduced in 5.5.17.
1713HY000ER_UNDO_RECORD_TOO_BIGUndo log record is too big. Note: Introduced in 5.5.17.
1714HY000ER_BINLOG_UNSAFE_INSERT_IGNORE_SELECTINSERT 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. Note: Introduced in 5.5.18.
1715HY000ER_BINLOG_UNSAFE_INSERT_SELECT_UPDATEINSERT... 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. Note: Introduced in 5.5.18.
1716HY000ER_BINLOG_UNSAFE_REPLACE_SELECTREPLACE... 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. Note: Introduced in 5.5.18.
1717HY000ER_BINLOG_UNSAFE_CREATE_IGNORE_SELECTCREATE... 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. Note: Introduced in 5.5.18.
1718HY000ER_BINLOG_UNSAFE_CREATE_REPLACE_SELECTCREATE... 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. Note: Introduced in 5.5.18.
1719HY000ER_BINLOG_UNSAFE_UPDATE_IGNOREUPDATE 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. Note: Introduced in 5.5.18.
1720HY000ER_PLUGIN_NO_UNINSTALLPlugin '%s' is marked as not dynamically uninstallable. You have to stop the server to uninstall it. Note: Introduced in 5.5.16.
1721HY000ER_PLUGIN_NO_INSTALLPlugin '%s' is marked as not dynamically installable. You have to stop the server to install it. Note: Introduced in 5.5.16.
1722HY000ER_BINLOG_UNSAFE_WRITE_AUTOINC_SELECTStatements 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. Note: Introduced in 5.5.22.
1723HY000ER_BINLOG_UNSAFE_CREATE_SELECT_AUTOINCCREATE 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. Note: Introduced in 5.5.22.
1724HY000ER_BINLOG_UNSAFE_INSERT_TWO_KEYSINSERT... ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe Note: Introduced in 5.5.24.
1725HY000ER_TABLE_IN_FK_CHECKTable is being used in foreign key check. Note: Introduced in 5.5.24.
1726HY000ER_UNSUPPORTED_ENGINEStorage engine '%s' does not support system tables. [%s.%s] Note: Introduced in 5.5.24.
1727HY000ER_BINLOG_UNSAFE_AUTOINC_NOT_FIRSTINSERT into autoincrement field which is not the first part in the composed primary key is unsafe. Note: Introduced in 5.5.25.

Codici di errore specifici di MariaDB

Codice di erroreSQLSTATEErroreSpiegazione
1900ER_VCOL_BASED_ON_VCOLA computed column cannot be based on a computed column
1901ER_VIRTUAL_COLUMN_FUNCTION_IS_NOT_ALLOWEDFunction or expression is not allowed for column '%s'
1902ER_DATA_CONVERSION_ERROR_FOR_VIRTUAL_COLUMNGenerated value for computed column '%s' cannot be converted to type '%s'
1903ER_PRIMARY_KEY_BASED_ON_VIRTUAL_COLUMNPrimary key cannot be defined upon a computed column
1904ER_KEY_BASED_ON_GENERATED_VIRTUAL_COLUMNKey/Index cannot be defined on a non-stored computed column
1905ER_WRONG_FK_OPTION_FOR_VIRTUAL_COLUMNCannot define foreign key with %s clause on a computed column
1906ER_WARNING_NON_DEFAULT_VALUE_FOR_VIRTUAL_COLUMNThe value specified for computed column '%s' in table '%s' ignored
1907ER_UNSUPPORTED_ACTION_ON_VIRTUAL_COLUMNThis is not yet supported for computed columns
1908ER_CONST_EXPR_IN_VCOLConstant expression in computed column function is not allowed
1909ER_ROW_EXPR_FOR_VCOLExpression for computed column cannot return a row
1910ER_UNSUPPORTED_ENGINE_FOR_VIRTUAL_COLUMNS%s storage engine does not support computed columns
1911ER_UNKNOWN_OPTIONUnknown option '%-.64s'
1912ER_BAD_OPTION_VALUEIncorrect value '%-.64s' for option '%-.64s'
1913ER_NETWORK_READ_EVENT_CHECKSUM_FAILUREReplication event checksum verification failed while reading from network.
1914ER_BINLOG_READ_EVENT_CHECKSUM_FAILUREReplication event checksum verification failed while reading from a log file.
1915ER_CANT_DO_ONLINECan't execute the given '%s' command as online
1916ER_DATA_OVERFLOW 22003Got overflow when converting '%-.128s' to %-.32s. Value truncated.
1917ER_DATA_TRUNCATED 22003Truncated value '%-.128s' when converting to %-.32s
1918ER_BAD_DATA 22007Encountered illegal value '%-.128s' when converting to %-.32s
1919ER_DYN_COL_WRONG_FORMATEncountered illegal format of dynamic column string
1920ER_DYN_COL_IMPLEMENTATION_LIMITDynamic column implementation limit reached
1921ER_DYN_COL_DATA 22007Illegal value used as argument of dynamic column function
1922ER_DYN_COL_WRONG_CHARSETDynamic column contains unknown character set
1923ER_ILLEGAL_SUBQUERY_OPTIMIZER_SWITCHESAt least one of the 'in_to_exists' or 'materialization' optimizer_switch flags must be 'on'.
1924ER_QUERY_CACHE_IS_DISABLEDQuery cache is disabled (resize or similar command in progress); repeat this command later
1925ER_QUERY_CACHE_IS_GLOBALY_DISABLEDQuery cache is globally disabled and you can't enable it only for this session
1926ER_VIEW_ORDERBY_IGNOREDView '%-.192s'.'%-.192s' ORDER BY clause ignored because there is other ORDER BY clause already.
1927ER_CONNECTION_KILLED 70100Connection was killed
1928ER_INTERNAL_ERRORInternal error: '%-.192s'
1929ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_SKIP_REPLICATIONCannot modify @@session.skip_replication inside a transaction
1930ER_STORED_FUNCTION_PREVENTS_SWITCH_SKIP_REPLICATIONCannot modify @@session.skip_replication inside a stored function or trigger
1931ER_QUERY_EXCEEDED_ROWS_EXAMINED_LIMITQuery execution was interrupted. The query examined at least %llu rows, which exceeds LIMIT ROWS EXAMINED (%llu). The query result may be incomplete.
1932ER_NO_SUCH_TABLE_IN_ENGINE 42S02Table '%-.192s.%-.192s' doesn't exist in engine
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.