Troubleshooting MYSQL or MariaDB Errors from Error 1711 to 1720

SQLServerF1

MariaDB ERROR Code 1711
MySQL SQL State HY000
ER_ERROR_IN_UNKNOWN_TRIGGER_BODY
Unknown trigger has an error in its body: ‘%s’
MariaDB ERROR Code 1712
MySQL SQL State HY000
ER_INDEX_CORRUPT
Index %s is corrupted
MariaDB ERROR Code 1713
MySQL SQL State HY000
ER_UNDO_RECORD_TOO_BIG
Undo log record is too big.

MariaDB ERROR Code 1714
MySQL SQL State HY000
ER_BINLOG_UNSAFE_INSERT_IGNORE_SELECT
INSERT IGNORE… SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and the slave.
MariaDB ERROR Code 1715
MySQL SQL State HY000
ER_BINLOG_UNSAFE_INSERT_SELECT_UPDATE
INSERT… SELECT… ON DUPLICATE KEY UPDATE is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are updated. This order cannot be predicted and may differ on master and the slave.
MariaDB ERROR Code 1716
MySQL SQL State HY000
ER_BINLOG_UNSAFE_REPLACE_SELECT
REPLACE… SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are replaced. This order cannot be predicted and may differ on master and the slave.

MariaDB ERROR Code 1717
MySQL SQL State HY000
ER_BINLOG_UNSAFE_CREATE_IGNORE_SELECT
CREATE… IGNORE SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and the slave.
MariaDB ERROR Code 1718
MySQL SQL State HY000
ER_BINLOG_UNSAFE_CREATE_REPLACE_SELECT
CREATE… REPLACE SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are replaced. This order cannot be predicted and may differ on master and the slave.
MariaDB ERROR Code 1719
MySQL SQL State HY000
ER_BINLOG_UNSAFE_UPDATE_IGNORE
UPDATE IGNORE is unsafe because the order in which rows are updated determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and the slave.
MariaDB ERROR Code 1720
MySQL SQL State HY000
ER_PLUGIN_NO_UNINSTALL
Plugin ‘%s’ is marked as not dynamically uninstallable. You have to stop the server to uninstall it. .

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