This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1030
HY000
ER_GET_ERRN
Got error %d from storage engine
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1048
23000
ER_BAD_NULL_ERROR
Column '%s' cannot be null
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1078
HY000
ER_GOT_SIGNAL
%s: Got signal %d. Aborting!
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1060
42S21
ER_DUP_FIELDNAME
Duplicate column name '%s'
Error 1019: Can't change dir to
Error Code
SQLSTATE
Error
Description
1019
HY000
ER_CANT_SET_WD
Can't change dir to '%s' (errno: %d)
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1024: Error reading file
Error Code
SQLSTATE
Error
Description
1024
HY000
ER_ERROR_ON_READ
Error reading file '%s' (errno: %d)
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1071: Specified key was too long; max key length is
Error Code
SQLSTATE
Error
Description
1071
42000
ER_TOO_LONG_KEY
Specified key was too long; max key length is %d bytes
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1075: Incorrect table definition; there can be only one auto column and it must be defined as
Error Code
SQLSTATE
Error
Description
1075
42000
ER_WRONG_AUTO_KEY
Incorrect table definition; there can be only one auto column and it must be defined as a key
Possible Causes and Solutions
There can only be one column per table, and the column must be defined as a . Not adhering to either of these restrictions will result in this error. For example:
This page is licensed: CC BY-SA / Gnu FDL
Error 1052: Column is ambiguous
Error Code
SQLSTATE
Error
Description
1052
23000
ER_NON_UNIQ_ERROR
Column '%s' in %s is ambiguous
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1074: Column length too big for column; use BLOB or TEXT instead
Error Code
SQLSTATE
Error
Description
1074
42000
ER_TOO_BIG_FIELDLENGTH
Column length too big for column '%s' (max = %lu); use BLOB or TEXT instead
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1088: Records Duplicates
Error Code
SQLSTATE
Error
Description
1088
HY000
ER_ALTER_INF
Records: %ld Duplicates: %ld
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1033: Incorrect information in file
Error Code
SQLSTATE
Error
Description
1033
HY000
ER_NOT_FORM_FILE
Incorrect information in file: '%s'
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1098: Can't generate a unique log-filename
Error Code
SQLSTATE
Error
Description
1098
HY000
ER_NO_UNIQUE_LOGFILE
Can't generate a unique log-filename %s.(1-999)
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1029: View doesn't exist for
Error Code
SQLSTATE
Error
Description
1029
HY000
ER_FORM_NOT_FOUND
View '%s' doesn't exist for '%s'
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1077: Normal shutdown
Error Code
SQLSTATE
Error
Description
1077
HY000
ER_NORMAL_SHUTDOWN
%s: Normal shutdown
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1056: Can't group on
Error Code
SQLSTATE
Error
Description
1056
42000
ER_WRONG_GROUP_FIELD
Can't group on '%s'
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1092: Records Duplicates Warnings
Error Code
SQLSTATE
Error
Description
1092
HY000
ER_INSERT_INF
Records: %ld Duplicates: %ld Warnings: %ld
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1067: Invalid default value for
Error Code
SQLSTATE
Error
Description
1067
42000
ER_INVALID_DEFAULT
Invalid default value for '%s'
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1040: Too many connections
Error Code
SQLSTATE
Error
Description
1040
08004
ER_CON_COUNT_ERROR
Too many connections
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1058: Column count doesn't match value count
Error Code
SQLSTATE
Error
Description
1058
21S01
ER_WRONG_VALUE_COUNT
Column count doesn't match value count
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1094: Unknown thread id
Error Code
SQLSTATE
Error
Description
1094
HY000
ER_NO_SUCH_THREAD
Unknown thread id: %lu
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1051: Unknown table
Error Code
SQLSTATE
Error
Description
1051
42S02
ER_BAD_TABLE_ERROR
Unknown table '%s'
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1047: Unknown command
Error Code
SQLSTATE
Error
Description
1047
08S01
ER_UNKNOWN_COM_ERROR
Unknown command
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1049: Unknown database
Error Code
SQLSTATE
Error
Description
1049
42000
ER_BAD_DB_ERROR
Unknown database '%s'
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1053: Server shutdown in progress
Error Code
SQLSTATE
Error
Description
1053
08S01
ER_SERVER_SHUTDOWN
Server shutdown in progress
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1081: Can't create IP socket
Error Code
SQLSTATE
Error
Description
1081
08S01
ER_IPSOCK_ERROR
Can't create IP socket
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1037: Out of memory; restart server and try again
Error Code
SQLSTATE
Error
Description
1038
HY001
ER_OUT_OF_SORTMEMORY
Out of sort memory, consider increasing server sort buffer size
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1065: Query was empty
Error Code
SQLSTATE
Error
Description
1065
42000
ER_EMPTY_QUERY
Query was empty
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1082: Table has no index like the one used in CREATE INDEX; recreate the table
Error Code
SQLSTATE
Error
Description
1082
42S12
ER_NO_SUCH_INDEX
Table '%s' has no index like the one used in CREATE INDEX; recreate the table
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1084: You can't use fixed rowlength with BLOBs; please use 'fields terminated by'
Error Code
SQLSTATE
Error
Description
1084
42000
ER_BLOBS_AND_NO_TERMINATED
You can't use fixed rowlength with BLOBs; please use 'fields terminated by'
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1073: BLOB column can't be used in key specification with the used table type
Error Code
SQLSTATE
Error
Description
1073
42000
ER_BLOB_USED_AS_KEY
BLOB column '%s' can't be used in key specification with the used table type
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1021: Disk full (%s); waiting for someone to free some space
Error Code
SQLSTATE
Error
Description
Error 1093: You can't specify target table for update in FROM clause
Error Code
SQLSTATE
Error
Description
Error 1068: Multiple primary key defined
Error Code
SQLSTATE
Error
Description
Error 1044: Access denied for user
Error Code
SQLSTATE
Error
Description
Error 1050: Table already exists
Error Code
SQLSTATE
Error
Description
Error 1059: Identifier name is too long
Error Code
SQLSTATE
Error
Description
Error 1072: Key column doesn't exist in table
Error Code
SQLSTATE
Error
Description
Error 1079: Shutdown complete
Error Code
SQLSTATE
Error
Description
Error 1087: Records Deleted Skipped Warnings
Error Code
SQLSTATE
Error
Description
Error 1090: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
Error Code
SQLSTATE
Error
Description
Error 1057: Statement has sum functions and columns in same statement
Error Code
SQLSTATE
Error
Description
Error 1043: Bad handshake
Error Code
SQLSTATE
Error
Description
Error 1089: Incorrect prefix key; the used key part isn't a string, the used length is longer than t
Error Code
SQLSTATE
Error
Description
Error 1076: ready for connections
Error Code
SQLSTATE
Error
Description
Error 1055: isn't in GROUP BY
Error Code
SQLSTATE
Error
Description
Error 1095: You are not owner of thread
Error Code
SQLSTATE
Error
Description
Error 1042: Can't get hostname for your address
Error Code
SQLSTATE
Error
Description
Error 1064: near at line
Error Code
SQLSTATE
Error
Description
Error 1010: Error dropping database (can't rmdir)
Error Code
SQLSTATE
Error
Description
Possible Causes and Solutions
The user is trying to access a database/schema they do not have access to. See Troubleshooting Connection Issues for more, as well as GRANT for details on setting permissions.
No more than one primary key can be defined per table. Attempting to define more in a single table will result in this error. For example:
It's also possible that this error results from a mistaken attempt to define a multi-part primary key. This is an example of the correct definition for such a key.
This page is licensed: CC BY-SA / Gnu FDL
1068
42000
ER_MULTIPLE_PRI_KEY
Multiple primary key defined
CREATE TABLE t1(
c1 INT NOT NULL AUTO_INCREMENT,
c2 INT NOT NULL,
PRIMARY KEY(c1),
PRIMARY KEY(c2)
);
ERROR 1068 (42000): Multiple primary key defined
CREATE TABLE t1(
c1 INT NOT NULL AUTO_INCREMENT,
c2 INT NOT NULL,
PRIMARY KEY(c1)
);
CREATE OR REPLACE TABLE animals (
id1 MEDIUMINT NOT NULL AUTO_INCREMENT,
id2 TINYINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (id1),
KEY (id2)
);
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key
CREATE OR REPLACE TABLE animals (
id1 MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL
);
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key
CREATE OR REPLACE TABLE animals (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (id)
);
Query OK, 0 rows affected (0.017 sec)
CREATE TABLE t1(
c1 INT NOT NULL AUTO_INCREMENT,
c2 INT NOT NULL,
PRIMARY KEY(c1, c2)
);
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1021
HY000
ER_DISK_FULL
Disk full (%s); waiting for someone to free some space...
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1093
HY000
ER_UPDATE_TABLE_USED
You can't specify target table '%s' for update in FROM clause
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1050
42S01
ER_TABLE_EXISTS_ERROR
Table '%s' already exists
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1059
42000
ER_TOO_LONG_IDENT
Identifier name '%s' is too long
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1072
42000
ER_KEY_COLUMN_DOES_NOT_EXITS
Key column '%s' doesn't exist in table
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1079
HY000
ER_SHUTDOWN_COMPLETE
%s: Shutdown complete
Possible Causes and Solutions
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1090
42000
ER_CANT_REMOVE_ALL_FIELDS
You can't delete all columns with ALTER TABLE; use DROP TABLE instead
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1057
42000
ER_WRONG_SUM_SELECT
Statement has sum functions and columns in same statement
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1043
08S01
ER_HANDSHAKE_ERROR
Bad handshake
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1089
HY000
ER_WRONG_SUB_KEY
Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1076
HY000
ER_READY
%s: ready for connections. Version: '%s' socket: '%s' port: %d
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1055
42000
ER_WRONG_FIELD_WITH_GROUP
'%s' isn't in GROUP BY
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1095
HY000
ER_KILL_DENIED_ERROR
You are not owner of thread %lu
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1042
08S01
ER_BAD_HOST_ERROR
Can't get hostname for your address
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1064
42000
ER_PARSE_ERROR
%s near '%s' at line %d
Possible Causes and Solutions
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1066: Not unique table/alias
Error Code
SQLSTATE
Error
Description
1066
42000
ER_NONUNIQ_TABLE
Not unique table/alias: '%s'
Possible Causes and Solutions
In order to avoid ambiguity, a table name or alias must uniquely identify an object. There are many situations where this could occur.
For example, statements use unqualified table names, requiring the use of an alias in certain contexts. For example:
In the previous example, the HANDLER was opened with the t1 table name. Since HANDLERs use unqualified table names, trying to access another table with this same name, even though it's in another database, will result in ambiguity. An alias needs to be used to avoid the ambiguity:
This page is licensed: CC BY-SA / Gnu FDL
Error 1063: Incorrect column specifier for column
Error Code
SQLSTATE
Error
Description
1063
42000
ER_WRONG_FIELD_SPEC
Incorrect column specifier for column '%s'
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1080: Forcing close of thread
Error Code
SQLSTATE
Error
Description
1080
08S01
ER_FORCING_CLOSE
%s: Forcing close of thread %ld user: '%s'
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1045: Access denied for user (using password)
Error Code
SQLSTATE
Error
Description
1045
28000
ER_ACCESS_DENIED_ERROR
Access denied for user '%s'@'%s' (using password: %s)
Possible Causes and Solutions
The user/password combination does not exist or the user does not have privileges to the given database. See for more, as well as for details on setting permissions.
See Also
This page is licensed: CC BY-SA / Gnu FDL
Error 1096: No tables used
Error Code
SQLSTATE
Error
Description
1096
HY000
ER_NO_TABLES_USED
No tables used
Possible Causes and Solutions
This article doesn't currently contain any content.
CREATE DATABASE db_new;
CREATE TABLE db_new.t1 (id INT);
INSERT INTO db_new.t1 VALUES (4),(5),(6);
HANDLER db_new.t1 OPEN;
ERROR 1066 (42000): Not unique table/alias: 't1'
HANDLER db_new.t1 OPEN AS db_new_t1;
HANDLER db_new_t1 READ NEXT LIMIT 3;
+------+
| id |
+------+
| 4 |
| 5 |
| 6 |
+------+
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1086
HY000
ER_FILE_EXISTS_ERROR
File '%s' already exists
Error 1032: Can't find record in
Error Code
SQLSTATE
Error
Description
1032
HY000
ER_KEY_NOT_FOUND
Can't find record in '%s'
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1023: Error on close of
Error Code
SQLSTATE
Error
Description
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1023
HY000
ER_ERROR_ON_CLOSE
Error on close of '%s' (errno: %d)
Error 1005: Can't create table
Error Code
SQLSTATE
Error
Description
1005
HY000
ER_CANT_CREATE_TABLE
Can't create table '%s' (errno: %d)
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1062: Duplicate entry for key
Error Code
SQLSTATE
Error
Description
Error 1046: No database selected
Error Code
SQLSTATE
Error
Description
Possible Causes and Solutions
This error occurs when a key that requires a unique value (unique or primary) instead receives a duplicate.
For example:
Solve the error by either not attempting to insert a duplicate value, or not requiring the key to be unique. For example, the below replaces the unique index with an index permitting duplicates:
This page is licensed: CC BY-SA / Gnu FDL
1062
23000
ER_DUP_ENTRY
Duplicate entry '%s' for key %d
CREATE TABLE t1 (
id INT AUTO_INCREMENT PRIMARY KEY,
f VARCHAR(10) UNIQUE
);
INSERT INTO t1 (f) VALUES ('a'),('b');
SELECT * FROM t1;
+----+------+
| id | f |
+----+------+
| 1 | a |
| 2 | b |
+----+------+
INSERT INTO t1 (f) VALUES ('b'),('c');
ERROR 1062 (23000): Duplicate entry 'b' for key 'f'
ALTER TABLE t1 DROP INDEX f, ADD INDEX (f);
INSERT INTO t1 (f) VALUES ('b'),('c');
SELECT * FROM t1;
+----+------+
| id | f |
+----+------+
| 1 | a |
| 2 | b |
| 3 | b |
| 4 | c |
+----+------+
Possible Causes and Solutions
This article doesn't currently contain any content.
Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
Possible Causes and Solutions
This article doesn't currently contain any content.