OBSOLETE backups

[wasim devale]

Hi All

The Barman is not deleting the old backups.

server1 20250501T000004 - R - Thu May  1 00:11:54 2025 - Size: 454.9 GiB - WAL Size: 3.2 GiB -  OBSOLETE

barman delete empirx1 20250501T000004
Deleting backup 20250501T000004 for server empirx1
Delete associated WAL segments:
EXCEPTION: [Errno 2] No such file or directory: '/data/empirx1/wals/0000000100001E3E'
See log file for more details.

Please help.

Thanks,
Wasim

[Israel Barth]

Hi Wasim,

Thank you for the details.

From the error message you shared, it looks like Barman is trying to delete a WAL segment it believes exists, but the corresponding file is missing from the filesystem:

EXCEPTION: [Errno 2] No such file or directory: '/data/empirx1/wals/0000000100001E3E'

This typically happens when Barman's WAL metadata cache (SERVER_NAME-xlog.db) indicates that a WAL segment is present, but the file itself has been removed by any means from the expected location.

To help us troubleshoot further, could you please provide the output of:

• Barman diagnose -- Please redact any sensitive information such as passwords, if any in the output:
  
  barman diagnose

• List of files under your WALs directory:
  
  tree /data/empirx1/wals
  
  
• Contents of your xlogdb:
  
  cat /data/empirx1/wals/empirx1-xlog.db

This will give us a clearer picture of the environment and configuration.

Best regards,  
Israel.

[wasim devale]

Thanks, Israel.

The issue is resolved. I created that missing folder at that specified path and executed Barman cron.

--
--
You received this message because you are subscribed to the "Barman for PostgreSQL" group.
To post to this group, send email to pgba...@googlegroups.com
To unsubscribe from this group, send email to
pgbarman+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/pgbarman?hl=en?hl=en-GB

---
You received this message because you are subscribed to the Google Groups "Barman, Backup and Recovery Manager for PostgreSQL" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pgbarman+unsubscribe@googlegroups.com.
To view this discussion, visit https://groups.google.com/d/msgid/pgbarman/CAA-GbMwrAgEtw7jT3WJQuAErBgKEaef2d%2B5tOodZjOwnjxHbfA%40mail.gmail.com.