PostgreSQL Number Files in wal_archive on socorro3.db.phx1.mozilla.com is WARNING: 22 Files - warning

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
RESOLVED FIXED
4 years ago
3 years ago

People

(Reporter: MOC Nagios API, Unassigned)

Tracking

Details

(Whiteboard: [id=nagios1.private.phx1.mozilla.com:332265], URL)

(Reporter)

Description

4 years ago
Automated alert report from nagios1.private.phx1.mozilla.com:

Hostname: socorro3.db.phx1.mozilla.com
Service:  PostgreSQL Number Files in wal_archive
State:    WARNING
Output:   22 Files - warning

Runbook:  http://m.allizom.org/PostgreSQL+Number+Files+in+wal_archive
(Reporter)

Comment 1

4 years ago
Automated alert recovery:

Hostname: socorro3.db.phx1.mozilla.com
Service:  PostgreSQL Number Files in wal_archive
State:    OK
Output:   13 Files - ok
Status: NEW → RESOLVED
Last Resolved: 4 years ago
Resolution: --- → FIXED

Comment 2

4 years ago
The wal_archive has been bouncing between OK and Warning all evening.  Not sure that its a big issue, but felt a bug to let the dbas know was in order.
Assignee: nobody → server-ops-database
Status: RESOLVED → REOPENED
Component: Server Operations: MOC → Server Operations: Database
QA Contact: bpannabecker → scabral
Resolution: FIXED → ---
I was able to fix this. It was an issue that write volume has increased significantly in the past few months and the check had not yet been updated to reflect that. It's fixed and resolved now.

Thanks!
Status: REOPENED → RESOLVED
Last Resolved: 4 years ago4 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.