Re: Exception: An I/O error occured while sending to the

From: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
To: Jan de Visser <jdevisser(at)digitalfairway(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Exception: An I/O error occured while sending to the
Date: 2006-03-02 19:48:45
Message-ID: 1141328925.17684.99.camel@archimedes
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

You might have more luck raising this issue on pgsql-hackers instead of
pgsql-jdbc, because there's really nothing JDBC-specific about the
server rejecting incoming connections under load.

-- Mark Lewis

On Thu, 2006-03-02 at 14:34 -0500, Jan de Visser wrote:
> Hello,
>
> While doing performance tests on Windows Server 2003 I get the following:
>
> An I/O error occured while sending to the backend.
> org.postgresql.util.PSQLException: An I/O error occured while sending to the
> backend.
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:214)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250)
>
>
> In my server log, I have:
>
> 2006-03-02 12:31:02 5692 6436342 LOG: could not receive data from client: A
> non-blocking socket operation could not be completed immediately.
>
> At the time my box is fairly heavy loaded, but still responsive. Server and
> JBoss appserver live on the same dual 2Ghz Opteron.
>
> A quick Google told me that:
>
> 1. More people have seen this.
> 2. No solutions.
> 3. The server message appears to indicate an unhandled WSAEWOULDBLOCK winsock
> error on recv(), which MSDN said is to be expected and should be retried.
>
> Is this a known bug?
>
> jan
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message William Penberthy 2006-03-02 19:52:47 Re: Need a GNU SQL CLI tool for Win32 with ODBC support.
Previous Message Jan de Visser 2006-03-02 19:34:00 Exception: An I/O error occured while sending to the backend

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jan de Visser 2006-03-02 19:56:24 Re: Exception: An I/O error occured while sending to the backend
Previous Message Jan de Visser 2006-03-02 19:34:00 Exception: An I/O error occured while sending to the backend