For starters... I am new to MariaDB and to lists.mariadb.org so please forgive me if I am asking this in the wrong place.
I am running 10.5.34 Community Version and I am trying to set up my backup strategy. As part of that process I am attempting to manually purge binary logs based on the last log included in the backup. In my test environment running "PURGE BINARY LOGS BEFORE 'YYYY-MM-DD hh:mm:ss'" the command works but when I run it in my production environment it does not delete anything. There are no errors returned (the limited output there is looks exactly as it does in my test environment) nor is anything written to the mariadb.log file. This is what I know so far: 1. I do not have expire_log_days or expire_log_hours set. 2. I do not have a replica configured. 3. Both the oldest and most recent logs on disk match what is found in my .index file. 4. The logs on disk and the log names in the .index file are both contiguous (no gaps in either). 5. There are no errors written anywhere. 6. Test and prod are configured identically. (Same configuration files, same server configuration, same directory structure, etc.). I am at a loss! At this point the only thing I know to do is to add a "rm" command to remove logs and a "sed" command to update the .index file to the end of my backup script but I really do not want to do that. Any help would be greatly appreciated. Respectfully, Mark _______________________________________________ discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-le...@lists.mariadb.org
