EC
3063
MariaDBWARNINGNotableReplicationHIGH confidence

Open temporary tables must be zero for this operation

Production Risk

Medium — replication may be affected if ignored.

What this means

A replication-related operation requires that there are no open temporary tables in the current session.

Why it happens
  1. 1Switching binlog format while temporary tables are open.
  2. 2Attempting STOP SLAVE or RESET SLAVE with open temporary tables.
How to reproduce
trigger — this will error
trigger — this will error
CREATE TEMPORARY TABLE t (id INT);
SET SESSION binlog_format = 'ROW';

expected output

Warning (Code 3063): There are open temporary tables. Please close all temporary tables before switching the binlog format.

Fix

Drop temporary tables before the operation

Drop temporary tables before the operation
DROP TEMPORARY TABLE IF EXISTS t;
SET SESSION binlog_format = 'ROW';

Why this works

Ensuring no open temporary tables removes the restriction.

What not to do

✕

Sources
Official documentation ↗

MySQL 8.0 — 3063 ER_WARN_OPEN_TEMP_TABLES_MUST_BE_ZERO2

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MariaDB errors