Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
1116
HY000
ER_TOO_MANY_TABLES
Too many tables; MariaDB can only use %d tables in a join
1120
42000
ER_WRONG_OUTER_JOIN
Cross dependency found in OUTER JOIN; examine your ON conditions
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
1127
HY000
ER_CANT_FIND_DL_ENTRY
Can't find symbol '%s' in library
1139
42000
ER_REGEXP_ERROR
Got error '%s' from regexp
1107
42000
ER_WRONG_PARAMCOUNT_TO_PROCEDURE
Incorrect parameter count to procedure '%s'
1143
42000
ER_COLUMNACCESS_DENIED_ERROR
%s command denied to user '%s'@'%s' for column '%s' in table '%s'
1136
21S01
ER_WRONG_VALUE_COUNT_ON_ROW
Column count doesn't match value count at row %ld
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
1134
HY000
ER_UPDATE_INF
Rows matched: %ld Changed: %ld Warnings: %ld
1122
HY000
ER_CANT_FIND_UDF
Can't load function '%s'
1156
08S01
ER_NET_PACKETS_OUT_OF_ORDER
Got packets out of order
1170
42000
ER_BLOB_KEY_WITHOUT_LENGTH
BLOB/TEXT column '%s' used in key specification without a key length
1105
HY000
ER_UNKNOWN_ERROR
Unknown error
1117
HY000
ER_TOO_MANY_FIELDS
Too many columns
1147
42000
ER_NONEXISTING_TABLE_GRANT
There is no such grant defined for user '%s' on host '%s' on table '%s'
1141
42000
ER_NONEXISTING_GRANT
There is no such grant defined for user '%s' on host '%s'
1153
08S01
ER_NET_PACKET_TOO_LARGE
Got a packet bigger than 'max_allowed_packet' bytes
1164
42000
ER_TABLE_CANT_HANDLE_AUTO_INCREMENT
The used table type doesn't support AUTO_INCREMENT columns
1125
HY000
ER_UDF_EXISTS
Function '%s' already exists
1113
42000
ER_TABLE_MUST_HAVE_COLUMNS
A table must have at least 1 column
1184
08S01
ER_NEW_ABORTING_CONNECTION
Aborted connection %ld to db: '%s' user: '%s' host: '%s' (%s)
1174
HY000
ER_NO_RAID_COMPILED
This version of MariaDB is not compiled with RAID support
1193
HY000
ER_UNKNOWN_SYSTEM_VARIABLE
Unknown system variable '%s'
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
1192
HY000
ER_LOCK_OR_ACTIVE_TRANSACTION
Can't execute the given command because you have active locked tables or an active transaction
1163
42000
ER_TABLE_CANT_HANDLE_BLOB
The used table type doesn't support BLOB/TEXT columns
1157
08S01
ER_NET_UNCOMPRESS_ERROR
Couldn't uncompress communication packet
1176
42000
ER_KEY_DOES_NOT_EXITS
Key '%s' doesn't exist in table '%s'
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
1190
08S01
ER_MASTER_NET_WRITE
Net error writing to master
1194
HY000
ER_CRASHED_ON_USAGE
Table '%s' is marked as crashed and should be repaired
This error occurs, in particular to , , or 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 statement, or one of the similar scripts, , or .
This page is licensed: CC BY-SA / Gnu FDL
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.
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:
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:
This means the connection was aborted by the application/user.
Ensure you have a stable internet connection.
Ensure that your applications calls mysql_close() for all open connections before exiting.
perror Getting a description for an error number.
1158
08S01
ER_NET_READ_ERROR
Got an error reading communication packets
This page is licensed: CC BY-SA / Gnu FDL
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.
1178
42000
ER_CHECK_NOT_IMPLEMENTED
The storage engine for the table doesn't support %s
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
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: -1shell> perror 104
OS error code 104: Connection reset by peer1146
42S02
ER_NO_SUCH_TABLE
Table '%s.%s' doesn't exist
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1115
42000
ER_UNKNOWN_CHARACTER_SET
Unknown character set: '%s'
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1180
HY000
ER_ERROR_DURING_COMMIT
Got error %d during COMMIT
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1166
42000
ER_WRONG_COLUMN_NAME
Incorrect column name '%s'
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1187
HY000
ER_INDEX_REBUILD
Failed rebuilding the index of dumped table '%s'
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1179
25000
ER_CANT_DO_THIS_DURING_AN_TRANSACTION
You are not allowed to execute this command in a transaction
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1133
42000
ER_PASSWORD_NO_MATCH
Can't find any matching row in the user table
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1161
08S01
ER_NET_WRITE_INTERRUPTED
Got timeout writing communication packets
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1138
22004
ER_INVALID_USE_OF_NULL
Invalid use of NULL value
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1160
08S01
ER_NET_ERROR_ON_WRITE
Got an error writing communication packets
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.
The may have more information about the cause of the error. Setting the MariaDB server option to a value of 4 or above can generate more diagnostic warnings in the error log when there is a problem reading packages:
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
You can use the perror utility to get a description of system and storage engine errors:
This means the connection was aborted by the application/user.
Ensure you have a stable internet connection.
Ensure that your applications calls mysql_close() for all open connections before exiting.
Getting a description for an error number.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
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.
This page is licensed: CC BY-SA / Gnu FDL
2024-02-17 12:32:45 5461 [ERROR] mariadbd: Could not write packet: fd: 406 state: 2 errno: 32 vio_errno: 1160 length: 34shell> perror 104
OS error code 104: Connection reset by peerThis article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
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
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 need to be present at the end of each statement. See . For example:
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:
When creating from the command-line, it is likely you will need to differentiate between the regular delimiter and a delimiter inside a block. See .
For example, take the following, seemingly-valid declaration:
Attempting to run will result in an error:
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:
cannot be used as unless they are quoted. For example:
The error was picked up after the accessible identifier, leading one to suspect that it's causing the problem. And indeed, it's a . There are a number of possible solutions.
Use a new, non-reserved, identifier:
or quote the identifier:
or the identifier:
Some syntax may be valid in a particular , but not in others. There are too many to list here, but the page provides a full list. For example:
The error message directs one to the identifier t. Double quotes cannot be used to unless ANSI_MODE is set, which in this case it isn't:
Either quote with the standard quote character, the backtick, or set the appropriate SQL_MODE:
in particular has a large number of differences to the default , for example:
The error is identified just after the VARCHAR2 type is specified, and this type is not valid in the default mode:
See for a full list of syntax differences.
This page is licensed: CC BY-SA / Gnu FDL
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 2SELECT 1;
SELECT 2;CREATE FUNCTION FortyTwo() RETURNS TINYINT DETERMINISTIC
BEGIN
DECLARE x TINYINT;
SET x = 42;
RETURN x;
END;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 3DELIMITER //
CREATE FUNCTION FortyTwo() RETURNS TINYINT DETERMINISTIC
BEGIN
DECLARE x TINYINT;
SET x = 42;
RETURN x;
END
//
DELIMITER ;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 1CREATE TABLE accessible_status(id INT);CREATE TABLE `accessible`(id INT);CREATE TABLE test.accessible(id INT);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 1select @@sql_mode;
+-------------------------------------------------------------------------------------------+
| @@sql_mode |
+-------------------------------------------------------------------------------------------+
| STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+-------------------------------------------------------------------------------------------+SET @@SQL_MODE = CONCAT(@@SQL_MODE, ',ANSI_QUOTES');
CREATE TABLE "t" (id INT);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 1SELECT @@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));1110
42000
ER_FIELD_SPECIFIED_TWICE
Column '%s' specified twice
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1168
HY000
ER_WRONG_MRG_TABLE
Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1111
HY000
ER_INVALID_GROUP_FUNC_USE
Invalid use of group function
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
1181
HY000
ER_ERROR_DURING_ROLLBACK
Got error %d during ROLLBACK
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL