898943 - pgsql on socorro1.stage.db.phx1 is refusing connections

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[Ashish Vijayaram [:ashish]]

19:06:13 < nagios-phx1> Sun 19:06:13 PDT [1205] socorro1.stage.db.phx1.mozilla.com:PostgreSQL Idle Transactions is UNKNOWN: ERROR: could not connect to server: Connection refused (http://m.allizom.org/PostgreSQL+Idle+Transactions)
19:07:34 < nagios-phx1> Sun 19:07:34 PDT [1207] socorro1.stage.db.phx1.mozilla.com:PostgreSQL Template1 is UNKNOWN: ERROR: could not connect to server: Connection refused (http://m.allizom.org/PostgreSQL+Template1)
19:08:53 < nagios-phx1> Sun 19:08:53 PDT [1209] socorro1.stage.db.phx1.mozilla.com:PostgreSQL Transaction Wraparound is UNKNOWN: ERROR: could not connect to server: Connection refused (http://m.allizom.org/PostgreSQL+Transaction+Wraparound)

and then these followed by:

19:12:43 < nagios-phx1> Sun 19:12:43 PDT [1214] socorroadm.stage.private.phx1.mozilla.com:Socorro Admin - procs is CRITICAL: PROCS CRITICAL: 0 processes with regex args startMonitor (http://m.allizom.org/Socorro+Admin+-+procs)

and both the processors stopped processing too. Filing this bug for tracking. Bug 898536 might be related.

Comment 1

[Lonnen :lonnen]

All of these seem to have cleared. I don't think it is related to 898536, which is ongoing (and appears to be a table permissions issue).