BUG #2312: Software caused connection abort (0x00002745/10053) with long Bytea (>4.5mb) in the query - Mailing list pgsql-bugs

From inner
Subject BUG #2312: Software caused connection abort (0x00002745/10053) with long Bytea (>4.5mb) in the query
Date
Msg-id 20060311110727.7E26BF0A01@svr2.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged online:

Bug reference:      2312
Logged by:          inner
Email address:      transto@inbox.ru
PostgreSQL version: 8.1.2
Operating system:   Windows XP pro
Description:        Software caused connection abort (0x00002745/10053) with
long Bytea (>4.5mb) in the query
Details:

Client application tries to execute query with Bytea quoted parameter.
When size of Bytea param is less than 4.5 mb query executes fine. But when
size of bytea param is more than 4.5mb (5mb e.g.) then raises exception:
---
Software caused connection abort (0x00002745/10053)
---
Server says: "could not receive data from client".
and doing "unexpected EOF on client connection".

Reading archives of postresql.org i find out, that it can be problem of
tcp_alive parameters in windows.

Please, tell me definitely is that normal limitation for bytea on windows
platform?

pgsql-bugs by date:

Previous
From: Joe Sunday
Date:
Subject: Re: Large join runs out of memory in 8.1
Next
From: "Alexander Kirpa"
Date:
Subject: BUG #2315: Crash engine after modify "active" function