log spam with postgres_fdw

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: log spam with postgres_fdw
Date: 2019-09-15 14:40:49
Message-ID: CAMkU=1xAi0_7P4M1LkGARBkJcea1dOn8ExBDuAf+vCHZ40AmXA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I'm sending this to hackers, because it is not exactly a bug, and it can't
be addressed from userland. I think it is a coding issue, although I
haven't identified the exact code.

When closing the local session which had used postgres_fdw over an ssl
connection, I get log spam on the foreign server saying:

LOG: could not receive data from client: Connection reset by peer

It is easy to reproduce, but you must be using ssl to do so.

On searching, I see that a lot of people have run into this issue, with
considerable confusion, but as far as I can see it has never been diagnosed.

Is there anything that can be done about this, other than just learning to
ignore it?

Cheers,

Jeff

Attachment Content-Type Size
fdw_log_spam.sql text/plain 345 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-09-15 15:14:30 Re: log spam with postgres_fdw
Previous Message Virendra Negi 2019-09-15 14:36:24 Re: Primary keepalive message not appearing in Logical Streaming Replication