Error
Error Code:
1371
MySQL Error 1371: Relay Log Purge Failure
Description
Error 1371 indicates that the MySQL server failed to automatically purge (delete) old relay log files during replication. This typically occurs on a replica server when it attempts to manage its log files, preventing the cleanup of disk space and potentially hindering replication operations.
Error Message
Failed purging old relay logs: %s
Known Causes
4 known causesInsufficient Disk Space
The file system hosting the relay logs may be full or nearing capacity, preventing the server from performing delete operations.
Incorrect File Permissions
The MySQL user lacks the necessary read/write/delete permissions on the directory where relay logs are stored, blocking the purge operation.
Corrupted Relay Logs
One or more relay log files or the relay log index file may be corrupted, making them unpurgeable by the server.
Relay Logs Locked by Other Processes
Another process or application might have a lock on the relay log files, preventing MySQL from deleting them.
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