Re: How to set Liveness & Readiness probe for pgadmin running in Kubernetes - Mailing list pgadmin-support
| From | Aruna Manivannan |
|---|---|
| Subject | Re: How to set Liveness & Readiness probe for pgadmin running in Kubernetes |
| Date | |
| Msg-id | CAOeu6=JH7eNTe1y1VLY9gz-6uo-wuG996_x3ZfE4k9R2Ycvqow@mail.gmail.com Whole thread Raw |
| In response to | Re: How to set Liveness & Readiness probe for pgadmin running in Kubernetes (Aruna Manivannan <aruna.manivannan@gmail.com>) |
| Responses |
Re: How to set Liveness & Readiness probe for pgadmin running in Kubernetes
|
| List | pgadmin-support |
Hi Yogesh / pgadmin-support team,
<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.
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+"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+"
<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,ArunOn 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 MahajanEnterpriseDBOn 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
pgadmin-support by date: