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(dot)manivannan(at)gmail(dot)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(dot)mahajan(at)enterprisedb(dot)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(dot)manivannan(at)gmail(dot)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
>>>
>>