Re: BUG #3855: backend sends corrupted data on EHOSTDOWN error - Mailing list pgsql-bugs

On Tue, 2008-01-08 at 01:50 +0000, Scot Loach wrote:
> The following bug has been logged online:
>
> Bug reference:      3855
> Logged by:          Scot Loach
> Email address:      sloach@sandvine.com
> PostgreSQL version: 8.2.4
> Operating system:   freebsd 6.1
> Description:        backend sends corrupted data on EHOSTDOWN error
> Details:
>

This is a FreeBSD bug.

http://www.freebsd.org/cgi/query-pr.cgi?pr=100172

It has been fixed here:

http://www.freebsd.org/cgi/cvsweb.cgi/src/sys/netinet/tcp_output.c

in revision 1.112.2.1.

I ran into this bug too, and it was very frustrating! For me, it
manifested itself as SSL errors.

You can demonstrate the problem with SSH as well (inducing an ARP
failure will terminate the SSH session, when TCP should protect you
against that), so it is clearly not a PostgreSQL bug.

Thanks to "Andrew - Supernews" (a PostgreSQL user) for tracking this bug
down.

Regards,
    Jeff Davis