Skip to content

Nightly Neon backup is failing #473

Description

@github-actions

The nightly pg_dump of workwell_spike failed: run 32807396702.

Treat this as a production incident, not a backup problem. This job is the only always-on
process that opens a real connection to the real database, so it is our de-facto database
health check. The 15-minute self-heal reconciler probes /actuator/health, which is
deliberately DB-free and cannot detect a database outage — do not "fix" that by adding a
query to it, or the reconciler becomes a compute-pinning loop (see docs/DEPLOY.md
"Database compute cost").

Most likely causes, in order:

  1. Database unreachable — check the Neon console. A 402 in the run log means the compute
    quota is exhausted and every DB-backed route is already returning internal_error.
  2. Rotated/expired DATABASE_URL_TWH or the backup IAM credentials.
  3. pg_dump version drift against the server.

Quick check — if this returns 500s, the live site is down:

curl -s -o /dev/null -w '%{http_code}\n' https://twh-api-ts.os.mieweb.org/api/version

This issue closes automatically on the next successful backup.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions