Error
Error Code:
3905
MySQL Error 3905: Multi-valued Index Value Limit Exceeded
Description
MySQL Error 3905 occurs when an operation attempts to store or update a record with a multi-valued index, and the number of values associated with that index for the given record surpasses the system's maximum allowed limit. This error typically arises when working with JSON columns that utilize multi-valued indexes, where an array or object contains an excessive number of elements that are being indexed.
Error Message
Exceeded max number of values per record for multi-valued index '%s' by %u value(s).
Known Causes
3 known causesExcessive Indexed JSON Elements
A JSON column, which is part of a multi-valued index, contains an array or object with more elements than MySQL's internal or configured maximum for that index type.
High Volume Data Ingestion
During bulk inserts, data migrations, or application writes, records are introduced that inadvertently push past the multi-valued index limit due to their content structure.
Index Configuration Limitations
While often an internal MySQL limit, the specific configuration or design of the multi-valued index itself might implicitly restrict the number of values per record, which has been encountered.
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