Error
Error Code:
3847
MySQL Error 3847: Redo Log Archive File Creation Failed
Description
This error indicates that MySQL's InnoDB storage engine failed to create a redo log archive file. This typically occurs during operations that require redo log archiving, such as certain `ALTER TABLE` statements or when redo log archiving is explicitly enabled. The failure is usually due to an underlying operating system issue preventing file creation.
Error Message
Cannot create redo log archive file '%s' (OS errno: %d - %s)
Known Causes
4 known causesInsufficient Disk Space
The file system where MySQL attempts to create the redo log archive file has run out of available storage space.
Permissions Denied
The MySQL server process lacks the necessary write permissions for the directory designated for redo log archive files.
Invalid Archive Path
The configured path for storing redo log archive files is incorrect or the specified directory does not exist on the file system.
File System Issues
Underlying file system problems, such as corruption, quotas, or inode limits, prevent new file creation.
Solutions
Coming SoonGeneral 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