Troubleshooting MYSQL or MariaDB Errors from Error 1671 to 1680

SQLServerF1

MariaDB ERROR Code 1671
MySQL SQL State HY000
ER_BINLOG_UNSAFE_AUTOINC_COLUMNS
Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. Inserted values cannot be logged correctly. Note: Introduced in 5.5.3.
MariaDB ERROR Code 1672
MySQL SQL State HY000
ER_BINLOG_UNSAFE_UDF
Statement is unsafe because it uses a UDF which may not return the same value on the slave. Note: Introduced in 5.5.3.
MariaDB ERROR Code 1673
MySQL SQL State HY000
ER_BINLOG_UNSAFE_SYSTEM_VARIABLE
Statement is unsafe because it uses a system variable that may have a different value on the slave. Note: Introduced in 5.5.3.

MariaDB ERROR Code 1674
MySQL SQL State HY000
ER_BINLOG_UNSAFE_SYSTEM_FUNCTION
Statement is unsafe because it uses a system function that may return a different value on the slave. Note: Introduced in 5.5.3.
MariaDB ERROR Code 1675
MySQL SQL State HY000
ER_BINLOG_UNSAFE_NONTRANS_AFTER_TRANS
Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction. Note: ER_BINLOG_UNSAFE_NONTRANS_AFTER_TRANS was introduced in 5.5.3.
MariaDB ERROR Code 1676
MySQL SQL State HY000
ER_MESSAGE_AND_STATEMENT
%s Statement: %s Note: Introduced in 5.5.3.

MariaDB ERROR Code 1677
MySQL SQL State HY000
ER_SLAVE_CONVERSION_FAILED
Column %d of table ‘%s.%s’ cannot be converted from type ‘%s’ to type ‘%s’ Note: Introduced in 5.5.3.
MariaDB ERROR Code 1678
MySQL SQL State HY000
ER_SLAVE_CANT_CREATE_CONVERSION
Can’t create conversion table for table ‘%s.%s’ Note: Introduced in 5.5.3.
MariaDB ERROR Code 1679
MySQL SQL State HY000
ER_INSIDE_TRANSACTION _PREVENTS_SWITCH_BINLOG_FORMAT
Cannot modify @@session.binlog_format inside a transaction Note: Introduced in 5.5.3.
MariaDB ERROR Code 1680
MySQL SQL State HY000
ER_PATH_LENGTH
The path specified for %s is too long. Note: Introduced in 5.5.3.

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