3301
MySQLERRORNotableInnoDB / Full-Text SearchHIGH confidence
InnoDB full-text auxiliary table ID is not a valid hex value
Production Risk
Medium — full-text search on the table is unavailable until the index is rebuilt.
How to reproduce
trigger — this will error
trigger — this will error
-- Internal error; not directly triggerable via SQL.
expected output
ERROR 3301 (HY000): InnoDB: FTS auxiliary table name is not a valid hex ID.
Fix
Rebuild the full-text index
Rebuild the full-text index
ALTER TABLE t DROP INDEX ft_idx; ALTER TABLE t ADD FULLTEXT INDEX ft_idx (col);
Why this works
Recreating the FTS index regenerates all auxiliary tables with correct names.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3301 ER_INNODB_FT_AUX_NOT_HEX_ID3
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev