3649
MySQLERRORNotableInnoDBHIGH confidence
Cannot create full-text index in InnoDB read-only mode
Production Risk
Medium — Index creation fails; full-text search unavailable until index is created on a writable node.
How to reproduce
trigger — this will error
trigger — this will error
CREATE FULLTEXT INDEX ft_idx ON articles(body); -- server in read-only mode
expected output
ERROR 3649 (HY000): Cannot create InnoDB full-text index in read-only mode.
Fix
Create FTS index on primary
Create FTS index on primary
-- Connect to the primary (writable) node and create the index there
Why this works
Performs DDL on a server instance that allows writes.
What not to do
✕
Version notes
Sources
Official documentation ↗
MySQL 8.0 — 3649 ER_INNODB_CREATE_FTS_INDEX_IN_READ_ONLY_MODE
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev