EC
1752
MariaDBWARNINGNotableTransactionsHIGH confidence

Incomplete rollback — dropped temporary table not restored

Production Risk

Low — warning only; temporary table is permanently removed.

What this means

A transaction that dropped a temporary table was rolled back, but DROP TEMPORARY TABLE is non-transactional and cannot be undone; the temporary table is permanently gone.

Why it happens
  1. 1DROP TEMPORARY TABLE executed inside a transaction that was subsequently rolled back.
How to reproduce
trigger — this will error
trigger — this will error
START TRANSACTION;
DROP TEMPORARY TABLE tmp_work;
ROLLBACK; -- tmp_work is gone permanently

expected output

Warning (Code 1752): Some temporary tables were dropped in a transaction that rolled back.

Fix

Recreate the temporary table if needed after an unintended rollback

Recreate the temporary table if needed after an unintended rollback
CREATE TEMPORARY TABLE tmp_work AS SELECT ...;

Why this works

Since DROP TEMPORARY TABLE cannot be rolled back, the table must be recreated manually.

What not to do

✕

Sources
Official documentation ↗

MySQL 8.0 — 1752 ER_WARNING_NOT_COMPLETE_ROLLBACK_WITH_DROPPED_TEMP_TABLE

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

← All MariaDB errors