Troubleshooting MYSQL or MariaDB Errors from Error 1011 to 1020

SQLServerF1

MariaDB ERROR Code 1011
MySQL SQL State HY000
ER_CANT_DELETE_FILE
Error on delete of ‘%s’ (errno: %d)
MariaDB ERROR Code 1012
MySQL SQL State HY000
ER_CANT_FIND_SYSTEM_REC
Can’t read record in system table
MariaDB ERROR Code 1013
MySQL SQL State HY000
ER_CANT_GET_STAT
Can’t get status of ‘%s’ (errno: %d)

MariaDB ERROR Code 1014
MySQL SQL State HY000
ER_CANT_GET_WD
Can’t get working directory (errno: %d)
MariaDB ERROR Code 1015
MySQL SQL State HY000 ER_CANT_LOCK
Can’t lock file (errno: %d)
MariaDB ERROR Code 1016
MySQL SQL State HY000 ER_CANT_OPEN_FILE
Can’t open file: ‘%s’ (errno: %d)

MariaDB ERROR Code 1017
MySQL SQL State HY000 ER_FILE_NOT_FOUND
Can’t find file: ‘%s’ (errno: %d)
MariaDB ERROR Code 1018
MySQL SQL State HY000 ER_CANT_READ_DIR
Can’t read dir of ‘%s’ (errno: %d)
MariaDB ERROR Code 1019
MySQL SQL State HY000 ER_CANT_SET_WD
Can’t change dir to ‘%s’ (errno: %d)
MariaDB ERROR Code 1020
MySQL SQL State HY000 ER_CHECKREAD
Record has changed since last read in table ‘%s’

Above are the list of shared MySQL and MariaDB Error Codes and their Description including SQL state and exact error code from Error 1011 to 1020 which performing certain operations against MySQL or MariaDB.

What are MYSQL/MariaDB Errors?

MySQL and MariaDB programs have access to several types of common error information when the server returns an error.

The MYSQL/MariaDB message displayed contains three types of information:
A numeric error code. This number is MySQL-specific and is not portable to other database systems.
A five-character SQLSTATE value. The values are specified by ANSI SQL and ODBC and are more standardized. Not all MySQL error numbers are mapped to SQLSTATE error codes.
A message string that provides a textual description of the error.
When an error occurs, you can access the MySQL error code, the SQLSTATE value, and the message string using C API functions:
MySQL error code: Call mysql_errno()
SQLSTATE value: Call mysql_sqlstate()
Error message: Call mysql_error()

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about MYSQL and MariaDB Error Codes and Error Messages or Warnings on Windows, Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *