The Ultimate Guide to High Availability with MariaDB

Error 1178: The storage engine for the table doesn't support

You are viewing an old version of this article. View the current version here.
Error CodeSQLSTATEErrorDescription
117842000ER_CHECK_NOT_IMPLEMENTEDThe storage engine for the table doesn't support %s

Contents

  1. Possible Causes and Solutions

Possible Causes and Solutions

MariaDB storage engines differ in many ways, and not all operations are supported by each engine. Perhaps you don't need the intended operation for the engine, or perhaps you need a different storage engine. For example, sequences don't support analyze table, as it's an unnecessary operation on a sequence table, which only contains one row. 

CREATE SEQUENCE s START WITH 100 INCREMENT BY 10;

ANALYZE TABLE s;
+--------+---------+----------+----------------------------------------------------------+
| Table  | Op      | Msg_type | Msg_text                                                 |
+--------+---------+----------+----------------------------------------------------------+
| test.s | analyze | note     | The storage engine for the table doesn't support analyze |
+--------+---------+----------+----------------------------------------------------------+

Comments

Comments loading...
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.