MySQL (error) Code Reference

HA_ERR_OUT_OF_MEM

---

#define HA_ERR_OUT_OF_MEM 128 /* Record-file is crashed */

---

TODO: Add Context

HA_ERR_WRONG_IN_RECORD

---

#define HA_ERR_WRONG_IN_RECORD 127 /* Record-file is crashed */

---

TODO: Add Context

HA_ERR_CRASHED

---

#define HA_ERR_CRASHED 126 /* Indexfile is crashed */

---

TODO: Find where 125 is defined - I doesn’t appear to be listed with the other HA_ERR_* defines in my_base.h

Was it depreciated?

HA_ERR_WRONG_INDEX

---

#define HA_ERR_WRONG_INDEX 124 /* Wrong index given to function */


---

TODO: Add Context

HA_ERR_RECORD_CHANGED

---

#define HA_ERR_RECORD_CHANGED 123 /* Uppdate with is recoverable */

---

TODO: Add context

TODO: Find where 122 is defined - I doesn’t appear to be listed with the other HA_ERR_* defines in my_base.h

Was it depreciated?

HA_ERR_FOUND_DUPP_KEY 

---

#define HA_ERR_FOUND_DUPP_KEY 121 /* Dupplicate key on write */


---

TODO: Add context

HA_ERR_KEY_NOT_FOUND

---

#define HA_ERR_KEY_NOT_FOUND 120 /* Didn’t find key on read or update */

---

TODO: Add context

ER_ERROR_ON_RENAME

---

#define ER_ERROR_ON_RENAME 1025

---

Got this when I was attempted to alter an existing table that had foreign keys. Apparently when you alter a table - it creates a new temporary table and does a quick swap of the existing table for the new one. But if the existing table has dependencies - it wont work.