Message: Error reading file '%s' (errno: %d)Įrror: 1025 SQLSTATE: HY000 ( ER_ERROR_ON_RENAME) Message: Error on close of '%s' (errno: %d)Įrror: 1024 SQLSTATE: HY000 ( ER_ERROR_ON_READ) Message: Can't write duplicate key in table '%s'Įrror: 1023 SQLSTATE: HY000 ( ER_ERROR_ON_CLOSE) Message: Disk full (%s) waiting for someone to free some space.Įrror: 1022 SQLSTATE: 23000 ( ER_DUP_KEY) Message: Record has changed since last read in table '%s'Įrror: 1021 SQLSTATE: HY000 ( ER_DISK_FULL) Message: Can't change dir to '%s' (errno: %d)Įrror: 1020 SQLSTATE: HY000 ( ER_CHECKREAD) Message: Can't read dir of '%s' (errno: %d)Įrror: 1019 SQLSTATE: HY000 ( ER_CANT_SET_WD) Message: Can't find file: '%s' (errno: %d)Įrror: 1018 SQLSTATE: HY000 ( ER_CANT_READ_DIR) Message: Can't open file: '%s' (errno: %d)Įrror: 1017 SQLSTATE: HY000 ( ER_FILE_NOT_FOUND) Message: Can't get working directory (errno: %d)Įrror: 1015 SQLSTATE: HY000 ( ER_CANT_LOCK)Įrror: 1016 SQLSTATE: HY000 ( ER_CANT_OPEN_FILE) Message: Can't get status of '%s' (errno: %d)Įrror: 1014 SQLSTATE: HY000 ( ER_CANT_GET_WD) Message: Can't read record in system tableĮrror: 1013 SQLSTATE: HY000 ( ER_CANT_GET_STAT) Message: Error on delete of '%s' (errno: %d)Įrror: 1012 SQLSTATE: HY000 ( ER_CANT_FIND_SYSTEM_REC) Message: Error dropping database (can't rmdir '%s', errno: %d)Įrror: 1011 SQLSTATE: HY000 ( ER_CANT_DELETE_FILE) Message: Error dropping database (can't delete '%s', errno: %d)Įrror: 1010 SQLSTATE: HY000 ( ER_DB_DROP_RMDIR) Message: Can't drop database '%s' database doesn't existĮrror: 1009 SQLSTATE: HY000 ( ER_DB_DROP_DELETE) Message: Can't create database '%s' database existsĮrror: 1008 SQLSTATE: HY000 ( ER_DB_DROP_EXISTS) Message: Can't create database '%s' (errno: %d)Įrror: 1007 SQLSTATE: HY000 ( ER_DB_CREATE_EXISTS) Message: Can't create table '%s' (errno: %d)Įrror: 1006 SQLSTATE: HY000 ( ER_CANT_CREATE_DB) Message: Can't create file '%s' (errno: %d)Įrror: 1005 SQLSTATE: HY000 ( ER_CANT_CREATE_TABLE) For information about errors related to InnoDB, see Section 14.3.13, "InnoDB Error Handling".Įrror: 1000 SQLSTATE: HY000 ( ER_HASHCHK)Įrror: 1001 SQLSTATE: HY000 ( ER_NISAMCHK)Įrror: 1004 SQLSTATE: HY000 ( ER_CANT_CREATE_FILE) See Section 4.8.1, " perror - Explain Error Codes".ĭescriptions of server and client errors are provided later in this Appendix. The perror program provides information from the command line about error numbers. SHOW ENGINE INNODB STATUS statement output includes information about the most recent foreign key error if a CREATE TABLE statement for an InnoDB table fails. SHOW SLAVE STATUS statement output includes information about replication errors occurring on the slave side. The error_count system variable indicates the number of errors. The warning_count system variable indicates the number of errors, warnings, and notes. SQL statement warning and error information is available through the SHOW WARNINGS and SHOW ERRORS statements. These errors are returned from the server side see Section C.3, "Server Error Codes and Messages".Įrrors can occur on the client side, usually involving problems communicating with the server see Section C.4, "Client Error Codes and Messages". Each SQL statement executed results in an error code, an SQLSTATE value, and an error message, as described in Section C.2, "Types of Error Values".
0 Comments
Leave a Reply. |