Re: How to set Liveness & Readiness probe for pgadmin running in Kubernetes

Hi Yogesh / pgadmin-support team, 

Have set up the liveness probe as suggested by you. However, It is now super helpful. The problem I am facing is though the /misc/ping is giving 200 status, I received complaints from users that they cant access pgadmin.
When I checked the logs, I noticed that /sqleditor/status/<some number> is 500 & 503. I guess the number could be session ID or something not sure. Please find the below log message 

[::ffff:<private_ip_address> - - [13/Apr/2023:16:28:13 +0000] "GET /misc/ping HTTP/1.1" 200 4 "-" "kube-probe/1.24+"

::ffff:<private_ip_address> - - [13/Apr/2023:16:28:13 +0000] "GET /misc/ping HTTP/1.1" 200 4 "-" "kube-probe/1.24+"
<public_ip_address> - - [13/Apr/2023:16:28:14 +0000] "GET /sqleditor/status/4397343 HTTP/1.1" 500 103 "https://pgadmin-url/sqleditor/panel/4397343?is_query_tool=true&sgid=96&sid=307&did=<db_id>&database_name=<db_name>" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0"
<public_ip_address> - - [13/Apr/2023:16:28:14 +0000] "GET /sqleditor/status/9414096 HTTP/1.1" 503 100 "https://pgadmin-url/sqleditor/panel/9414096?is_query_tool=true&sgid=96&sid=307&did=<db_id>&database_name=<db_name>" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0"
<public_ip_address> - - [13/Apr/2023:16:28:14 +0000] "GET /sqleditor/status/9414096 HTTP/1.1" 503 100 "https://pgadmin-url/sqleditor/panel/9414096?is_query_tool=true&sgid=96&sid=307&did=<db_id>&database_name=<db_name>" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0"
<public_ip_address> - - [13/Apr/2023:16:28:14 +0000] "GET /sqleditor/status/9414096 HTTP/1.1" 503 100 "https://pgadmin-url/sqleditor/panel/9414096?is_query_tool=true&sgid=96&sid=307&did=<db_id>&database_name=<db_name>" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0

Later I restarted the pgadmin pod to get rid of this issue. Could you please explain what exactly is happening and how to fix it ? Thanks. 

Regards,

Arun

On Tue, Apr 11, 2023 at 10:42 AM Aruna Manivannan <aruna.manivannan@gmail.com> wrote:

Hi Yogesh, 

Thanks for your response. Will use it and let you know the result. Thank you again.

Regards,

Arun

On Tue, Apr 11, 2023 at 1:58 AM Yogesh Mahajan <yogesh.mahajan@enterprisedb.com> wrote:

Hi Aruna,

You can use 'misc/ping' to monitor health checks.

E.g.

pgadmin:    image: dpage/pgadmin4    healthcheck:      test: ["CMD", "wget", "-O", "-", "http://localhost:80/misc/ping"]

Thanks,

Yogesh Mahajan

EnterpriseDB

On Tue, Apr 11, 2023 at 2:20 AM Aruna Manivannan <aruna.manivannan@gmail.com> wrote:

Hi Team, 

This is Arun. Could you please help me with setting up a Liveness & Readiness probe for pgadmin4 6.17 which is running in the Kubernetes cluster as Statefulset. I mean, is there any URL endpoint which I can configure to hit? Thanks. 

Regards,

Arun