EC
1700
MySQLERRORCommonStorage EngineHIGH confidence

Storage engine is not loaded

Production Risk

High — table is inaccessible until the engine is loaded.

What this means

A table operation referenced a storage engine that is not currently loaded or installed on the server.

Why it happens
  1. 1The storage engine plugin is not listed in the plugin directory.
  2. 2The plugin failed to load at startup.
  3. 3The engine was uninstalled while the server was running.
How to reproduce
trigger — this will error
trigger — this will error
CREATE TABLE t (id INT) ENGINE=RocksDB;

expected output

ERROR 1700 (HY000): Storage engine 'RocksDB' is not loaded.

Fix

Install and load the required storage engine plugin

Install and load the required storage engine plugin
INSTALL PLUGIN rocksdb SONAME 'ha_rocksdb.so';
-- Or add plugin-load-add=ha_rocksdb.so to my.cnf and restart.

Why this works

INSTALL PLUGIN dynamically loads the engine shared library into the running server.

What not to do

✕

Sources
Official documentation ↗

MySQL 8.0 — 1700 ER_STORAGE_ENGINE_NOT_LOADED

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

← All MySQL errors