Error
Error Code:
3649
MySQL Error 3649: Corrupted JSON Data Diff
Description
This error indicates that MySQL encountered malformed or unreadable internal data related to JSON column updates. Specifically, it refers to a "JSON diff," which is an internal representation of changes to a JSON column. This usually happens during operations like replication, backup restoration, or internal database processes when the expected format for JSON updates is violated.
Error Message
Corrupted JSON diff for table %.*s, column %s.
Known Causes
3 known causesUnderlying Data Corruption
The internal representation of JSON data or its diffs on disk may have become physically corrupted due to hardware failure, file system issues, or unexpected system shutdowns.
Replication Data Mismatch
During replication, an invalid or malformed JSON diff event might be applied to a replica, indicating a discrepancy or corruption in the binary log stream from the source server.
Corrupted Backup Restoration
Restoring a database from a corrupted backup or an incompatible backup format can introduce malformed internal data structures, leading to this error during subsequent operations.
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