{"id":354,"date":"2017-02-01T04:12:45","date_gmt":"2017-01-31T20:12:45","guid":{"rendered":"http:\/\/vinta.ws\/code\/?p=354"},"modified":"2026-02-18T01:20:36","modified_gmt":"2026-02-17T17:20:36","slug":"mysql-error-codes","status":"publish","type":"post","link":"https:\/\/vinta.ws\/code\/mysql-error-codes.html","title":{"rendered":"MySQL system error codes"},"content":{"rendered":"<p>Print all OS error codes and MySQL error codes using the <code>perror<\/code> command.<\/p>\n<pre class=\"line-numbers\"><code class=\"language-bash\">$ for i in {1..190..1}; do perror \"$i\"; done\n\nOS error code   1:  Operation not permitted\nOS error code   2:  No such file or directory\nOS error code   3:  No such process\nOS error code   4:  Interrupted system call\nOS error code   5:  Input\/output error\nOS error code   6:  No such device or address\nOS error code   7:  Argument list too long\nOS error code   8:  Exec format error\nOS error code   9:  Bad file descriptor\nOS error code  10:  No child processes\nOS error code  11:  Resource temporarily unavailable\nOS error code  12:  Cannot allocate memory\nOS error code  13:  Permission denied\nOS error code  14:  Bad address\nOS error code  15:  Block device required\nOS error code  16:  Device or resource busy\nOS error code  17:  File exists\nOS error code  18:  Invalid cross-device link\nOS error code  19:  No such device\nOS error code  20:  Not a directory\nOS error code  21:  Is a directory\nOS error code  22:  Invalid argument\nOS error code  23:  Too many open files in system\nOS error code  24:  Too many open files\nOS error code  25:  Inappropriate ioctl for device\nOS error code  26:  Text file busy\nOS error code  27:  File too large\nOS error code  28:  No space left on device\nOS error code  30:  Read-only file system\nOS error code  31:  Too many links\nOS error code  32:  Broken pipe\nOS error code  33:  Numerical argument out of domain\nOS error code  34:  Numerical result out of range\nOS error code  35:  Resource deadlock avoided\nOS error code  36:  File name too long\nOS error code  37:  No locks available\nOS error code  38:  Function not implemented\nOS error code  39:  Directory not empty\nOS error code  40:  Too many levels of symbolic links\nOS error code  42:  No message of desired type\nOS error code  43:  Identifier removed\nOS error code  44:  Channel number out of range\nOS error code  45:  Level 2 not synchronized\nOS error code  46:  Level 3 halted\nOS error code  47:  Level 3 reset\nOS error code  48:  Link number out of range\nOS error code  49:  Protocol driver not attached\nOS error code  50:  No CSI structure available\nOS error code  51:  Level 2 halted\nOS error code  52:  Invalid exchange\nOS error code  53:  Invalid request descriptor\nOS error code  54:  Exchange full\nOS error code  55:  No anode\nOS error code  56:  Invalid request code\nOS error code  57:  Invalid slot\nOS error code  59:  Bad font file format\nOS error code  60:  Device not a stream\nOS error code  61:  No data available\nOS error code  62:  Timer expired\nOS error code  63:  Out of streams resources\nOS error code  64:  Machine is not on the network\nOS error code  65:  Package not installed\nOS error code  66:  Object is remote\nOS error code  67:  Link has been severed\nOS error code  68:  Advertise error\nOS error code  69:  Srmount error\nOS error code  70:  Communication error on send\nOS error code  71:  Protocol error\nOS error code  72:  Multihop attempted\nOS error code  73:  RFS specific error\nOS error code  74:  Bad message\nOS error code  75:  Value too large for defined data type\nOS error code  76:  Name not unique on network\nOS error code  77:  File descriptor in bad state\nOS error code  78:  Remote address changed\nOS error code  79:  Can not access a needed shared library\nOS error code  80:  Accessing a corrupted shared library\nOS error code  81:  .lib section in a.out corrupted\nOS error code  82:  Attempting to link in too many shared libraries\nOS error code  83:  Cannot exec a shared library directly\nOS error code  84:  Invalid or incomplete multibyte or wide character\nOS error code  85:  Interrupted system call should be restarted\nOS error code  86:  Streams pipe error\nOS error code  87:  Too many users\nOS error code  88:  Socket operation on non-socket\nOS error code  89:  Destination address required\nOS error code  90:  Message too long\nOS error code  91:  Protocol wrong type for socket\nOS error code  92:  Protocol not available\nOS error code  93:  Protocol not supported\nOS error code  94:  Socket type not supported\nOS error code  95:  Operation not supported\nOS error code  96:  Protocol family not supported\nOS error code  97:  Address family not supported by protocol\nOS error code  98:  Address already in use\nOS error code  99:  Cannot assign requested address\nOS error code 100:  Network is down\nOS error code 101:  Network is unreachable\nOS error code 102:  Network dropped connection on reset\nOS error code 103:  Software caused connection abort\nOS error code 104:  Connection reset by peer\nOS error code 105:  No buffer space available\nOS error code 106:  Transport endpoint is already connected\nOS error code 107:  Transport endpoint is not connected\nOS error code 108:  Cannot send after transport endpoint shutdown\nOS error code 109:  Too many references: cannot splice\nOS error code 110:  Connection timed out\nOS error code 111:  Connection refused\nOS error code 112:  Host is down\nOS error code 113:  No route to host\nOS error code 114:  Operation already in progress\nOS error code 115:  Operation now in progress\nOS error code 116:  Stale NFS file handle\nOS error code 117:  Structure needs cleaning\nOS error code 118:  Not a XENIX named type file\nOS error code 119:  No XENIX semaphores available\nOS error code 120:  Is a named type file\nOS error code 121:  Remote I\/O error\nOS error code 122:  Disk quota exceeded\nOS error code 123:  No medium found\nOS error code 124:  Wrong medium type\nOS error code 125:  Operation canceled\nOS error code 126:  Required key not available\nOS error code 127:  Key has expired\nOS error code 128:  Key has been revoked\nOS error code 129:  Key was rejected by service\nOS error code 130:  Owner died\nOS error code 131:  State not recoverable\nOS error code 132:  Operation not possible due to RF-kill\nOS error code 133:  Memory page has hardware error\nMySQL error code 120: Did not find key on read or update\nMySQL error code 121: Duplicate key on write or update\nMySQL error code 122: Internal (unspecified) error in handler\nMySQL error code 123: Someone has changed the row since it was read (while the table was locked to prevent it)\nMySQL error code 124: Wrong index given to function\nMySQL error code 125: Undefined handler error 125\nMySQL error code 126: Index file is crashed\nMySQL error code 127: Record file is crashed\nMySQL error code 128: Out of memory in engine\nMySQL error code 129: Undefined handler error 129\nMySQL error code 130: Incorrect file format\nMySQL error code 131: Command not supported by database\nMySQL error code 132: Old database file\nMySQL error code 126: Index file is crashed\nMySQL error code 127: Record-file is crashed\nMySQL error code 128: Out of memory\nMySQL error code 130: Incorrect file format\nMySQL error code 131: Command not supported by database\nMySQL error code 132: Old database file\nMySQL error code 133: No record read before update\nMySQL error code 134: Record was already deleted (or record file crashed)\nMySQL error code 135: No more room in record file\nMySQL error code 136: No more room in index file\nMySQL error code 137: No more records (read after end of file)\nMySQL error code 138: Unsupported extension used for table\nMySQL error code 139: Too big row\nMySQL error code 140: Wrong create options\nMySQL error code 141: Duplicate unique key or constraint on write or update\nMySQL error code 142: Unknown character set used in table\nMySQL error code 143: Conflicting table definitions in sub-tables of MERGE table\nMySQL error code 144: Table is crashed and last repair failed\nMySQL error code 145: Table was marked as crashed and should be repaired\nMySQL error code 146: Lock timed out; Retry transaction\nMySQL error code 147: Lock table is full;  Restart program with a larger locktable\nMySQL error code 148: Updates are not allowed under a read only transactions\nMySQL error code 149: Lock deadlock; Retry transaction\nMySQL error code 150: Foreign key constraint is incorrectly formed\nMySQL error code 151: Cannot add a child row\nMySQL error code 152: Cannot delete a parent row\nMySQL error code 153: No savepoint with that name\nMySQL error code 154: Non unique key block size\nMySQL error code 155: The table does not exist in engine\nMySQL error code 156: The table already existed in storage engine\nMySQL error code 157: Could not connect to storage engine\nMySQL error code 158: Unexpected null pointer found when using spatial index\nMySQL error code 159: The table changed in storage engine\nMySQL error code 160: There is no partition in table for the given value\nMySQL error code 161: Row-based binlogging of row failed\nMySQL error code 162: Index needed in foreign key constraint\nMySQL error code 163: Upholding foreign key constraints would lead to a duplicate key error in some other table\nMySQL error code 164: Table needs to be upgraded before it can be used\nMySQL error code 165: Table is read only\nMySQL error code 166: Failed to get next auto increment value\nMySQL error code 167: Failed to set row auto increment value\nMySQL error code 168: Unknown (generic) error from engine\nMySQL error code 169: Record is the same\nMySQL error code 170: It is not possible to log this statement\nMySQL error code 171: The event was corrupt, leading to illegal data being read\nMySQL error code 172: The table is of a new format not supported by this version\nMySQL error code 173: The event could not be processed no other hanlder error happened\nMySQL error code 174: Got a fatal error during initialzaction of handler\nMySQL error code 175: File to short; Expected more data in file\nMySQL error code 176: Read page with wrong checksum\nMySQL error code 177: Too many active concurrent transactions\nMySQL error code 178: Record not matching the given partition set\nMySQL error code 179: Index column length exceeds limit\nMySQL error code 180: Index corrupted\nMySQL error code 181: Undo record too big\nMySQL error code 182: Invalid InnoDB FTS Doc ID\nMySQL error code 183: Table is being used in foreign key check\nMySQL error code 184: Tablespace already exists\nMySQL error code 185: Too many columns\nMySQL error code 186: Row in wrong partition\nMySQL error code 187: InnoDB is in read only mode\nMySQL error code 188: FTS query exceeds result cache memory limit\nMySQL error code 189: Temporary file write failure\nMySQL error code 190: Operation not allowed when innodb_forced_recovery &gt; 0\nMySQL error code 191: Too many words in a FTS phrase or proximity search\nMySQL error code 192: Foreign key cascade delete\/update exceeds max depth\nMySQL error code 193: Required Create option missing\nMySQL error code 194: Out of memory in storage engine\nMySQL error code 195: Table corrupted\nMySQL error code 196: Query interrupted\nMySQL error code 197: Tablespace cannot be accessed\nMySQL error code 198: Tablespace is not empty\nMySQL error code 199: Incorrect file name\nMySQL error code 200: Operation is not allowed\nMySQL error code 201: Compute generate value failed<\/code><\/pre>\n<p>ref:<br \/>\n<a href=\"http:\/\/man7.org\/linux\/man-pages\/man3\/perror.3.html\">http:\/\/man7.org\/linux\/man-pages\/man3\/perror.3.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Print all OS error codes and MySQL error codes using the perror command.<\/p>\n","protected":false},"author":1,"featured_media":355,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,38],"tags":[101,74,23],"class_list":["post-354","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-about-database","category-about-devops","tag-cli-tool","tag-linux","tag-mysql"],"_links":{"self":[{"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/posts\/354","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/comments?post=354"}],"version-history":[{"count":0,"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/posts\/354\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/media\/355"}],"wp:attachment":[{"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/media?parent=354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/categories?post=354"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/tags?post=354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}