EC
1266
MariaDBWARNINGNotableTable / StorageHIGH confidence

Using storage engine fallback for table

Production Risk

Medium — table uses a different engine than intended; behavior and features differ.

What this means

ER_WARN_USING_OTHER_HANDLER (1266, SQLSTATE HY000) is a warning issued when MySQL substitutes a different storage engine than the one requested in CREATE TABLE or ALTER TABLE because the requested engine is unavailable.

Why it happens
  1. 1Requesting ENGINE=InnoDB when InnoDB is disabled
  2. 2Using a storage engine plugin that is not installed
How to reproduce
trigger — this will error
trigger — this will error
CREATE TABLE t1 (id INT) ENGINE=FEDERATED;  -- if FEDERATED plugin not installed

expected output

Warning (Code 1266): Using storage engine MyISAM for table 't1'

Fix

Install or enable the required storage engine

Install or enable the required storage engine
-- Check available engines:
SHOW ENGINES;

-- Install FEDERATED if needed (in my.cnf):
-- federated

Why this works

Ensure the required storage engine is compiled in or loaded as a plugin before creating the table.

Sources
Official documentation ↗

MySQL 8.0 — 1266 ER_WARN_USING_OTHER_HANDLER

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

← All MariaDB errors