Warning
Error Code:
1867
MariaDB Error 1867: Log File Purge Incomplete
Description
This warning indicates that MariaDB attempted to purge old binary or relay log files, but some files could not be removed. This usually happens because one or more database threads are actively reading the log files, preventing their deletion and resulting in an incomplete purge.
Error Message
file %s was not purged because it was being read by %d thread(s), purged only %d out of %d files.
Known Causes
3 known causesLagging Replication Slaves
One or more replication slave servers are behind in processing events and still actively reading an older binary log file from the master.
Long-Running Database Operations
Extended database transactions or queries may hold references to older log files, delaying their release and subsequent purging by MariaDB.
Active Backup Processes
An ongoing database backup operation (e.g., `mariabackup`) might be reading log files to ensure data consistency, temporarily preventing their deletion.
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