bcgov / bcgov/foi-flow

Production - one of the Patroni-docreviewer pod is not running

Open
#4,533 0 comments 0 reactions 0 assignees View on GitHub
bug production Task
Dominant language
Python
Stars
8
Forks
2
Avg merge
14h 34m
Merged PRs (30d)
46

Description

Title of ticket:

#### Description

We have 3 pods for patroni-docreviewer in prod. One of them is not running.
[Private Zenhub Image](https://api.zenhub.com/attachedFiles/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdFRqIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--9e68956da91a4e02b108c7041360d287dc0b6535/image.png)

**Log error:**
2023-09-27 18:42:08,477 WARNING: Postgresql is not running.
2023-09-27 18:42:08.686 UTC [2024597] FATAL: data directory "/home/postgres/pgdata/pgroot/data" has invalid permissions
2023-09-27 18:42:08.686 UTC [2024597] DETAIL: Permissions should be u=rwx (0700) or u=rwx,g=rx (0750).
localhost:5432 - no response

**Other details**
[Private Zenhub Image](https://api.zenhub.com/attachedFiles/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdGZqIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--1704c20a8ed6f4d73829c5cea9e8431ba419af3a/image.png)

#### Dependencies
Are there any dependencies?

#### DOD
- [ ] List the items that need to be complete for this ticket to be considered done
- [ ]
- [ ]
- [ ]
- [ ]

Contributor guide

Open the contributing guide

Research direction

Inspect the patroni-docreviewer pod and the PostgreSQL log shown in the issue, starting by comparing the running and non-running replicas. Verify the data-directory permissions and pod health, and record the root cause and remediation; done means all three production pods are running and PostgreSQL responds on localhost:5432.

Written by the indexing model from the issue text.

Assessment

Tech stack
kubernetes, postgresql
Domain
databases, devops, infrastructure
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.