Closed Bug 1018017 Opened 10 years ago Closed 10 years ago

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

Categories

(Data & BI Services Team :: DB: MySQL, task)

Product:
Data & BI Services Team
Component:
DB: MySQL
Platform:
Other
Other
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: nagiosapi, Unassigned)

References

(
URL
)

Details

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

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
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
Closed: 10 years ago
Resolution: --- → FIXED
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
Closed: 10 years ago → 10 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.