1 of 100

MariaDB Error Codes 1200 to 1299

Error 1200: The server is not configured as 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

Possible Causes and Solutions

Error 1201: Could not initialize master info structure

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

Possible Causes and Solutions

Error 1202: Could not create slave thread; check system resources

Error Code

SQLSTATE

Error

Description

1202

HY000

ER_SLAVE_THREAD

Could not create slave thread; check system resources

Possible Causes and Solutions

Error 1203: User already has more than 'max_user_connections' active connections

Error Code

SQLSTATE

Error

Description

Error 1204: You may only use constant expressions with SET

Error Code

SQLSTATE

Error

Description

Error 1205: Lock wait timeout exceeded; try restarting transaction

Error Code

SQLSTATE

Error

Description

1205

HY000

ER_LOCK_WAIT_TIMEOUT

Lock wait timeout exceeded; try restarting transaction

Possible Causes and Solutions

Error 1206: The total number of locks exceeds the lock table size

Error Code

SQLSTATE

Error

Description

1206

HY000

ER_LOCK_TABLE_FULL

The total number of locks exceeds the lock table size

Possible Causes and Solutions

Error 1207: Update locks cannot be acquired during a READ UNCOMMITTED transaction

Error Code

SQLSTATE

Error

Description

1207

25000

ER_READ_ONLY_TRANSACTION

Update locks cannot be acquired during a READ UNCOMMITTED transaction

Possible Causes and Solutions

Error 1208: DROP DATABASE not allowed while thread is holding global read lock

Error Code

SQLSTATE

Error

Description

Error 1209: CREATE DATABASE not allowed while thread is holding global read lock

Error Code

SQLSTATE

Error

Description

Error 1210: Incorrect arguments to

Error Code

SQLSTATE

Error

Description

Error 1211: is not allowed to create new users

Error Code

SQLSTATE

Error

Description

1211

42000

ER_NO_PERMISSION_TO_CREATE_USER

'%s'@'%s' is not allowed to create new users

Possible Causes and Solutions

Error 1212: Incorrect table definition; all MERGE tables must be in the same database

Error Code

SQLSTATE

Error

Description

Error 1213: Deadlock found when trying to get lock; try restarting transaction

Error Code

SQLSTATE

Error

Description

1213

40001

ER_LOCK_DEADLOCK

Deadlock found when trying to get lock; try restarting transaction

Possible Causes and Solutions

Error 1214: The used table type doesn't support FULLTEXT indexes

Error Code

SQLSTATE

Error

Description

1214

HY000

ER_TABLE_CANT_HANDLE_FT

The used table type doesn't support FULLTEXT indexes

Possible Causes and Solutions

Error 1215: Cannot add foreign key constraint

Error Code

SQLSTATE

Error

Description

Error 1216: Cannot add or update a child row: a foreign key constraint fails

Error Code

SQLSTATE

Error

Description

Error 1217: Cannot delete or update a parent row: a foreign key constraint fails

Error Code

SQLSTATE

Error

Description

Error 1218: Error connecting to master

Error Code

SQLSTATE

Error

Description

1218

08S01

ER_CONNECT_TO_MASTER

Error connecting to master: %s

Possible Causes and Solutions

Error 1219: Error running query on master

Error Code

SQLSTATE

Error

Description

1219

HY000

ER_QUERY_ON_MASTER

Error running query on master: %s

Possible Causes and Solutions

Error 1220: Error when executing command

Error Code

SQLSTATE

Error

Description

Error 1221: Incorrect usage of

Error Code

SQLSTATE

Error

Description

Error 1222: The used SELECT statements have a different number of columns

Error Code

SQLSTATE

Error

Description

1222

21000

ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT

The used SELECT statements have a different number of columns

Possible Causes and Solutions

Error 1223: Can't execute the query because you have a conflicting read lock

Error Code

SQLSTATE

Error

Description

Error 1224: Mixing of transactional and non-transactional tables is disabled

Error Code

SQLSTATE

Error

Description

Error 1225: Option used twice in statement

Error Code

SQLSTATE

Error

Description

Error 1227: Access denied; you need (at least one of) the privilege(s) for this operation

Error Code

SQLSTATE

Error

Description

Error 1228: Variable is a SESSION variable and can't be used with SET GLOBAL

Error Code

SQLSTATE

Error

Description

1228

HY000

ER_LOCAL_VARIABLE

Variable '%s' is a SESSION variable and can't be used with SET GLOBAL

Possible Causes and Solutions

Error 1230: Variable doesn't have a default value

Error Code

SQLSTATE

Error

Description

Error 1231: Variable can't be set to the value of

Error Code

SQLSTATE

Error

Description

1231

42000

ER_WRONG_VALUE_FOR_VAR

Variable '%s' can't be set to the value of '%s'

Possible Causes and Solutions

Error 1232: Incorrect argument type to variable

Error Code

SQLSTATE

Error

Description

Error 1234: Incorrect usage/placement

Error Code

SQLSTATE

Error

Description

Error 1235: This version of MariaDB doesn't yet support

Error Code

SQLSTATE

Error

Description

Error 1236: Got fatal error from master when reading data from binary log

Error Code

SQLSTATE

Error

Description

1236

HY000

ER_MASTER_FATAL_ERROR_READING_BINLOG

Got fatal error %d from master when reading data from binary log: '%s'

Possible Causes and Solutions

Error 1237: Slave SQL thread ignored the query because of replicate-*-table rules

Error Code

SQLSTATE

Error

Description

Error 1238: Variable is a

Error Code

SQLSTATE

Error

Description

1238

HY000

ER_INCORRECT_GLOBAL_LOCAL_VAR

Variable '%s' is a %s variable

Possible Causes and Solutions

Error 1239: Incorrect foreign key definition

Error Code

SQLSTATE

Error

Description

Error 1240: Key reference and table reference don't match

Error Code

SQLSTATE

Error

Description

Error 1241: Operand should contain column(s)

Error Code

SQLSTATE

Error

Description

1241

21000

ER_OPERAND_COLUMNS

Operand should contain %d column(s)

Possible Causes and Solutions

Error 1242: Subquery returns more than 1 row

Error Code

SQLSTATE

Error

Description

1242

21000

ER_SUBQUERY_NO_1_ROW

Subquery returns more than 1 row

Possible Causes and Solutions

Error 1243: Unknown prepared statement handler given

Error Code

SQLSTATE

Error

Description

Error 1244: Help database is corrupt or does not exist

Error Code

SQLSTATE

Error

Description

1244

HY000

ER_CORRUPT_HELP_DB

Help database is corrupt or does not exist

Possible Causes and Solutions

Error 1245: Cyclic reference on subqueries

Error Code

SQLSTATE

Error

Description

1245

HY000

ER_CYCLIC_REFERENCE

Cyclic reference on subqueries

Possible Causes and Solutions

Error 1246: Converting column from to

Error Code

SQLSTATE

Error

Description

1246

HY000

ER_AUTO_CONVERT

Converting column '%s' from %s to %s

Possible Causes and Solutions

Error 1247: Reference not supported

Error Code

SQLSTATE

Error

Description

Error 1248: Every derived table must have its own alias

Error Code

SQLSTATE

Error

Description

1248

42000

ER_DERIVED_MUST_HAVE_ALIAS

Every derived table must have its own alias

Possible Causes and Solutions

Error 1249: Select was reduced during optimization

Error Code

SQLSTATE

Error

Description

1249

01000

ER_SELECT_REDUCED

Select %u was reduced during optimization

Possible Causes and Solutions

Error 1250: Table from one of the SELECTs cannot be used

Error Code

SQLSTATE

Error

Description

Error 1251: Client does not support authentication protocol requested by server

Error Code

SQLSTATE

Error

Description

Error 1252: All parts of a SPATIAL index must be NOT NULL

Error Code

SQLSTATE

Error

Description

Error 1253: COLLATION is not valid for CHARACTER SET

Error Code

SQLSTATE

Error

Description

1253

42000

ER_COLLATION_CHARSET_MISMATCH

COLLATION '%s' is not valid for CHARACTER SET '%s'

Possible Causes and Solutions

Error 1254: Slave is already running

Error Code

SQLSTATE

Error

Description

Error 1255: Slave already has been stopped

Error Code

SQLSTATE

Error

Description

1255

HY000

ER_SLAVE_WAS_NOT_RUNNING

Slave already has been stopped

Possible Causes and Solutions

Error 1256: Uncompressed data size too large

Error Code

SQLSTATE

Error

Description

Error 1257: ZLIB: Not enough memory

Error Code

SQLSTATE

Error

Description

Error 1258: ZLIB: Not enough room in the output buffer

Error Code

SQLSTATE

Error

Description

Error 1259: ZLIB: Input data corrupted

Error Code

SQLSTATE

Error

Description

Error 1260: Row was cut by GROUP_CONCAT()

Error Code

SQLSTATE

Error

Description

1260

HY000

ER_CUT_VALUE_GROUP_CONCAT

Row %u was cut by GROUP_CONCAT()

Possible Causes and Solutions

Error 1261: Row doesn't contain data for all columns

Error Code

SQLSTATE

Error

Description

Error 1263: Column set to default value; NULL supplied to NOT NULL columnError 1263: Column set to d

Error Code

SQLSTATE

Error

Description

1263

22004

ER_WARN_NULL_TO_NOTNULL

Column set to default value; NULL supplied to NOT NULL column '%s' at row %ld

Possible Causes and Solutions

Error 1264: Out of range value for column

Error Code

SQLSTATE

Error

Description

1260

HY000

ER_CUT_VALUE_GROUP_CONCAT

Row %u was cut by GROUP_CONCAT()

Possible Causes and Solutions

Error 1265: Data truncated for column

Error Code

SQLSTATE

Error

Description

Error 1266: Using storage engine for table

Error Code

SQLSTATE

Error

Description

Error 1268: Cannot drop one or more of the requested users

Error Code

SQLSTATE

Error

Description

Error 1269: Can't revoke all privileges for one or more of the requested users

Error Code

SQLSTATE

Error

Description

Error 1270: Illegal mix of collations for operation

Error Code

SQLSTATE

Error

Description

1270

HY000

ER_CANT_AGGREGATE_3COLLATIONS

Illegal mix of collations (%s,%s), (%s,%s), (%s,%s) for operation '%s'

Possible Causes and Solutions

Error 1271: Illegal mix of collations for operation

Error Code

SQLSTATE

Error

Description

Error 1272: Variable is not a variable component (can't be used as XXXX.variable_name)

Error Code

SQLSTATE

Error

Description

1272

HY000

ER_VARIABLE_IS_NOT_STRUCT

Variable '%s' is not a variable component (can't be used as XXXX.variable_name)

Possible Causes and Solutions

Error 1273: Unknown collation

Error Code

SQLSTATE

Error

Description

Error 1274: SSL parameters in CHANGE MASTER are ignored because this MariaDB slave was compiled with

Error Code

SQLSTATE

Error

Description

Error 1275: Server is running in --secure-auth mode, but has a password in the old format

Error Code

SQLSTATE

Error

Description

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

Possible Causes and Solutions

Error 1276: Field or reference of SELECT was resolved in SELECT

Error Code

SQLSTATE

Error

Description

1276

HY000

ER_WARN_FIELD_RESOLVED

Field or reference '%s%s%s%s%s' of SELECT #%d was resolved in SELECT #%d

Possible Causes and Solutions

Error 1277: Incorrect parameter or combination of parameters for START SLAVE UNTIL

Error Code

SQLSTATE

Error

Description

1277

HY000

ER_BAD_SLAVE_UNTIL_COND

Incorrect parameter or combination of parameters for START SLAVE UNTIL

Possible Causes and Solutions

Error 1278: It is recommended to use --skip-slave-start when doing step-by-step replication with STA

Error Code

SQLSTATE

Error

Description

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

Possible Causes and Solutions

Error 1280: Incorrect index name

Error Code

SQLSTATE

Error

Description

1280

42000

ER_WRONG_NAME_FOR_INDEX

Incorrect index name '%s'

Possible Causes and Solutions

Error 1281: Incorrect catalog name

Error Code

SQLSTATE

Error

Description

Error 1282: Query cache failed to set size; new query cache size is

Error Code

SQLSTATE

Error

Description

1282

HY000

ER_WARN_QC_RESIZE

Query cache failed to set size %lu; new query cache size is %lu

Possible Causes and Solutions

Error 1283: Column cannot be part of FULLTEXT index

Error Code

SQLSTATE

Error

Description

1283

HY000

ER_BAD_FT_COLUMN

Column '%s' cannot be part of FULLTEXT index

Possible Causes and Solutions

Error 1284: Unknown key cache

Error Code

SQLSTATE

Error

Description

1284

HY000

ER_UNKNOWN_KEY_CACHE

Unknown key cache '%s'

Possible Causes and Solutions

Error 1285: MariaDB is started in --skip-name-resolve mode

Error Code

SQLSTATE

Error

Description

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

Possible Causes and Solutions

Error 1286: Unknown storage engine

Error Code

SQLSTATE

Error

Description

1286

42000

ER_UNKNOWN_STORAGE_ENGINE

Unknown storage engine '%s'

Possible Causes and Solutions

Error 1287: is deprecated and will be removed in a future release. Please use instead

Error Code

SQLSTATE

Error

Description

1287

HY000

ER_WARN_DEPRECATED_SYNTAX

'%s' is deprecated and will be removed in a future release. Please use %s instead

Possible Causes and Solutions

Error 1289: The feature is disabled; you need MariaDB built with to have it working

Error Code

SQLSTATE

Error

Description

1289

HY000

ER_FEATURE_DISABLED

The '%s' feature is disabled; you need MariaDB built with '%s' to have it working

Possible Causes and Solutions

Error 1290: The MariaDB server is running with the option so it cannot execute this statement

Error Code

SQLSTATE

Error

Description

1290

HY000

ER_OPTION_PREVENTS_STATEMENT

The MariaDB server is running with the %s option so it cannot execute this statement

Possible Causes and Solutions

Error 1291: Column has duplicated value

Error Code

SQLSTATE

Error

Description

Error 1292: Truncated incorrect value

Error Code

SQLSTATE

Error

Description

1292

22007

ER_TRUNCATED_WRONG_VALUE

Truncated incorrect %s value: '%s'

Possible Causes and Solutions

Error 1293: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAM

Error Code

SQLSTATE

Error

Description

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

Possible Causes and Solutions

Error 1294: Invalid ON UPDATE clause

Error Code

SQLSTATE

Error

Description

Error 1295: This command is not supported in the prepared statement protocol yet

Error Code

SQLSTATE

Error

Description

Error 1296: Got error from

Error Code

SQLSTATE

Error

Description

1296

HY000

ER_GET_ERRMSG

Got error %d '%s' from %s

Possible Causes and Solutions

Error 1298: Unknown or incorrect time zone

Error Code

SQLSTATE

Error

Description

1298

HY000

ER_UNKNOWN_TIME_ZONE

Unknown or incorrect time zone: '%s'