Mysql Error List
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.5 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators SQL Statement Syntax The InnoDB Storage Engine Alternative Storage Engines High Availability and Scalability Replication MySQL Cluster NDB 7.2 Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.5 Frequently Asked Questions Errors, Error Codes, and Common Problems Sources of Error Information Types of Error Values Server Error Codes and Messages Client Error Codes and Messages Problems and Common Errors How to Determine What Is Causing a Problem Common Errors When Using MySQL Programs Access denied Can't connect to [local] MySQL server Lost connection to MySQL server Client does not support authentication protocol Password Fails When Entered Interactively Host 'host_name' is blocked Too many connections Out of memory MySQL server has gone away Packet Too Large Communication Errors and Aborted Connections The table is full Can't create/write to file Commands out of sync Ignoring user Table 'tbl_name' doesn't exist Can't initialize character set File Not Found and Similar Errors Table-Corruption Issues Administration-Related Issues Problems with File Permissions How to Reset the Root Password What to Do If MySQL Keeps Crashing How MySQL Handles a Full Disk Where MySQL Stores Temporary Files How to Protect or Change the MySQL Unix Socket File Time Zone Problems Query-Related Issues Case Sensitivity in String Searches Problems Using DATE Columns Problems
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Using MySQL as a Document Store Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators SQL Statement Syntax The InnoDB Storage Engine Alternative Storage Engines High Availability and Scalability Replication MySQL Cluster NDB 7.5 Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema MySQL sys Schema https://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.7 Frequently Asked Questions Errors, Error Codes, and Common Problems Sources of Error Information Types of Error Values Server Error Codes and Messages Client Error Codes and Messages Problems and Common Errors How to Determine What Is Causing a Problem Common Errors When Using MySQL Programs http://dev.mysql.com/doc/en/error-messages-server.html Access denied Can't connect to [local] MySQL server Lost connection to MySQL server Client does not support authentication protocol Password Fails When Entered Interactively Host 'host_name' is blocked Too many connections Out of memory MySQL server has gone away Packet Too Large Communication Errors and Aborted Connections The table is full Can't create/write to file Commands out of sync Ignoring user Table 'tbl_name' doesn't exist Can't initialize character set File Not Found and Similar Errors Table-Corruption Issues Administration-Related Issues Problems with File Permissions How to Reset the Root Password What to Do If MySQL Keeps Crashing How MySQL Handles a Full Disk Where MySQL Stores Temporary Files How to Protect or Change the MySQL Unix Socket File Time Zone Problems Query-Related Issues Case Sensitivity in String Searches Problems Using DATE Columns Problems with NULL Values Problems with Column Aliases Rollback Failure for Nontransactional Tables Deleting Rows from Related Tables Solving Problems with No Matching Rows Problems with Floating-Point Values Optimizer-Related Issues Table Definition-Related Issues Problems with AL
they could be. But never the less read them carefully. Most of the time http://www.fromdual.com/mysql-error-codes-and-messages 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 https://major.io/2007/08/09/mysql-error-codes/ 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 error mysql> SHOW WARNINGS is often your friend! Further sources to find the problems are: mysql> SHOW SLAVE STATUS\G shell> perror
you need a good reference, and this is one of those times. MySQL's perror command returns many error codes, and I've provided a listing here. To find errors individually, just run: XHTML # perror 28 OS error code 28: No space left on device 12 # perror 28OS error code28:No space left on device Here's the list: XHTML OS error code 1: Operation not permitted OS error code 2: No such file or directory OS error code 3: No such process OS error code 4: Interrupted system call OS error code 5: Input/output error OS error code 6: No such device or address OS error code 7: Argument list too long OS error code 8: Exec format error OS error code 9: Bad file descriptor OS error code 10: No child processes OS error code 11: Resource temporarily unavailable OS error code 12: Cannot allocate memory OS error code 13: Permission denied OS error code 14: Bad address OS error code 15: Block device required OS error code 16: Device or resource busy OS error code 17: File exists OS error code 18: Invalid cross-device link OS error code 19: No such device OS error code 20: Not a directory OS error code 21: Is a directory OS error code 22: Invalid argument OS error code 23: Too many open files in system OS error code 24: Too many open files OS error code 25: Inappropriate ioctl for device OS error code 26: Text file busy OS error code 27: File too large OS error code 28: No space left on device OS error code 30: Read-only file system OS error code 31: Too many links OS error code 32: Broken pipe OS error code 33: Numerical argument out of domain OS error code 34: Numerical result out of range OS error code 35: Resource deadlock avoided OS error code 36: File name too long OS error code 37: No locks available OS error code 38: Function not implemented OS error code 39: Directory not empty OS error code 40: Too many levels of symbolic links OS error code 42: No message of desired type OS error code 43: Identifier removed OS error code 44: Channel number out of range OS error code 45: Level 2 not synchronized OS error code 46: Level 3 halted OS error code 47: Level 3 reset OS error code 48: Link number out of range OS error code 49: Protocol driver not attached OS error code 50: No CSI structure available OS error code 51: Level 2 halted OS error code 52: Invalid exchange OS error code 53: Invalid request descriptor OS error code 54: Exchange full OS error code 55: No anode OS error code 56: Invalid request code OS error code 57: Invalid slot OS error code 59: Bad font file format OS error code 60: Device not a stream OS error code 61: No data available OS error code 62: Timer