Troubleshooting MYSQL or MariaDB Errors from Error 1701 to 1710

SQLServerF1

MariaDB ERROR Code 1701
MySQL SQL State 42000
ER_TRUNCATE_ILLEGAL_FK
Cannot truncate a table referenced in a foreign key constraint (%s)
MariaDB ERROR Code 1702
MySQL SQL State HY000
ER_PLUGIN_IS_PERMANENT
Plugin ‘%s’ is force_plus_permanent and can not be unloaded
MariaDB ERROR Code 1703
MySQL SQL State HY000
ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MIN
The requested value for the heartbeat period is less than 1 millisecond. The value is reset to 0, meaning that heartbeating will effectively be disabled.

MariaDB ERROR Code 1704
MySQL SQL State HY000
ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE_MAX
The requested value for the heartbeat period exceeds the value of slave_net_timeout seconds. A sensible value for the period should be less than the timeout.
MariaDB ERROR Code 1705
MySQL SQL State HY000
ER_STMT_CACHE_FULL
Multi-row statements required more than ‘max_binlog_stmt_cache_size’ bytes of storage; increase this mysqld variable and try again
MariaDB ERROR Code 1706
MySQL SQL State HY000
ER_MULTI_UPDATE_KEY_CONFLICT
Primary key/partition key update is not allowed since the table is updated both as ‘%s’ and ‘%s’.

MariaDB ERROR Code 1707
MySQL SQL State HY000
ER_TABLE_NEEDS_REBUILD
Table rebuild required. Please do “ALTER TABLE `%s` FORCE” or dump/reload to fix it!
MariaDB ERROR Code 1708
MySQL SQL State HY000
WARN_OPTION_BELOW_LIMIT
The value of ‘%s’ should be no less than the value of ‘%s’ Note: Introduced in 5.5.12.
MariaDB ERROR Code 1709
MySQL SQL State HY000
ER_INDEX_COLUMN_TOO_LONG
Index column size too large. The maximum column size is %lu bytes. Note: Introduced in 5.5.14.
MariaDB ERROR Code 1710
MySQL SQL State HY000
ER_ERROR_IN_TRIGGER_BODY
Trigger ‘%s’ has an error in its body: ‘%s’ Note: Introduced in 5.5.15.

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

SQLServerF1

MariaDB ERROR Code 1681
MySQL SQL State HY000
ER_WARN_DEPRECATED_SYNTAX_NO_REPLACEMENT
‘%s’ is deprecated and will be removed in a future release. Note: Introduced in 5.5.3.
MariaDB ERROR Code 1682
MySQL SQL State HY000
ER_WRONG_NATIVE_TABLE_STRUCTURE
Native table ‘%s’.’%s’ has the wrong structure Note: Introduced in 5.5.3.
MariaDB ERROR Code 1683
MySQL SQL State HY000
ER_WRONG_PERFSCHEMA_USAGE
Invalid performance_schema usage. Note: Introduced in 5.5.3.

MariaDB ERROR Code 1684
MySQL SQL State HY000
ER_WARN_I_S_SKIPPED_TABLE
Table ‘%s’.’%s’ was skipped since its definition is being modified by concurrent DDL statement Note: Introduced in 5.5.3.
MariaDB ERROR Code 1685
MySQL SQL State HY000
ER_INSIDE_TRANSACTION _PREVENTS_SWITCH_BINLOG_DIRECT
Cannot modify @@session.binlog_direct_non_transactional_updates inside a transaction Note: Introduced in 5.5.3.
MariaDB ERROR Code 1686
MySQL SQL State HY000
ER_STORED_FUNCTION_PREVENTS _SWITCH_BINLOG_DIRECT
Cannot change the binlog direct flag inside a stored function or trigger Note: Introduced in 5.5.3.

MariaDB ERROR Code 1687
MySQL SQL State 42000
ER_SPATIAL_MUST_HAVE_GEOM_COL
A SPATIAL index may only contain a geometrical type column Note: Introduced in 5.5.2.
MariaDB ERROR Code 1688
MySQL SQL State HY000
ER_TOO_LONG_INDEX_COMMENT
Comment for index ‘%s’ is too long (max = %lu) Note: Introduced in 5.5.3.
MariaDB ERROR Code 1689
MySQL SQL State HY000
ER_LOCK_ABORTED
Wait on a lock was aborted due to a pending exclusive lock Note: Introduced in 5.5.4.
MariaDB ERROR Code 1690
MySQL SQL State 22003
ER_DATA_OUT_OF_RANGE
%s value is out of range in ‘%s’ Note: Introduced in 5.5.5.

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

SQLServerF1

MariaDB ERROR Code 1641
MySQL SQL State 42000
ER_DUP_SIGNAL_SET
Duplicate condition information item ‘%s’
MariaDB ERROR Code 1642
MySQL SQL State 01000
ER_SIGNAL_WARN
Unhandled user-defined warning condition
MariaDB ERROR Code 1643
MySQL SQL State 02000
ER_SIGNAL_NOT_FOUND
Unhandled user-defined not found condition

MariaDB ERROR Code 1644
MySQL SQL State HY000
ER_SIGNAL_EXCEPTION
Unhandled user-defined exception condition
MariaDB ERROR Code 1645
MySQL SQL State 0K000
ER_RESIGNAL_WITHOUT_ACTIVE_HANDLER
RESIGNAL when handler not active
MariaDB ERROR Code 1646
MySQL SQL State HY000
ER_SIGNAL_BAD_CONDITION_TYPE
SIGNAL/RESIGNAL can only use a CONDITION defined with SQLSTATE

MariaDB ERROR Code 1647
MySQL SQL State HY000
WARN_COND_ITEM_TRUNCATED
Data truncated for condition item ‘%s’
MariaDB ERROR Code 1648
MySQL SQL State HY000
ER_COND_ITEM_TOO_LONG
Data too long for condition item ‘%s’
MariaDB ERROR Code 1649
MySQL SQL State HY000
ER_UNKNOWN_LOCALE
Unknown locale: ‘%s’
MariaDB ERROR Code 1650
MySQL SQL State HY000
ER_SLAVE_IGNORE_SERVER_IDS
The requested server id %d clashes with the slave startup option –replicate-same-server-id

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

SQLServerF1

MariaDB ERROR Code 1621
MySQL SQL State HY000
ER_VARIABLE_IS_READONLY
%s variable ‘%s’ is read-only. Use SET %s to assign the value
MariaDB ERROR Code 1622
MySQL SQL State HY000
ER_WARN_ENGINE_TRANSACTION_ROLLBACK
Storage engine %s does not support rollback for this statement. Transaction rolled back and must be restarted
MariaDB ERROR Code 1623
MySQL SQL State HY000
ER_SLAVE_HEARTBEAT_FAILURE
Unexpected master’s heartbeat data: %s

MariaDB ERROR Code 1624
MySQL SQL State HY000
ER_SLAVE_HEARTBEAT_VALUE_OUT_OF_RANGE
The requested value for the heartbeat period is either negative or exceeds the maximum allowed (%s seconds).
MariaDB ERROR Code 1625
MySQL SQL State HY000
ER_NDB_REPLICATION_SCHEMA_ERROR
Bad schema for mysql.ndb_replication table. Message: %s
MariaDB ERROR Code 1626
MySQL SQL State HY000
ER_CONFLICT_FN_PARSE_ERROR
Error in parsing conflict function. Message: %s

MariaDB ERROR Code 1627
MySQL SQL State HY000
ER_EXCEPTIONS_WRITE_ERROR
Write to exceptions table failed. Message: %s”
MariaDB ERROR Code 1628
MySQL SQL State HY000
ER_TOO_LONG_TABLE_COMMENT
Comment for table ‘%s’ is too long (max = %lu)
MariaDB ERROR Code 1629
MySQL SQL State HY000
ER_TOO_LONG_FIELD_COMMENT
Comment for field ‘%s’ is too long (max = %lu)
MariaDB ERROR Code 1630
MySQL SQL State 42000
ER_FUNC_INEXISTENT_NAME_COLLISION
FUNCTION %s does not exist. Check the ‘Function Name Parsing and Resolution’ section in the Reference Manual

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

SQLServerF1

MariaDB ERROR Code 1581
MySQL SQL State HY000
ER_CANT_RENAME_LOG_TABLE
Cannot rename ‘%s’. When logging enabled, rename to/from log table must rename two tables: the log table to an archive table and another table back to ‘%s’
MariaDB ERROR Code 1582
MySQL SQL State 42000
ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
Incorrect parameter count in the call to native function ‘%s’
MariaDB ERROR Code 1583
MySQL SQL State 42000
ER_WRONG_PARAMETERS_TO_NATIVE_FCT
Incorrect parameters in the call to native function ‘%s’

MariaDB ERROR Code 1584
MySQL SQL State 42000
ER_WRONG_PARAMETERS_TO_STORED_FCT
Incorrect parameters in the call to stored function ‘%s’
MariaDB ERROR Code 1585
MySQL SQL State HY000
ER_NATIVE_FCT_NAME_COLLISION
This function ‘%s’ has the same name as a native function
MariaDB ERROR Code 1586
MySQL SQL State 23000
ER_DUP_ENTRY_WITH_KEY_NAME
Duplicate entry ‘%s’ for key ‘%s’ Note: This error string is also used with ER_DUP_ENTRY.

MariaDB ERROR Code 1587
MySQL SQL State HY000
ER_BINLOG_PURGE_EMFILE
Too many files opened, please execute the command again
MariaDB ERROR Code 1588
MySQL SQL State HY000
ER_EVENT_CANNOT_CREATE_IN_THE_PAST
Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.
MariaDB ERROR Code 1589
MySQL SQL State HY000
ER_EVENT_CANNOT_ALTER_IN_THE_PAST
Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.
MariaDB ERROR Code 1590
MySQL SQL State HY000
ER_SLAVE_INCIDENT
The incident %s occured on the master. Message: %s

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

SQLServerF1

MariaDB ERROR Code 1461
MySQL SQL State 42000
ER_MAX_PREPARED_STMT_COUNT_REACHED
Can’t create more than max_prepared_stmt_count statements (current value: %lu)
MariaDB ERROR Code 1462
MySQL SQL State HY000
ER_VIEW_RECURSIVE
`%s`.`%s` contains view recursion
MariaDB ERROR Code 1463
MySQL SQL State 42000
ER_NON_GROUPING_FIELD_USED
Non-grouping field ‘%s’ is used in %s clause

MariaDB ERROR Code 1464
MySQL SQL State HY000
ER_TABLE_CANT_HANDLE_SPKEYS
The used table type doesn’t support SPATIAL indexes
MariaDB ERROR Code 1465
MySQL SQL State HY000
ER_NO_TRIGGERS_ON_SYSTEM_SCHEMA
Triggers can not be created on system tables
MariaDB ERROR Code 1466
MySQL SQL State HY000
ER_REMOVED_SPACES
Leading spaces are removed from name ‘%s’

MariaDB ERROR Code 1467
MySQL SQL State HY000
ER_AUTOINC_READ_FAILED
Failed to read auto-increment value from storage engine
MariaDB ERROR Code 1468
MySQL SQL State HY000
ER_USERNAME
user name
MariaDB ERROR Code 1469
MySQL SQL State HY000
ER_HOSTNAME
host name
MariaDB ERROR Code 1470
MySQL SQL State HY000
ER_WRONG_STRING_LENGTH
String ‘%s’ is too long for %s (should be no longer than %d)

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

SQLServerF1

MariaDB ERROR Code 1451
MySQL SQL State 23000
ER_ROW_IS_REFERENCED_2
Cannot delete or update a parent row: a foreign key constraint fails (%s)
MariaDB ERROR Code 1452
MySQL SQL State 23000
ER_NO_REFERENCED_ROW_2
Cannot add or update a child row: a foreign key constraint fails (%s)
MariaDB ERROR Code 1453
MySQL SQL State 42000
ER_SP_BAD_VAR_SHADOW
Variable ‘%s’ must be quoted with `…`, or renamed

MariaDB ERROR Code 1454
MySQL SQL State HY000
ER_TRG_NO_DEFINER
No definer attribute for trigger ‘%s’.’%s’. The trigger will be activated under the authorization of the invoker, which may have insufficient privileges. Please recreate the trigger.
MariaDB ERROR Code 1455
MySQL SQL State HY000
ER_OLD_FILE_FORMAT
‘%s’ has an old format, you should re-create the ‘%s’ object(s)
MariaDB ERROR Code 1456
MySQL SQL State HY000
ER_SP_RECURSION_LIMIT
Recursive limit %d (as set by the max_sp_recursion_depth variable) was exceeded for routine %s

MariaDB ERROR Code 1457
MySQL SQL State HY000
ER_SP_PROC_TABLE_CORRUPT
Failed to load routine %s. The table mysql.proc is missing, corrupt, or contains bad data (internal code %d)
MariaDB ERROR Code 1458
MySQL SQL State 42000
ER_SP_WRONG_NAME
Incorrect routine name ‘%s’
MariaDB ERROR Code 1459
MySQL SQL State HY000
ER_TABLE_NEEDS_UPGRADE Table upgrade required. Please do “REPAIR TABLE `%s`” or dump/reload to fix it!
MariaDB ERROR Code 1460
MySQL SQL State 42000
ER_SP_NO_AGGREGATE
AGGREGATE is not supported for stored functions

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

SQLServerF1

 

MariaDB ERROR Code 1431
MySQL SQL State HY000
ER_FOREIGN_DATA_SOURCE_DOESNT_EXIST
The foreign data source you are trying to reference does not exist. Data source error: %s
MariaDB ERROR Code 1432
MySQL SQL State HY000
ER_FOREIGN_DATA_STRING_INVALID_CANT_CREATE
Can’t create federated table. The data source connection string ‘%s’ is not in the correct format
MariaDB ERROR Code 1433
MySQL SQL State HY000
ER_FOREIGN_DATA_STRING_INVALID
The data source connection string ‘%s’ is not in the correct format

MariaDB ERROR Code 1434
MySQL SQL State HY000
ER_CANT_CREATE_FEDERATED_TABLE
Can’t create federated table. Foreign data src error: %s
MariaDB ERROR Code 1435
MySQL SQL State HY000
ER_TRG_IN_WRONG_SCHEMA
Trigger in wrong schema
MariaDB ERROR Code 1436
MySQL SQL State HY000
ER_STACK_OVERRUN_NEED_MORE
Thread stack overrun: %ld bytes used of a %ld byte stack, and %ld bytes needed. Use ‘mysqld –thread_stack=#’ to specify a bigger stack.

MariaDB ERROR Code 1437
MySQL SQL State 42000
ER_TOO_LONG_BODY
Routine body for ‘%s’ is too long
MariaDB ERROR Code 1438
MySQL SQL State HY000
ER_WARN_CANT_DROP_DEFAULT_KEYCACHE
Cannot drop default keycache
MariaDB ERROR Code 1439
MySQL SQL State 42000
ER_TOO_BIG_DISPLAYWIDTH
Display width out of range for column ‘%s’ (max = %lu)
MariaDB ERROR Code 1440
MySQL SQL State XAE08
ER_XAER_DUPID
XAER_DUPID: The XID already exists

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

SQLServerF1

MariaDB ERROR Code 1421
MySQL SQL State HY000
ER_STMT_HAS_NO_OPEN_CURSOR
The statement (%lu) has no open cursor.
MariaDB ERROR Code 1422
MySQL SQL State HY000
ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG
Explicit or implicit commit is not allowed in stored function or trigger.
MariaDB ERROR Code 1423
MySQL SQL State HY000
ER_NO_DEFAULT_FOR_VIEW_FIELD
Field of view ‘%s.%s’ underlying table doesn’t have a default value

MariaDB ERROR Code 1424
MySQL SQL State HY000
ER_SP_NO_RECURSION
Recursive stored functions and triggers are not allowed.
MariaDB ERROR Code 1425
MySQL SQL State 42000
ER_TOO_BIG_SCALE
Too big scale %d specified for column ‘%s’. Maximum is %lu.
MariaDB ERROR Code 1426
MySQL SQL State 42000
ER_TOO_BIG_PRECISION
Too big precision %d specified for column ‘%s’. Maximum is %lu.

MariaDB ERROR Code 1427
MySQL SQL State 42000
ER_M_BIGGER_THAN_D
For float(M,D, double(M,D or decimal(M,D, M must be >= D (column ‘%s’).
MariaDB ERROR Code 1428
MySQL SQL State HY000
ER_WRONG_LOCK_OF_SYSTEM_TABLE
You can’t combine write-locking of system tables with other tables or lock types
MariaDB ERROR Code 1429
MySQL SQL State HY000
ER_CONNECT_TO_FOREIGN_DATA_SOURCE
Unable to connect to foreign data source: %s
MariaDB ERROR Code 1430
MySQL SQL State HY000
ER_QUERY_ON_FOREIGN_DATA_SOURCE
There was a problem processing the query on the foreign data source. Data source error: %s

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

SQLServerF1

MariaDB ERROR Code 1401
MySQL SQL State XAE03
ER_XAER_RMERR
XAER_RMERR: Fatal error occurred in the transaction branch – check your data for consistency
MariaDB ERROR Code 1402
MySQL SQL State XA100
ER_XA_RBROLLBACK
XA_RBROLLBACK: Transaction branch was rolled back
MariaDB ERROR Code 1403
MySQL SQL State 42000
ER_NONEXISTING_PROC_GRANT
There is no such grant defined for user ‘%s’ on host ‘%s’ on routine ‘%s’

MariaDB ERROR Code 1404
MySQL SQL State HY000
ER_PROC_AUTO_GRANT_FAIL
Failed to grant EXECUTE and ALTER ROUTINE privileges
MariaDB ERROR Code 1405
MySQL SQL State HY000
ER_PROC_AUTO_REVOKE_FAIL
Failed to revoke all privileges to dropped routine
MariaDB ERROR Code 1406
MySQL SQL State 22001
ER_DATA_TOO_LONG
Data too long for column ‘%s’ at row %ld

MariaDB ERROR Code 1407
MySQL SQL State 42000
ER_SP_BAD_SQLSTATE
Bad SQLSTATE: ‘%s’
MariaDB ERROR Code 1408
MySQL SQL State HY000
ER_STARTUP
%s: ready for connections. Version: ‘%s’ socket: ‘%s’ port: %d %s
MariaDB ERROR Code 1409
MySQL SQL State HY000
ER_LOAD_FROM_FIXED_SIZE_ROWS_TO_VAR
Can’t load value from file with fixed size rows to variable
MariaDB ERROR Code 1410
MySQL SQL State 42000
ER_CANT_CREATE_USER_WITH_GRANT
You are not allowed to create a user with GRANT

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

 
1 2 3 4