Client has encountered a connection error and is not queryable

Question

Client has encountered a connection error and is not queryable

maxpain opened this issue 3 years ago · 4 comments

By some reason pg-listen doesn't reconnect in some cases.

Answer 1 · 2021-12-17T07:35:17.000Z

Thanks for sharing!

Hmm, might be an issue with pg itself, though. It's a bit nasty to debug and we would first need to find out if the unhandled promise rejection is caused by pg-listen or pg.

Can you share the exact version of pg that you are using, @maxpain?

Answer 2 · 2021-12-17T07:53:31.000Z

Can you share the exact version of pg that you are using, @maxpain?

8.7.1

I also noticed that this is happening when PostgreSQL instance restarts.

This is log from our staging environment:

Answer 3 · 2022-07-08T00:33:02.000Z

Any updates?

Answer 4 · 2022-07-08T01:00:53.000Z

I fixed this problem by setting retryTimeout: Number.POSITIVE_INFINITY in pg-listen options.
Why is it 3000 by default?