BUG #16353: pg_isready timeout is ignored

Started by PG Bug reporting formabout 6 years ago2 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 16353
Logged by: vonProteus
Email address: vonproteus+postgresql.org@gmail.com
PostgreSQL version: 11.7
Operating system: docker postgres:11-alpine (x64)
Description:

hi
i have problem with pg_isready and time out
it look like it is ignored
this is my setup

$ docker run --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -p
3333:5432 --rm -d postgres:11-alpine
4765f8dc49374044d551b3cdb0ce5284905ee1c01bf6a81b2cddf30ab6798bc8

$ time docker run --rm postgres:11-alpine pg_isready -t 120 -h
10.110.12.163 -p 3333
10.110.12.163:3333 - accepting connections

real 0m0.781s
user 0m0.000s
sys 0m0.031s

$ docker stop some-postgres
some-postgres

$ time docker run --rm postgres:11-alpine pg_isready -t 120 -h
10.110.12.163 -p 3333
10.110.12.163:3333 - no response

real 0m2.722s
user 0m0.000s
sys 0m0.031s

i would expect that second call would exit after 120s
i run this on windows

#2Hamid Akhtar
hamid.akhtar@gmail.com
In reply to: PG Bug reporting form (#1)
Re: BUG #16353: pg_isready timeout is ignored

For pg_isready attempts to make a connection with the sever. If a
connection is not successful and we didn't receive any error response from
the server, it is a fair assumption to make that server is not running. In
this case, it makes perfect sense to not honour the timeout value and
return immediately.

So, this is actually not a bug but rather an expected behaviour.

On Thu, Apr 9, 2020 at 11:18 AM PG Bug reporting form <
noreply@postgresql.org> wrote:

The following bug has been logged on the website:

Bug reference: 16353
Logged by: vonProteus
Email address: vonproteus+postgresql.org@gmail.com
PostgreSQL version: 11.7
Operating system: docker postgres:11-alpine (x64)
Description:

hi
i have problem with pg_isready and time out
it look like it is ignored
this is my setup

$ docker run --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -p
3333:5432 --rm -d postgres:11-alpine
4765f8dc49374044d551b3cdb0ce5284905ee1c01bf6a81b2cddf30ab6798bc8

$ time docker run --rm postgres:11-alpine pg_isready -t 120 -h
10.110.12.163 -p 3333
10.110.12.163:3333 - accepting connections

real 0m0.781s
user 0m0.000s
sys 0m0.031s

$ docker stop some-postgres
some-postgres

$ time docker run --rm postgres:11-alpine pg_isready -t 120 -h
10.110.12.163 -p 3333
10.110.12.163:3333 - no response

real 0m2.722s
user 0m0.000s
sys 0m0.031s

i would expect that second call would exit after 120s
i run this on windows

--
Highgo Software (Canada/China/Pakistan)
URL : www.highgo.ca
ADDR: 10318 WHALLEY BLVD, Surrey, BC
CELL:+923335449950 EMAIL: mailto:hamid.akhtar@highgo.ca
SKYPE: engineeredvirus