LOG: could not receive data from client: An existing connection was forcibly closed by the remote host.

Герман Рихтер 1 Reputation point
2021-11-02T03:46:07.07+00:00

I'm getting this message in Azure PostgreSQL Database server log about every five minutes. I have not changed any configuration settings and the database is not being used by anything since it was created. The only user that connects to my database is azure_superuserdatabase. Why is this happening? Is this an issue?

2021-11-01 07:04:13 UTC-617f903a.eec-LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

2021-11-01 07:04:13 UTC-617f916d.fbc-LOG:  connection received: host=127.0.0.1 port=24569 pid=4028
2021-11-01 07:04:13 UTC-617f916d.fbc-LOG:  connection authorized: user=azure_superuserdatabase=azure_sys SSL enabled
2021-11-01 07:09:19 UTC-617f929f.fc0-LOG:  connection received: host=127.0.0.1 port=25338 pid=4032
2021-11-01 07:09:19 UTC-617f929f.fc0-LOG:  connection authorized: user=azure_superuserdatabase=postgres SSL enabled
2021-11-01 07:09:20 UTC-617f903a.f50-LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.


2021-11-01 07:09:20 UTC-617f92a0.1028-LOG:  connection received: host=127.0.0.1 port=25341 pid=4136
2021-11-01 07:09:20 UTC-617f92a0.1028-LOG:  connection authorized: user=azure_superuserdatabase=azure_sys SSL enabled
2021-11-01 07:14:26 UTC-617f93d2.102c-LOG:  connection received: host=127.0.0.1 port=26081 pid=4140
2021-11-01 07:14:26 UTC-617f93d2.102c-LOG:  connection authorized: user=azure_superuserdatabase=postgres SSL enabled
2021-11-01 07:14:27 UTC-617f929f.fc0-LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.
Azure Database for PostgreSQL
{count} votes

1 answer

Sort by: Most helpful
  1. Astha Sharma 1 Reputation point
    2022-04-18T12:44:01.82+00:00

    Hi @Герман Рихтер , were you able to resolve this issue? If yes could you please tell me as I'm also stuck with this issue.