Error
Error Code:
1795
MariaDB Error 1795: InnoDB FULLTEXT Index Limit
Description
This error occurs in MariaDB when you attempt to create more than one FULLTEXT index on an InnoDB table concurrently. InnoDB is designed to process only one FULLTEXT index creation operation at a time, preventing multiple such operations from running in parallel.
Error Message
InnoDB presently supports one FULLTEXT index creation at a time
Known Causes
3 known causesConcurrent Index Creation
Another `ALTER TABLE ... ADD FULLTEXT INDEX` statement is already executing on an InnoDB table within the same MariaDB instance.
Automated Script Overlap
Multiple automated scripts or deployment tools are attempting to create FULLTEXT indexes simultaneously on InnoDB tables.
Manual and Scripted Conflict
A user manually initiated a FULLTEXT index creation while an automated process or another user simultaneously started a similar operation.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service