Re: Connection lost - Mailing list pgsql-general

From Hernan Danielan
Subject Re: Connection lost
Date
Msg-id AANLkTiliEUEhYmRwQh8j8MNl5XF1xlFot2lnfo82DKhx@mail.gmail.com
Whole thread Raw
In response to Re: Connection lost  (Joshua Tolley <eggyknap@gmail.com>)
Responses Re: Connection lost  (Joshua Tolley <eggyknap@gmail.com>)
List pgsql-general
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@gmail.com> wrote:
On Tue, May 18, 2010 at 1:18 PM, Hernan Danielan
<hernandanielan@gmail.com> 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

pgsql-general by date:

Previous
From: "Little, Douglas"
Date:
Subject: object tracking
Next
From: "Joshua D. Drake"
Date:
Subject: Re: object tracking