Re: Connection lost

[Hernan Danielan <hernandanielan@xxxxxxxxx>]

Yes, the most interesting thing is that the log says 

unexpected EOF on client connection or  could not send data to client: Broken pipe

But this shouldn't be happening according to the code i sent because i do NOT close the socket. Moreover the transaction only takes up a few seconds. 

I read a person who had this problem and he fixed changing th cache size but I wasn't successful.

Any ideas?

On Tue, May 18, 2010 at 11:34 PM, Joshua Tolley <eggyknap@xxxxxxxxx> wrote:

On Tue, May 18, 2010 at 1:18 PM, Hernan Danielan
<hernandanielan@xxxxxxxxx> wrote:
> Hello! I am using postgress 8.4. I am trying to save to my DB a Large Binary
> Object, in localhost, let's say 1.4MB. I read that LargeObjectAPI should be
> used.
> I have a problem that sometimes i can store the file and some others i get
> an exception of
>>>org.postgresql.util.PSQLException: An I/O error occured while sending to
>>> the backend.
>>>java.net.SocketException: Socket closed

Do the PostgreSQL logs include any useful information?

--
Joshua Tolley  /  eggyknap
End Point Corporation