You are here

help

MySQL Client Error Codes and Messages 2050 - 2099

Undefined
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

MySQL Server Error Codes and Messages 1700 - 1749

Undefined
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

MySQL Server Error Codes and Messages 1650 - 1699

Undefined
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

MySQL Server Error Codes and Messages 1600 - 1649

Undefined
1550 - 1599 1650 - 1699

MySQL Server Error Codes and Messages 1550 - 1599

Undefined
1500 - 1549 1600 - 1649

MySQL Server Error Codes and Messages 1500 - 1549

Undefined
1450 - 1499 1550 - 1599
  • Error: 1500 SQLSTATE: HY000 (ER_SUBPARTITION_ERROR)

    Message: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning

MySQL Server Error Codes and Messages 1450 - 1499

Undefined
1400 - 1449 1500 - 1549

MySQL Server Error Codes and Messages 1400 - 1449

Undefined
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)

MySQL Server Error Codes and Messages 1250 - 1299

Undefined
1200 - 1249 1300 - 1349

MySQL Server Error Codes and Messages 1200 - 1249

Undefined
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

MySQL Server Error Codes and Messages 1150 - 1199

Undefined
1100 - 1149 1200 - 1249

MySQL Server Error Codes and Messages 1100 - 1149

Undefined
1050 - 1099 1150 - 1199
  • Error: 1100 SQLSTATE: HY000 (ER_TABLE_NOT_LOCKED)

    Message: Table '%s' was not locked with LOCK TABLES

MySQL Server Error Codes and Messages 1000 - 1049

Undefined
1050 - 1099
  • Error: 1000 SQLSTATE: HY000 (ER_HASHCHK)

    Message: hashchk

  • Error: 1001 SQLSTATE: HY000 (ER_NISAMCHK)

    Message: isamchk

MySQL Error codes and messages

Undefined

Just a general rule with error messages: Usually they are not as good as they could be. But never the less 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