MySQL Server Error Codes and Messages 1550 - 1599

Error: 1550 SQLSTATE: HY000 (ER_EVENT_COMPILE_ERROR)

Message: Error during compilation of event's body

Error: 1551 SQLSTATE: HY000 (ER_EVENT_SAME_NAME)

Message: Same old and new event name

Error: 1552 SQLSTATE: HY000 (ER_EVENT_DATA_TOO_LONG)

Message: Data for column '%s' too long

Error: 1553 SQLSTATE: HY000 (ER_DROP_INDEX_FK)

Message: Cannot drop index '%s': needed in a foreign key constraint

Error: 1554 SQLSTATE: HY000 (ER_WARN_DEPRECATED_SYNTAX_WITH_VER)

Message: The syntax '%s' is deprecated and will be removed in MySQL %s. Please use %s instead

Error: 1555 SQLSTATE: HY000 (ER_CANT_WRITE_LOCK_LOG_TABLE)

Message: You can't write-lock a log table. Only read access is possible

Error: 1556 SQLSTATE: HY000 (ER_CANT_LOCK_LOG_TABLE)

Message: You can't use locks with log tables.

Error: 1557 SQLSTATE: 23000 (ER_FOREIGN_DUPLICATE_KEY)

Message: Upholding foreign key constraints for table '%s', entry '%s', key %d would lead to a duplicate entry

Error: 1558 SQLSTATE: HY000 (ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE)

Message: Column count of mysql.%s is wrong. Expected %d, found %d. Created with MySQL %d, now running %d. Please use mysql_upgrade to fix this error.

Error: 1559 SQLSTATE: HY000 (ER_TEMP_TABLE_PREVENTS_SWITCH_OUT_OF_RBR)

Message: Cannot switch out of the row-based binary log format when the session has open temporary tables

Error: 1560 SQLSTATE: HY000 (ER_STORED_FUNCTION_PREVENTS_SWITCH_BINLOG_FORMAT)

Message: Cannot change the binary logging format inside a stored function or trigger

Error: 1561 SQLSTATE: HY000 (ER_NDB_CANT_SWITCH_BINLOG_FORMAT)

Message: The NDB cluster engine does not support changing the binlog format on the fly yet

Error: 1562 SQLSTATE: HY000 (ER_PARTITION_NO_TEMPORARY)

Message: Cannot create temporary table with partitions

Error: 1563 SQLSTATE: HY000 (ER_PARTITION_CONST_DOMAIN_ERROR)

Message: Partition constant is out of partition function domain

Error: 1564 SQLSTATE: HY000 (ER_PARTITION_FUNCTION_IS_NOT_ALLOWED)

Message: This partition function is not allowed

Error: 1565 SQLSTATE: HY000 (ER_DDL_LOG_ERROR)

Message: Error in DDL log

Error: 1566 SQLSTATE: HY000 (ER_NULL_IN_VALUES_LESS_THAN)

Message: Not allowed to use NULL value in VALUES LESS THAN

Error: 1567 SQLSTATE: HY000 (ER_WRONG_PARTITION_NAME)

Message: Incorrect partition name

Error: 1568 SQLSTATE: 25001 (ER_CANT_CHANGE_TX_ISOLATION)

Message: Transaction isolation level can't be changed while a transaction is in progress

Error: 1569 SQLSTATE: HY000 (ER_DUP_ENTRY_AUTOINCREMENT_CASE)

Message: ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '%s' for key '%s'

Error: 1570 SQLSTATE: HY000 (ER_EVENT_MODIFY_QUEUE_ERROR)

Message: Internal scheduler error %d

Error: 1571 SQLSTATE: HY000 (ER_EVENT_SET_VAR_ERROR)

Message: Error during starting/stopping of the scheduler. Error code %u

Error: 1572 SQLSTATE: HY000 (ER_PARTITION_MERGE_ERROR)

Message: Engine cannot be used in partitioned tables

Error: 1573 SQLSTATE: HY000 (ER_CANT_ACTIVATE_LOG)

Message: Cannot activate '%s' log

Error: 1574 SQLSTATE: HY000 (ER_RBR_NOT_AVAILABLE)

Message: The server was not built with row-based replication

Error: 1575 SQLSTATE: HY000 (ER_BASE64_DECODE_ERROR)

Message: Decoding of base64 string failed

Error: 1576 SQLSTATE: HY000 (ER_EVENT_RECURSION_FORBIDDEN)

Message: Recursion of EVENT DDL statements is forbidden when body is present

Error: 1577 SQLSTATE: HY000 (ER_EVENTS_DB_ERROR)

Message: Cannot proceed because system tables used by Event Scheduler were found damaged at server start

Error: 1578 SQLSTATE: HY000 (ER_ONLY_INTEGERS_ALLOWED)

Message: Only integers allowed as number here

Error: 1579 SQLSTATE: HY000 (ER_UNSUPORTED_LOG_ENGINE)

Message: This storage engine cannot be used for log tables"

Error: 1580 SQLSTATE: HY000 (ER_BAD_LOG_STATEMENT)

Message: You cannot '%s' a log table if logging is enabled

Error: 1581 SQLSTATE: HY000 (ER_CANT_RENAME_LOG_TABLE)

Message: 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'

Error: 1582 SQLSTATE: 42000 (ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT)

Message: Incorrect parameter count in the call to native function '%s'

Error: 1583 SQLSTATE: 42000 (ER_WRONG_PARAMETERS_TO_NATIVE_FCT)

Message: Incorrect parameters in the call to native function '%s'

Error: 1584 SQLSTATE: 42000 (ER_WRONG_PARAMETERS_TO_STORED_FCT)

Message: Incorrect parameters in the call to stored function '%s'

Error: 1585 SQLSTATE: HY000 (ER_NATIVE_FCT_NAME_COLLISION)

Message: This function '%s' has the same name as a native function

Error: 1586 SQLSTATE: 23000 (ER_DUP_ENTRY_WITH_KEY_NAME)

Message: Duplicate entry '%s' for key '%s'

Error: 1587 SQLSTATE: HY000 (ER_BINLOG_PURGE_EMFILE)

Message: Too many files opened, please execute the command again

Error: 1588 SQLSTATE: HY000 (ER_EVENT_CANNOT_CREATE_IN_THE_PAST)

Message: Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.

Error: 1589 SQLSTATE: HY000 (ER_EVENT_CANNOT_ALTER_IN_THE_PAST)

Message: Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. The event was dropped immediately after creation.

Error: 1590 SQLSTATE: HY000 (ER_SLAVE_INCIDENT)

Message: The incident %s occured on the master. Message: %s

Error: 1591 SQLSTATE: HY000 (ER_NO_PARTITION_FOR_GIVEN_VALUE_SILENT)

Message: Table has no partition for some existing values

Error: 1592 SQLSTATE: HY000 (ER_BINLOG_UNSAFE_STATEMENT)

Message: Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. %s

Error: 1593 SQLSTATE: HY000 (ER_SLAVE_FATAL_ERROR)

Message: Fatal error: %s

Error: 1594 SQLSTATE: HY000 (ER_SLAVE_RELAY_LOG_READ_FAILURE)
    Message: Relay log read failure: %s

Error: 1595 SQLSTATE: HY000 (ER_SLAVE_RELAY_LOG_WRITE_FAILURE)
    Message: Relay log write failure: %s

How does the MySQL error message look like?

SHOW SLAVE STATUS\G
    ...
    Last_IO_Errno: 1595, Relay log write failure: could not queue event from master

What does the MySQL error message mean?

MySQL had a problem with a binary log event and could not write it to the relay log.

When does this MySQL error message happen?

We tried to replicate from MySQL 5.0 to MariaDB 10.3. It seems like the MySQL 5.0 binary log format is too old for MariaDB 10.3.

How to fix this MySQL error?

We will try to use a MariaDB 5.5 intermediate Slave.

Error: 1596 SQLSTATE: HY000 (ER_SLAVE_CREATE_EVENT_FAILURE)
    Message: Failed to create %s

Error: 1598 SQLSTATE: HY000 (ER_BINLOG_LOGGING_IMPOSSIBLE)

Message: Binary logging not possible. Message: %s

Error: 1599 SQLSTATE: HY000 (ER_VIEW_NO_CREATION_CTX)

Message: View `%s`.`%s` has no creation context