Project

General

Profile

Actions
Copy link

action #87838

closed

*alert* osd: Open database connections by user alert

Added by okurz almost 4 years ago. Updated almost 4 years ago.

Status:
Resolved
Priority:
High
Assignee:
okurz
Category:
-
Target version:
openQA Project (public) - Ready
Start date:
2021-01-18
Due date:
2021-01-26
% Done:

0%

Estimated time:

Description

Observation

Alert message received 20201-01-18 05:59, received automatic resolution again 06:04:

Alert message details:

90% of postgresql connections reached or connections are already not possible any more. Check on OSD what query is blocking with e.g.: ``` SELECT datid, datname, pid, usesysid, usename, query_start, state, query FROM pg_stat_activity WHERE state = 'active' ORDER BY query_start LIMIT 10; ```

Metric name
Value
TOTAL
113.000

Actions
Copy link

Also available in: Atom PDF