This is a read-only copy of the MariaDB Knowledgebase generated on 2024-12-22. For the latest, interactive version please visit https://mariadb.com/kb/.

Created: 9 months, 2 weeks ago
Modified: 9 months, 2 weeks ago
Type: article
Status: active
License: CC BY-SA / Gnu FDL

Attachments

No attachments exist

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

Error Code	SQLSTATE	Error	Description
1559	HY000	ER_TEMP_TABLE_PREVENTS_SWITCH_OUT_OF_RBR	Cannot switch out of the row-based binary log format when the session has open temporary tables

Possible Causes and Solutions

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

↑ MariaDB Error Codes 1500 to 1599 ↑
Error 1500: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning
Error 1501: Failed to create specific handler file
Error 1502: A BLOB field is not allowed in partition function
Error 1503: must include all columns in the table's partitioning function
Error 1504: Number of = 0 is not an allowed value
Error 1505: Partition management on a not partitioned table is not possible
Error 1506: Foreign key clause is not yet supported in conjunction with partitioning
Error 1507: Error in list of partitions to
Error 1508: Cannot remove all partitions, use DROP TABLE instead
Error 1509: COALESCE PARTITION can only be used on HASH/KEY partitions
Error 1510: REORGANIZE PARTITION can only be used to reorganize partitions not to change their numbers
Error 1511: REORGANIZE PARTITION without parameters can only be used on auto-partitioned tables using HASH PARTITIONs
Error 1512: PARTITION can only be used on RANGE/LIST partitions
Error 1513: Trying to Add partition(s) with wrong number of subpartitions
Error 1514: At least one partition must be added
Error 1515: At least one partition must be coalesced
Error 1516: More partitions to reorganize than there are partitions
Error 1517: Duplicate partition name
Error 1518: It is not allowed to shut off binlog on this command
Error 1519: When reorganizing a set of partitions they must be in consecutive order
Error 1520: Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range
Error 1521: Partition function not supported in this version for this handler
Error 1522: Partition state cannot be defined from CREATE/ALTER TABLE
Error 1523: The handler only supports 32 bit integers in VALUES
Error 1524: Plugin is not loaded
Error 1525: Incorrect value
Error 1526: Table has no partition for value
Error 1527: It is not allowed to specify more than once
Error 1528: Failed to create
Error 1529: Failed to drop
Error 1530: The handler doesn't support autoextend of tablespaces
Error 1531: A size parameter was incorrectly specified, either number or on the form 10M
Error 1532: The size number was correct but we don't allow the digit part to be more than 2 billion
Error 1533: Failed to alter
Error 1534: Writing one row to the row-based binary log failed
Error 1535: Table definition on master and slave does not match
Error 1536: Slave running with --log-slave-updates must use row-based binary logging to be able to replicate row-based binary log events
Error 1537: Event already exists
Error 1538: Failed to store event. Error code from storage engine.
Error 1539: Unknown event
Error 1540: Failed to alter event
Error 1541: Failed to drop
Error 1542: INTERVAL is either not positive or too big
Error 1543: ENDS is either invalid or before STARTS
Error 1544: Event execution time is in the past. Event has been disabled
Error 1545: Failed to open mysql.event
Error 1546: No datetime expression provided
Error 1547: Column count is wrong. Expected found. The table is probably corrupted
Error 1548: Cannot load from mysql. The table is probably corrupted
Error 1549: Failed to delete the event from mysql.event
Error 1550: Error during compilation of event's body
Error 1551: Same old and new event name
Error 1552: Data for column too long
Error 1553: Cannot drop index needed in a foreign key constraint
Error 1554: The syntax is deprecated and will be removed in MariaDB
Error 1555: You can't write-lock a log table. Only read access is possible
Error 1556: You can't use locks with log tables
Error 1557: Upholding foreign key constraints for table, entry, key would lead to a duplicate entry
Error 1558: Column count is wrong. Expected found. Created with MariaDB now running. Please use mysql_upgrade to fix this error.
Error 1559: Cannot switch out of the row-based binary log format when the session has open temporary tables
Error 1560: Cannot change the binary logging format inside a stored function or trigger
Error 1561: You should never see it
Error 1562: Cannot create temporary table with partitions
Error 1563: Partition constant is out of partition function domain
Error 1564: This partition function is not allowed
Error 1565: Error in DDL log
Error 1566: Not allowed to use NULL value in VALUES LESS THAN
Error 1567: Incorrect partition name
Error 1568: Transaction isolation level can't be changed while a transaction is in progress
Error 1569: ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry for key
Error 1570: Internal scheduler error
Error 1571: Error during starting/stopping of the scheduler
Error 1572: Engine cannot be used in partitioned tables
Error 1573: Cannot activate log
Error 1574: The server was not built with row-based replication
Error 1575: Decoding of base64 string failed
Error 1576: Recursion of EVENT DDL statements is forbidden when body is present
Error 1577: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
Error 1578: Only integers allowed as number here
Error 1579: This storage engine cannot be used for log tables
Error 1580: You cannot '%s' a log table if logging is enabled
Error 1581: Cannot rename. When logging enabled, rename to/from log table must rename two tables
Error 1582: Incorrect parameter count in the call to native function
Error 1583: Incorrect parameters in the call to native function
Error 1584: Incorrect parameters in the call to stored function
Error 1585: This function has the same name as a native function
Error 1586: Duplicate entry for key
Error 1587: Too many files opened, please execute the command again
Error 1588: Event execution time is in the past and ON COMPLETION NOT PRESERVE is set
Error 1589: Event execution time is in the past and ON COMPLETION NOT PRESERVE is set
Error 1590: The incident occured on the master
Error 1591: Table has no partition for some existing values
Error 1592: Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT
Error 1593: Fatal error
Error 1594: Relay log read failure
Error 1595: Relay log write failure
Error 1596: Failed to create
Error 1597: Master command failed
Error 1598: Binary logging not possible
Error 1599: View has no creation context

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

Contents

Possible Causes and Solutions

Products

Services

Pricing

Resources

About Us

Download MariaDB