Troubleshooting MYSQL or MariaDB Errors from Error 1201 to 1210

SQLServerF1

MariaDB ERROR Code 1201
MySQL SQL State HY000
ER_MASTER_INF
Could not initialize master info structure; more error messages can be found in the MariaDB error log
MariaDB ERROR Code 1202
MySQL SQL State HY000
ER_SLAVE_THREAD
Could not create slave thread; check system resources
MariaDB ERROR Code 1203
MySQL SQL State 42000
ER_TOO_MANY_USER_CONNECTIONS
User %s already has more than ‘max_user_connections’ active connections

MariaDB ERROR Code 1204
MySQL SQL State HY000
ER_SET_CONSTANTS_ONLY
You may only use constant expressions with SET
MariaDB ERROR Code 1205
MySQL SQL State HY000
ER_LOCK_WAIT_TIMEOUT
Lock wait timeout exceeded; try restarting transaction
MariaDB ERROR Code 1206
MySQL SQL State HY000
ER_LOCK_TABLE_FULL
The total number of locks exceeds the lock table size

MariaDB ERROR Code 1207
MySQL SQL State 25000
ER_READ_ONLY_TRANSACTION
Update locks cannot be acquired during a READ UNCOMMITTED transaction
MariaDB ERROR Code 1208
MySQL SQL State HY000
ER_DROP_DB_WITH_READ_LOCK
DROP DATABASE not allowed while thread is holding global read lock
MariaDB ERROR Code 1209
MySQL SQL State HY000
ER_CREATE_DB_WITH_READ_LOCK
CREATE DATABASE not allowed while thread is holding global read lock
MariaDB ERROR Code 1210
MySQL SQL State HY000
ER_WRONG_ARGUMENTS
Incorrect arguments to %s

Above are the list of shared MySQL and MariaDB Error Codes and their Description including SQL state and exact error code from Error 1201 to 1210 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.

 

Troubleshooting MYSQL or MariaDB Errors from Error 1171 to 1180

SQLServerF1

MariaDB ERROR Code 1171
MySQL SQL State 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
MariaDB ERROR Code 1172
MySQL SQL State 42000
ER_TOO_MANY_ROWS
Result consisted of more than one row
MariaDB ERROR Code 1173
MySQL SQL State 42000
ER_REQUIRES_PRIMARY_KEY
This table type requires a primary key

MariaDB ERROR Code 1174
MySQL SQL State HY000
ER_NO_RAID_COMPILED
This version of MariaDB is not compiled with RAID support
MariaDB ERROR Code 1175
MySQL SQL State 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
MariaDB ERROR Code 1176
MySQL SQL State 42000
ER_KEY_DOES_NOT_EXITS
Key ‘%s’ doesn’t exist in table ‘%s’

MariaDB ERROR Code 1177
MySQL SQL State 42000
ER_CHECK_NO_SUCH_TABLE
Can’t open table
MariaDB ERROR Code 1178
MySQL SQL State 42000
ER_CHECK_NOT_IMPLEMENTED
The storage engine for the table doesn’t support %s
MariaDB ERROR Code 1179
MySQL SQL State 25000
ER_CANT_DO_THIS_DURING_AN_TRANSACTION
You are not allowed to execute this command in a transaction
MariaDB ERROR Code 1180
MySQL SQL State HY000
ER_ERROR_DURING_COMMIT
Got error %d during COMMIT

Above are the list of shared MySQL and MariaDB Error Codes and their Description including SQL state and exact error code from Error 1171 to 1180 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.