Help

MySQL Client Error Codes and Messages 2050 - 2099

2000 - 2049

  • Error: 2050 (CR_FETCH_CANCELED)

    Message: Row retrieval was canceled by mysql_stmt_close() call

  • Error: 2051 (CR_NO_DATA)

    Message: Attempt to read column without prior row fetch

  • Error: 2052 (CR_NO_STMT_METADATA)

    Message: Prepared statement contains no metadata

  • Error: 2053 (CR_NO_RESULT_SET)

    Message: Attempt to read a row while there is no result set associated with the statement

  • Error: 2054 (CR_NOT_IMPLEMENTED)

    Message: This feature is not implemented yet

  • Error: 2055 ( …

MySQL Client Error Codes and Messages 2000 - 2049

1700 - 1749 2050 - 2099

  • Error: 2000 (CR_UNKNOWN_ERROR)

    Message: Unknown MySQL error

  • Error: 2001 (CR_SOCKET_CREATE_ERROR)

    Message: Can’t create UNIX socket (%d)


  • Error: 2002 (CR_CONNECTION_ERROR) Message: Can’t connect to local MySQL server through socket ‘%s’

    How does the MySQL error message look like?

    shell> mysql --user=root --socket=/tmp/mysql.sock
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    

    What does the MySQL error …

MySQL Server Error Codes and Messages 1700 - 1749

1650 - 1699 2000 - 2049

  • Error: 1700 SQLSTATE: HY000 (ER_GRANT_PLUGIN_USER_EXISTS)

    Message: GRANT with IDENTIFIED WITH is illegal because the user %-.
    *s already exists

  • Error: 1701 SQLSTATE: 42000 (ER_TRUNCATE_ILLEGAL_FK)

    Message: Cannot truncate a table referenced in a foreign key constraint (%s)

  • Error: 1702 SQLSTATE: HY000 (ER_PLUGIN_IS_PERMANENT)

    Message: Plugin ‘%s’ is force_plus_permanent and can not be unloaded

  • Error: 1703 SQLSTATE: HY000 ( …

MySQL Server Error Codes and Messages 1650 - 1699

1600 - 1649 1700 - 1749

  • Error: 1650 SQLSTATE: HY000 (ER_SLAVE_IGNORE_SERVER_IDS)

    Message: The requested server id %d clashes with the slave startup option –replicate-same-server-id

  • Error: 1651 SQLSTATE: HY000 (ER_QUERY_CACHE_DISABLED)

    Message: Query cache is disabled; restart the server with query_cache_type=1 to enable it

  • Error: 1652 SQLSTATE: HY000 (ER_SAME_NAME_PARTITION_FIELD)

    Message: Duplicate partition field name ‘%s’

  • Error: 1653 SQLSTATE: HY000 ( …

MySQL Server Error Codes and Messages 1600 - 1649

1550 - 1599 1650 - 1699

MySQL Server Error Codes and Messages 1550 - 1599

1500 - 1549 1600 - 1649

  • Error: 1550 SQLSTATE: HY000 (ER_EVENT_COMPILE_ERROR)

    Message: Error during compilation of event’s body

  • Error: 1551 SQLSTATE: HY000 (ER_EVENT_SAME_NAME)

    Message: Same old and new event name

  • Error: 1552 SQLSTATE: HY000 (ER_EVENT_DATA_TOO_LONG)

    Message: Data for column ‘%s’ too long

  • Error: 1553 SQLSTATE: HY000 (ER_DROP_INDEX_FK)

    Message: Cannot drop index ‘%s’: needed in a foreign key constraint

  • Error: 1554 SQLSTATE: HY000 ( …

MySQL Server Error Codes and Messages 1500 - 1549

1450 - 1499 1550 - 1599

MySQL Server Error Codes and Messages 1450 - 1499

1400 - 1449 1500 - 1549

  • Error: 1450 SQLSTATE: HY000 (ER_FORBID_SCHEMA_CHANGE)

    Message: Changing schema from ‘%s’ to ‘%s’ is not allowed.

  • Error: 1451 SQLSTATE: 23000 (ER_ROW_IS_REFERENCED_2)

    Message: Cannot delete or update a parent row: a foreign key constraint fails (%s)

  • Error: 1452 SQLSTATE: 23000 (ER_NO_REFERENCED_ROW_2)

    Message: Cannot add or update a child row: a foreign key constraint fails (%s)

  • Error: 1453 SQLSTATE: 42000 (ER_SP_BAD_VAR_SHADOW)

    Message: Variable …

MySQL Server Error Codes and Messages 1400 - 1449

1350 - 1399 1450 - 1499

  • Error: 1400 SQLSTATE: XAE09 (ER_XAER_OUTSIDE)

    Message: XAER_OUTSIDE: Some work is done outside global transaction

  • Error: 1401 SQLSTATE: XAE03 (ER_XAER_RMERR)

    Message: XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency

  • Error: 1402 SQLSTATE: XA100 (ER_XA_RBROLLBACK)

    Message: XA_RBROLLBACK: Transaction branch was rolled back

  • Error: 1403 SQLSTATE: 42000 (ER_NONEXISTING_PROC_GRANT)

    Message: There is no such grant defined for user …

MySQL Server Error Codes and Messages 1350 - 1399

1300 - 1349 1400 - 1449

  • Error: 1350 SQLSTATE: HY000 (ER_VIEW_SELECT_CLAUSE)

    Message: View’s SELECT contains a ‘%s’ clause

  • Error: 1351 SQLSTATE: HY000 (ER_VIEW_SELECT_VARIABLE)

    Message: View’s SELECT contains a variable or parameter

  • Error: 1352 SQLSTATE: HY000 (ER_VIEW_SELECT_TMPTABLE)

    Message: View’s SELECT refers to a temporary table ‘%s’

  • Error: 1353 SQLSTATE: HY000 (ER_VIEW_WRONG_LIST)

    Message: View’s SELECT and view’s field list have …

MySQL Server Error Codes and Messages 1300 - 1349

1250 - 1299 1350 - 1399

MySQL Server Error Codes and Messages 1250 - 1299

1200 - 1249 1300 - 1349

MySQL Server Error Codes and Messages 1200 - 1249

1150 - 1199 1250 - 1299


  Error: 1200 SQLSTATE: HY000 (ER_BAD_SLAVE)
  Message: The server is not configured as slave; fix in config file or with CHANGE MASTER TO

How does the MySQL error message look like?


  Error: 1201 SQLSTATE: HY000 (ER_MASTER_INFO)
  Message: Could not initialize master info structure; more error messages can be found in the MySQL error log

How does the MySQL error message look like?


  Error: 1202 SQLSTATE: HY000 (ER_SLAVE_THREAD)
  Message: Could not create slave thread; …

MySQL Server Error Codes and Messages 1150 - 1199

1100 - 1149 1200 - 1249


  Error: 1153 SQLSTATE: 08S01 (ER_NET_PACKET_TOO_LARGE)
  Message: Got a packet bigger than …

MySQL Server Error Codes and Messages 1100 - 1149

1050 - 1099 1150 - 1199

  • Error: 1100 SQLSTATE: HY000 (ER_TABLE_NOT_LOCKED)

    Message: Table ‘%s’ was not locked with LOCK TABLES

  • Error: 1101 SQLSTATE: 42000 (ER_BLOB_CANT_HAVE_DEFAULT)

    Message: BLOB/TEXT column ‘%s’ can’t have a default value

  • Error: 1102 SQLSTATE: 42000 (ER_WRONG_DB_NAME)

    Message: Incorrect database name ‘%s’

  • Error: 1103 SQLSTATE: 42000 (ER_WRONG_TABLE_NAME)

    Message: Incorrect table name ‘%s’

  • Error: 1104 SQLSTATE: 42000 ( …

MySQL Server Error Codes and Messages 1050 - 1099

1000 - 1049 1100 - 1149


Error: 1050 SQLSTATE: 42S01 (ER_TABLE_EXISTS_ERROR)

Message: Table ‘%s’ already exists

MySQL Server Error Codes and Messages 1000 - 1049

1050 - 1099

  • Error: 1000 SQLSTATE: HY000 (ER_HASHCHK)

    Message: hashchk

  • Error: 1001 SQLSTATE: HY000 (ER_NISAMCHK)

    Message: isamchk

  • Error: 1002 SQLSTATE: HY000 (ER_NO)

    Message: NO

  • Error: 1003 SQLSTATE: HY000 (ER_YES)

    Message: YES

  • Error: 1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE)

    Message: Can’t create file ‘%s’ (errno: %d)

  • Error: 1005 SQLSTATE: HY000 (ER_CANT_CREATE_TABLE)

    Message: Can’t create table ‘%s’ (errno: %d)


  Error: 1006 SQLSTATE: HY000 …

MySQL Error codes and messages

Just a general rule with error messages: Usually they are not as good as they could be. But nevertheless read them carefully. Most of the time they tell you what you need to know…

And an other wisdom: Errors are really errors and they have to be solved. Warnings are warnings and you should investigate if they appear. Do not ignore both of them unless you have clearly understood what you are doing.

With MySQL:

mysql> SHOW WARNINGS

is often your friend! Further sources to find the problems are: …

Subscribe to RSS - Help