Unable to login, postgresql pod in CrashLoopBackOff

Products

• DX Operational Intelligence
• DX Application Performance Management
• CA App Experience Analytics
• DX Operational Observability

Issue/Introduction

Symptoms:

- Unable to login
- dxi-postgresql pod is in CrashLoopBackOff status
- postgres pod logs reports the below messages

2022-03-16 09:26:16.383 UTC [26] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-03-16 09:26:16.385 UTC [26] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
2022-03-16 09:26:16.990 UTC [26] LOG:  redirecting log output to logging collector process
2022-03-16 09:26:16.990 UTC [26] HINT:  Future log output will appear in directory "log".
.... stopped waiting
pg_ctl: could not start server
Examine the log output.

 

Environment

DX O2 2*

Cause

Insufficient allocated disk space

pg-data-clamp pvc had been manually reconfigured and reduced from 1GB to 300MB and only 34Mb was available.

Resolution

Increase capacity to the pg-data-clamp PVC, contact your Openshift or Kubernetes support team for assistance.