Error
Error Code:
3906
MySQL Error 3906: Multi-Valued Index Space Exceeded
Description
This error occurs when the combined length of all values extracted and indexed for a multi-valued index on a single record surpasses MySQL's internal limit. It typically happens when a JSON column contains a large number of elements or very long string values that are part of a multi-valued index, leading to an excessive total index size for that specific row.
Error Message
Exceeded max total length of values per record for multi-valued index '%s' by %u bytes.
Known Causes
3 known causesExcessive JSON Array Elements
A JSON column used in a multi-valued index contains an array with an unusually large number of elements, causing the total indexed value length for a record to surpass the allowed maximum.
Overly Long String Values
Individual string values within the JSON array, which contribute to the multi-valued index, are excessively long, leading to the overall index size limit being breached for a single record.
High Data Volume Per Record
A particular record contains a large volume of data within the column targeted by the multi-valued index, resulting in the indexed values' aggregated length exceeding the system-defined maximum.
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