Connection Heroku PostgreSQL reset by peer


We use the PostgreSQL Crane plan and get a lot of magazines like this.
app postgres - - [5-1] ... LOG: could not receive data from client: Connection reset by peer

We use about 50 speakers.
Does PostgreSQL end up with a bunch of speakers?
Can someone help me explain this case?

thanks

+4
source share
2 answers

From what I found to be the cause of the errors, the client does not disconnect at the end of the session or a new connection is not created.

New Connection Solving the Problem: Postgres Error on Heroku with Resque

Explicit fix: https://github.com/resque/resque/issues/367 (comment # 2)

+1
source

There is an entry in Herek: Understanding the registration protocols and chronic errors of Postgres Heroku: could not get data from the client: Connection reset by peer .

Although this log is emitted from postgres, the cause of the error has nothing to do with the database itself. Your application crashed while connecting to postgres and did not clear its connection to the database. Postgres noticed that the client (your application) disappeared without ending the connection correctly, and launched a message about it.

If you do not see the backtrace of your applications, you may need to make sure that you are actually logging into stdout (and not the file) and that you have stdout synchronization.

+1
source

Source: https://habr.com/ru/post/1445232/


All Articles