Hello,
While doing performance tests on Windows Server 2003 we observed to following
two problems.
Environment: J2EE application running in JBoss application server, against
pgsql 8.1 database. Load is caused by a smallish number of (very) complex
transactions, typically about 5-10 concurrently.
The first one, which bothers me the most, is that after about 6-8 hours the
application stops processing. No errors are reported, neither by the JDBC
driver nor by the server, but when I kill the application server, I see that
all my connections hang in a SQL statements (which never seem to return):
2006-03-03 08:17:12 4504 6632560 LOG: duration: 45087000.000 ms statement:
EXECUTE <unnamed> [PREPARE: SELECT objID FROM objects WHERE objID = $1 FOR
UPDATE]
I think I can reliably reproduce this by loading the app, and waiting a couple
of hours.
The second problem is less predictable:
JDBC exception:
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
--
--------------------------------------------------------------
Jan de Visser [EMAIL PROTECTED]
Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
