Shared MariaDB/MySQL error codes
|
Error Code | SQLSTATE | Error | Description
|
1000 | HY000 | ER_HASHCHK | hashchk
|
1001 | HY000 | ER_NISAMCHK | isamchk
|
1002 | HY000 | ER_NO | NO
|
1003 | HY000 | ER_YES | YES
|
1004 | HY000 | ER_CANT_CREATE_FILE | Can't create file '%s' (errno: %d)
|
1005 | HY000 | ER_CANT_CREATE_TABLE | Can't create table '%s' (errno: %d)
|
1006 | HY000 | ER_CANT_CREATE_DB | Can't create database '%s' (errno: %d)
|
1007 | HY000 | ER_DB_CREATE_EXISTS | Can't create database '%s'; database
exists
|
1008 | HY000 | ER_DB_DROP_EXISTS | Can't drop database '%s'; database doesn't
exist
|
1009 | HY000 | ER_DB_DROP_DELETE | Error dropping database (can't delete '%s',
errno: %d)
|
1010 | HY000 | ER_DB_DROP_RMDIR | Error dropping database (can't rmdir '%s',
errno: %d)
|
1011 | HY000 | ER_CANT_DELETE_FILE | Error on delete of '%s' (errno: %d)
|
1012 | HY000 | ER_CANT_FIND_SYSTEM_REC | Can't read record in system table
|
1013 | HY000 | ER_CANT_GET_STAT | Can't get status of '%s' (errno: %d)
|
1014 | HY000 | ER_CANT_GET_WD | Can't get working directory (errno: %d)
|
1015 | HY000 | ER_CANT_LOCK | Can't lock file (errno: %d)
|
1016 | HY000 | ER_CANT_OPEN_FILE | Can't open file: '%s' (errno: %d)
|
1017 | HY000 | ER_FILE_NOT_FOUND | Can't find file: '%s' (errno: %d)
|
1018 | HY000 | ER_CANT_READ_DIR | Can't read dir of '%s' (errno: %d)
|
1019 | HY000 | ER_CANT_SET_WD | Can't change dir to '%s' (errno: %d)
|
1020 | HY000 | ER_CHECKREAD | Record has changed since last read in table '%s'
|
1021 | HY000 | ER_DISK_FULL | Disk full (%s); waiting for someone to free some
space...
|
1022 | 23000 | ER_DUP_KEY | Can't write; duplicate key in table '%s'
|
1023 | HY000 | ER_ERROR_ON_CLOSE | Error on close of '%s' (errno: %d)
|
1024 | HY000 | ER_ERROR_ON_READ | Error reading file '%s' (errno: %d)
|
1025 | HY000 | ER_ERROR_ON_RENAME | Error on rename of '%s' to '%s' (errno: %d)
|
1026 | HY000 | ER_ERROR_ON_WRITE | Error writing file '%s' (errno: %d)
|
1027 | HY000 | ER_FILE_USED | '%s' is locked against change
|
1028 | HY000 | ER_FILSORT_ABORT | Sort aborted
|
1029 | HY000 | ER_FORM_NOT_FOUND | View '%s' doesn't exist for '%s'
|
1030 | HY000 | ER_GET_ERRN | Got error %d from storage engine
|
1031 | HY000 | ER_ILLEGAL_HA | Table storage engine for '%s' doesn't have this
option
|
1032 | HY000 | ER_KEY_NOT_FOUND | Can't find record in '%s'
|
1033 | HY000 | ER_NOT_FORM_FILE | Incorrect information in file: '%s'
|
1034 | HY000 | ER_NOT_KEYFILE | Incorrect key file for table '%s'; try to repair
it
|
1035 | HY000 | ER_OLD_KEYFILE | Old key file for table '%s'; repair it!
|
1036 | HY000 | ER_OPEN_AS_READONLY | Table '%s' is read only
|
1037 | HY001 | ER_OUTOFMEMORY | Out of memory; restart server and try again
(needed %d bytes)
|
1038 | HY001 | ER_OUT_OF_SORTMEMORY | Out of sort memory, consider increasing
server sort buffer size
|
1039 | HY000 | ER_UNEXPECTED_EOF | Unexpected EOF found when reading file '%s'
(Errno: %d)
|
1040 | 08004 | ER_CON_COUNT_ERROR | Too many connections
|
1041 | HY000 | ER_OUT_OF_RESOURCES | Out 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
|
1042 | 08S01 | ER_BAD_HOST_ERROR | Can't get hostname for your address
|
1043 | 08S01 | ER_HANDSHAKE_ERROR | Bad handshake
|
1044 | 42000 | ER_DBACCESS_DENIED_ERROR | Access denied for user '%s'@'%s' to
database '%s'
|
1045 | 28000 | ER_ACCESS_DENIED_ERROR | Access denied for user '%s'@'%s' (using
password: %s)
|
1046 | 3D000 | ER_NO_DB_ERROR | No database selected
|
1047 | 08S01 | ER_UNKNOWN_COM_ERROR | Unknown command
|
1048 | 23000 | ER_BAD_NULL_ERROR | Column '%s' cannot be null
|
1049 | 42000 | ER_BAD_DB_ERROR | Unknown database '%s'
|
1050 | 42S01 | ER_TABLE_EXISTS_ERROR | Table '%s' already exists
|
1051 | 42S02 | ER_BAD_TABLE_ERROR | Unknown table '%s'
|
1052 | 23000 | ER_NON_UNIQ_ERROR | Column '%s' in %s is ambiguous
|
1053 | 08S01 | ER_SERVER_SHUTDOWN | Server shutdown in progress
|
1054 | 42S22 | ER_BAD_FIELD_ERROR | Unknown column '%s' in '%s'
|
1055 | 42000 | ER_WRONG_FIELD_WITH_GROUP | '%s' isn't in GROUP BY
|
1056 | 42000 | ER_WRONG_GROUP_FIELD | Can't group on '%s'
|
1057 | 42000 | ER_WRONG_SUM_SELECT | Statement has sum functions and columns in
same statement
|
1058 | 21S01 | ER_WRONG_VALUE_COUNT | Column count doesn't match value count
|
1059 | 42000 | ER_TOO_LONG_IDENT | Identifier name '%s' is too long
|
1060 | 42S21 | ER_DUP_FIELDNAME | Duplicate column name '%s'
|
1061 | 42000 | ER_DUP_KEYNAME | Duplicate key name '%s'
|
1062 | 23000 | ER_DUP_ENTRY | Duplicate entry '%s' for key %d
|
1063 | 42000 | ER_WRONG_FIELD_SPEC | Incorrect column specifier for column '%s'
|
1064 | 42000 | ER_PARSE_ERROR | %s near '%s' at line %d
|
1065 | 42000 | ER_EMPTY_QUERY | Query was empty
|
1066 | 42000 | ER_NONUNIQ_TABLE | Not unique table/alias: '%s'
|
1067 | 42000 | ER_INVALID_DEFAULT | Invalid default value for '%s'
|
1068 | 42000 | ER_MULTIPLE_PRI_KEY | Multiple primary key defined
|
1069 | 42000 | ER_TOO_MANY_KEYS | Too many keys specified; max %d keys allowed
|
1070 | 42000 | ER_TOO_MANY_KEY_PARTS | Too many key parts specified; max %d
parts allowed
|
1071 | 42000 | ER_TOO_LONG_KEY | Specified key was too long; max key length is
%d bytes
|
1072 | 42000 | ER_KEY_COLUMN_DOES_NOT_EXITS | Key column '%s' doesn't exist in
table
|
1073 | 42000 | ER_BLOB_USED_AS_KEY | BLOB column '%s' can't be used in key
specification with the used table type
|
1074 | 42000 | ER_TOO_BIG_FIELDLENGTH | Column length too big for column '%s'
(max = %lu); use BLOB or TEXT instead
|
1075 | 42000 | ER_WRONG_AUTO_KEY | Incorrect table definition; there can be only
one auto column and it must be defined as a key
|
1076 | HY000 | ER_READY | %s: ready for connections. Version: '%s' socket: '%s'
port: %d
|
1077 | HY000 | ER_NORMAL_SHUTDOWN | %s: Normal shutdown
|
1078 | HY000 | ER_GOT_SIGNAL | %s: Got signal %d. Aborting!
|
1079 | HY000 | ER_SHUTDOWN_COMPLETE | %s: Shutdown complete
|
1080 | 08S01 | ER_FORCING_CLOSE | %s: Forcing close of thread %ld user: '%s'
|
1081 | 08S01 | ER_IPSOCK_ERROR | Can't create IP socket
|
1082 | 42S12 | ER_NO_SUCH_INDEX | Table '%s' has no index like the one used in
CREATE INDEX; recreate the table
|
1083 | 42000 | ER_WRONG_FIELD_TERMINATORS | Field separator argument is not what
is expected; check the manual
|
1084 | 42000 | ER_BLOBS_AND_NO_TERMINATED | You can't use fixed rowlength with
BLOBs; please use 'fields terminated by'
|
1085 | HY000 | ER_TEXTFILE_NOT_READABLE | The file '%s' must be in the database
directory or be readable by all
|
1086 | HY000 | ER_FILE_EXISTS_ERROR | File '%s' already exists
|
1087 | HY000 | ER_LOAD_INF | Records: %ld Deleted: %ld Skipped: %ld Warnings:
%ld
|
1088 | HY000 | ER_ALTER_INF | Records: %ld Duplicates: %ld
|
1089 | HY000 | ER_WRONG_SUB_KEY | Incorrect 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
|
1090 | 42000 | ER_CANT_REMOVE_ALL_FIELDS | You can't delete all columns with
ALTER TABLE; use DROP TABLE instead
|
1091 | 42000 | ER_CANT_DROP_FIELD_OR_KEY | Can't DROP '%s'; check that
column/key exists
|
1092 | HY000 | ER_INSERT_INF | Records: %ld Duplicates: %ld Warnings: %ld
|
1093 | HY000 | ER_UPDATE_TABLE_USED | You can't specify target table '%s' for
update in FROM clause
|
1094 | HY000 | ER_NO_SUCH_THREAD | Unknown thread id: %lu
|
1095 | HY000 | ER_KILL_DENIED_ERROR | You are not owner of thread %lu
|
1096 | HY000 | ER_NO_TABLES_USED | No tables used
|
1097 | HY000 | ER_TOO_BIG_SET | Too many strings for column %s and SET
|
1098 | HY000 | ER_NO_UNIQUE_LOGFILE | Can't generate a unique log-filename %s.(1
-999)
|
1099 | HY000 | ER_TABLE_NOT_LOCKED_FOR_WRITE | Table '%s' was locked with a READ
lock and can't be updated
|
Error Code | SQLSTATE | Error | Description
|
1100 | HY000 | ER_TABLE_NOT_LOCKED | Table '%s' was not locked with LOCK TABLES
|
1101 | | ER_UNUSED_17 | You should never see it
|
1102 | 42000 | ER_WRONG_DB_NAME | Incorrect database name '%s'
|
1103 | 42000 | ER_WRONG_TABLE_NAME | Incorrect table name '%s'
|
1104 | 42000 | ER_TOO_BIG_SELECT | The 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
|
1105 | HY000 | ER_UNKNOWN_ERROR | Unknown error
|
1106 | 42000 | ER_UNKNOWN_PROCEDURE | Unknown procedure '%s'
|
1107 | 42000 | ER_WRONG_PARAMCOUNT_TO_PROCEDURE | Incorrect parameter count to
procedure '%s'
|
1108 | HY000 | ER_WRONG_PARAMETERS_TO_PROCEDURE | Incorrect parameters to
procedure '%s'
|
1109 | 42S02 | ER_UNKNOWN_TABLE | Unknown table '%s' in %s
|
1110 | 42000 | ER_FIELD_SPECIFIED_TWICE | Column '%s' specified twice
|
1111 | HY000 | ER_INVALID_GROUP_FUNC_USE | Invalid use of group function
|
1112 | 42000 | ER_UNSUPPORTED_EXTENSION | Table '%s' uses an extension that
doesn't exist in this MariaDB version
|
1113 | 42000 | ER_TABLE_MUST_HAVE_COLUMNS | A table must have at least 1 column
|
1114 | HY000 | ER_RECORD_FILE_FULL | The table '%s' is full
|
1115 | 42000 | ER_UNKNOWN_CHARACTER_SET | Unknown character set: '%s'
|
1116 | HY000 | ER_TOO_MANY_TABLES | Too many tables; MariaDB can only use %d
tables in a join
|
1117 | HY000 | ER_TOO_MANY_FIELDS | Too many columns
|
1118 | 42000 | ER_TOO_BIG_ROWSIZE | Row 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
|
1119 | HY000 | ER_STACK_OVERRUN | Thread stack overrun: Used: %ld of a %ld
stack. Use 'mysqld --thread_stack=#' to specify a bigger stack if needed
|
1120 | 42000 | ER_WRONG_OUTER_JOIN | Cross dependency found in OUTER JOIN;
examine your ON conditions
|
1121 | 42000 | ER_NULL_COLUMN_IN_INDEX | Table handler doesn't support NULL in
given index. Please change column '%s' to be NOT NULL or use another
handler
|
1122 | HY000 | ER_CANT_FIND_UDF | Can't load function '%s'
|
1123 | HY000 | ER_CANT_INITIALIZE_UDF | Can't initialize function '%s'; %s
|
1124 | HY000 | ER_UDF_NO_PATHS | No paths allowed for shared library
|
1125 | HY000 | ER_UDF_EXISTS | Function '%s' already exists
|
1126 | HY000 | ER_CANT_OPEN_LIBRARY | Can't open shared library '%s' (Errno: %d
%s)
|
1127 | HY000 | ER_CANT_FIND_DL_ENTRY | Can't find symbol '%s' in library
|
1128 | HY000 | ER_FUNCTION_NOT_DEFINED | Function '%s' is not defined
|
1129 | HY000 | ER_HOST_IS_BLOCKED | Host '%s' is blocked because of many
connection errors; unblock with 'mysqladmin flush-hosts'
|
1130 | HY000 | ER_HOST_NOT_PRIVILEGED | Host '%s' is not allowed to connect to
this MariaDB server
|
1131 | 42000 | ER_PASSWORD_ANONYMOUS_USER | You are using MariaDB as an
anonymous user and anonymous users are not allowed to change passwords
|
1132 | 42000 | ER_PASSWORD_NOT_ALLOWED | You must have privileges to update
tables in the mysql database to be able to change passwords for others
|
1133 | 42000 | ER_PASSWORD_NO_MATCH | Can't find any matching row in the user
table
|
1134 | HY000 | ER_UPDATE_INF | Rows matched: %ld Changed: %ld Warnings: %ld
|
1135 | HY000 | ER_CANT_CREATE_THREAD | Can'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
|
1136 | 21S01 | ER_WRONG_VALUE_COUNT_ON_ROW | Column count doesn't match value
count at row %ld
|
1137 | HY000 | ER_CANT_REOPEN_TABLE | Can't reopen table: '%s'
|
1138 | 22004 | ER_INVALID_USE_OF_NULL | Invalid use of NULL value
|
1139 | 42000 | ER_REGEXP_ERROR | Got error '%s' from regexp
|
1140 | 42000 | ER_MIX_OF_GROUP_FUNC_AND_FIELDS | Mixing of GROUP columns
(MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no
GROUP BY clause
|
1141 | 42000 | ER_NONEXISTING_GRANT | There is no such grant defined for user
'%s' on host '%s'
|
1142 | 42000 | ER_TABLEACCESS_DENIED_ERROR | %s command denied to user '%s'@'%s'
for table '%s'
|
1143 | 42000 | ER_COLUMNACCESS_DENIED_ERROR | %s command denied to user
'%s'@'%s' for column '%s' in table '%s'
|
1144 | 42000 | ER_ILLEGAL_GRANT_FOR_TABLE | Illegal GRANT/REVOKE command; please
consult the manual to see which privileges can be used
|
1145 | 42000 | ER_GRANT_WRONG_HOST_OR_USER | The host or user argument to GRANT
is too long
|
1146 | 42S02 | ER_NO_SUCH_TABLE | Table '%s.%s' doesn't exist
|
1147 | 42000 | ER_NONEXISTING_TABLE_GRANT | There is no such grant defined for
user '%s' on host '%s' on table '%s'
|
1148 | 42000 | ER_NOT_ALLOWED_COMMAND | The used command is not allowed with
this MariaDB version
|
1149 | 42000 | ER_SYNTAX_ERROR | You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right syntax
to use
|
1150 | HY000 | ER_DELAYED_CANT_CHANGE_LOCK | Delayed insert thread couldn't get
requested lock for table %s
|
1151 | HY000 | ER_TOO_MANY_DELAYED_THREADS | Too many delayed threads in use
|
1152 | 08S01 | ER_ABORTING_CONNECTION | Aborted connection %ld to db: '%s' user:
'%s' (%s)
|
1153 | 08S01 | ER_NET_PACKET_TOO_LARGE | Got a packet bigger than
'max_allowed_packet' bytes
|
1154 | 08S01 | ER_NET_READ_ERROR_FROM_PIPE | Got a read error from the
connection pipe
|
1155 | 08S01 | ER_NET_FCNTL_ERROR | Got an error from fcntl()
|
1156 | 08S01 | ER_NET_PACKETS_OUT_OF_ORDER | Got packets out of order
|
1157 | 08S01 | ER_NET_UNCOMPRESS_ERROR | Couldn't uncompress communication
packet
|
1158 | 08S01 | ER_NET_READ_ERROR | Got an error reading communication packets
|
1159 | 08S01 | ER_NET_READ_INTERRUPTED | Got timeout reading communication
packets
|
1160 | 08S01 | ER_NET_ERROR_ON_WRITE | Got an error writing communication
packets
|
1161 | 08S01 | ER_NET_WRITE_INTERRUPTED | Got timeout writing communication
packets
|
1162 | 42000 | ER_TOO_LONG_STRING | Result string is longer than
'max_allowed_packet' bytes
|
1163 | 42000 | ER_TABLE_CANT_HANDLE_BLOB | The used table type doesn't support
BLOB/TEXT columns
|
1164 | 42000 | ER_TABLE_CANT_HANDLE_AUTO_INCREMENT | The used table type doesn't
support AUTO_INCREMENT columns
|
1165 | HY000 | ER_DELAYED_INSERT_TABLE_LOCKED | INSERT DELAYED can't be used
with table '%s' because it is locked with LOCK TABLES
|
1166 | 42000 | ER_WRONG_COLUMN_NAME | Incorrect column name '%s'
|
1167 | 42000 | ER_WRONG_KEY_COLUMN | The used storage engine can't index column
'%s'
|
1168 | HY000 | ER_WRONG_MRG_TABLE | Unable to open underlying table which is
differently defined or of non-MyISAM type or doesn't exist
|
1169 | 23000 | ER_DUP_UNIQUE | Can't write, because of unique constraint, to
table '%s'
|
1170 | 42000 | ER_BLOB_KEY_WITHOUT_LENGTH | BLOB/TEXT column '%s' used in key
specification without a key length
|
1171 | 42000 | ER_PRIMARY_CANT_HAVE_NULL | All parts of a PRIMARY KEY must be
NOT NULL; if you need NULL in a key, use UNIQUE instead
|
1172 | 42000 | ER_TOO_MANY_ROWS | Result consisted of more than one row
|
1173 | 42000 | ER_REQUIRES_PRIMARY_KEY | This table type requires a primary key
|
1174 | HY000 | ER_NO_RAID_COMPILED | This version of MariaDB is not compiled
with RAID support
|
1175 | HY000 | ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE | You are using safe update
mode and you tried to update a table without a WHERE that uses a KEY column
|
1176 | 42000 | ER_KEY_DOES_NOT_EXITS | Key '%s' doesn't exist in table '%s'
|
1177 | 42000 | ER_CHECK_NO_SUCH_TABLE | Can't open table
|
1178 | 42000 | ER_CHECK_NOT_IMPLEMENTED | The storage engine for the table
doesn't support %s
|
1179 | 25000 | ER_CANT_DO_THIS_DURING_AN_TRANSACTION | You are not allowed to
execute this command in a transaction
|
1180 | HY000 | ER_ERROR_DURING_COMMIT | Got error %d during COMMIT
|
1181 | HY000 | ER_ERROR_DURING_ROLLBACK | Got error %d during ROLLBACK
|
1182 | HY000 | ER_ERROR_DURING_FLUSH_LOGS | Got error %d during FLUSH_LOGS
|
1183 | HY000 | ER_ERROR_DURING_CHECKPOINT | Got error %d during CHECKPOINT
|
1184 | 08S01 | ER_NEW_ABORTING_CONNECTION | Aborted connection %ld to db: '%s'
user: '%s' host: '%s' (%s)
|
1185 | | ER_UNUSED_10 | You should never see it
|
1186 | HY000 | ER_FLUSH_MASTER_BINLOG_CLOSED | Binlog closed, cannot RESET
MASTER
|
1187 | HY000 | ER_INDEX_REBUILD | Failed rebuilding the index of dumped table
'%s'
|
1188 | HY000 | ER_MASTER | Error from master: '%s'
|
1189 | 08S01 | ER_MASTER_NET_READ | Net error reading from master
|
1190 | 08S01 | ER_MASTER_NET_WRITE | Net error writing to master
|
1191 | HY000 | ER_FT_MATCHING_KEY_NOT_FOUND | Can't find FULLTEXT index matching
the column list
|
1192 | HY000 | ER_LOCK_OR_ACTIVE_TRANSACTION | Can't execute the given command
because you have active locked tables or an active transaction
|
1193 | HY000 | ER_UNKNOWN_SYSTEM_VARIABLE | Unknown system variable '%s'
|
1194 | HY000 | ER_CRASHED_ON_USAGE | Table '%s' is marked as crashed and should
be repaired
|
1195 | HY000 | ER_CRASHED_ON_REPAIR | Table '%s' is marked as crashed and last
(automatic?) repair failed
|
1196 | HY000 | ER_WARNING_NOT_COMPLETE_ROLLBACK | Some non-transactional changed
tables couldn't be rolled back
|
1197 | HY000 | ER_TRANS_CACHE_FULL | Multi-statement transaction required more
than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable
and try again
|
1198 | HY000 | ER_SLAVE_MUST_STOP | This operation cannot be performed with a
running slave; run STOP SLAVE first
|
1199 | HY000 | ER_SLAVE_NOT_RUNNING | This operation requires a running slave;
configure slave and do START SLAVE
|
Error Code | SQLSTATE | Error | Description
|
1200 | HY000 | ER_BAD_SLAVE | The server is not configured as slave; fix in
config file or with CHANGE MASTER TO
|
Error Code | SQLSTATE | Error | Description
|
1201 | HY000 | ER_MASTER_INFO | Could not initialize master info structure; more
error messages can be found in the MariaDB error log
|
1202 | HY000 | ER_SLAVE_THREAD | Could not create slave thread; check system
resources
|
1203 | 42000 | ER_TOO_MANY_USER_CONNECTIONS | User %s already has more than
'max_user_connections' active connections
|
1204 | HY000 | ER_SET_CONSTANTS_ONLY | You may only use constant expressions
with SET
|
1205 | HY000 | ER_LOCK_WAIT_TIMEOUT | Lock wait timeout exceeded; try restarting
transaction
|
1206 | HY000 | ER_LOCK_TABLE_FULL | The total number of locks exceeds the lock
table size
|
1207 | 25000 | ER_READ_ONLY_TRANSACTION | Update locks cannot be acquired during
a READ UNCOMMITTED transaction
|
1208 | HY000 | ER_DROP_DB_WITH_READ_LOCK | DROP DATABASE not allowed while
thread is holding global read lock
|
1209 | HY000 | ER_CREATE_DB_WITH_READ_LOCK | CREATE DATABASE not allowed while
thread is holding global read lock
|
1210 | HY000 | ER_WRONG_ARGUMENTS | Incorrect arguments to %s
|
1211 | 42000 | ER_NO_PERMISSION_TO_CREATE_USER | '%s'@'%s' is not allowed to
create new users
|
1212 | HY000 | ER_UNION_TABLES_IN_DIFFERENT_DIR | Incorrect table definition;
all MERGE tables must be in the same database
|
1213 | 40001 | ER_LOCK_DEADLOCK | Deadlock found when trying to get lock; try
restarting transaction
|
1214 | HY000 | ER_TABLE_CANT_HANDLE_FT | The used table type doesn't support
FULLTEXT indexes
|
1215 | HY000 | ER_CANNOT_ADD_FOREIGN | Cannot add foreign key constraint
|
1216 | 23000 | ER_NO_REFERENCED_ROW | Cannot add or update a child row: a
foreign key constraint fails
|
1217 | 23000 | ER_ROW_IS_REFERENCED | Cannot delete or update a parent row: a
foreign key constraint fails
|
1218 | 08S01 | ER_CONNECT_TO_MASTER | Error connecting to master: %s
|
1219 | HY000 | ER_QUERY_ON_MASTER | Error running query on master: %s
|
1220 | HY000 | ER_ERROR_WHEN_EXECUTING_COMMAND | Error when executing command
%s: %s
|
1221 | HY000 | ER_WRONG_USAGE | Incorrect usage of %s and %s
|
1222 | 21000 | ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT | The used SELECT statements
have a different number of columns
|
1223 | HY000 | ER_CANT_UPDATE_WITH_READLOCK | Can't execute the query because
you have a conflicting read lock
|
1224 | HY000 | ER_MIXING_NOT_ALLOWED | Mixing of transactional and non
-transactional tables is disabled
|
1225 | HY000 | ER_DUP_ARGUMENT | Option '%s' used twice in statement
|
1226 | 42000 | ER_USER_LIMIT_REACHED | User '%s' has exceeded the '%s' resource
(current value: %ld)
|
1227 | 42000 | ER_SPECIFIC_ACCESS_DENIED_ERROR | Access denied; you need (at
least one of) the %s privilege(s) for this operation
|
1228 | HY000 | ER_LOCAL_VARIABLE | Variable '%s' is a SESSION variable and can't
be used with SET GLOBAL
|
1229 | HY000 | ER_GLOBAL_VARIABLE | Variable '%s' is a GLOBAL variable and
should be set with SET GLOBAL
|
1230 | 42000 | ER_NO_DEFAULT | Variable '%s' doesn't have a default value
|
1231 | 42000 | ER_WRONG_VALUE_FOR_VAR | Variable '%s' can't be set to the value
of '%s'
|
1232 | 42000 | ER_WRONG_TYPE_FOR_VAR | Incorrect argument type to variable '%s'
|
1233 | HY000 | ER_VAR_CANT_BE_READ | Variable '%s' can only be set, not read
|
1234 | 42000 | ER_CANT_USE_OPTION_HERE | Incorrect usage/placement of '%s'
|
1235 | 42000 | ER_NOT_SUPPORTED_YET | This version of MariaDB doesn't yet
support '%s'
|
1236 | HY000 | ER_MASTER_FATAL_ERROR_READING_BINLOG | Got fatal error %d from
master when reading data from binary log: '%s'
|
1237 | HY000 | ER_SLAVE_IGNORED_TABLE | Slave SQL thread ignored the query
because of replicate-*-table rules
|
1238 | HY000 | ER_INCORRECT_GLOBAL_LOCAL_VAR | Variable '%s' is a %s variable
|
1239 | 42000 | ER_WRONG_FK_DEF | Incorrect foreign key definition for '%s': %s
|
1240 | HY000 | ER_KEY_REF_DO_NOT_MATCH_TABLE_REF | Key reference and table
reference don't match
|
1241 | 21000 | ER_OPERAND_COLUMNS | Operand should contain %d column(s)
|
1242 | 21000 | ER_SUBQUERY_NO_1_ROW | Subquery returns more than 1 row
|
1243 | HY000 | ER_UNKNOWN_STMT_HANDLER | Unknown prepared statement handler
(%.*s) given to %s
|
1244 | HY000 | ER_CORRUPT_HELP_DB | Help database is corrupt or does not exist
|
1245 | HY000 | ER_CYCLIC_REFERENCE | Cyclic reference on subqueries
|
1246 | HY000 | ER_AUTO_CONVERT | Converting column '%s' from %s to %s
|
1247 | 42S22 | ER_ILLEGAL_REFERENCE | Reference '%s' not supported (%s)
|
1248 | 42000 | ER_DERIVED_MUST_HAVE_ALIAS | Every derived table must have its
own alias
|
1249 | 01000 | ER_SELECT_REDUCED | Select %u was reduced during optimization
|
1250 | 42000 | ER_TABLENAME_NOT_ALLOWED_HERE | Table '%s' from one of the
SELECTs cannot be used in %s
|
1251 | 08004 | ER_NOT_SUPPORTED_AUTH_MODE | Client does not support
authentication protocol requested by server; consider upgrading MariaDB
client
|
1252 | 42000 | ER_SPATIAL_CANT_HAVE_NULL | All parts of a SPATIAL index must be
NOT NULL
|
1253 | 42000 | ER_COLLATION_CHARSET_MISMATCH | COLLATION '%s' is not valid for
CHARACTER SET '%s'
|
1254 | HY000 | ER_SLAVE_WAS_RUNNING | Slave is already running
|
1255 | HY000 | ER_SLAVE_WAS_NOT_RUNNING | Slave already has been stopped
|
1256 | HY000 | ER_TOO_BIG_FOR_UNCOMPRESS | Uncompressed data size too large; the
maximum size is %d (probably, length of uncompressed data was corrupted)
|
1257 | HY000 | ER_ZLIB_Z_MEM_ERROR | ZLIB: Not enough memory
|
1258 | HY000 | ER_ZLIB_Z_BUF_ERROR | ZLIB: Not enough room in the output buffer
(probably, length of uncompressed data was corrupted)
|
1259 | HY000 | ER_ZLIB_Z_DATA_ERROR | ZLIB: Input data corrupted
|
1260 | HY000 | ER_CUT_VALUE_GROUP_CONCAT | Row %u was cut by GROUP_CONCAT()
|
1261 | 01000 | ER_WARN_TOO_FEW_RECORDS | Row %ld doesn't contain data for all
columns
|
1262 | 01000 | ER_WARN_TOO_MANY_RECORDS | Row %ld was truncated; it contained
more data than there were input columns
|
1263 | 22004 | ER_WARN_NULL_TO_NOTNULL | Column set to default value; NULL
supplied to NOT NULL column '%s' at row %ld
|
1264 | 22003 | ER_WARN_DATA_OUT_OF_RANGE | Out of range value for column '%s' at
row %ld
|
1265 | 01000 | WARN_DATA_TRUNCATED | Data truncated for column '%s' at row %ld
|
1266 | HY000 | ER_WARN_USING_OTHER_HANDLER | Using storage engine %s for table
'%s'
|
1267 | HY000 | ER_CANT_AGGREGATE_2COLLATIONS | Illegal mix of collations (%s,%s)
and (%s,%s) for operation '%s'
|
1268 | HY000 | ER_DROP_USER | Cannot drop one or more of the requested users
|
1269 | HY000 | ER_REVOKE_GRANTS | Can't revoke all privileges for one or more of
the requested users
|
1270 | HY000 | ER_CANT_AGGREGATE_3COLLATIONS | Illegal mix of collations
(%s,%s), (%s,%s), (%s,%s) for operation '%s'
|
1271 | HY000 | ER_CANT_AGGREGATE_NCOLLATIONS | Illegal mix of collations for
operation '%s'
|
1272 | HY000 | ER_VARIABLE_IS_NOT_STRUCT | Variable '%s' is not a variable
component (can't be used as XXXX.variable_name)
|
1273 | HY000 | ER_UNKNOWN_COLLATION | Unknown collation: '%s'
|
1274 | HY000 | ER_SLAVE_IGNORED_SSL_PARAMS | SSL 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
|
1275 | HY000 | ER_SERVER_IS_IN_SECURE_AUTH_MODE | Server is running in --secure
-auth mode, but '%s'@'%s' has a password in the old format; please change
the password to the new format
|
1276 | HY000 | ER_WARN_FIELD_RESOLVED | Field or reference '%s%s%s%s%s' of
SELECT #%d was resolved in SELECT #%d
|
1277 | HY000 | ER_BAD_SLAVE_UNTIL_COND | Incorrect parameter or combination of
parameters for START SLAVE UNTIL
|
1278 | HY000 | ER_MISSING_SKIP_SLAVE | It 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
|
1279 | HY000 | ER_UNTIL_COND_IGNORED | SQL thread is not to be started so UNTIL
options are ignored
|
1280 | 42000 | ER_WRONG_NAME_FOR_INDEX | Incorrect index name '%s'
|
1281 | 42000 | ER_WRONG_NAME_FOR_CATALOG | Incorrect catalog name '%s'
|
1282 | HY000 | ER_WARN_QC_RESIZE | Query cache failed to set size %lu; new query
cache size is %lu
|
1283 | HY000 | ER_BAD_FT_COLUMN | Column '%s' cannot be part of FULLTEXT index
|
1284 | HY000 | ER_UNKNOWN_KEY_CACHE | Unknown key cache '%s'
|
1285 | HY000 | ER_WARN_HOSTNAME_WONT_WORK | MariaDB is started in --skip-name
-resolve mode; you must restart it without this switch for this grant to
work
|
1286 | 42000 | ER_UNKNOWN_STORAGE_ENGINE | Unknown storage engine '%s'
|
1287 | HY000 | ER_WARN_DEPRECATED_SYNTAX | '%s' is deprecated and will be
removed in a future release. Please use %s instead
|
1288 | HY000 | ER_NON_UPDATABLE_TABLE | The target table %s of the %s is not
updatable
|
1289 | HY000 | ER_FEATURE_DISABLED | The '%s' feature is disabled; you need
MariaDB built with '%s' to have it working
|
1290 | HY000 | ER_OPTION_PREVENTS_STATEMENT | The MariaDB server is running with
the %s option so it cannot execute this statement
|
1291 | HY000 | ER_DUPLICATED_VALUE_IN_TYPE | Column '%s' has duplicated value
'%s' in %s
|
1292 | 22007 | ER_TRUNCATED_WRONG_VALUE | Truncated incorrect %s value: '%s'
|
1293 | HY000 | ER_TOO_MUCH_AUTO_TIMESTAMP_COLS | Incorrect table definition;
there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or
ON UPDATE clause
|
1294 | HY000 | ER_INVALID_ON_UPDATE | Invalid ON UPDATE clause for '%s' column
|
1295 | HY000 | ER_UNSUPPORTED_PS | This command is not supported in the prepared
statement protocol yet
|
1296 | HY000 | ER_GET_ERRMSG | Got error %d '%s' from %s
|
1297 | HY000 | ER_GET_TEMPORARY_ERRMSG | Got temporary error %d '%s' from %s
|
1298 | HY000 | ER_UNKNOWN_TIME_ZONE | Unknown or incorrect time zone: '%s'
|
1299 | HY000 | ER_WARN_INVALID_TIMESTAMP | Invalid TIMESTAMP value in column
'%s' at row %ld
|
Error Code | SQLSTATE | Error | Description
|
1300 | HY000 | ER_INVALID_CHARACTER_STRING | Invalid %s character string: '%s'
|
1301 | HY000 | ER_WARN_ALLOWED_PACKET_OVERFLOWED | Result of %s() was larger
than max_allowed_packet (%ld) - truncated
|
1302 | HY000 | ER_CONFLICTING_DECLARATIONS | Conflicting declarations: '%s%s'
and '%s%s'
|
1303 | 2F003 | ER_SP_NO_RECURSIVE_CREATE | Can't create a %s from within another
stored routine
|
1304 | 42000 | ER_SP_ALREADY_EXISTS | %s %s already exists
|
1305 | 42000 | ER_SP_DOES_NOT_EXIST | %s %s does not exist
|
1306 | HY000 | ER_SP_DROP_FAILED | Failed to DROP %s %s
|
1307 | HY000 | ER_SP_STORE_FAILED | Failed to CREATE %s %s
|
1308 | 42000 | ER_SP_LILABEL_MISMATCH | %s with no matching label: %s
|
1309 | 42000 | ER_SP_LABEL_REDEFINE | Redefining label %s
|
1310 | 42000 | ER_SP_LABEL_MISMATCH | End-label %s without match
|
1311 | 01000 | ER_SP_UNINIT_VAR | Referring to uninitialized variable %s
|
1312 | 0A000 | ER_SP_BADSELECT | PROCEDURE %s can't return a result set in the
given context
|
1313 | 42000 | ER_SP_BADRETURN | RETURN is only allowed in a FUNCTION
|
1314 | 0A000 | ER_SP_BADSTATEMENT | %s is not allowed in stored procedures
|
1315 | 42000 | ER_UPDATE_LOG_DEPRECATED_IGNORED | The 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.
|
1316 | 42000 | ER_UPDATE_LOG_DEPRECATED_TRANSLATED | The 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.
|
1317 | 70100 | ER_QUERY_INTERRUPTED | Query execution was interrupted
|
1318 | 42000 | ER_SP_WRONG_NO_OF_ARGS | Incorrect number of arguments for %s %s;
expected %u, got %u
|
1319 | 42000 | ER_SP_COND_MISMATCH | Undefined CONDITION: %s
|
1320 | 42000 | ER_SP_NORETURN | No RETURN found in FUNCTION %s
|
1321 | 2F005 | ER_SP_NORETURNEND | FUNCTION %s ended without RETURN
|
1322 | 42000 | ER_SP_BAD_CURSOR_QUERY | Cursor statement must be a SELECT
|
1323 | 42000 | ER_SP_BAD_CURSOR_SELECT | Cursor SELECT must not have INTO
|
1324 | 42000 | ER_SP_CURSOR_MISMATCH | Undefined CURSOR: %s
|
1325 | 24000 | ER_SP_CURSOR_ALREADY_OPEN | Cursor is already open
|
1326 | 24000 | ER_SP_CURSOR_NOT_OPEN | Cursor is not open
|
1327 | 42000 | ER_SP_UNDECLARED_VAR | Undeclared variable: %s
|
1328 | HY000 | ER_SP_WRONG_NO_OF_FETCH_ARGS | Incorrect number of FETCH
variables
|
1329 | 02000 | ER_SP_FETCH_NO_DATA | No data - zero rows fetched, selected, or
processed
|
1330 | 42000 | ER_SP_DUP_PARAM | Duplicate parameter: %s
|
1331 | 42000 | ER_SP_DUP_VAR | Duplicate variable: %s
|
1332 | 42000 | ER_SP_DUP_COND | Duplicate condition: %s
|
1333 | 42000 | ER_SP_DUP_CURS | Duplicate cursor: %s
|
1334 | HY000 | ER_SP_CANT_ALTER | Failed to ALTER %s %s
|
1335 | 0A000 | ER_SP_SUBSELECT_NYI | Subquery value not supported
|
1336 | 0A000 | ER_STMT_NOT_ALLOWED_IN_SF_OR_TRG | %s is not allowed in stored
function or trigger
|
1337 | 42000 | ER_SP_VARCOND_AFTER_CURSHNDLR | Variable or condition declaration
after cursor or handler declaration
|
1338 | 42000 | ER_SP_CURSOR_AFTER_HANDLER | Cursor declaration after handler
declaration
|
1339 | 20000 | ER_SP_CASE_NOT_FOUND | Case not found for CASE statement
|
1340 | HY000 | ER_FPARSER_TOO_BIG_FILE | Configuration file '%s' is too big
|
1341 | HY000 | ER_FPARSER_BAD_HEADER | Malformed file type header in file '%s'
|
1342 | HY000 | ER_FPARSER_EOF_IN_COMMENT | Unexpected end of file while parsing
comment '%s'
|
1343 | HY000 | ER_FPARSER_ERROR_IN_PARAMETER | Error while parsing parameter
'%s' (line: '%s')
|
1344 | HY000 | ER_FPARSER_EOF_IN_UNKNOWN_PARAMETER | Unexpected end of file
while skipping unknown parameter '%s'
|
1345 | HY000 | ER_VIEW_NO_EXPLAIN | EXPLAIN/SHOW can not be issued; lacking
privileges for underlying table
|
1346 | HY000 | ER_FRM_UNKNOWN_TYPE | File '%s' has unknown type '%s' in its
header
|
1347 | HY000 | ER_WRONG_OBJECT | '%s.%s' is not %s
|
1348 | HY000 | ER_NONUPDATEABLE_COLUMN | Column '%s' is not updatable
|
1349 | HY000 | ER_VIEW_SELECT_DERIVED | View's SELECT contains a subquery in the
FROM clause
|
1350 | HY000 | ER_VIEW_SELECT_CLAUSE | View's SELECT contains a '%s' clause
|
1351 | HY000 | ER_VIEW_SELECT_VARIABLE | View's SELECT contains a variable or
parameter
|
1352 | HY000 | ER_VIEW_SELECT_TMPTABLE | View's SELECT refers to a temporary
table '%s'
|
1353 | HY000 | ER_VIEW_WRONG_LIST | View's SELECT and view's field list have
different column counts
|
1354 | HY000 | ER_WARN_VIEW_MERGE | View merge algorithm can't be used here for
now (assumed undefined algorithm)
|
1355 | HY000 | ER_WARN_VIEW_WITHOUT_KEY | View being updated does not have
complete key of underlying table in it
|
1356 | HY000 | ER_VIEW_INVALID | View '%s.%s' references invalid table(s) or
column(s) or function(s) or definer/invoker of view lack rights to use them
|
1357 | HY000 | ER_SP_NO_DROP_SP | Can't drop or alter a %s from within another
stored routine
|
1358 | HY000 | ER_SP_GOTO_IN_HNDLR | GOTO is not allowed in a stored procedure
handler
|
1359 | HY000 | ER_TRG_ALREADY_EXISTS | Trigger already exists
|
1360 | HY000 | ER_TRG_DOES_NOT_EXIST | Trigger does not exist
|
1361 | HY000 | ER_TRG_ON_VIEW_OR_TEMP_TABLE | Trigger's '%s' is view or
temporary table
|
1362 | HY000 | ER_TRG_CANT_CHANGE_ROW | Updating of %s row is not allowed in
%strigger
|
1363 | HY000 | ER_TRG_NO_SUCH_ROW_IN_TRG | There is no %s row in %s trigger
|
1364 | HY000 | ER_NO_DEFAULT_FOR_FIELD | Field '%s' doesn't have a default
value
|
1365 | 22012 | ER_DIVISION_BY_ZER | Division by 0
|
1366 | HY000 | ER_TRUNCATED_WRONG_VALUE_FOR_FIELD | Incorrect %s value: '%s' for
column '%s' at row %ld
|
1367 | 22007 | ER_ILLEGAL_VALUE_FOR_TYPE | Illegal %s '%s' value found during
parsing
|
1368 | HY000 | ER_VIEW_NONUPD_CHECK | CHECK OPTION on non-updatable view
'%s.%s'
|
1369 | HY000 | ER_VIEW_CHECK_FAILED | CHECK OPTION failed '%s.%s'
|
1370 | 42000 | ER_PROCACCESS_DENIED_ERROR | %s command denied to user '%s'@'%s'
for routine '%s'
|
1371 | HY000 | ER_RELAY_LOG_FAIL | Failed purging old relay logs: %s
|
1372 | HY000 | ER_PASSWD_LENGTH | Password hash should be a %d-digit hexadecimal
number
|
1373 | HY000 | ER_UNKNOWN_TARGET_BINLOG | Target log not found in binlog index
|
1374 | HY000 | ER_IO_ERR_LOG_INDEX_READ | I/O error reading log index file
|
1375 | HY000 | ER_BINLOG_PURGE_PROHIBITED | Server configuration does not permit
binlog purge
|
1376 | HY000 | ER_FSEEK_FAIL | Failed on fseek()
|
1377 | HY000 | ER_BINLOG_PURGE_FATAL_ERR | Fatal error during log purge
|
1378 | HY000 | ER_LOG_IN_USE | A purgeable log is in use, will not purge
|
1379 | HY000 | ER_LOG_PURGE_UNKNOWN_ERR | Unknown error during log purge
|
1380 | HY000 | ER_RELAY_LOG_INIT | Failed initializing relay log position: %s
|
1381 | HY000 | ER_NO_BINARY_LOGGING | You are not using binary logging
|
1382 | HY000 | ER_RESERVED_SYNTAX | The '%s' syntax is reserved for purposes
internal to the MariaDB server
|
1383 | HY000 | ER_WSAS_FAILED | WSAStartup Failed
|
1384 | HY000 | ER_DIFF_GROUPS_PROC | Can't handle procedures with different
groups yet
|
1385 | HY000 | ER_NO_GROUP_FOR_PROC | Select must have a group with this
procedure
|
1386 | HY000 | ER_ORDER_WITH_PROC | Can't use ORDER clause with this procedure
|
1387 | HY000 | ER_LOGGING_PROHIBIT_CHANGING_OF | Binary logging and replication
forbid changing the global server %s
|
1388 | HY000 | ER_NO_FILE_MAPPING | Can't map file: %s, errno: %d
|
1389 | HY000 | ER_WRONG_MAGIC | Wrong magic in %s
|
1390 | HY000 | ER_PS_MANY_PARAM | Prepared statement contains too many
placeholders
|
1391 | HY000 | ER_KEY_PART_0 | Key part '%s' length cannot be 0
|
1392 | HY000 | ER_VIEW_CHECKSUM | View text checksum failed
|
1393 | HY000 | ER_VIEW_MULTIUPDATE | Can not modify more than one base table
through a join view '%s.%s'
|
1394 | HY000 | ER_VIEW_NO_INSERT_FIELD_LIST | Can not insert into join view
'%s.%s' without fields list
|
1395 | HY000 | ER_VIEW_DELETE_MERGE_VIEW | Can not delete from join view
'%s.%s'
|
1396 | HY000 | ER_CANNOT_USER | Operation %s failed for %s
|
1397 | XAE04 | ER_XAER_NOTA | XAER_NOTA: Unknown XID
|
1398 | XAE05 | ER_XAER_INVAL | XAER_INVAL: Invalid arguments (or unsupported
command)
|
1399 | XAE07 | ER_XAER_RMFAIL | XAER_RMFAIL: The command cannot be executed when
global transaction is in the %s state
|
Error Code | SQLSTATE | Error | Description
|
1400 | XAE09 | ER_XAER_OUTSIDE | XAER_OUTSIDE: Some work is done outside global
transaction
|
1401 | XAE03 | ER_XAER_RMERR | XAER_RMERR: Fatal error occurred in the
transaction branch - check your data for consistency
|
1402 | XA100 | ER_XA_RBROLLBACK | XA_RBROLLBACK: Transaction branch was rolled
back
|
1403 | 42000 | ER_NONEXISTING_PROC_GRANT | There is no such grant defined for
user '%s' on host '%s' on routine '%s'
|
1404 | HY000 | ER_PROC_AUTO_GRANT_FAIL | Failed to grant EXECUTE and ALTER
ROUTINE privileges
|
1405 | HY000 | ER_PROC_AUTO_REVOKE_FAIL | Failed to revoke all privileges to
dropped routine
|
1406 | 22001 | ER_DATA_TOO_LONG | Data too long for column '%s' at row %ld
|
1407 | 42000 | ER_SP_BAD_SQLSTATE | Bad SQLSTATE: '%s'
|
1408 | HY000 | ER_STARTUP | %s: ready for connections. Version: '%s' socket:
'%s' port: %d %s
|
1409 | HY000 | ER_LOAD_FROM_FIXED_SIZE_ROWS_TO_VAR | Can't load value from file
with fixed size rows to variable
|
1410 | 42000 | ER_CANT_CREATE_USER_WITH_GRANT | You are not allowed to create a
user with GRANT
|
1411 | HY000 | ER_WRONG_VALUE_FOR_TYPE | Incorrect %s value: '%s' for function
%s
|
1412 | HY000 | ER_TABLE_DEF_CHANGED | Table definition has changed, please retry
transaction
|
1413 | 42000 | ER_SP_DUP_HANDLER | Duplicate handler declared in the same block
|
1414 | 42000 | ER_SP_NOT_VAR_ARG | OUT or INOUT argument %d for routine %s is
not a variable or NEW pseudo-variable in BEFORE trigger
|
1415 | 0A000 | ER_SP_NO_RETSET | Not allowed to return a result set from a %s
|
1416 | 22003 | ER_CANT_CREATE_GEOMETRY_OBJECT | Cannot get geometry object from
data you send to the GEOMETRY field
|
1417 | HY000 | ER_FAILED_ROUTINE_BREAK_BINLOG | A 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
|
1418 | HY000 | ER_BINLOG_UNSAFE_ROUTINE | This 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)
|
1419 | HY000 | ER_BINLOG_CREATE_ROUTINE_NEED_SUPER | You 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)
|
1420 | HY000 | ER_EXEC_STMT_WITH_OPEN_CURSOR | You can't execute a prepared
statement which has an open cursor associated with it. Reset the statement
to re-execute it.
|
1421 | HY000 | ER_STMT_HAS_NO_OPEN_CURSOR | The statement (%lu) has no open
cursor.
|
1422 | HY000 | ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG | Explicit or implicit commit
is not allowed in stored function or trigger.
|
1423 | HY000 | ER_NO_DEFAULT_FOR_VIEW_FIELD | Field of view '%s.%s' underlying
table doesn't have a default value
|
1424 | HY000 | ER_SP_NO_RECURSION | Recursive stored functions and triggers are
not allowed.
|
1425 | 42000 | ER_TOO_BIG_SCALE | Too big scale %d specified for column '%s'.
Maximum is %lu.
|
1426 | 42000 | ER_TOO_BIG_PRECISION | Too big precision %d specified for column
'%s'. Maximum is %lu.
|
1427 | 42000 | ER_M_BIGGER_THAN_D | For float(M,D, double(M,D or decimal(M,D, M
must be >= D (column '%s').
|
1428 | HY000 | ER_WRONG_LOCK_OF_SYSTEM_TABLE | You can't combine write-locking
of system tables with other tables or lock types
|
1429 | HY000 | ER_CONNECT_TO_FOREIGN_DATA_SOURCE | Unable to connect to foreign
data source: %s
|
1430 | HY000 | ER_QUERY_ON_FOREIGN_DATA_SOURCE | There was a problem processing
the query on the foreign data source. Data source error: %s
|
1431 | HY000 | ER_FOREIGN_DATA_SOURCE_DOESNT_EXIST | The foreign data source you
are trying to reference does not exist. Data source error: %s
|
1432 | HY000 | ER_FOREIGN_DATA_STRING_INVALID_CANT_CREATE | Can't create
federated table. The data source connection string '%s' is not in the
correct format
|
1433 | HY000 | ER_FOREIGN_DATA_STRING_INVALID | The data source connection
string '%s' is not in the correct format
|
1434 | HY000 | ER_CANT_CREATE_FEDERATED_TABLE | Can't create federated table.
Foreign data src error: %s
|
1435 | HY000 | ER_TRG_IN_WRONG_SCHEMA | Trigger in wrong schema
|
1436 | HY000 | ER_STACK_OVERRUN_NEED_MORE | Thread stack overrun: %ld bytes used
of a %ld byte stack, and %ld bytes needed. Use 'mysqld --thread_stack=#' to
specify a bigger stack.
|
1437 | 42000 | ER_TOO_LONG_BODY | Routine body for '%s' is too long
|
1438 | HY000 | ER_WARN_CANT_DROP_DEFAULT_KEYCACHE | Cannot drop default
keycache
|
1439 | 42000 | ER_TOO_BIG_DISPLAYWIDTH | Display width out of range for column
'%s' (max = %lu)
|
1440 | XAE08 | ER_XAER_DUPID | XAER_DUPID: The XID already exists
|
1441 | 22008 | ER_DATETIME_FUNCTION_OVERFLOW | Datetime function: %s field
overflow
|
1442 | HY000 | ER_CANT_UPDATE_USED_TABLE_IN_SF_OR_TRG | Can't update table '%s'
in stored function/trigger because it is already used by statement which
invoked this stored function/trigger.
|
1443 | HY000 | ER_VIEW_PREVENT_UPDATE | The definition of table '%s' prevents
operation %s on table '%s'.
|
1444 | HY000 | ER_PS_NO_RECURSION | The 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
|
1445 | HY000 | ER_SP_CANT_SET_AUTOCOMMIT | Not allowed to set autocommit from a
stored function or trigger
|
1446 | HY000 | ER_MALFORMED_DEFINER | Definer is not fully qualified
|
1447 | HY000 | ER_VIEW_FRM_NO_USER | View '%s'.'%s' has no definer information
(old table format). Current user is used as definer. Please recreate the
view!
|
1448 | HY000 | ER_VIEW_OTHER_USER | You need the SUPER privilege for creation
view with '%s'@'%s' definer
|
1449 | HY000 | ER_NO_SUCH_USER | The user specified as a definer ('%s'@'%s')
does not exist
|
1450 | HY000 | ER_FORBID_SCHEMA_CHANGE | Changing schema from '%s' to '%s' is
not allowed.
|
1451 | 23000 | ER_ROW_IS_REFERENCED_2 | Cannot delete or update a parent row: a
foreign key constraint fails (%s)
|
1452 | 23000 | ER_NO_REFERENCED_ROW_2 | Cannot add or update a child row: a
foreign key constraint fails (%s)
|
1453 | 42000 | ER_SP_BAD_VAR_SHADOW | Variable '%s' must be quoted with `...`,
or renamed
|
1454 | HY000 | ER_TRG_NO_DEFINER | No 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.
|
1455 | HY000 | ER_OLD_FILE_FORMAT | '%s' has an old format, you should re-create
the '%s' object(s)
|
1456 | HY000 | ER_SP_RECURSION_LIMIT | Recursive limit %d (as set by the
max_sp_recursion_depth variable) was exceeded for routine %s
|
1457 | HY000 | ER_SP_PROC_TABLE_CORRUPT | Failed to load routine %s. The table
mysql.proc is missing, corrupt, or contains bad data (internal code %d)
|
1458 | 42000 | ER_SP_WRONG_NAME | Incorrect routine name '%s'
|
1459 | HY000 | ER_TABLE_NEEDS_UPGRADE | Table upgrade required. Please do "REPAIR TABLE `%s`" or
dump/reload to fix it!
|
1460 | 42000 | ER_SP_NO_AGGREGATE | AGGREGATE is not supported for stored
functions
|
1461 | 42000 | ER_MAX_PREPARED_STMT_COUNT_REACHED | Can't create more than
max_prepared_stmt_count statements (current value: %lu)
|
1462 | HY000 | ER_VIEW_RECURSIVE | `%s`.`%s` contains view recursion
|
1463 | 42000 | ER_NON_GROUPING_FIELD_USED | Non-grouping field '%s' is used in
%s clause
|
1464 | HY000 | ER_TABLE_CANT_HANDLE_SPKEYS | The used table type doesn't support
SPATIAL indexes
|
1465 | HY000 | ER_NO_TRIGGERS_ON_SYSTEM_SCHEMA | Triggers can not be created on
system tables
|
1466 | HY000 | ER_REMOVED_SPACES | Leading spaces are removed from name '%s'
|
1467 | HY000 | ER_AUTOINC_READ_FAILED | Failed to read auto-increment value from
storage engine
|
1468 | HY000 | ER_USERNAME | user name
|
1469 | HY000 | ER_HOSTNAME | host name
|
1470 | HY000 | ER_WRONG_STRING_LENGTH | String '%s' is too long for %s (should
be no longer than %d)
|
1471 | HY000 | ER_NON_INSERTABLE_TABLE | The target table %s of the %s is not
insertable-into
|
1472 | HY000 | ER_ADMIN_WRONG_MRG_TABLE | Table '%s' is differently defined or
of non-MyISAM type or doesn't exist
|
1473 | HY000 | ER_TOO_HIGH_LEVEL_OF_NESTING_FOR_SELECT | Too high level of
nesting for select
|
1474 | HY000 | ER_NAME_BECOMES_EMPTY | Name '%s' has become ''
|
1475 | HY000 | ER_AMBIGUOUS_FIELD_TERM | First character of the FIELDS
TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS
ENCLOSED BY
|
1476 | HY000 | ER_FOREIGN_SERVER_EXISTS | The foreign server, %s, you are trying
to create already exists.
|
1477 | HY000 | ER_FOREIGN_SERVER_DOESNT_EXIST | The foreign server name you are
trying to reference does not exist. Data source error: %s
|
1478 | HY000 | ER_ILLEGAL_HA_CREATE_OPTION | Table storage engine '%s' does not
support the create option '%s'
|
1479 | HY000 | ER_PARTITION_REQUIRES_VALUES_ERROR | Syntax error: %s
PARTITIONING requires definition of VALUES %s for each partition
|
1480 | HY000 | ER_PARTITION_WRONG_VALUES_ERROR | Only %s PARTITIONING can use
VALUES %s in partition definition
|
1481 | HY000 | ER_PARTITION_MAXVALUE_ERROR | MAXVALUE can only be used in last
partition definition
|
1482 | HY000 | ER_PARTITION_SUBPARTITION_ERROR | Subpartitions can only be hash
partitions and by key
|
1483 | HY000 | ER_PARTITION_SUBPART_MIX_ERROR | Must define subpartitions on all
partitions if on one partition
|
1484 | HY000 | ER_PARTITION_WRONG_NO_PART_ERROR | Wrong number of partitions
defined, mismatch with previous setting
|
1485 | HY000 | ER_PARTITION_WRONG_NO_SUBPART_ERROR | Wrong number of
subpartitions defined, mismatch with previous setting
|
1486 | HY000 | ER_CONST_EXPR_IN_PARTITION_FUNC_ERROR | Constant/Random
expression in (sub)partitioning function is not allowed
|
1486 | HY000 | ER_WRONG_EXPR_IN_PARTITION_FUNC_ERROR | Constant, random or
timezone-dependent expressions in (sub)partitioning function are not
allowed
|
1487 | HY000 | ER_NO_CONST_EXPR_IN_RANGE_OR_LIST_ERROR | Expression in
RANGE/LIST VALUES must be constant
|
1488 | HY000 | ER_FIELD_NOT_FOUND_PART_ERROR | Field in list of fields for
partition function not found in table
|
1489 | HY000 | ER_LIST_OF_FIELDS_ONLY_IN_HASH_ERROR | List of fields is only
allowed in KEY partitions
|
1490 | HY000 | ER_INCONSISTENT_PARTITION_INFO_ERROR | The partition info in the
frm file is not consistent with what can be written into the frm file
|
1491 | HY000 | ER_PARTITION_FUNC_NOT_ALLOWED_ERROR | The %s function returns the
wrong type
|
1492 | HY000 | ER_PARTITIONS_MUST_BE_DEFINED_ERROR | For %s partitions each
partition must be defined
|
1493 | HY000 | ER_RANGE_NOT_INCREASING_ERROR | VALUES LESS THAN value must be
strictly increasing for each partition
|
1494 | HY000 | ER_INCONSISTENT_TYPE_OF_FUNCTIONS_ERROR | VALUES value must be of
same type as partition function
|
1495 | HY000 | ER_MULTIPLE_DEF_CONST_IN_LIST_PART_ERROR | Multiple definition of
same constant in list partitioning
|
1496 | HY000 | ER_PARTITION_ENTRY_ERROR | Partitioning can not be used stand
-alone in query
|
1497 | HY000 | ER_MIX_HANDLER_ERROR | The mix of handlers in the partitions is
not allowed in this version of MariaDB
|
1498 | HY000 | ER_PARTITION_NOT_DEFINED_ERROR | For the partitioned engine it is
necessary to define all %s
|
1499 | HY000 | ER_TOO_MANY_PARTITIONS_ERROR | Too many partitions (including
subpartitions) were defined
|
Error Code | SQLSTATE | Error | Description
|
1500 | HY000 | ER_SUBPARTITION_ERROR | It is only possible to mix RANGE/LIST
partitioning with HASH/KEY partitioning for subpartitioning
|
1501 | HY000 | ER_CANT_CREATE_HANDLER_FILE | Failed to create specific handler
file
|
1502 | HY000 | ER_BLOB_FIELD_IN_PART_FUNC_ERROR | A BLOB field is not allowed in
partition function
|
1503 | HY000 | ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF | A %s must include all
columns in the table's partitioning function
|
1504 | HY000 | ER_NO_PARTS_ERROR | Number of %s = 0 is not an allowed value
|
1505 | HY000 | ER_PARTITION_MGMT_ON_NONPARTITIONED | Partition management on a
not partitioned table is not possible
|
1506 | HY000 | ER_FOREIGN_KEY_ON_PARTITIONED | Foreign key clause is not yet
supported in conjunction with partitioning
|
1507 | HY000 | ER_DROP_PARTITION_NON_EXISTENT | Error in list of partitions to
%s
|
1508 | HY000 | ER_DROP_LAST_PARTITION | Cannot remove all partitions, use DROP
TABLE instead
|
1509 | HY000 | ER_COALESCE_ONLY_ON_HASH_PARTITION | COALESCE PARTITION can only
be used on HASH/KEY partitions
|
1510 | HY000 | ER_REORG_HASH_ONLY_ON_SAME_N | REORGANIZE PARTITION can only be
used to reorganize partitions not to change their numbers
|
1511 | HY000 | ER_REORG_NO_PARAM_ERROR | REORGANIZE PARTITION without parameters
can only be used on auto-partitioned tables using HASH PARTITIONs
|
1512 | HY000 | ER_ONLY_ON_RANGE_LIST_PARTITION | %s PARTITION can only be used
on RANGE/LIST partitions
|
1513 | HY000 | ER_ADD_PARTITION_SUBPART_ERROR | Trying to Add partition(s) with
wrong number of subpartitions
|
1514 | HY000 | ER_ADD_PARTITION_NO_NEW_PARTITION | At least one partition must
be added
|
1515 | HY000 | ER_COALESCE_PARTITION_NO_PARTITION | At least one partition must
be coalesced
|
1516 | HY000 | ER_REORG_PARTITION_NOT_EXIST | More partitions to reorganize than
there are partitions
|
1517 | HY000 | ER_SAME_NAME_PARTITION | Duplicate partition name %s
|
1518 | HY000 | ER_NO_BINLOG_ERROR | It is not allowed to shut off binlog on this
command
|
1519 | HY000 | ER_CONSECUTIVE_REORG_PARTITIONS | When reorganizing a set of
partitions they must be in consecutive order
|
1520 | HY000 | ER_REORG_OUTSIDE_RANGE | Reorganize of range partitions cannot
change total ranges except for last partition where it can extend the range
|
1521 | HY000 | ER_PARTITION_FUNCTION_FAILURE | Partition function not supported
in this version for this handler
|
1522 | HY000 | ER_PART_STATE_ERROR | Partition state cannot be defined from
CREATE/ALTER TABLE
|
1523 | HY000 | ER_LIMITED_PART_RANGE | The %s handler only supports 32 bit
integers in VALUES
|
1524 | HY000 | ER_PLUGIN_IS_NOT_LOADED | Plugin '%s' is not loaded
|
1525 | HY000 | ER_WRONG_VALUE | Incorrect %s value: '%s'
|
1526 | HY000 | ER_NO_PARTITION_FOR_GIVEN_VALUE | Table has no partition for
value %s
|
1527 | HY000 | ER_FILEGROUP_OPTION_ONLY_ONCE | It is not allowed to specify %s
more than once
|
1528 | HY000 | ER_CREATE_FILEGROUP_FAILED | Failed to create %s
|
1529 | HY000 | ER_DROP_FILEGROUP_FAILED | Failed to drop %s
|
1530 | HY000 | ER_TABLESPACE_AUTO_EXTEND_ERROR | The handler doesn't support
autoextend of tablespaces
|
1531 | HY000 | ER_WRONG_SIZE_NUMBER | A size parameter was incorrectly
specified, either number or on the form 10M
|
1532 | HY000 | ER_SIZE_OVERFLOW_ERROR | The size number was correct but we don't
allow the digit part to be more than 2 billion
|
1533 | HY000 | ER_ALTER_FILEGROUP_FAILED | Failed to alter: %s
|
1534 | HY000 | ER_BINLOG_ROW_LOGGING_FAILED | Writing one row to the row-based
binary log failed
|
1535 | HY000 | ER_BINLOG_ROW_WRONG_TABLE_DEF | Table definition on master and
slave does not match: %s
|
1536 | HY000 | ER_BINLOG_ROW_RBR_TO_SBR | Slave running with --log-slave-updates
must use row-based binary logging to be able to replicate row-based binary
log events
|
1537 | HY000 | ER_EVENT_ALREADY_EXISTS | Event '%s' already exists
|
1538 | HY000 | ER_EVENT_STORE_FAILED | Failed to store event %s. Error code %d
from storage engine.
|
1539 | HY000 | ER_EVENT_DOES_NOT_EXIST | Unknown event '%s'
|
1540 | HY000 | ER_EVENT_CANT_ALTER | Failed to alter event '%s'
|
1541 | HY000 | ER_EVENT_DROP_FAILED | Failed to drop %s
|
1542 | HY000 | ER_EVENT_INTERVAL_NOT_POSITIVE_OR_TOO_BIG | INTERVAL is either
not positive or too big
|
1543 | HY000 | ER_EVENT_ENDS_BEFORE_STARTS | ENDS is either invalid or before
STARTS
|
1544 | HY000 | ER_EVENT_EXEC_TIME_IN_THE_PAST | Event execution time is in the
past. Event has been disabled
|
1545 | HY000 | ER_EVENT_OPEN_TABLE_FAILED | Failed to open mysql.event
|
1546 | HY000 | ER_EVENT_NEITHER_M_EXPR_NOR_M_AT | No datetime expression
provided
|
1547 | HY000 | ER_COL_COUNT_DOESNT_MATCH_CORRUPTED | Column count of mysql.%s is
wrong. Expected %d, found %d. The table is probably corrupted
|
1548 | HY000 | ER_CANNOT_LOAD_FROM_TABLE | Cannot load from mysql.%s. The table
is probably corrupted
|
1549 | HY000 | ER_EVENT_CANNOT_DELETE | Failed to delete the event from
mysql.event
|
1550 | HY000 | ER_EVENT_COMPILE_ERROR | Error during compilation of event's
body
|
1551 | HY000 | ER_EVENT_SAME_NAME | Same old and new event name
|
1552 | HY000 | ER_EVENT_DATA_TOO_LONG | Data for column '%s' too long
|
1553 | HY000 | ER_DROP_INDEX_FK | Cannot drop index '%s': needed in a foreign
key constraint
|
1554 | HY000 | ER_WARN_DEPRECATED_SYNTAX_WITH_VER | The syntax '%s' is
deprecated and will be removed in MariaDB %s. Please use %s instead
|
1555 | HY000 | ER_CANT_WRITE_LOCK_LOG_TABLE | You can't write-lock a log table.
Only read access is possible
|
1556 | HY000 | ER_CANT_LOCK_LOG_TABLE | You can't use locks with log tables.
|
1557 | 23000 | ER_FOREIGN_DUPLICATE_KEY | Upholding foreign key constraints for
table '%s', entry '%s', key %d would lead to a duplicate entry
|
1558 | HY000 | ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE | Column 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.
|
1559 | HY000 | ER_TEMP_TABLE_PREVENTS_SWITCH_OUT_OF_RBR | Cannot switch out of
the row-based binary log format when the session has open temporary tables
|
1560 | HY000 | ER_STORED_FUNCTION_ PREVENTS_SWITCH_BINLOG_FORMAT | Cannot change
the binary logging format inside a stored function or trigger
|
1561 | | ER_UNUSED_13 | You should never see it
|
1562 | HY000 | ER_PARTITION_NO_TEMPORARY | Cannot create temporary table with
partitions
|
1563 | HY000 | ER_PARTITION_CONST_DOMAIN_ERROR | Partition constant is out of
partition function domain
|
1564 | HY000 | ER_PARTITION_FUNCTION_IS_NOT_ALLOWED | This partition function is
not allowed
|
1565 | HY000 | ER_DDL_LOG_ERROR | Error in DDL log
|
1566 | HY000 | ER_NULL_IN_VALUES_LESS_THAN | Not allowed to use NULL value in
VALUES LESS THAN
|
1567 | HY000 | ER_WRONG_PARTITION_NAME | Incorrect partition name
|
1568 | 25001 | ER_CANT_CHANGE_TX_ISOLATION | Transaction isolation level can't
be changed while a transaction is in progress
|
1569 | HY000 | ER_DUP_ENTRY_AUTOINCREMENT_CASE | ALTER TABLE causes
auto_increment resequencing, resulting in duplicate entry '%s' for key '%s'
|
1570 | HY000 | ER_EVENT_MODIFY_QUEUE_ERROR | Internal scheduler error %d
|
1571 | HY000 | ER_EVENT_SET_VAR_ERROR | Error during starting/stopping of the
scheduler. Error code %u
|
1572 | HY000 | ER_PARTITION_MERGE_ERROR | Engine cannot be used in partitioned
tables
|
1573 | HY000 | ER_CANT_ACTIVATE_LOG | Cannot activate '%s' log
|
1574 | HY000 | ER_RBR_NOT_AVAILABLE | The server was not built with row-based
replication
|
1575 | HY000 | ER_BASE64_DECODE_ERROR | Decoding of base64 string failed
|
1576 | HY000 | ER_EVENT_RECURSION_FORBIDDEN | Recursion of EVENT DDL statements
is forbidden when body is present
|
1577 | HY000 | ER_EVENTS_DB_ERROR | Cannot proceed because system tables used by
Event Scheduler were found damaged at server start
|
1578 | HY000 | ER_ONLY_INTEGERS_ALLOWED | Only integers allowed as number here
|
1579 | HY000 | ER_UNSUPORTED_LOG_ENGINE | This storage engine cannot be used for
log tables"
|
1580 | HY000 | ER_BAD_LOG_STATEMENT | You cannot '%s' a log table if logging is enabled
|
1581 | HY000 | ER_CANT_RENAME_LOG_TABLE | Cannot 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'
|
1582 | 42000 | ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT | Incorrect parameter count in the call to native function '%s'
|
1583 | 42000 | ER_WRONG_PARAMETERS_TO_NATIVE_FCT | Incorrect parameters in the call to native function '%s'
|
1584 | 42000 | ER_WRONG_PARAMETERS_TO_STORED_FCT | Incorrect parameters in the call to stored function '%s'
|
1585 | HY000 | ER_NATIVE_FCT_NAME_COLLISION | This function '%s' has the same name as a native function
|
1586 | 23000 | ER_DUP_ENTRY_WITH_KEY_NAME | Duplicate entry '%s' for key '%s'
|
1587 | HY000 | ER_BINLOG_PURGE_EMFILE | Too many files opened, please execute the command again
|
1588 | HY000 | ER_EVENT_CANNOT_CREATE_IN_THE_PAST | Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.
|
1589 | HY000 | ER_EVENT_CANNOT_ALTER_IN_THE_PAST | Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.
|
1590 | HY000 | ER_SLAVE_INCIDENT | The incident %s occured on the master. Message: %s
|
1591 | HY000 | ER_NO_PARTITION_FOR_GIVEN_VALUE_SILENT | Table has no partition for some existing values
|
1592 | HY000 | ER_BINLOG_UNSAFE_STATEMENT | Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. %s
|
1593 | HY000 | ER_SLAVE_FATAL_ERROR | Fatal error: %s
|
1594 | HY000 | ER_SLAVE_RELAY_LOG_READ_FAILURE | Relay log read failure: %s
|
1595 | HY000 | ER_SLAVE_RELAY_LOG_WRITE_FAILURE | Relay log write failure: %s
|
1596 | HY000 | ER_SLAVE_CREATE_EVENT_FAILURE | Failed to create %s
|
1597 | HY000 | ER_SLAVE_MASTER_COM_FAILURE | Master command %s failed: %s
|
1598 | HY000 | ER_BINLOG_LOGGING_IMPOSSIBLE | Binary logging not possible. Message: %s
|
1599 | HY000 | ER_VIEW_NO_CREATION_CTX | View `%s`.`%s` has no creation context
|
Error Code | SQLSTATE | Error | Description
|
1600 | HY000 | ER_VIEW_INVALID_CREATION_CTX | Creation context of view `%s`.`%s' is invalid
|
1601 | HY000 | ER_SR_INVALID_CREATION_CTX | Creation context of stored routine `%s`.`%s` is invalid
|
1602 | HY000 | ER_TRG_CORRUPTED_FILE | Corrupted TRG file for table `%s`.`%s`
|
1603 | HY000 | ER_TRG_NO_CREATION_CTX | Triggers for table `%s`.`%s` have no creation context
|
1604 | HY000 | ER_TRG_INVALID_CREATION_CTX | Trigger creation context of table `%s`.`%s` is invalid
|
1605 | HY000 | ER_EVENT_INVALID_CREATION_CTX | Creation context of event `%s`.`%s` is invalid
|
1606 | HY000 | ER_TRG_CANT_OPEN_TABLE | Cannot open table for trigger `%s`.`%s`
|
1607 | HY000 | ER_CANT_CREATE_SROUTINE | Cannot create stored routine `%s`. Check warnings
|
1608 | | ER_UNUSED_11 | You should never see it
|
1609 | HY000 | ER_NO_FORMAT_DESCRIPTION_EVENT _BEFORE_BINLOG_STATEMENT | The BINLOG statement of type `%s` was not preceded by a format description BINLOG statement.
|
1610 | HY000 | ER_SLAVE_CORRUPT_EVENT | Corrupted replication event was detected
|
1611 | HY000 | ER_LOAD_DATA_INVALID_COLUMN | Invalid column reference (%s) in LOAD DATA
|
1612 | HY000 | ER_LOG_PURGE_NO_FILE | Being purged log %s was not found
|
1613 | XA106 | ER_XA_RBTIMEOUT | XA_RBTIMEOUT: Transaction branch was rolled back: took too long
|
1614 | XA102 | ER_XA_RBDEADLOCK | XA_RBDEADLOCK: Transaction branch was rolled back: deadlock was detected
|
1615 | HY000 | ER_NEED_REPREPARE | Prepared statement needs to be re-prepared
|
1616 | HY000 | ER_DELAYED_NOT_SUPPORTED | DELAYED option not supported for table '%s'
|
1617 | HY000 | WARN_NO_MASTER_INF | The master info structure does not exist
|
1618 | HY000 | WARN_OPTION_IGNORED | <%s> option ignored
|
1619 | HY000 | WARN_PLUGIN_DELETE_BUILTIN | Built-in plugins cannot be deleted
|
1620 | HY000 | WARN_PLUGIN_BUSY | Plugin is busy and will be uninstalled on shutdown
|
1621 | HY000 | ER_VARIABLE_IS_READONLY | %s variable '%s' is read-only. Use SET %s to assign the value
|
1622 | HY000 | ER_WARN_ENGINE_TRANSACTION_ROLLBACK | Storage engine %s does not support rollback for this statement. Transaction rolled back and must be restarted
|
1623 | HY000 | ER_SLAVE_HEARTBEAT_FAILURE | Unexpected master's heartbeat data: %s
|
1624 | HY000 | ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE | The requested value for the heartbeat period is either negative or exceeds the maximum allowed (%s seconds).
|
1625 | | ER_UNUSED_14 | You should never see it
|
1626 | HY000 | ER_CONFLICT_FN_PARSE_ERROR | Error in parsing conflict function. Message: %s
|
1627 | HY000 | ER_EXCEPTIONS_WRITE_ERROR | Write to exceptions table failed. Message: %s"
|
1628 | HY000 | ER_TOO_LONG_TABLE_COMMENT | Comment for table '%s' is too long
(max = %lu)
|
1629 | HY000 | ER_TOO_LONG_FIELD_COMMENT | Comment for field '%s' is too long
(max = %lu)
|
1630 | 42000 | ER_FUNC_INEXISTENT_NAME_COLLISION | FUNCTION %s does not exist.
Check the 'Function Name Parsing and Resolution' section in the Reference
Manual
|
1631 | HY000 | ER_DATABASE_NAME | Database
|
1632 | HY000 | ER_TABLE_NAME | Table
|
1633 | HY000 | ER_PARTITION_NAME | Partition
|
1634 | HY000 | ER_SUBPARTITION_NAME | Subpartition
|
1635 | HY000 | ER_TEMPORARY_NAME | Temporary
|
1636 | HY000 | ER_RENAMED_NAME | Renamed
|
1637 | HY000 | ER_TOO_MANY_CONCURRENT_TRXS | Too many active concurrent
transactions
|
1638 | HY000 | WARN_NON_ASCII_SEPARATOR_NOT_IMPLEMENTED | Non-ASCII separator
arguments are not fully supported
|
1639 | HY000 | ER_DEBUG_SYNC_TIMEOUT | debug sync point wait timed out
|
1640 | HY000 | ER_DEBUG_SYNC_HIT_LIMIT | debug sync point hit limit reached
|
1641 | 42000 | ER_DUP_SIGNAL_SET | Duplicate condition information item '%s'
|
1642 | 01000 | ER_SIGNAL_WARN | Unhandled user-defined warning condition
|
1643 | 02000 | ER_SIGNAL_NOT_FOUND | Unhandled user-defined not found condition
|
1644 | HY000 | ER_SIGNAL_EXCEPTION | Unhandled user-defined exception condition
|
1645 | 0K000 | ER_RESIGNAL_WITHOUT_ACTIVE_HANDLER | RESIGNAL when handler not
active
|
1646 | HY000 | ER_SIGNAL_BAD_CONDITION_TYPE | SIGNAL/RESIGNAL can only use a
CONDITION defined with SQLSTATE
|
1647 | HY000 | WARN_COND_ITEM_TRUNCATED | Data truncated for condition item
'%s'
|
1648 | HY000 | ER_COND_ITEM_TOO_LONG | Data too long for condition item '%s'
|
1649 | HY000 | ER_UNKNOWN_LOCALE | Unknown locale: '%s'
|
1650 | HY000 | ER_SLAVE_IGNORE_SERVER_IDS | The requested server id %d clashes
with the slave startup option --replicate-same-server-id
|
1651 | HY000 | ER_QUERY_CACHE_DISABLED | Query cache is disabled; restart the
server with query_cache_type=1 to enable it
|
1652 | HY000 | ER_SAME_NAME_PARTITION_FIELD | Duplicate partition field name
'%s'
|
1653 | HY000 | ER_PARTITION_COLUMN_LIST_ERROR | Inconsistency in usage of column
lists for partitioning
|
1654 | HY000 | ER_WRONG_TYPE_COLUMN_VALUE_ERROR | Partition column values of
incorrect type
|
1655 | HY000 | ER_TOO_MANY_PARTITION_FUNC_FIELDS_ERROR | Too many fields in
'%s'
|
1656 | HY000 | ER_MAXVALUE_IN_VALUES_IN | Cannot use MAXVALUE as value in VALUES
IN
|
1657 | HY000 | ER_TOO_MANY_VALUES_ERROR | Cannot have more than one value for
this type of %s partitioning
|
1658 | HY000 | ER_ROW_SINGLE_PARTITION_FIELD_ERROR | Row expressions in VALUES
IN only allowed for multi-field column partitioning
|
1659 | HY000 | ER_FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELD | Field '%s' is of a
not allowed type for this type of partitioning
|
1660 | HY000 | ER_PARTITION_FIELDS_TOO_LONG | The total length of the
partitioning fields is too large
|
1661 | HY000 | ER_BINLOG_ROW_ENGINE_AND_STMT_ENGINE | Cannot execute statement:
impossible to write to binary log since both row-incapable engines and
statement-incapable engines are involved.
|
1662 | HY000 | ER_BINLOG_ROW_MODE_AND_STMT_ENGINE | Cannot 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.
|
1663 | HY000 | ER_BINLOG_UNSAFE_AND_STMT_ENGINE | Cannot 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
|
1664 | HY000 | ER_BINLOG_ROW_INJECTION_AND_STMT_ENGINE | Cannot 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.
|
1665 | HY000 | ER_BINLOG_STMT_MODE_AND_ROW_ENGINE | Cannot 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
|
1666 | HY000 | ER_BINLOG_ROW_INJECTION_AND_STMT_MODE | Cannot execute statement:
impossible to write to binary log since statement is in row format and
BINLOG_FORMAT = STATEMENT.
|
1667 | HY000 | ER_BINLOG_MULTIPLE_ENGINES _AND_SELF_LOGGING_ENGINE | Cannot
execute statement: impossible to write to binary log since more than one
engine is involved and at least one engine is self-logging.
|
1668 | HY000 | ER_BINLOG_UNSAFE_LIMIT | The statement is unsafe because it uses
a LIMIT clause. This is unsafe because the set of rows included cannot be
predicted.
|
1669 | HY000 | ER_BINLOG_UNSAFE_INSERT_DELAYED | The statement is unsafe because
it uses INSERT DELAYED. This is unsafe because the times when rows are
inserted cannot be predicted.
|
1670 | HY000 | ER_BINLOG_UNSAFE_SYSTEM_TABLE | The 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.
|
1671 | HY000 | ER_BINLOG_UNSAFE_AUTOINC_COLUMNS | Statement is unsafe because it
invokes a trigger or a stored function that inserts into an AUTO_INCREMENT
column. Inserted values cannot be logged correctly.
|
1672 | HY000 | ER_BINLOG_UNSAFE_UDF | Statement is unsafe because it uses a UDF
which may not return the same value on the slave.
|
1673 | HY000 | ER_BINLOG_UNSAFE_SYSTEM_VARIABLE | Statement is unsafe because it
uses a system variable that may have a different value on the slave.
|
1674 | HY000 | ER_BINLOG_UNSAFE_SYSTEM_FUNCTION | Statement is unsafe because it
uses a system function that may return a different value on the slave.
|
1675 | HY000 | ER_BINLOG_UNSAFE_NONTRANS_AFTER_TRANS | Statement is unsafe
because it accesses a non-transactional table after accessing a
transactional table within the same transaction.
|
1676 | HY000 | ER_MESSAGE_AND_STATEMENT | %s Statement: %s
|
1677 | HY000 | ER_SLAVE_CONVERSION_FAILED | Column %d of table '%s.%s' cannot be
converted from type '%s' to type '%s'
|
1678 | HY000 | ER_SLAVE_CANT_CREATE_CONVERSION | Can't create conversion table
for table '%s.%s'
|
1679 | HY000 | ER_INSIDE_TRANSACTION _PREVENTS_SWITCH_BINLOG_FORMAT | Cannot
modify @@session.binlog_format inside a transaction
|
1680 | HY000 | ER_PATH_LENGTH | The path specified for %s is too long.
|
1681 | HY000 | ER_WARN_DEPRECATED_SYNTAX_NO_REPLACEMENT | '%s' is deprecated and
will be removed in a future release.
|
1682 | HY000 | ER_WRONG_NATIVE_TABLE_STRUCTURE | Native table '%s'.'%s' has the
wrong structure
|
1683 | HY000 | ER_WRONG_PERFSCHEMA_USAGE | Invalid performance_schema usage.
|
1684 | HY000 | ER_WARN_I_S_SKIPPED_TABLE | Table '%s'.'%s' was skipped since its
definition is being modified by concurrent DDL statement
|
1685 | HY000 | ER_INSIDE_TRANSACTION _PREVENTS_SWITCH_BINLOG_DIRECT | Cannot
modify @@session.binlog_direct_non_transactional_updates inside a
transaction
|
1686 | HY000 | ER_STORED_FUNCTION_PREVENTS _SWITCH_BINLOG_DIRECT | Cannot change
the binlog direct flag inside a stored function or trigger
|
1687 | 42000 | ER_SPATIAL_MUST_HAVE_GEOM_COL | A SPATIAL index may only contain
a geometrical type column
|
1688 | HY000 | ER_TOO_LONG_INDEX_COMMENT | Comment for index '%s' is too long
(max = %lu)
|
1689 | HY000 | ER_LOCK_ABORTED | Wait on a lock was aborted due to a pending
exclusive lock
|
1690 | 22003 | ER_DATA_OUT_OF_RANGE | %s value is out of range in '%s'
|
1691 | HY000 | ER_WRONG_SPVAR_TYPE_IN_LIMIT | A variable of a non-integer based
type in LIMIT clause
|
1692 | HY000 | ER_BINLOG_UNSAFE_MULTIPLE_ENGINES _AND_SEL
F_LOGGING_ENGINE | Mixing self-logging and non-self-logging engines in a
statement is unsafe.
|
1693 | HY000 | ER_BINLOG_UNSAFE_MIXED_STATEMENT | Statement accesses
nontransactional table as well as transactional or temporary table, and
writes to any of them.
|
1694 | HY000 | ER_INSIDE_TRANSACTION_ PREVENTS_SWITCH_SQL_LOG_BIN | Cannot
modify @@session.sql_log_bin inside a transaction
|
1695 | HY000 | ER_STORED_FUNCTION_ PREVENTS_SWITCH_SQL_LOG_BIN | Cannot change
the sql_log_bin inside a stored function or trigger
|
1696 | HY000 | ER_FAILED_READ_FROM_PAR_FILE | Failed to read from the .par file
|
1697 | HY000 | ER_VALUES_IS_NOT_INT_TYPE_ERROR | VALUES value for partition '%s'
must have type INT
|
1698 | 28000 | ER_ACCESS_DENIED_NO_PASSWORD_ERROR | Access denied for user
'%s'@'%s'
|
1699 | HY000 | ER_SET_PASSWORD_AUTH_PLUGIN | SET PASSWORD has no significance
for users authenticating via plugins
|
Error Code | SQLSTATE | Error | Description
|
1700 | HY000 | ER_GRANT_PLUGIN_USER_EXISTS | GRANT with IDENTIFIED WITH is
illegal because the user %-.*s already exists
|
1701 | 42000 | ER_TRUNCATE_ILLEGAL_FK | Cannot truncate a table referenced in a
foreign key constraint (%s)
|
1702 | HY000 | ER_PLUGIN_IS_PERMANENT | Plugin '%s' is force_plus_permanent and
can not be unloaded
|
1703 | HY000 | ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MIN | The requested value
for the heartbeat period is less than 1 millisecond. The value is reset to
0, meaning that heartbeating will effectively be disabled.
|
1704 | HY000 | ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MAX | The 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.
|
1705 | HY000 | ER_STMT_CACHE_FULL | Multi-row statements required more than
'max_binlog_stmt_cache_size' bytes of storage; increase this mysqld variable
and try again
|
1706 | HY000 | ER_MULTI_UPDATE_KEY_CONFLICT | Primary key/partition key update
is not allowed since the table is updated both as '%s' and '%s'.
|
1707 | HY000 | ER_TABLE_NEEDS_REBUILD | Table rebuild required. Please do "ALTER TABLE `%s` FORCE" or
dump/reload to fix it!
|
1708 | HY000 | WARN_OPTION_BELOW_LIMIT | The value of '%s' should be no less
than the value of '%s'
|
1709 | HY000 | ER_INDEX_COLUMN_TOO_LONG | Index column size too large. The
maximum column size is %lu bytes.
|
1710 | HY000 | ER_ERROR_IN_TRIGGER_BODY | Trigger '%s' has an error in its body:
'%s'
|
1711 | HY000 | ER_ERROR_IN_UNKNOWN_TRIGGER_BODY | Unknown trigger has an error
in its body: '%s'
|
1712 | HY000 | ER_INDEX_CORRUPT | Index %s is corrupted
|
1713 | HY000 | ER_UNDO_RECORD_TOO_BIG | Undo log record is too big.
|
1714 | HY000 | ER_BINLOG_UNSAFE_INSERT_IGNORE_SELECT | INSERT 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.
|
1715 | HY000 | ER_BINLOG_UNSAFE_INSERT_SELECT_UPDATE | INSERT... 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.
|
1716 | HY000 | ER_BINLOG_UNSAFE_REPLACE_SELECT | 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.
|
1717 | HY000 | ER_BINLOG_UNSAFE_CREATE_IGNORE_SELECT | CREATE... 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.
|
1718 | HY000 | ER_BINLOG_UNSAFE_CREATE_REPLACE_SELECT | CREATE... 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.
|
1719 | HY000 | ER_BINLOG_UNSAFE_UPDATE_IGNORE | UPDATE 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.
|
1720 | | ER_UNUSED_15 | You should never see it
|
1721 | | ER_UNUSED_16 | You should never see it
|
1722 | HY000 | ER_BINLOG_UNSAFE_WRITE_AUTOINC_SELECT | Statements 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.
|
1723 | HY000 | ER_BINLOG_UNSAFE_CREATE_SELECT_AUTOINC | CREATE 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.
|
1724 | HY000 | ER_BINLOG_UNSAFE_INSERT_TWO_KEYS | INSERT... ON DUPLICATE KEY
UPDATE on a table with more than one UNIQUE KEY is unsafe
|
1725 | HY000 | ER_TABLE_IN_FK_CHECK | Table is being used in foreign key check.
|
1726 | HY000 | ER_UNSUPPORTED_ENGINE | Storage engine '%s' does not support
system tables. [%s.%s]
|
1727 | HY000 | ER_BINLOG_UNSAFE_AUTOINC_NOT_FIRST | INSERT into autoincrement
field which is not the first part in the composed primary key is unsafe.
|
1728 | HY000 | ER_CANNOT_LOAD_FROM_TABLE_V2 | Cannot load from %s.%s. The table
is probably corrupted
|
1729 | HY000 | ER_MASTER_DELAY_VALUE_OUT_OF_RANGE | The requested value %s for
the master delay exceeds the maximum %u
|
1730 | HY000 | ER_ONLY_FD_AND_RBR_EVENTS_ALLOWED_IN_BINLOG_STATEMENT | Only
Format_description_log_event and row events are allowed in BINLOG statements
(but %s was provided
|
1731 | HY000 | ER_PARTITION_EXCHANGE_DIFFERENT_OPTION | Non matching attribute
'%s' between partition and table
|
1732 | HY000 | ER_PARTITION_EXCHANGE_PART_TABLE | Table to exchange with
partition is partitioned: '%s'
|
1733 | HY000 | ER_PARTITION_EXCHANGE_TEMP_TABLE | Table to exchange with
partition is temporary: '%s'
|
1734 | HY000 | ER_PARTITION_INSTEAD_OF_SUBPARTITION | Subpartitioned table, use
subpartition instead of partition
|
1735 | HY000 | ER_UNKNOWN_PARTITION | Unknown partition '%s' in table '%s'
|
1736 | HY000 | ER_TABLES_DIFFERENT_METADATA | Tables have different definitions
|
1737 | HY000 | ER_ROW_DOES_NOT_MATCH_PARTITION | Found a row that does not match
the partition
|
1738 | HY000 | ER_BINLOG_CACHE_SIZE_GREATER_THAN_MAX | Option binlog_cache_size
(%lu) is greater than max_binlog_cache_size (%lu); setting binlog_cache_size
equal to max_binlog_cache_size.
|
1739 | HY000 | ER_WARN_INDEX_NOT_APPLICABLE | Cannot use %s access on index '%s'
due to type or collation conversion on field '%s'
|
1740 | HY000 | ER_PARTITION_EXCHANGE_FOREIGN_KEY | Table to exchange with
partition has foreign key references: '%s'
|
1741 | HY000 | ER_NO_SUCH_KEY_VALUE | Key value '%s' was not found in table
'%s.%s'
|
1742 | HY000 | ER_RPL_INFO_DATA_TOO_LONG | Data for column '%s' too long
|
1743 | HY000 | ER_NETWORK_READ_EVENT_CHECKSUM_FAILURE | Replication event
checksum verification failed while reading from network.
|
1744 | HY000 | ER_BINLOG_READ_EVENT_CHECKSUM_FAILURE | Replication event
checksum verification failed while reading from a log file.
|
1745 | HY000 | ER_BINLOG_STMT_CACHE_SIZE_GREATER_THAN_MAX | Option
binlog_stmt_cache_size (%lu) is greater than max_binlog_stmt_cache_size
(%lu); setting binlog_stmt_cache_size equal to max_binlog_stmt_cache_size.
|
1746 | HY000 | ER_CANT_UPDATE_TABLE_IN_CREATE_TABLE_SELECT | Can't update table
'%s' while '%s' is being created.
|
1747 | HY000 | ER_PARTITION_CLAUSE_ON_NONPARTITIONED | PARTITION () clause on
non partitioned table
|
1748 | HY000 | ER_ROW_DOES_NOT_MATCH_GIVEN_PARTITION_SET | Found a row not
matching the given partition set
|
1749 | HY000 | ER_NO_SUCH_PARTITION_UNUSED | partition '%s' doesn't exist
|
1750 | HY000 | ER_CHANGE_RPL_INFO_REPOSITORY_FAILURE | Failure while changing
the type of replication repository: %s.
|
1751 | HY000 | ER_WARNING_NOT_COMPLETE_ROLLBACK_WITH_CREATED_TEMP_TABLE | The
creation of some temporary tables could not be rolled back.
|
1752 | HY000 | ER_WARNING_NOT_COMPLETE_ROLLBACK_WITH_DROPPED_TEMP_TABLE | Some
temporary tables were dropped, but these operations could not be rolled
back.
|
1753 | HY000 | ER_MTS_FEATURE_IS_NOT_SUPPORTED | %s is not supported in multi
-threaded slave mode. %s
|
1754 | HY000 | ER_MTS_UPDATED_DBS_GREATER_MAX | The number of modified databases
exceeds the maximum %d; the database names will not be included in the
replication event metadata.
|
1755 | HY000 | ER_MTS_CANT_PARALLEL | Cannot execute the current event group in
the parallel mode. Encountered event %s, relay-log name %s, position %s
which prevents execution of this event group in parallel mode. Reason: %s.
|
1756 | HY000 | ER_MTS_INCONSISTENT_DATA | %s
|
1757 | HY000 | ER_FULLTEXT_NOT_SUPPORTED_WITH_PARTITIONING | FULLTEXT index is
not supported for partitioned tables.
|
1758 | 35000 | ER_DA_INVALID_CONDITION_NUMBER | Invalid condition number
|
1759 | HY000 | ER_INSECURE_PLAIN_TEXT | Sending passwords in plain text without
SSL/TLS is extremely insecure.
|
1760 | HY000 | ER_INSECURE_CHANGE_MASTER | Storing MariaDB user name or password
information in the master.info repository is not secure and is therefore not
recommended. Please see the MariaDB Manual for more about this issue and
possible alternatives
|
1761 | 23000 | ER_FOREIGN_DUPLICATE_KEY_WITH_CHILD_INFO | Foreign key constraint
for table '%s', record '%s' would lead to a duplicate entry in table '%s',
key '%s'
|
1762 | 23000 | ER_FOREIGN_DUPLICATE_KEY_WITHOUT_CHILD_INFO | Foreign key
constraint for table '%s', record '%s' would lead to a duplicate entry in a
child table
|
1763 | HY000 | ER_SQLTHREAD_WITH_SECURE_SLAVE | Setting authentication options
is not possible when only the Slave SQL Thread is being started.
|
1764 | HY000 | ER_TABLE_HAS_NO_FT | The table does not have FULLTEXT index to
support this query
|
1765 | HY000 | ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER | The system variable
%s cannot be set in stored functions or triggers.
|
1766 | HY000 | ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION | The system variable %s
cannot be set when there is an ongoing transaction.
|
1767 | HY000 | ER_GTID_NEXT_IS_NOT_IN_GTID_NEXT_LIST | The system variable
@@SESSION.GTID_NEXT has the value %s, which is not listed in
@@SESSION.GTID_NEXT_LIST.
|
1768 | HY000 | ER_CANT_CHANGE_GTID_NEXT_IN_TRANSACTION
_WHEN_GTID_NEXT_LIST_IS_NULL | The system variable @@SESSION.GTID_NEXT cannot
change inside a transaction.
|
1769 | HY000 | ER_SET_STATEMENT_CANNOT_INVOKE_FUNCTION | The statement 'SET %s'
cannot invoke a stored function.
|
1770 | HY000 | ER_GTID_NEXT_CANT_BE_AUTOMATIC_IF_GTID_NEX
T_LIST_IS_NON_NULL | The system variable @@SESSION.GTID_NEXT cannot be
'AUTOMATIC' when @@SESSION.GTID_NEXT_LIST is non-NULL.
|
1771 | HY000 | ER_SKIPPING_LOGGED_TRANSACTION | Skipping transaction %s because
it has already been executed and logged.
|
1772 | HY000 | ER_MALFORMED_GTID_SET_SPECIFICATION | Malformed GTID set
specification '%s'.
|
1773 | HY000 | ER_MALFORMED_GTID_SET_ENCODING | Malformed GTID set encoding.
|
1774 | HY000 | ER_MALFORMED_GTID_SPECIFICATION | Malformed GTID specification
'%s'.
|
1775 | HY000 | ER_GNO_EXHAUSTED | Impossible to generate Global Transaction
Identifier: the integer component reached the maximal value. Restart the
server with a new server_uuid.
|
1776 | HY000 | ER_BAD_SLAVE_AUTO_POSITION | Parameters MASTER_LOG_FILE,
MASTER_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be set when
MASTER_AUTO_POSITION is active.
|
1777 | HY000 | ER_AUTO_POSITION_REQUIRES_GTID_MODE_ON | CHANGE MASTER TO
MASTER_AUTO_POSITION = 1 can only be executed when @@GLOBAL.GTID_MODE = ON.
|
1778 | HY000 | ER_CANT_DO_IMPLICIT_COMMIT_IN_TRX_WHEN_GTID_NEXT_IS_SET | Cannot
execute statements with implicit commit inside a transaction when
@@SESSION.GTID_NEXT != AUTOMATIC.
|
1779 | HY000 | ER_GTID_MODE_2_OR_3_REQUIRES_DISABLE_GTID_
UNSAFE_STATEMENTS_ON | GTID_MODE = ON or GTID_MODE = UPGRADE_STEP_2 requires
DISABLE_GTID_UNSAFE_STATEMENTS = 1.
|
1779 | HY000 | ER_GTID_MODE_2_OR_3_REQUIRES_ENFORCE_GTID_
CONSISTENCY_ON | @@GLOBAL.GTID_MODE = ON or UPGRADE_STEP_2 requires
@@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.
|
1780 | HY000 | ER_GTID_MODE_REQUIRES_BINLOG | @@GLOBAL.GTID_MODE = ON or
UPGRADE_STEP_1 or UPGRADE_STEP_2 requires --log-bin and --log-slave
-updates.
|
1781 | HY000 | ER_CANT_SET_GTID_NEXT_TO_GTID_WHEN_GTID_MO
DE_IS_OFF | @@SESSION.GTID_NEXT cannot be set to UUID:NUMBER when
@@GLOBAL.GTID_MODE = OFF.
|
1782 | HY000 | ER_CANT_SET_GTID_NEXT_TO_ANONYMOUS_WHEN_GT
ID_MODE_IS_ON | @@SESSION.GTID_NEXT cannot be set to ANONYMOUS when
@@GLOBAL.GTID_MODE = ON.
|
1783 | HY000 | ER_CANT_SET_GTID_NEXT_LIST_TO_NON_NULL_WHE
N_GTID_MODE_IS_OFF | @@SESSION.GTID_NEXT_LIST cannot be set to a non-NULL
value when @@GLOBAL.GTID_MODE = OFF.
|
1784 | HY000 | ER_FOUND_GTID_EVENT_WHEN_GTID_MODE_IS_OFF | Found a
Gtid_log_event or Previous_gtids_log_event when @@GLOBAL.GTID_MODE = OFF.
|
1785 | HY000 | ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE | When
@@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, updates to non-transactional tables
can only be done in either autocommitted statements or single-statement
transactions, and never in the same statement as updates to transactional
tables.
|
1786 | HY000 | ER_GTID_UNSAFE_CREATE_SELECT | CREATE TABLE ... SELECT is
forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.
|
1787 | HY000 | ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION | When
@@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, the statements CREATE TEMPORARY TABLE
and DROP TEMPORARY TABLE can be executed in a non-transactional context
only, and require that AUTOCOMMIT = 1.
|
1788 | HY000 | ER_GTID_MODE_CAN_ONLY_CHANGE_ONE_STEP_AT_A_TIME | The value of
@@GLOBAL.GTID_MODE can only change one step at a time: OFF <-> UPGRADE_STEP_1
<-> UPGRADE_STEP_2 <-> ON. Also note that this value must be stepped up or down
simultaneously on all servers; see the Manual for instructions.
|
1789 | HY000 | ER_MASTER_HAS_PURGED_REQUIRED_GTIDS | The slave is connecting
using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged
binary logs containing GTIDs that the slave requires.
|
1790 | HY000 | ER_CANT_SET_GTID_NEXT_WHEN_OWNING_GTID | @@SESSION.GTID_NEXT
cannot be changed by a client that owns a GTID. The client owns %s.
Ownership is released on COMMIT or ROLLBACK.
|
1791 | HY000 | ER_UNKNOWN_EXPLAIN_FORMAT | Unknown EXPLAIN format name: '%s'
|
1792 | 25006 | ER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION | Cannot execute
statement in a READ ONLY transaction.
|
1793 | HY000 | ER_TOO_LONG_TABLE_PARTITION_COMMENT | Comment for table partition
'%s' is too long (max = %lu
|
1794 | HY000 | ER_SLAVE_CONFIGURATION | Slave is not configured or failed to
initialize properly. You must at least set --server-id to enable either a
master or a slave. Additional error messages can be found in the MariaDB
error log
|
1795 | HY000 | ER_INNODB_FT_LIMIT | InnoDB presently supports one FULLTEXT index
creation at a time
|
1796 | HY000 | ER_INNODB_NO_FT_TEMP_TABLE | Cannot create FULLTEXT index on
temporary InnoDB table
|
1797 | HY000 | ER_INNODB_FT_WRONG_DOCID_COLUMN | Column '%s' is of wrong type
for an InnoDB FULLTEXT index
|
1798 | HY000 | ER_INNODB_FT_WRONG_DOCID_INDEX | Index '%s' is of wrong type for
an InnoDB FULLTEXT index
|
1799 | HY000 | ER_INNODB_ONLINE_LOG_TOO_BIG | Creating index '%s' required more
than 'innodb_online_alter_log_max_size' bytes of modification log. Please
try again.
|
Error Code | SQLSTATE | Error | Description
|
1800 | HY000 | ER_UNKNOWN_ALTER_ALGORITHM | Unknown ALGORITHM '%s'
|
1801 | HY000 | ER_UNKNOWN_ALTER_LOCK | Unknown LOCK type '%s'
|
1802 | HY000 | ER_MTS_CHANGE_MASTER_CANT_RUN_WITH_GAPS | CHANGE MASTER cannot be
executed when the slave was stopped with an error or killed in MTS mode.
Consider using RESET SLAVE or START SLAVE UNTIL.
|
1803 | HY000 | ER_MTS_RECOVERY_FAILURE | Cannot recover after SLAVE errored out
in parallel execution mode. Additional error messages can be found in the
MariaDB error log
|
1804 | HY000 | ER_MTS_RESET_WORKERS | Cannot clean up worker info tables.
Additional error messages can be found in the MariaDB error log
|
1805 | HY000 | ER_COL_COUNT_DOESNT_MATCH_CORRUPTED_V2 | Column count of %s.%s is
wrong. Expected %d, found %d. The table is probably corrupted
|
1806 | HY000 | ER_SLAVE_SILENT_RETRY_TRANSACTION | Slave must silently retry
current transaction
|
1807 | HY000 | ER_DISCARD_FK_CHECKS_RUNNING | There is a foreign key check
running on table '%s'. Cannot discard the table.
|
1808 | HY000 | ER_TABLE_SCHEMA_MISMATCH | Schema mismatch (%s
|
1809 | HY000 | ER_TABLE_IN_SYSTEM_TABLESPACE | Table '%s' in system tablespace
|
1810 | HY000 | ER_IO_READ_ERROR | IO Read error: (%lu, %s) %s
|
1811 | HY000 | ER_IO_WRITE_ERROR | IO Write error: (%lu, %s) %s
|
1812 | HY000 | ER_TABLESPACE_MISSING | Tablespace is missing for table '%s'
|
1813 | HY000 | ER_TABLESPACE_EXISTS | Tablespace for table '%s' exists. Please
DISCARD the tablespace before IMPORT.
|
1814 | HY000 | ER_TABLESPACE_DISCARDED | Tablespace has been discarded for table
'%s'
|
1815 | HY000 | ER_INTERNAL_ERROR | Internal error: %s
|
1816 | HY000 | ER_INNODB_IMPORT_ERROR | ALTER TABLE '%s' IMPORT TABLESPACE
failed with error %lu : '%s'
|
1817 | HY000 | ER_INNODB_INDEX_CORRUPT | Index corrupt: %s
|
1818 | HY000 | ER_INVALID_YEAR_COLUMN_LENGTH | YEAR(%lu) column type is
deprecated. Creating YEAR(4) column instead.
|
1819 | HY000 | ER_NOT_VALID_PASSWORD | Your password does not satisfy the
current policy requirements
|
1820 | HY000 | ER_MUST_CHANGE_PASSWORD | You must SET PASSWORD before executing
this statement
|
1821 | HY000 | ER_FK_NO_INDEX_CHILD | Failed to add the foreign key constaint.
Missing index for constraint '%s' in the foreign table '%s'
|
1822 | HY000 | ER_FK_NO_INDEX_PARENT | Failed to add the foreign key constaint.
Missing index for constraint '%s' in the referenced table '%s'
|
1823 | HY000 | ER_FK_FAIL_ADD_SYSTEM | Failed to add the foreign key constraint
'%s' to system tables
|
1824 | HY000 | ER_FK_CANNOT_OPEN_PARENT | Failed to open the referenced table
'%s'
|
1825 | HY000 | ER_FK_INCORRECT_OPTION | Failed to add the foreign key constraint
on table '%s'. Incorrect options in FOREIGN KEY constraint '%s'
|
1826 | HY000 | ER_FK_DUP_NAME | Duplicate foreign key constraint name '%s'
|
1827 | HY000 | ER_PASSWORD_FORMAT | The password hash doesn't have the expected
format. Check if the correct password algorithm is being used with the
PASSWORD() function.
|
1828 | HY000 | ER_FK_COLUMN_CANNOT_DROP | Cannot drop column '%s': needed in a
foreign key constraint '%s'
|
1829 | HY000 | ER_FK_COLUMN_CANNOT_DROP_CHILD | Cannot drop column '%s': needed
in a foreign key constraint '%s' of table '%s'
|
1830 | HY000 | ER_FK_COLUMN_NOT_NULL | Column '%s' cannot be NOT NULL: needed in
a foreign key constraint '%s' SET NULL
|
1831 | HY000 | ER_DUP_INDEX | Duplicate index '%s' defined on the table '%s.%s'.
This is deprecated and will be disallowed in a future release.
|
1832 | HY000 | ER_FK_COLUMN_CANNOT_CHANGE | Cannot change column '%s': used in a
foreign key constraint '%s'
|
1833 | HY000 | ER_FK_COLUMN_CANNOT_CHANGE_CHILD | Cannot change column '%s':
used in a foreign key constraint '%s' of table '%s'
|
1834 | HY000 | ER_FK_CANNOT_DELETE_PARENT | Cannot delete rows from table which
is parent in a foreign key constraint '%s' of table '%s'
|
1835 | HY000 | ER_MALFORMED_PACKET | Malformed communication packet.
|
1836 | HY000 | ER_READ_ONLY_MODE | Running in read-only mode
|
1837 | HY000 | ER_GTID_NEXT_TYPE_UNDEFINED_GROUP | When GTID_NEXT is set to a
GTID, you must explicitly set it again after a COMMIT or ROLLBACK. If you
see this error message in the slave SQL thread, it means that a table in the
current transaction is transactional on the master and non-transactional on
the slave. In a client connection, it means that you executed SET GTID_NEXT
before a transaction and forgot to set GTID_NEXT to a different identifier
or to 'AUTOMATIC' after COMMIT or ROLLBACK. Current GTID_NEXT is '%s'
|
1838 | HY000 | ER_VARIABLE_NOT_SETTABLE_IN_SP | The system variable %s cannot be
set in stored procedures.
|
1839 | HY000 | ER_CANT_SET_GTID_PURGED_WHEN_GTID_MODE_IS_
OFF | @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ON.
|
1840 | HY000 | ER_CANT_SET_GTID_PURGED_WHEN_GTID_EXECUTED
_IS_NOT_EMPTY | @@GLOBAL.GTID_PURGED can only be set when
@@GLOBAL.GTID_EXECUTED is empty.
|
1841 | HY000 | ER_CANT_SET_GTID_PURGED_WHEN_OWNED_GTIDS_I
S_NOT_EMPTY | @@GLOBAL.GTID_PURGED can only be set when there are no ongoing
transactions (not even in other clients).
|
1842 | HY000 | ER_GTID_PURGED_WAS_CHANGED | @@GLOBAL.GTID_PURGED was changed
from '%s' to '%s'.
|
1843 | HY000 | ER_GTID_EXECUTED_WAS_CHANGED | @@GLOBAL.GTID_EXECUTED was changed
from '%s' to '%s'.
|
1844 | HY000 | ER_BINLOG_STMT_MODE_AND_NO_REPL_TABLES | Cannot execute
statement: impossible to write to binary log since BINLOG_FORMAT =
STATEMENT, and both replicated and non replicated tables are written to.
|
1845 | 0A000 | ER_ALTER_OPERATION_NOT_SUPPORTED | %s is not supported for this
operation. Try %s.
|
1846 | 0A000 | ER_ALTER_OPERATION_NOT_SUPPORTED_REASON | %s is not supported.
Reason: %s. Try %s.
|
1847 | HY000 | ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_COPY | COPY algorithm
requires a lock
|
1848 | HY000 | ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_PARTITION | Partition
specific operations do not yet support LOCK/ALGORITHM
|
1849 | HY000 | ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FK_RENAME | Columns
participating in a foreign key are renamed
|
1850 | HY000 | ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_COLUMN_TYPE | Cannot
change column type INPLACE
|
1851 | HY000 | ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FK_CHECK | Adding foreign
keys needs foreign_key_checks=OFF
|
1852 | HY000 | ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_IGNORE | Creating unique
indexes with IGNORE requires COPY algorithm to remove duplicate rows
|
1853 | HY000 | ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOPK | Dropping a primary
key is not allowed without also adding a new primary key
|
1854 | HY000 | ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_AUTOINC | Adding an auto
-increment column requires a lock
|
1855 | HY000 | ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_HIDDEN_FTS | Cannot
replace hidden FTS_DOC_ID with a user-visible one
|
1856 | HY000 | ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_CHANGE_FTS | Cannot drop
or rename FTS_DOC_ID
|
1857 | HY000 | ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FTS | Fulltext index
creation requires a lock
|
1858 | HY000 | ER_SQL_SLAVE_SKIP_COUNTER_NOT_SETTABLE_IN_
GTID_MODE | sql_slave_skip_counter can not be set when the server is running
with @@GLOBAL.GTID_MODE = ON. Instead, for each transaction that you want to
skip, generate an empty transaction with the same GTID as the transaction
|
1859 | 23000 | ER_DUP_UNKNOWN_IN_INDEX | Duplicate entry for key '%s'
|
1860 | HY000 | ER_IDENT_CAUSES_TOO_LONG_PATH | Long database name and identifier
for object resulted in path length exceeding %d characters. Path: '%s'.
|
1861 | HY000 | ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOT_NULL | cannot
silently convert NULL values, as required in this SQL_MODE
|
1862 | HY000 | ER_MUST_CHANGE_PASSWORD_LOGIN | Your password has expired. To log
in you must change it using a client that supports expired passwords.
|
1863 | HY000 | ER_ROW_IN_WRONG_PARTITION | Found a row in wrong partition %s
|
1864 | HY000 | ER_MTS_EVENT_BIGGER_PENDING_JOBS_SIZE_MAX | Cannot schedule event
%s, relay-log name %s, position %s to Worker thread because its size %lu
exceeds %lu of slave_pending_jobs_size_max.
|
1865 | HY000 | ER_INNODB_NO_FT_USES_PARSER | Cannot CREATE FULLTEXT INDEX WITH
PARSER on InnoDB table
|
1866 | HY000 | ER_BINLOG_LOGICAL_CORRUPTION | The binary log file '%s' is
logically corrupted: %s
|
1867 | HY000 | ER_WARN_PURGE_LOG_IN_USE | file %s was not purged because it was
being read by %d thread(s), purged only %d out of %d files.
|
1868 | HY000 | ER_WARN_PURGE_LOG_IS_ACTIVE | file %s was not purged because it
is the active log file.
|
1869 | HY000 | ER_AUTO_INCREMENT_CONFLICT | Auto-increment value in UPDATE
conflicts with internally generated values
|
1870 | HY000 | WARN_ON_BLOCKHOLE_IN_RBR | Row events are not logged for %s
statements that modify BLACKHOLE tables in row format. Table(s): '%s'
|
1871 | HY000 | ER_SLAVE_MI_INIT_REPOSITORY | Slave failed to initialize master
info structure from the repository
|
1872 | HY000 | ER_SLAVE_RLI_INIT_REPOSITORY | Slave failed to initialize relay
log info structure from the repository
|
1873 | 28000 | ER_ACCESS_DENIED_CHANGE_USER_ERROR | Access denied trying to
change to user '%s'@'%s' (using password: %s). Disconnecting.
|
1874 | HY000 | ER_INNODB_READ_ONLY | InnoDB is in read only mode.
|
1875 | HY000 | ER_STOP_SLAVE_SQL_THREAD_TIMEOUT | STOP SLAVE command execution
is incomplete: Slave SQL thread got the stop signal, thread is busy, SQL
thread will stop once the current task is complete.
|
1876 | HY000 | ER_STOP_SLAVE_IO_THREAD_TIMEOUT | STOP SLAVE command execution is
incomplete: Slave IO thread got the stop signal, thread is busy, IO thread
will stop once the current task is complete.
|
1877 | HY000 | ER_TABLE_CORRUPT | Operation cannot be performed. The table
'%s.%s' is missing, corrupt or contains bad data.
|
1878 | HY000 | ER_TEMP_FILE_WRITE_FAILURE | Temporary file write failure.
|
1879 | HY000 | ER_INNODB_FT_AUX_NOT_HEX_ID | Upgrade index name failed, please
use create index(alter table) algorithm copy to rebuild index.
|
1880 | | ER_LAST_MYSQL_ERROR_MESSAGE | "
|
MariaDB-specific error codes
|
Error Code | SQLSTATE | Error | Description
|
1900 | | ER_UNUSED_18 | "
|
1901 | | ER_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED | Function or expression
'%s' cannot be used in the %s clause of %`s
|
1902 | | ER_UNUSED_19 | "
|
1903 | | ER_PRIMARY_KEY_BASED_ON_GENERATED_COLUMN | Primary key cannot be defined upon a generated column
|
1904 | | ER_KEY_BASED_ON_GENERATED_VIRTUAL_COLUMN | Key/Index cannot be defined on a virtual generated column
|
1905 | | ER_WRONG_FK_OPTION_FOR_GENERATED_COLUMN | Cannot define foreign key with %s clause on a generated column
|
1906 | | ER_WARNING_NON_DEFAULT_VALUE_FOR_GENERATED_COLUMN | The value specified for generated column '%s' in table '%s' has been ignored
|
1907 | | ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN | This is not yet supported for generated columns
|
1908 | | ER_UNUSED_20 | "
|
1909 | | ER_UNUSED_21 | "
|
1910 | | ER_UNSUPPORTED_ENGINE_FOR_GENERATED_COLUMNS | %s storage engine does not support generated columns
|
1911 | | ER_UNKNOWN_OPTION | Unknown option '%-.64s'
|
1912 | | ER_BAD_OPTION_VALUE | Incorrect value '%-.64s' for option '%-.64s'
|
1913 | | ER_UNUSED_6 | You should never see it
|
1914 | | ER_UNUSED_7 | You should never see it
|
1915 | | ER_UNUSED_8 | You should never see it
|
1916 | | ER_DATA_OVERFLOW 22003 | Got overflow when converting '%-.128s' to %-.32s. Value truncated.
|
1917 | | ER_DATA_TRUNCATED 22003 | Truncated value '%-.128s' when converting to %-.32s
|
1918 | | ER_BAD_DATA 22007 | Encountered illegal value '%-.128s' when converting to %-.32s
|
1919 | | ER_DYN_COL_WRONG_FORMAT | Encountered illegal format of dynamic column string
|
1920 | | ER_DYN_COL_IMPLEMENTATION_LIMIT | Dynamic column implementation limit reached
|
1921 | | ER_DYN_COL_DATA 22007 | Illegal value used as argument of dynamic column function
|
1922 | | ER_DYN_COL_WRONG_CHARSET | Dynamic column contains unknown character set
|
1923 | | ER_ILLEGAL_SUBQUERY_OPTIMIZER_SWITCHES | At least one of the 'in_to_exists' or 'materialization' optimizer_switch flags must be 'on'.
|
1924 | | ER_QUERY_CACHE_IS_DISABLED | Query cache is disabled (resize or similar command in progress); repeat this command later
|
1925 | | ER_QUERY_CACHE_IS_GLOBALY_DISABLED | Query cache is globally disabled and you can't enable it only for this session
|
1926 | | ER_VIEW_ORDERBY_IGNORED | View '%-.192s'.'%-.192s' ORDER BY clause ignored because there is other ORDER BY clause already.
|
1927 | 70100 | ER_CONNECTION_KILLED | Connection was killed
|
1928 | | ER_UNUSED_11 | You should never see it
|
1929 | | ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_SKIP_REPLICATION | Cannot modify @@session.skip_replication inside a transaction
|
1930 | | ER_STORED_FUNCTION_PREVENTS_SWITCH_SKIP_REPLICATION | Cannot modify @@session.skip_replication inside a stored function or trigger
|
1931 | | ER_QUERY_RESULT_INCOMPLETE | Query execution was interrupted. The query exceeded %s %llu. The query result may be incomplete
|
1932 | | ER_NO_SUCH_TABLE_IN_ENGINE 42S02 | Table '%-.192s.%-.192s' doesn't exist in engine
|
1933 | | ER_TARGET_NOT_EXPLAINABLE | Target is not running an EXPLAINable command
|
1934 | | ER_CONNECTION_ALREADY_EXISTS | Connection '%.*s' conflicts with existing connection '%.*s'
|
1935 | | ER_MASTER_LOG_PREFIX | Master '%.*s':
|
1936 | | ER_CANT_START_STOP_SLAVE | Can't %s SLAVE '%.*s'
|
1937 | | ER_SLAVE_STARTED | SLAVE '%.*s' started
|
1938 | | ER_SLAVE_STOPPED | SLAVE '%.*s' stopped
|
1939 | | ER_SQL_DISCOVER_ERROR | Engine %s failed to discover table %`-.192s.%`-.192s with '%s'
|
1940 | | ER_FAILED_GTID_STATE_INIT | Failed initializing replication GTID state
|
1941 | | ER_INCORRECT_GTID_STATE | Could not parse GTID list
|
1942 | | ER_CANNOT_UPDATE_GTID_STATE | Could not update replication slave gtid state
|
1943 | | ER_DUPLICATE_GTID_DOMAIN | GTID %u-%u-%llu and %u-%u-%llu conflict (duplicate domain id %u)
|
1944 | | ER_GTID_OPEN_TABLE_FAILED | Failed to open %s.%s
|
1945 | | ER_GTID_POSITION_NOT_FOUND_IN_BINLOG | Connecting slave requested to start from GTID %u-%u-%llu, which is not in the master's binlog
|
1946 | | ER_CANNOT_LOAD_SLAVE_GTID_STATE | Failed to load replication slave GTID position from table %s.%s
|
1947 | | ER_MASTER_GTID_POS_CONFLICTS_WITH_BINLOG | Specified GTID %u-%u-%llu conflicts with the binary log which contains a more recent GTID %u-%u-%llu. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos.
|
1948 | | ER_MASTER_GTID_POS_MISSING_DOMAIN | Specified value for @@gtid_slave_pos contains no value for replication domain %u. This conflicts with the binary log which contains GTID %u-%u-%llu. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos.
|
1949 | | ER_UNTIL_REQUIRES_USING_GTID | START SLAVE UNTIL master_gtid_pos requires that slave is using GTID
|
1950 | | ER_GTID_STRICT_OUT_OF_ORDER | An attempt was made to binlog GTID %u-%u-%llu which would create an out-of-order sequence number with existing GTID %u-%u-%llu, and gtid strict mode is enabled.
|
1951 | | ER_GTID_START_FROM_BINLOG_HOLE | The binlog on the master is missing the GTID %u-%u-%llu requested by the slave (even though a subsequent sequence number does exist), and GTID strict mode is enabled
|
1952 | | ER_SLAVE_UNEXPECTED_MASTER_SWITCH | Unexpected GTID received from master after reconnect. This normally indicates that the master server was replaced without restarting the slave threads. %s
|
1953 | | ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_GTID_DOMAIN_ID_SEQ_NO | Cannot modify @@session.gtid_domain_id or @@session.gtid_seq_no inside a transaction
|
1954 | | ER_STORED_FUNCTION_PREVENTS_SWITCH_GTID_DOMAIN_ID_SEQ_NO | Cannot modify @@session.gtid_domain_id or @@session.gtid_seq_no inside a stored function or trigger
|
1955 | | ER_GTID_POSITION_NOT_FOUND_IN_BINLOG2 | Connecting slave requested to start from GTID %u-%u-%llu, which is not in the master's binlog. Since the master's binlog contains GTIDs with higher sequence numbers, it probably means that the slave has diverged due to executing extra errorneous transactions
|
1956 | | ER_BINLOG_MUST_BE_EMPTY | This operation is not allowed if any GTID has been logged to the binary log. Run RESET MASTER first to erase the log
|
1957 | | ER_NO_SUCH_QUERY | Unknown query id: %lld
|
1958 | | ER_BAD_BASE64_DATA | Bad base64 data as position %u
|
1959 | | ER_INVALID_ROLE | Invalid role specification %`s.
|
1960 | | ER_INVALID_CURRENT_USER | The current user is invalid.
|
1961 | | ER_CANNOT_GRANT_ROLE | Cannot grant role '%s' to: %s.
|
1962 | | ER_CANNOT_REVOKE_ROLE | Cannot revoke role '%s' from: %s.
|
1963 | | ER_CHANGE_SLAVE_PARALLEL_THREADS_ACTIVE | Cannot change @@slave_parallel_threads while another change is in progress
|
1964 | | ER_PRIOR_COMMIT_FAILED | Commit failed due to failure of an earlier commit on which this one depends
|
1965 | | ER_IT_IS_A_VIEW | '%-.192s' is a view
|
1966 | | ER_SLAVE_SKIP_NOT_IN_GTID | When using GTID, @@sql_slave_skip_counter can not be used. Instead, setting @@gtid_slave_pos explicitly can be used to skip to after a given GTID position.
|
1967 | | ER_TABLE_DEFINITION_TOO_BIG | The definition for table %`s is too big
|
1968 | | ER_PLUGIN_INSTALLED | Plugin '%-.192s' already installed
|
1969 | | ER_STATEMENT_TIMEOUT | Query execution was interrupted (max_statement_time exceeded)
|
1970 | | ER_SUBQUERIES_NOT_SUPPORTED | %s does not support subqueries or stored functions.
|
1971 | | ER_SET_STATEMENT_NOT_SUPPORTED | The system variable %.200s cannot be set in SET STATEMENT.
|
1972 | | ER_UNUSED_9 | You should never see it
|
1973 | | ER_USER_CREATE_EXISTS | Can't create user '%-.64s'@'%-.64s'; it already exists
|
1974 | | ER_USER_DROP_EXISTS | Can't drop user '%-.64s'@'%-.64s'; it doesn't exist
|
1975 | | ER_ROLE_CREATE_EXISTS | Can't create role '%-.64s'; it already exists
|
1976 | | ER_ROLE_DROP_EXISTS | Can't drop role '%-.64s'; it doesn't exist
|
1977 | | ER_CANNOT_CONVERT_CHARACTER | Cannot convert '%s' character 0x%-.64s to '%s'
|
1978 | | ER_INVALID_DEFAULT_VALUE_FOR_FIELD | Incorrect default value '%-.128s' for column '%.192s'
|
1979 | | ER_KILL_QUERY_DENIED_ERROR | You are not owner of query %lu
|
1980 | | ER_NO_EIS_FOR_FIELD | Engine-independent statistics are not collected for column '%s'
|
1981 | | ER_WARN_AGGFUNC_DEPENDENCE | Aggregate function '%-.192s)' of SELECT #%d belongs to SELECT #%d
|
1982 | | WARN_INNODB_PARTITION_OPTION_IGNORED | <%-.64s> option ignored for InnoDB partition
|
Error Code | SQLSTATE | Error | Description
|
3000 | | ER_FILE_CORRUPT | File %s is corrupted
|
3001 | | ER_ERROR_ON_MASTER | Query partially completed on the master (error on master: %d) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;. Query:'%s'"
|
3002 | | ER_INCONSISTENT_ERROR | Query caused different errors on master and
slave. Error on master: message (format)='%s' error code=%d; Error on
slave:actual message='%s', error code=%d. Default database:'%s'. Query:'%s'
|
3003 | | ER_STORAGE_ENGINE_NOT_LOADED | Storage engine for table '%s'.'%s' is
not loaded.
|
3004 | | ER_GET_STACKED_DA_WITHOUT_ACTIVE_HANDLER 0Z002 | GET STACKED
DIAGNOSTICS when handler not active
|
3005 | | ER_WARN_LEGACY_SYNTAX_CONVERTED | %s is no longer supported. The
statement was converted to %s.
|
3006 | | ER_BINLOG_UNSAFE_FULLTEXT_PLUGIN | Statement is unsafe because it uses
a fulltext parser plugin which may not return the same value on the slave.
|
3007 | | ER_CANNOT_DISCARD_TEMPORARY_TABLE | Cannot DISCARD/IMPORT tablespace
associated with temporary table
|
3008 | | ER_FK_DEPTH_EXCEEDED | Foreign key cascade delete/update exceeds max
depth of %d.
|
3009 | | ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE_V2 | Column count of %s.%s is
wrong. Expected %d, found %d. Created with MariaDB %d, now running %d.
Please use mysql_upgrade to fix this error.
|
3010 | | ER_WARN_TRIGGER_DOESNT_HAVE_CREATED | Trigger %s.%s.%s does not have
CREATED attribute.
|
3011 | | ER_REFERENCED_TRG_DOES_NOT_EXIST_MYSQL | Referenced trigger '%s' for
the given action time and event type does not exist.
|
3012 | | ER_EXPLAIN_NOT_SUPPORTED | EXPLAIN FOR CONNECTION command is supported
only for SELECT/UPDATE/INSERT/DELETE/REPLACE
|
3013 | | ER_INVALID_FIELD_SIZE | Invalid size for column '%-.192s'.
|
3014 | | ER_MISSING_HA_CREATE_OPTION | Table storage engine '%-.64s' found
required create option missing
|
3015 | | ER_ENGINE_OUT_OF_MEMORY | Out of memory in storage engine '%-.64s'.
|
3016 | | ER_PASSWORD_EXPIRE_ANONYMOUS_USER | The password for anonymous user
cannot be expired.
|
3017 | | ER_SLAVE_SQL_THREAD_MUST_STOP | This operation cannot be performed
with a running slave sql thread; run STOP SLAVE SQL_THREAD first
|
3018 | | ER_NO_FT_MATERIALIZED_SUBQUERY | Cannot create FULLTEXT index on
materialized subquery
|
3019 | | ER_INNODB_UNDO_LOG_FULL | Undo Log error: %s
|
3020 | | ER_INVALID_ARGUMENT_FOR_LOGARITHM | Invalid argument for logarithm
|
3021 | | ER_SLAVE_CHANNEL_IO_THREAD_MUST_STOP | This operation cannot be
performed with a running slave io thread; run STOP SLAVE IO_THREAD FOR
CHANNEL '%s' first.
|
3022 | | ER_WARN_OPEN_TEMP_TABLES_MUST_BE_ZERO | This operation may not be safe
when the slave has temporary tables. The tables will be kept open until the
server restarts or until the tables are deleted by any replicated DROP
statement. Suggest to wait until slave_open_temp_tables = 0.
|
3023 | | ER_WARN_ONLY_MASTER_LOG_FILE_NO_POS | CHANGE MASTER TO with a
MASTER_LOG_FILE clause but no MASTER_LOG_POS clause may not be safe. The old
position value may not be valid for the new binary log file.
|
3024 | | ER_QUERY_TIMEOUT | Query execution was interrupted, maximum statement
execution time exceeded
|
3025 | | ER_NON_RO_SELECT_DISABLE_TIMER | Select is not a read only statement,
disabling timer
|
3026 | | ER_DUP_LIST_ENTRY | Duplicate entry '%-.192s'.
|
3027 | | ER_SQL_MODE_NO_EFFECT | '%s' mode no longer has any effect. Use
STRICT_ALL_TABLES or STRICT_TRANS_TABLES instead.
|
3028 | | ER_AGGREGATE_ORDER_FOR_UNION | Expression #%u of ORDER BY contains
aggregate function and applies to a UNION
|
3029 | | ER_AGGREGATE_ORDER_NON_AGG_QUERY | Expression #%u of ORDER BY contains
aggregate function and applies to the result of a non-aggregated query
|
3030 | | ER_SLAVE_WORKER_STOPPED_PREVIOUS_THD_ERROR | Slave worker has stopped
after at least one previous worker encountered an error when slave-preserve
-commit-order was enabled. To preserve commit order, the last transaction
executed by this thread has not been committed. When restarting the slave
after fixing any failed threads, you should fix this worker as well.
|
3031 | | ER_DONT_SUPPORT_SLAVE_PRESERVE_COMMIT_ORDER |
slave_preserve_commit_order is not supported %s.
|
3032 | | ER_SERVER_OFFLINE_MODE | The server is currently in offline mode
|
3033 | | ER_GIS_DIFFERENT_SRIDS | Binary geometry function %s given two
geometries of different srids: %u and %u, which should have been identical.
|
3034 | | ER_GIS_UNSUPPORTED_ARGUMENT | Calling geometry function %s with
unsupported types of arguments.
|
3035 | | ER_GIS_UNKNOWN_ERROR | Unknown GIS error occurred in function %s.
|
3036 | | ER_GIS_UNKNOWN_EXCEPTION | Unknown exception caught in GIS function
%s.
|
3037 | | ER_GIS_INVALID_DATA | Invalid GIS data provided to function %s.
|
3038 | | ER_BOOST_GEOMETRY_EMPTY_INPUT_EXCEPTION | The geometry has no data in
function %s.
|
3039 | | ER_BOOST_GEOMETRY_CENTROID_EXCEPTION | Unable to calculate centroid
because geometry is empty in function %s.
|
3040 | | ER_BOOST_GEOMETRY_OVERLAY_INVALID_INPUT_EXCEPTION | Geometry overlay
calculation error: geometry data is invalid in function %s.
|
3041 | | ER_BOOST_GEOMETRY_TURN_INFO_EXCEPTION | Geometry turn info calculation
error: geometry data is invalid in function %s.
|
3042 | | ER_BOOST_GEOMETRY_SELF_INTERSECTION_POINT_EXCEPTION | Analysis
procedures of intersection points interrupted unexpectedly in function %s.
|
3043 | | ER_BOOST_GEOMETRY_UNKNOWN_EXCEPTION | Unknown exception thrown in
function %s.
|
3044 | | ER_STD_BAD_ALLOC_ERROR | Memory allocation error: %-.256s in function
%s.
|
3045 | | ER_STD_DOMAIN_ERROR | Domain error: %-.256s in function %s.
|
3046 | | ER_STD_LENGTH_ERROR | Length error: %-.256s in function %s.
|
3047 | | ER_STD_INVALID_ARGUMENT | Invalid argument error: %-.256s in function
%s.
|
3048 | | ER_STD_OUT_OF_RANGE_ERROR | Out of range error: %-.256s in function
%s.
|
3049 | | ER_STD_OVERFLOW_ERROR | Overflow error error: %-.256s in function %s.
|
3050 | | ER_STD_RANGE_ERROR | Range error: %-.256s in function %s.
|
3051 | | ER_STD_UNDERFLOW_ERROR | Underflow error: %-.256s in function %s.
|
3052 | | ER_STD_LOGIC_ERROR | Logic error: %-.256s in function %s.
|
3053 | | ER_STD_RUNTIME_ERROR | Runtime error: %-.256s in function %s.
|
3054 | | ER_STD_UNKNOWN_EXCEPTION | Unknown exception: %-.384s in function %s.
|
3055 | | ER_GIS_DATA_WRONG_ENDIANESS | Geometry byte string must be little
endian.
|
3056 | | ER_CHANGE_MASTER_PASSWORD_LENGTH | The password provided for the
replication user exceeds the maximum length of 32 characters
|
3057 | 42000 | ER_USER_LOCK_WRONG_NAME | Incorrect user-level lock name '%
-.192s'.
|
3058 | | ER_USER_LOCK_DEADLOCK | Deadlock found when trying to get user-level
lock; try rolling back transaction/releasing locks and restarting lock
acquisition.
|
3059 | | ER_REPLACE_INACCESSIBLE_ROWS | REPLACE cannot be executed as it
requires deleting rows that are not in the view
|
3060 | | ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_GIS | Do not support online
operation on table with GIS index
|
Error Code | SQLSTATE | Error | Description
|
4000 | 0A000 | ER_COMMULTI_BADCONTEXT | COM_MULTI can't return a result set in
the given context
|
4001 | | ER_BAD_COMMAND_IN_MULTI | Command '%s' is not allowed for COM_MULTI
|
4002 | | ER_WITH_COL_WRONG_LIST | WITH column list and SELECT field list have
different column counts
|
4003 | | ER_TOO_MANY_DEFINITIONS_IN_WITH_CLAUSE | Too many WITH elements in
WITH clause
|
4004 | | ER_DUP_QUERY_NAME | Duplicate query name %`-.64s in WITH clause
|
4005 | | ER_RECURSIVE_WITHOUT_ANCHORS | No anchors for recursive WITH element
'%s'
|
4006 | | ER_UNACCEPTABLE_MUTUAL_RECURSION | Unacceptable mutual recursion with
anchored table '%s'
|
4007 | | ER_REF_TO_RECURSIVE_WITH_TABLE_IN_DERIVED | Reference to recursive
WITH table '%s' in materialized derived
|
4008 | | ER_NOT_STANDARD_COMPLIANT_RECURSIVE | Restrictions imposed on
recursive definitions are violated for table '%s'"R_WRONG_WINDOW_SPEC_NAME
|
4009 | | ER_WRONG_WINDOW_SPEC_NAME | Window specification with name '%s' is not defined
|
4010 | | ER_DUP_WINDOW_NAME | Multiple window specifications with the same name '%s'
|
4011 | | ER_PARTITION_LIST_IN_REFERENCING_WINDOW_SPEC | Window specification referencing another one '%s' cannot contain partition list
|
4012 | | ER_ORDER_LIST_IN_REFERENCING_WINDOW_SPEC | Referenced window specification '%s' already contains order list
|
4013 | | ER_WINDOW_FRAME_IN_REFERENCED_WINDOW_SPEC | Referenced window specification '%s' cannot contain window frame
|
4014 | | ER_BAD_COMBINATION_OF_WINDOW_FRAME_BOUND_SPECS | Unacceptable combination of window frame bound specifications
|
4015 | | ER_WRONG_PLACEMENT_OF_WINDOW_FUNCTION | Window function is allowed only in SELECT list and ORDER BY clause
|
4016 | | ER_WINDOW_FUNCTION_IN_WINDOW_SPEC | Window function is not allowed in window specification
|
4017 | | ER_NOT_ALLOWED_WINDOW_FRAME | Window frame is not allowed with '%s'
|
4018 | | ER_NO_ORDER_LIST_IN_WINDOW_SPEC | No order list in window specification for '%s'
|
4019 | | ER_RANGE_FRAME_NEEDS_SIMPLE_ORDERBY | RANGE-type frame requires ORDER BY clause with single sort key
|
4020 | | ER_WRONG_TYPE_FOR_ROWS_FRAME | Integer is required for ROWS-type frame
|
4021 | | ER_WRONG_TYPE_FOR_RANGE_FRAME | Numeric datatype is required for RANGE-type frame
|
4022 | | ER_FRAME_EXCLUSION_NOT_SUPPORTED | Frame exclusion is not supported yet
|
4023 | | ER_WINDOW_FUNCTION_DONT_HAVE_FRAME | This window function may not have a window frame
|
4024 | | ER_INVALID_NTILE_ARGUMENT | Argument of NTILE must be greater than 0
|
4025 | 23000 | ER_CONSTRAINT_FAILED | CONSTRAINT %`s failed for %`-.192s.%`-.192s
|
4026 | | ER_EXPRESSION_IS_TOO_BIG | Expression in the %s clause is too big
|
4027 | | ER_ERROR_EVALUATING_EXPRESSION | Got an error evaluating stored expression %s
|
4028 | | ER_CALCULATING_DEFAULT_VALUE | Got an error when calculating default value for %`s
|
4029 | | ER_EXPRESSION_REFERS_TO_UNINIT_FIELD | Expression for field %`-.64s is referring to uninitialized field %`s
|
4030 | | ER_PARTITION_DEFAULT_ERROR | Only one DEFAULT partition allowed
|
4031 | | ER_REFERENCED_TRG_DOES_NOT_EXIST | Referenced trigger '%s' for the given action time and event type does not exist
|
4032 | | ER_INVALID_DEFAULT_PARAM | Default/ignore value is not supported for such parameter usage
|
4033 | | ER_BINLOG_NON_SUPPORTED_BULK | Only row based replication supported for bulk operations
|
4034 | | ER_BINLOG_UNCOMPRESS_ERROR | Uncompress the compressed binlog failed
|
4035 | | ER_JSON_BAD_CHR | Broken JSON string in argument %d to function '%s' at position %d
|
4036 | | ER_JSON_NOT_JSON_CHR | Character disallowed in JSON in argument %d to function '%s' at position %d
|
4037 | | ER_JSON_EOS | Unexpected end of JSON text in argument %d to function '%s'
|
4038 | | ER_JSON_SYNTAX | Syntax error in JSON text in argument %d to function '%s' at position %d
|
4039 | | ER_JSON_ESCAPING | Incorrect escaping in JSON text in argument %d to function '%s' at position %d
|
4040 | | ER_JSON_DEPTH | Limit of %d on JSON nested strucures depth is reached in argument %d to function '%s' at position %d
|
4041 | | ER_JSON_PATH_EOS | Unexpected end of JSON path in argument %d to function '%s'
|
4042 | | ER_JSON_PATH_SYNTAX | Syntax error in JSON path in argument %d to function '%s' at position %d
|
4043 | | ER_JSON_PATH_DEPTH | Limit of %d on JSON path depth is reached in argument %d to function '%s' at position %d
|
4044 | | ER_JSON_PATH_NO_WILDCARD | Wildcards in JSON path not allowed in argument %d to function '%s'
|
4045 | | ER_JSON_PATH_ARRAY | JSON path should end with an array identifier in argument %d to function '%s'
|
4046 | | ER_JSON_ONE_OR_ALL | Argument 2 to function '%s' must be "one" or "all".
|
4047 | | ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE | CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
|
4048 | | ER_GEOJSON_INCORRECT | Incorrect GeoJSON format specified for st_geomfromgeojson function.
|
4049 | | ER_GEOJSON_TOO_FEW_POINTS | Incorrect GeoJSON format - too few points for linestring specified.
|
4050 | | ER_GEOJSON_NOT_CLOSED | Incorrect GeoJSON format - polygon not closed.
|
4051 | | ER_JSON_PATH_EMPTY | Path expression '$' is not allowed in argument %d to function '%s'.
|
4052 | | ER_SLAVE_SAME_ID | A slave with the same server_uuid/server_id as this slave has connected to the master
|
4053 | | ER_FLASHBACK_NOT_SUPPORTED | Flashback does not support %s %s
|
4054 | | ER_KEYS_OUT_OF_ORDER | Keys are out order during bulk load
|
4055 | | ER_OVERLAPPING_KEYS | Bulk load rows overlap existing rows
|
4056 | | ER_REQUIRE_ROW_BINLOG_FORMAT | Can't execute updates on master with binlog_format != ROW.
|
4057 | | ER_ISOLATION_MODE_NOT_SUPPORTED | MyRocks supports only READ COMMITTED and REPEATABLE READ isolation levels. Please change from current isolation level %s
|
4058 | | ER_ON_DUPLICATE_DISABLED | When unique checking is disabled in MyRocks, INSERT,UPDATE,LOAD statements with clauses that update or replace the key (i.e. INSERT ON DUPLICATE KEY UPDATE, REPLACE) are not allowed. Query: %s
|
4059 | | ER_UPDATES_WITH_CONSISTENT_SNAPSHOT | Can't execute updates when you started a transaction with START TRANSACTION WITH CONSISTENT [ROCKSDB] SNAPSHOT.
|
4060 | | ER_ROLLBACK_ONLY | This transaction was rolled back and cannot be committed. Only supported operation is to roll it back, so all pending changes will be discarded. Please restart another transaction.
|
4061 | | ER_ROLLBACK_TO_SAVEPOINT | MyRocks currently does not support ROLLBACK TO SAVEPOINT if modifying rows.
|
4062 | | ER_ISOLATION_LEVEL_WITH_CONSISTENT_SNAPSHOT | Only REPEATABLE READ isolation level is supported for START TRANSACTION WITH CONSISTENT SNAPSHOT in RocksDB Storage Engine.
|
4063 | | ER_UNSUPPORTED_COLLATION | Unsupported collation on string indexed column %s.%s Use binary collation (%s).
|
4064 | | ER_METADATA_INCONSISTENCY | Table '%s' does not exist, but metadata information exists inside MyRocks. This is a sign of data inconsistency. Please check if '%s.frm' exists, and try to restore it if it does not exist.
|
4065 | | ER_CF_DIFFERENT | Column family ('%s') flag (%d) is different from an existing flag (%d). Assign a new CF flag, or do not change existing CF flag.
|
4066 | | ER_RDB_TTL_DURATION_FORMAT | TTL duration (%s) in MyRocks must be an unsigned non-null 64-bit integer.
|
4067 | | ER_RDB_STATUS_GENERAL | Status error %d received from RocksDB: %s
|
4068 | | ER_RDB_STATUS_MSG | %s, Status error %d received from RocksDB: %s
|
4069 | | ER_RDB_TTL_UNSUPPORTED | TTL support is currently disabled when table has a hidden PK.
|
4070 | | ER_RDB_TTL_COL_FORMAT | TTL column (%s) in MyRocks must be an unsigned non-null 64-bit integer, exist inside the table, and have an accompanying ttl duration.
|
4071 | | ER_PER_INDEX_CF_DEPRECATED | The per-index column family option has been deprecated
|
4072 | | ER_KEY_CREATE_DURING_ALTER | MyRocks failed creating new key definitions during alter.
|
4073 | | ER_SK_POPULATE_DURING_ALTER | MyRocks failed populating secondary key during alter.
|
4074 | | ER_SUM_FUNC_WITH_WINDOW_FUNC_AS_ARG | Window functions can not be used as arguments to group functions.
|
4075 | | ER_NET_OK_PACKET_TOO_LARGE | OK packet too large
|
4076 | | ER_GEOJSON_EMPTY_COORDINATES | Incorrect GeoJSON format - empty 'coordinates' array.
|
4077 | | ER_MYROCKS_CANT_NOPAD_COLLATION | MyRocks doesn't currently support collations with \"No pad\" attribute.
|
4078 | | ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION | Illegal parameter data types %s and %s for operation '%s'
|
4079 | | ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION | Illegal parameter data type %s for operation '%s'
|
4080 | | ER_WRONG_PARAMCOUNT_TO_CURSOR | Incorrect parameter count to cursor '%-.192s'
|
4081 | | ER_UNKNOWN_STRUCTURED_VARIABLE | Unknown structured system variable or ROW routine variable '%-.*s'
|
4082 | | ER_ROW_VARIABLE_DOES_NOT_HAVE_FIELD | Row variable '%-.192s' does not have a field '%-.192s'
|
4083 | | ER_END_IDENTIFIER_DOES_NOT_MATCH | END identifier '%-.192s' does not match '%-.192s'
|
4084 | | ER_SEQUENCE_RUN_OUT | Sequence '%-.64s.%-.64s' has run out
|
4085 | | ER_SEQUENCE_INVALID_DATA | Sequence '%-.64s.%-.64s' values are conflicting
|
4086 | | ER_SEQUENCE_INVALID_TABLE_STRUCTURE | Sequence '%-.64s.%-.64s' table structure is invalid (%s)
|
4087 | | ER_SEQUENCE_ACCESS_ERROR | Sequence '%-.64s.%-.64s' access error
|
4088 | | ER_SEQUENCE_BINLOG_FORMAT | Sequences requires binlog_format mixed or row
|
4089 | | ER_NOT_SEQUENCE | '%-.64s.%-.64s' is not a SEQUENCE
|
4090 | | ER_NOT_SEQUENCE2 | '%-.192s' is not a SEQUENCE
|
4091 | | ER_UNKNOWN_SEQUENCES | Unknown SEQUENCE: '%-.300s'
|
4092 | | ER_UNKNOWN_VIEW | Unknown VIEW: '%-.300s'
|
4093 | | ER_WRONG_INSERT_INTO_SEQUENCE | Wrong INSERT into a SEQUENCE. One can only do single table INSERT into a sequence object (like with mysqldump). If you want to change the SEQUENCE, use ALTER SEQUENCE instead.
|
4094 | | ER_SP_STACK_TRACE | At line %u in %s
|
4095 | | ER_PACKAGE_ROUTINE_IN_SPEC_NOT_DEFINED_IN_BODY | Subroutine '%-.192s' is declared in the package specification but is not defined in the package body
|
4096 | | ER_PACKAGE_ROUTINE_FORWARD_DECLARATION_NOT_DEFINED | Subroutine '%-.192s' has a forward declaration but is not defined
|
4097 | | ER_COMPRESSED_COLUMN_USED_AS_KEY | Compressed column '%-.192s' can't be used in key specification
|
4098 | | ER_UNKNOWN_COMPRESSION_METHOD | Unknown compression method: %s
|
4099 | | ER_WRONG_NUMBER_OF_VALUES_IN_TVC | The used table value constructor has a different number of values
|
Error Code | SQLSTATE | Error | Description
|
4100 | | ER_FIELD_REFERENCE_IN_TVC | Field reference '%-.192s' can't be used in table value constructor
|
4101 | | ER_WRONG_TYPE_FOR_PERCENTILE_FUNC | Numeric datatype is required for %s function
|
4102 | | ER_ARGUMENT_NOT_CONSTANT | Argument to the %s function is not a constant for a partition
|
4103 | | ER_ARGUMENT_OUT_OF_RANGE | Argument to the %s function does not belong to the range [0,1]
|
4104 | | ER_WRONG_TYPE_OF_ARGUMENT | %s function only accepts arguments that can be converted to numerical types
|
4105 | | ER_NOT_AGGREGATE_FUNCTION | Aggregate specific instruction (FETCH GROUP NEXT ROW) used in a wrong context
|
4106 | | ER_INVALID_AGGREGATE_FUNCTION | Aggregate specific instruction(FETCH GROUP NEXT ROW) missing from the aggregate function
|
4107 | | ER_INVALID_VALUE_TO_LIMIT | Limit only accepts integer values
|
4108 | | ER_INVISIBLE_NOT_NULL_WITHOUT_DEFAULT | Invisible column %`s must have a default value
|
4109 | | ER_UPDATE_INFO_WITH_SYSTEM_VERSIONING | Rows matched: %ld Changed: %ld Inserted: %ld Warnings: %ld
|
4110 | | ER_VERS_FIELD_WRONG_TYPE | %`s must be of type %s for system-versioned table %`s
|
4111 | | ER_VERS_ENGINE_UNSUPPORTED | Transaction-precise system versioning for %`s is not supported
|
4112 | | ER_UNUSED_23 | You should never see it
|
4113 | | ER_PARTITION_WRONG_TYPE | Wrong partitioning type, expected type: %`s
|
4114 | | WARN_VERS_PART_FULL | Versioned table %`s.%`s: last HISTORY partition (%`s) is out of %s, need more HISTORY partitions
|
4115 | | WARN_VERS_PARAMETERS | Maybe missing parameters: %s
|
4116 | | ER_VERS_DROP_PARTITION_INTERVAL | Can only drop oldest partitions when rotating by INTERVAL
|
4117 | | ER_UNUSED_25 | You should never see it
|
4118 | | WARN_VERS_PART_NON_HISTORICAL | Partition %`s contains non-historical data
|
4119 | | ER_VERS_ALTER_NOT_ALLOWED | Not allowed for system-versioned %`s.%`s. Change @@system_versioning_alter_history to proceed with ALTER.
|
4120 | | ER_VERS_ALTER_ENGINE_PROHIBITED | Not allowed for system-versioned %`s.%`s. Change to/from native system versioning engine is not supported.
|
4121 | | ER_VERS_RANGE_PROHIBITED | SYSTEM_TIME range selector is not allowed
|
4122 | | ER_CONFLICTING_FOR_SYSTEM_TIME | Conflicting FOR SYSTEM_TIME clauses in WITH RECURSIVE
|
4123 | | ER_VERS_TABLE_MUST_HAVE_COLUMNS | Table %`s must have at least one versioned column
|
4124 | | ER_VERS_NOT_VERSIONED | Table %`s is not system-versioned
|
4125 | | ER_MISSING | Wrong parameters for %`s: missing '%s'
|
4126 | | ER_VERS_PERIOD_COLUMNS | PERIOD FOR SYSTEM_TIME must use columns %`s and %`s
|
4127 | | ER_PART_WRONG_VALUE | Wrong parameters for partitioned %`s: wrong value for '%s'
|
4128 | | ER_VERS_WRONG_PARTS | Wrong partitions for %`s: must have at least one HISTORY and exactly one last CURRENT
|
4129 | | ER_VERS_NO_TRX_ID | TRX_ID %llu not found in `mysql.transaction_registry`
|
4130 | | ER_VERS_ALTER_SYSTEM_FIELD | Can not change system versioning field %`s
|
4131 | | ER_DROP_VERSIONING_SYSTEM_TIME_PARTITION | Can not DROP SYSTEM VERSIONING for table %`s partitioned BY SYSTEM_TIME
|
4132 | | ER_VERS_DB_NOT_SUPPORTED | System-versioned tables in the %`s database are not supported
|
4133 | | ER_VERS_TRT_IS_DISABLED | Transaction registry is disabled
|
4134 | | ER_VERS_DUPLICATE_ROW_START_END | Duplicate ROW %s column %`s
|
4135 | | ER_VERS_ALREADY_VERSIONED | Table %`s is already system-versioned
|
4136 | | ER_UNUSED_24 | You should never see it
|
4137 | | ER_VERS_NOT_SUPPORTED | System-versioned tables do not support %s
|
4138 | | ER_VERS_TRX_PART_HISTORIC_ROW_NOT_SUPPORTED | Transaction-precise system-versioned tables do not support partitioning by ROW START or ROW END
|
4139 | | ER_INDEX_FILE_FULL | The index file for table '%-.192s' is full
|
4140 | | ER_UPDATED_COLUMN_ONLY_ONCE | The column %`s.%`s cannot be changed more than once in a single UPDATE statement
|
4141 | | ER_EMPTY_ROW_IN_TVC | Row with no elements is not allowed in table value constructor in this context
|
4142 | | ER_VERS_QUERY_IN_PARTITION | SYSTEM_TIME partitions in table %`s does not support historical query
|
4143 | | ER_KEY_DOESNT_SUPPORT | %s index %`s does not support this operation
|
4144 | | ER_ALTER_OPERATION_TABLE_OPTIONS_NEED_REBUILD | Changing table options requires the table to be rebuilt
|
4145 | | ER_BACKUP_LOCK_IS_ACTIVE | Can't execute the command as you have a BACKUP STAGE active
|
4146 | | ER_BACKUP_NOT_RUNNING | You must start backup with \"BACKUP
STAGE START\"
|
4147 | | ER_BACKUP_WRONG_STAGE | Backup stage '%s' is same or before current backup stage '%s'
|
4148 | | ER_BACKUP_STAGE_FAILED | Backup stage '%s' failed
|
4149 | | ER_BACKUP_UNKNOWN_STAGE | Unknown backup stage: '%s'. Stage should be one of START, FLUSH, BLOCK_DDL, BLOCK_COMMIT or END
|
4150 | | ER_USER_IS_BLOCKED | User is blocked because of too many credential errors; unblock with 'FLUSH PRIVILEGES'
|
4151 | | ER_ACCOUNT_HAS_BEEN_LOCKED | Access denied, this account is locked
|
4152 | | ER_PERIOD_TEMPORARY_NOT_ALLOWED | Application-time period table cannot be temporary
|
4153 | | ER_PERIOD_TYPES_MISMATCH | Fields of PERIOD FOR %`s have different types
|
4154 | | ER_MORE_THAN_ONE_PERIOD | Cannot specify more than one application-time period
|
4155 | | ER_PERIOD_FIELD_WRONG_ATTRIBUTES | Period field %`s cannot be %s
|
4156 | | ER_PERIOD_NOT_FOUND | Period %`s is not found in table
|
4157 | | ER_PERIOD_COLUMNS_UPDATED | Column %`s used in period %`s specified in update SET list
|
4158 | | ER_PERIOD_CONSTRAINT_DROP | Can't DROP CONSTRAINT `%s`. Use DROP PERIOD `%s` for this
|
4159 | 42000 S1009 | ER_TOO_LONG_KEYPART | Specified key part was too long; max key part length is %u bytes
|
4160 | | ER_TOO_LONG_DATABASE_COMMENT | Comment for database '%-.64s' is too long (max = %u)
|
4161 | | ER_UNKNOWN_DATA_TYPE | Unknown data type: '%-.64s'
|
4162 | | ER_UNKNOWN_OPERATOR | Operator does not exists: '%-.128s'
|
4163 | | ER_WARN_HISTORY_ROW_START_TIME | Table `%s.%s` history row start '%s' is later than row end '%s'
|
4164 | | ER_PART_STARTS_BEYOND_INTERVAL | %`s: STARTS is later than query time, first history partition may exceed INTERVAL value
|
4165 | | ER_GALERA_REPLICATION_NOT_SUPPORTED | DDL-statement is forbidden as table storage engine does not support Galera replication
|
4166 | HY000 | ER_LOAD_INFILE_CAPABILITY_DISABLED | The used command is not allowed because the MariaDB server or client has disabled the local infile capability
|
4167 | | ER_NO_SECURE_TRANSPORTS_CONFIGURED | No secure transports are configured, unable to set --require_secure_transport=ON
|
4168 | | ER_SLAVE_IGNORED_SHARED_TABLE | Slave SQL thread ignored the '%s' because table is shared
|
4169 | | ER_NO_AUTOINCREMENT_WITH_UNIQUE | AUTO_INCREMENT column %`s cannot be used in the UNIQUE index %`s
|
4170 | | ER_KEY_CONTAINS_PERIOD_FIELDS | Key %`s cannot explicitly include column %`s
|
4171 | | ER_KEY_CANT_HAVE_WITHOUT_OVERLAPS | Key %`s cannot have WITHOUT OVERLAPS
|
4172 | | ER_NOT_ALLOWED_IN_THIS_CONTEXT | '%-.128s' is not allowed in this context
|
4173 | | ER_DATA_WAS_COMMITED_UNDER_ROLLBACK | Engine %s does not support rollback. Changes were committed during rollback call
|
4174 | | ER_PK_INDEX_CANT_BE_IGNORED | A primary key cannot be marked as IGNORE
|
4175 | | ER_BINLOG_UNSAFE_SKIP_LOCKED | SKIP LOCKED makes this statement unsafe
|
4176 | | ER_JSON_TABLE_ERROR_ON_FIELD | Field '%s' can't be set for JSON_TABLE '%s'.
|
4177 | | ER_JSON_TABLE_ALIAS_REQUIRED | Every table function must have an alias.
|
4178 | | ER_JSON_TABLE_SCALAR_EXPECTED | Can't store an array or an object in the scalar column '%s' of JSON_TABLE '%s'.
|
4179 | | ER_JSON_TABLE_MULTIPLE_MATCHES | Can't store multiple matches of the path in the column '%s' of JSON_TABLE '%s'.
|
4180 | | ER_WITH_TIES_NEEDS_ORDER | FETCH ... WITH TIES requires ORDER BY clause to be present
|
4181 | | ER_REMOVED_ORPHAN_TRIGGER | Dropped orphan trigger '%-.64s', originally created for table: '%-.192s'
|
4182 | | ER_STORAGE_ENGINE_DISABLED | Storage engine %s is disabled
|
4183 | | WARN_SFORMAT_ERROR | SFORMAT error: %s
|
4184 | | ER_PARTITION_CONVERT_SUBPARTITIONED | Convert partition is not supported for subpartitioned table.
|
4185 | | ER_PROVIDER_NOT_LOADED | MariaDB tried to use the %s, but its provider plugin is not loaded
|
4186 | | ER_JSON_HISTOGRAM_PARSE_FAILED | Failed to parse histogram for table %s.%s: %s at offset %d.
|
4187 | | ER_SF_OUT_INOUT_ARG_NOT_ALLOWED | OUT or INOUT argument %d for function %s is not allowed here
|
4188 | | ER_INCONSISTENT_SLAVE_TEMP_TABLE | Replicated query '%s' table `%s.%s` can not be temporary
|
4189 | | ER_VERS_HIST_PART_FAILED | Versioned table %`s.%`s: adding HISTORY partition(s) failed
|
4190 | | WARN_OPTION_CHANGING | %s is implicitly changing the value of '%s' from '%s' to '%s'
|
4191 | | ER_CM_OPTION_MISSING_REQUIREMENT | CHANGE MASTER TO option '%s=%s' is missing requirement %s
|
4192 | | ER_SLAVE_STATEMENT_TIMEOUT | Slave log event execution was interrupted (slave_max_statement_time exceeded)
|
4193 | | ER_JSON_INVALID_VALUE_FOR_KEYWORD | Invalid value for keyword %s
|
4194 | | ER_JSON_SCHEMA_KEYWORD_UNSUPPORTED | %s keyword is not supported
|
4195 | | ER_JSON_NO_VARIABLE_SCHEMA | Variable schema is not supported.
|