All pages
Powered by GitBook
Couldn't generate the PDF for 101 pages, generation stopped at 100.
Extend with 50 more pages.
1 of 100

MariaDB Error Codes 1100 to 1199

Error 1100: Table was not locked with LOCK TABLES

Error Code
SQLSTATE
Error
Description

1100

HY000

ER_TABLE_NOT_LOCKED

Table '%s' was not locked with LOCK TABLES

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1101: You should never see it

Error Code
SQLSTATE
Error
Description

1101

ER_UNUSED_17

You should never see it

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1102: Incorrect database name

Error Code
SQLSTATE
Error
Description

1102

42000

ER_WRONG_DB_NAME

Incorrect database name '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1103: Incorrect table name

Error Code
SQLSTATE
Error
Description

1103

42000

ER_WRONG_TABLE_NAME

Incorrect table name '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1104: The SELECT would examine more than MAX_JOIN_SIZE rows

Error 1104: The SELECT would examine more than MAX_JOIN_SIZE rows

Error Code
SQLSTATE
Error
Description

1104

42000

ER_TOO_BIG_SELECT

The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1105: Unknown error

Error Code
SQLSTATE
Error
Description

1105

HY000

ER_UNKNOWN_ERROR

Unknown error

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1106: Unknown procedure

Error Code
SQLSTATE
Error
Description

1106

42000

ER_UNKNOWN_PROCEDURE

Unknown procedure '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1107: Incorrect parameter count to procedure

Error Code
SQLSTATE
Error
Description

1107

42000

ER_WRONG_PARAMCOUNT_TO_PROCEDURE

Incorrect parameter count to procedure '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1108: Incorrect parameters to procedure

Error Code
SQLSTATE
Error
Description

1108

HY000

ER_WRONG_PARAMETERS_TO_PROCEDURE

Incorrect parameters to procedure '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1109: Unknown table

Error Code
SQLSTATE
Error
Description

1109

42S02

ER_UNKNOWN_TABLE

Unknown table '%s' in %s

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1110: Column specified twice

Error Code
SQLSTATE
Error
Description

1110

42000

ER_FIELD_SPECIFIED_TWICE

Column '%s' specified twice

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1111: Invalid use of group function

Error Code
SQLSTATE
Error
Description

1111

HY000

ER_INVALID_GROUP_FUNC_USE

Invalid use of group function

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1112: Table uses an extension that doesn't exist in this MariaDB version

Error Code
SQLSTATE
Error
Description

1112

42000

ER_UNSUPPORTED_EXTENSION

Table '%s' uses an extension that doesn't exist in this MariaDB version

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1113: A table must have at least 1 column

Error Code
SQLSTATE
Error
Description

1113

42000

ER_TABLE_MUST_HAVE_COLUMNS

A table must have at least 1 column

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1114: The table is full

Error Code
SQLSTATE
Error
Description

1114

HY000

ER_RECORD_FILE_FULL

The table '%s' is full

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1115: Unknown character set

Error Code
SQLSTATE
Error
Description

1115

42000

ER_UNKNOWN_CHARACTER_SET

Unknown character set: '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1116: Too many tables; MariaDB can only use tables in a join

Error Code
SQLSTATE
Error
Description

1116

HY000

ER_TOO_MANY_TABLES

Too many tables; MariaDB can only use %d tables in a join

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1117: Too many columns

Error Code
SQLSTATE
Error
Description

1117

HY000

ER_TOO_MANY_FIELDS

Too many columns

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1118: Row size too large

Error Code
SQLSTATE
Error
Description

1118

42000

ER_TOO_BIG_ROWSIZE

Row size too large. The maximum row size for the used table type, not counting BLOBs, is %ld. You have to change some columns to TEXT or BLOBs

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1119: Thread stack overrun

Error Code
SQLSTATE
Error
Description

1119

HY000

ER_STACK_OVERRUN

Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld --thread_stack=#' to specify a bigger stack if needed

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1120: Cross dependency found in OUTER JOIN; examine your ON conditions

Error Code
SQLSTATE
Error
Description

1120

42000

ER_WRONG_OUTER_JOIN

Cross dependency found in OUTER JOIN; examine your ON conditions

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1121: Table handler doesn't support NULL in given index

Error Code
SQLSTATE
Error
Description

1121

42000

ER_NULL_COLUMN_IN_INDEX

Table handler doesn't support NULL in given index. Please change column '%s' to be NOT NULL or use another handler

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1122: Can't load function

Error Code
SQLSTATE
Error
Description

1122

HY000

ER_CANT_FIND_UDF

Can't load function '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1123: Can't initialize function

Error Code
SQLSTATE
Error
Description

1123

HY000

ER_CANT_INITIALIZE_UDF

Can't initialize function '%s'; %s

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1124: No paths allowed for shared library

Error Code
SQLSTATE
Error
Description

1124

HY000

ER_UDF_NO_PATHS

No paths allowed for shared library

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1125: Function already exists

Error Code
SQLSTATE
Error
Description

1125

HY000

ER_UDF_EXISTS

Function '%s' already exists

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1126: Can't open shared library

Error 1127: Can't find symbol in library

Error Code
SQLSTATE
Error
Description

1127

HY000

ER_CANT_FIND_DL_ENTRY

Can't find symbol '%s' in library

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1128: Function is not defined

Error Code
SQLSTATE
Error
Description

1128

HY000

ER_FUNCTION_NOT_DEFINED

Function '%s' is not defined

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1129: Host is blocked because of many connection errors

Error Code
SQLSTATE
Error
Description

1129

HY000

ER_HOST_IS_BLOCKED

Host '%s' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1130: Host is not allowed to connect to this MariaDB server

Error Code
SQLSTATE
Error
Description

1130

HY000

ER_HOST_NOT_PRIVILEGED

Host '%s' is not allowed to connect to this MariaDB server

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1131: You are using MariaDB as an anonymous user

Error Code
SQLSTATE
Error
Description

1131

42000

ER_PASSWORD_ANONYMOUS_USER

You are using MariaDB as an anonymous user and anonymous users are not allowed to change passwords

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1132: You must have privileges to update tables in the mysql database

Error Code
SQLSTATE
Error
Description

1132

42000

ER_PASSWORD_NOT_ALLOWED

You must have privileges to update tables in the mysql database to be able to change passwords for others

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1133: Can't find any matching row in the user table

Error Code
SQLSTATE
Error
Description

1133

42000

ER_PASSWORD_NO_MATCH

Can't find any matching row in the user table

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1134: Rows matched Changed Warnings

Error Code
SQLSTATE
Error
Description

1134

HY000

ER_UPDATE_INF

Rows matched: %ld Changed: %ld Warnings: %ld

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1135: Can't create a new thread

Error Code
SQLSTATE
Error
Description

1135

HY000

ER_CANT_CREATE_THREAD

Can't create a new thread (Errno %d); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1136: Column count doesn't match value count at row

Error Code
SQLSTATE
Error
Description

1136

21S01

ER_WRONG_VALUE_COUNT_ON_ROW

Column count doesn't match value count at row %ld

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1137: Can't reopen table

Error Code
SQLSTATE
Error
Description

1137

HY000

ER_CANT_REOPEN_TABLE

Can't reopen table: '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1138: Invalid use of NULL value

Error Code
SQLSTATE
Error
Description

1138

22004

ER_INVALID_USE_OF_NULL

Invalid use of NULL value

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1139: Got error from regexp

Error Code
SQLSTATE
Error
Description

1139

42000

ER_REGEXP_ERROR

Got error '%s' from regexp

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1140: Mixing of GROUP columns with no GROUP columns

Error Code
SQLSTATE
Error
Description

1140

42000

ER_MIX_OF_GROUP_FUNC_AND_FIELDS

Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1141: There is no such grant defined for user on host

Error Code
SQLSTATE
Error
Description

1141

42000

ER_NONEXISTING_GRANT

There is no such grant defined for user '%s' on host '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1142: command denied to user for table

Error Code
SQLSTATE
Error
Description

1142

42000

ER_TABLEACCESS_DENIED_ERROR

%s command denied to user '%s'@'%s' for table '%s'

Possible Causes and Solutions

The user is trying to access a table or a column from a table they do not have access to. See GRANT for details on setting permissions.

See Also

  • When access_denied_errors status variable is incremented

This page is licensed: CC BY-SA / Gnu FDL

Error 1143: command denied to user for column in table

Error Code
SQLSTATE
Error
Description

1143

42000

ER_COLUMNACCESS_DENIED_ERROR

%s command denied to user '%s'@'%s' for column '%s' in table '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1144: Illegal GRANT/REVOKE command

Error Code
SQLSTATE
Error
Description

1144

42000

ER_ILLEGAL_GRANT_FOR_TABLE

Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1145: The host or user argument to GRANT is too long

Error Code
SQLSTATE
Error
Description

1145

42000

ER_GRANT_WRONG_HOST_OR_USER

The host or user argument to GRANT is too long

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1146: Table doesn't exist

Error Code
SQLSTATE
Error
Description

1146

42S02

ER_NO_SUCH_TABLE

Table '%s.%s' doesn't exist

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1147: There is no such grant defined for user on host on table

Error Code
SQLSTATE
Error
Description

1147

42000

ER_NONEXISTING_TABLE_GRANT

There is no such grant defined for user '%s' on host '%s' on table '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1148: The used command is not allowed with this MariaDB version

Error Code
SQLSTATE
Error
Description

1148

42000

ER_NOT_ALLOWED_COMMAND

The used command is not allowed with this MariaDB version

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1149: You have an error in your SQL syntax

Error Code
SQLSTATE
Error
Description

1149

42000

ER_SYNTAX_ERROR

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use

Possible Causes and Solutions

This is one of the most common errors to see. It's caused by an SQL syntax error. The error message will give you a clue as to where the error could be, as MariaDB displays the text following where it picked up an error. There are a huge number of possible causes (and in most cases they're simple typos), but here are a few common ones;

Delimiters

Delimiters need to be present at the end of each statement. See Delimiters. For example:

SELECT 1
SELECT 2;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds 
  to your MariaDB server version for the right syntax to use near 'SELECT 2' at line 2

Here, there was no delimiter separating the first and the second line. MariaDB picked up the error at the start of the second line, pointing one to the end of the first line. The correct syntax is:

SELECT 1;
SELECT 2;

Delimiters in Stored Programs

When creating stored programs from the command-line, it is likely you will need to differentiate between the regular delimiter and a delimiter inside a BEGIN END block. See Delimiters.

For example, take the following, seemingly-valid declaration:

CREATE FUNCTION FortyTwo() RETURNS TINYINT DETERMINISTIC
BEGIN
  DECLARE x TINYINT;
  SET x = 42;
  RETURN x;
END;

Attempting to run will result in an error:

CREATE FUNCTION FortyTwo() RETURNS TINYINT DETERMINISTIC
    -> BEGIN
    ->   DECLARE x TINYINT;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds 
  to your MariaDB server version for the right syntax to use near '' at line 3

The error was picked up at the end of the DECLARE x TINYINT; line, guiding one to the delimiter found there. The solution is to specify a distinct delimiter for the duration of the process, using the DELIMITER command, for example:

DELIMITER //

CREATE FUNCTION FortyTwo() RETURNS TINYINT DETERMINISTIC
BEGIN
  DECLARE x TINYINT;
  SET x = 42;
  RETURN x;
END 

//

DELIMITER ;

Reserved Words

Reserved words cannot be used as identifiers unless they are quoted. For example:

CREATE TABLE accessible(id INT);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds 
  to your MariaDB server version for the right syntax to use near 'accessible(id INT)' at line 1

The error was picked up after the accessible identifier, leading one to suspect that it's causing the problem. And indeed, it's a reserved word. There are a number of possible solutions.

Use a new, non-reserved, identifier:

CREATE TABLE accessible_status(id INT);

or quote the identifier:

CREATE TABLE `accessible`(id INT);

or fully qualify the identifier:

CREATE TABLE test.accessible(id INT);

Syntax Doesn't Match SQL_MODE

Some syntax may be valid in a particular SQL_MODE, but not in others. There are too many to list here, but the SQL_MODE page provides a full list. For example:

CREATE TABLE "t" (id INT);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds 
  to your MariaDB server version for the right syntax to use near '"t" (id INT)' at line 1

The error message directs one to the identifier t. Double quotes cannot be used to quote identifiers unless ANSI_MODE is set, which in this case it isn't:

select @@sql_mode;
+-------------------------------------------------------------------------------------------+
| @@sql_mode                                                                                |
+-------------------------------------------------------------------------------------------+
| STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+-------------------------------------------------------------------------------------------+

Either quote with the standard quote character, the backtick, or set the appropriate SQL_MODE:

SET @@SQL_MODE = CONCAT(@@SQL_MODE, ',ANSI_QUOTES');
CREATE TABLE "t" (id INT);

Oracle Mode

Oracle mode in particular has a large number of differences to the default SQL_MODE, for example:

CREATE TABLE t (id VARCHAR2(10));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds 
  to your MariaDB server version for the right syntax to use near '(10))' at line 1

The error is identified just after the VARCHAR2 type is specified, and this type is not valid in the default mode:

SELECT @@sql_mode;
+--------------------------------------------------------------------+
| @@sql_mode                                                         |
+--------------------------------------------------------------------+
| STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER |
+--------------------------------------------------------------------+
SET SQL_MODE='ORACLE';
CREATE TABLE t (id VARCHAR2(10));

See Oracle mode for a full list of syntax differences.

This page is licensed: CC BY-SA / Gnu FDL

Error 1150: Delayed insert thread couldn't get requested lock for table

Error Code
SQLSTATE
Error
Description

1150

HY000

ER_DELAYED_CANT_CHANGE_LOCK

Delayed insert thread couldn't get requested lock for table %s

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1151: Too many delayed threads in use

Error Code
SQLSTATE
Error
Description

1151

HY000

ER_TOO_MANY_DELAYED_THREADS

Too many delayed threads in use

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1152: Aborted connection to db user

Error Code
SQLSTATE
Error
Description

1152

08S01

ER_ABORTING_CONNECTION

Aborted connection %ld to db: '%s' user: '%s' (%s)

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1153: Got a packet bigger than 'max_allowed_packet' bytes

Error Code
SQLSTATE
Error
Description

1153

08S01

ER_NET_PACKET_TOO_LARGE

Got a packet bigger than 'max_allowed_packet' bytes

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1154: Got a read error from the connection pipe

Error Code
SQLSTATE
Error
Description

1154

08S01

ER_NET_READ_ERROR_FROM_PIPE

Got a read error from the connection pipe

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1155: Got an error from fcntl()

Error Code
SQLSTATE
Error
Description

1155

08S01

ER_NET_FCNTL_ERROR

Got an error from fcntl()

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1156: Got packets out of order

Error Code
SQLSTATE
Error
Description

1156

08S01

ER_NET_PACKETS_OUT_OF_ORDER

Got packets out of order

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1157: Couldn't uncompress communication packet

Error Code
SQLSTATE
Error
Description

1157

08S01

ER_NET_UNCOMPRESS_ERROR

Couldn't uncompress communication packet

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1158: Got an error reading communication packets

Error Code
SQLSTATE
Error
Description

1158

08S01

ER_NET_READ_ERROR

Got an error reading communication packets

Possible Causes

This error tells us that the connection between the server and client was aborted. The most common cause is that the client hard-aborted the connection, without calling mysql_close(). It could also be a problem with the connection to the server, such as a wrong or lost package.

How to Find Out More

The error log may have more information about the cause of the error. Setting the MariaDB server option log_warnings to a value of 4 or above can generate more diagnostic warnings in the error log when there is a problem reading packages:

2024-04-19 17:02:11 20090 [Warning] mariadbd: Could not read packet: fd: 4575  state: 1  read_length: 4  errno: 104  vio_errno: 1158  length: -1

How to interpret the above:

  • 20090 is the connection id that got the warning/error.

  • fd: 4575 4575 is the file descriptor that had a problem.

  • state: 1 shows that the file is open. Anything else means the file is not active. Note that in some cases MariaDB will try to abort a read on a file descriptor by closing it.

  • read_length: 4 is how many characters the server tried to read from the file.

  • errno 104 is the system error code (more below).

  • vio_errno: 1158 is our internal error code from the vio library, which stands for ER_NET_READ_ERROR "Got an error reading communication packets".

  • length: -1 is how many characters was reported to be read from the read() system call. -1 indicates failure. If length <= read_length then something broke in the communication.

You can use the perror utility to get a description of system and storage engine errors:

shell> perror 104
OS error code 104: Connection reset by peer

This means the connection was aborted by the application/user.

How to Fix

  • Ensure you have a stable internet connection.

  • Ensure that your applications calls mysql_close() for all open connections before exiting.

See Also

  • perror Getting a description for an error number.

This page is licensed: CC BY-SA / Gnu FDL

Error 1159: Got timeout reading communication packets

Error Code
SQLSTATE
Error
Description

1159

08S01

ER_NET_READ_INTERRUPTED

Got timeout reading communication packets

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1160: Got an error writing communication packets

Error Code
SQLSTATE
Error
Description

1160

08S01

ER_NET_ERROR_ON_WRITE

Got an error writing communication packets

Possible Causes

This error tells us that the connection between the server and client was aborted. The most common cause is that the client hard-aborted the connection, without calling mysql_close(). It could also be a problem with the connection to the server, such as a wrong or lost package.

How to Find Out More

The error log may have more information about the cause of the error. Setting the MariaDB server option log_warnings to a value of 4 or above can generate more diagnostic warnings in the error log when there is a problem reading packages:

2024-02-17 12:32:45 5461 [ERROR] mariadbd: Could not write packet: fd: 406  state: 2  errno: 32  vio_errno: 1160  length: 34

How to interpret the above:

  • 5461 is the connection id that got the warning/error.

  • fd: 406 406 is the file descriptor that had a problem.

  • state: 2

  • length: 34 is how many characters the server tried to wrote to the file.

  • errno 32 is the system error code (more below).

  • vio_errno: 1160 is our internal error code from the vio library, which stands for ER_NET_WRITE_ERROR "Got an error writing communication packets".

  • length: -1 is how many characters was reported to be read from the read() system call. -1 indicates failure. If length <= read_length then something broke in the communication.

You can use the perror utility to get a description of system and storage engine errors:

shell> perror 104
OS error code 104: Connection reset by peer

This means the connection was aborted by the application/user.

How to Fix

  • Ensure you have a stable internet connection.

  • Ensure that your applications calls mysql_close() for all open connections before exiting.

See Also

  • perror Getting a description for an error number.

This page is licensed: CC BY-SA / Gnu FDL

Error 1161: Got timeout writing communication packets

Error Code
SQLSTATE
Error
Description

1161

08S01

ER_NET_WRITE_INTERRUPTED

Got timeout writing communication packets

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1162: Result string is longer than 'max_allowed_packet' bytes

Error Code
SQLSTATE
Error
Description

1162

42000

ER_TOO_LONG_STRING

Result string is longer than 'max_allowed_packet' bytes

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1163: The used table type doesn't support BLOB/TEXT columns

Error Code
SQLSTATE
Error
Description

1163

42000

ER_TABLE_CANT_HANDLE_BLOB

The used table type doesn't support BLOB/TEXT columns

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1164: The used table type doesn't support AUTO_INCREMENT columns

Error Code
SQLSTATE
Error
Description

1164

42000

ER_TABLE_CANT_HANDLE_AUTO_INCREMENT

The used table type doesn't support AUTO_INCREMENT columns

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1165: INSERT DELAYED can't be used with table because it is locked

Error Code
SQLSTATE
Error
Description

1165

HY000

ER_DELAYED_INSERT_TABLE_LOCKED

INSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1166: Incorrect column name

Error Code
SQLSTATE
Error
Description

1166

42000

ER_WRONG_COLUMN_NAME

Incorrect column name '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1167: The used storage engine can't index column

Error Code
SQLSTATE
Error
Description

1167

42000

ER_WRONG_KEY_COLUMN

The used storage engine can't index column '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1168: Unable to open underlying table which is differently defined or of non-MyISAM type or do

Error Code
SQLSTATE
Error
Description

1168

HY000

ER_WRONG_MRG_TABLE

Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1169: Can't write, because of unique constraint, to table

Error Code
SQLSTATE
Error
Description

1169

23000

ER_DUP_UNIQUE

Can't write, because of unique constraint, to table '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1170: BLOB/TEXT column used in key specification without a key length

Error Code
SQLSTATE
Error
Description

1170

42000

ER_BLOB_KEY_WITHOUT_LENGTH

BLOB/TEXT column '%s' used in key specification without a key length

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1171: All parts of a PRIMARY KEY must be NOT NULL

Error Code
SQLSTATE
Error
Description

1171

42000

ER_PRIMARY_CANT_HAVE_NULL

All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1172: Result consisted of more than one row

Error Code
SQLSTATE
Error
Description

1172

42000

ER_TOO_MANY_ROWS

Result consisted of more than one row

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1173: This table type requires a primary key

Error Code
SQLSTATE
Error
Description

1173

42000

ER_REQUIRES_PRIMARY_KEY

This table type requires a primary key

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1174: This version of MariaDB is not compiled with RAID support

Error Code
SQLSTATE
Error
Description

1174

HY000

ER_NO_RAID_COMPILED

This version of MariaDB is not compiled with RAID support

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1175: You are using safe update mode and you tried to update a table without a WHERE that uses

Error Code
SQLSTATE
Error
Description

1175

HY000

ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE

You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1176: Key doesn't exist in table

Error Code
SQLSTATE
Error
Description

1176

42000

ER_KEY_DOES_NOT_EXITS

Key '%s' doesn't exist in table '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1177: Can't open table

Error Code
SQLSTATE
Error
Description

1177

42000

ER_CHECK_NO_SUCH_TABLE

Can't open table

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1178: The storage engine for the table doesn't support

Error Code
SQLSTATE
Error
Description

1178

42000

ER_CHECK_NOT_IMPLEMENTED

The storage engine for the table doesn't support %s

Possible Causes and Solutions

MariaDB storage engines differ in many ways, and not all operations are supported by each engine. Perhaps you don't need the intended operation for the engine, or perhaps you need a different storage engine. For example, sequences don't support analyze table, as it's an unnecessary operation on a sequence table, which only contains one row.

CREATE SEQUENCE s START WITH 100 INCREMENT BY 10;

ANALYZE TABLE s;
+--------+---------+----------+----------------------------------------------------------+
| Table  | Op      | Msg_type | Msg_text                                                 |
+--------+---------+----------+----------------------------------------------------------+
| test.s | analyze | note     | The storage engine for the table doesn't support analyze |
+--------+---------+----------+----------------------------------------------------------+

This page is licensed: CC BY-SA / Gnu FDL

Error 1179: You are not allowed to execute this command in a transaction

Error Code
SQLSTATE
Error
Description

1179

25000

ER_CANT_DO_THIS_DURING_AN_TRANSACTION

You are not allowed to execute this command in a transaction

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1180: Got error during COMMIT

Error 1181: Got error during ROLLBACK

Error Code
SQLSTATE
Error
Description

1181

HY000

ER_ERROR_DURING_ROLLBACK

Got error %d during ROLLBACK

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1182: Got error during FLUSH_LOGS

Error Code
SQLSTATE
Error
Description

1182

HY000

ER_ERROR_DURING_FLUSH_LOGS

Got error %d during FLUSH_LOGS

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1183: Got error during CHECKPOINT

Error Code
SQLSTATE
Error
Description

1183

HY000

ER_ERROR_DURING_CHECKPOINT

Got error %d during CHECKPOINT

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1184: Aborted connection to db user host

Error Code
SQLSTATE
Error
Description

1184

08S01

ER_NEW_ABORTING_CONNECTION

Aborted connection %ld to db: '%s' user: '%s' host: '%s' (%s)

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1185: You should never see it

Error Code
SQLSTATE
Error
Description

1185

ER_UNUSED_10

You should never see it

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1186: Binlog closed, cannot RESET MASTER

Error Code
SQLSTATE
Error
Description

1186

HY000

ER_FLUSH_MASTER_BINLOG_CLOSED

Binlog closed, cannot RESET MASTER

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1187: Failed rebuilding the index of dumped table

Error Code
SQLSTATE
Error
Description

1187

HY000

ER_INDEX_REBUILD

Failed rebuilding the index of dumped table '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1188: Error from master

Error Code
SQLSTATE
Error
Description

1188

HY000

ER_MASTER

Error from master: '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1189: Net error reading from master

Error Code
SQLSTATE
Error
Description

1189

08S01

ER_MASTER_NET_READ

Net error reading from master

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1190: Net error writing to master

Error Code
SQLSTATE
Error
Description

1190

08S01

ER_MASTER_NET_WRITE

Net error writing to master

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1191: Can't find FULLTEXT index matching the column list

Error Code
SQLSTATE
Error
Description

1191

HY000

ER_FT_MATCHING_KEY_NOT_FOUND

Can't find FULLTEXT index matching the column list

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1192: Can't execute the given command because you have active locked tables or an active trans

Error Code
SQLSTATE
Error
Description

1192

HY000

ER_LOCK_OR_ACTIVE_TRANSACTION

Can't execute the given command because you have active locked tables or an active transaction

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1193: Unknown system variable

Error Code
SQLSTATE
Error
Description

1193

HY000

ER_UNKNOWN_SYSTEM_VARIABLE

Unknown system variable '%s'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1194: Table is marked as crashed and should be repaired

Error Code
SQLSTATE
Error
Description

1194

HY000

ER_CRASHED_ON_USAGE

Table '%s' is marked as crashed and should be repaired

Possible Causes and Solutions

This error occurs, in particular to MyISAM, Aria, Archive or CSV tables, if the table is marked as crashed. This can occur for a number of reasons, for example:

  • running out of disk space

  • sudden shutdown while the table was in use

Fixing the problem can usually be done by running a REPAIR TABLE statement, or one of the similar scripts, aria_chk, myisamchk or mariadb-check.

This page is licensed: CC BY-SA / Gnu FDL

Error 1195: Table is marked as crashed and last (automatic?) repair failed

Error Code
SQLSTATE
Error
Description

1195

HY000

ER_CRASHED_ON_REPAIR

Table '%s' is marked as crashed and last (automatic?) repair failed

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1196: Some non-transactional changed tables couldn't be rolled back

Error Code
SQLSTATE
Error
Description

1196

HY000

ER_WARNING_NOT_COMPLETE_ROLLBACK

Some non-transactional changed tables couldn't be rolled back

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1197: Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage

Error Code
SQLSTATE
Error
Description

1197

HY000

ER_TRANS_CACHE_FULL

Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 1198: This operation cannot be performed with a running slave; run STOP SLAVE first

Error Code
SQLSTATE
Error
Description

1198

HY000

ER_SLAVE_MUST_STOP

This operation cannot be performed with a running slave; run STOP SLAVE first

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL