RE: Interrupted system call and JDBC

InterruptedIOException is being thrown below JDBC, and most likely at the
Linux kernel. Is your machine low on resources at the time this is thrown,
or are you noticing that the postgresql backend is dying unexpectedly?

ie: Can you reproduce the same query in psql (via tcp not unix sockets), and
it also dies?

Peter

--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount(at)maidstone(dot)gov(dot)uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough
Council

-----Original Message-----
From: Tsuchiya, Mitsy [mailto:Mitsy(dot)Tsuchiya(at)echostar(dot)com]
Sent: Tuesday, October 17, 2000 4:24 PM
To: 'pgsql-interfaces(at)postgresql(dot)org'
Subject: [INTERFACES] Interrupted system call and JDBC

I've been using Postgres 6.5.2 on RH6.1, with JDBC driver 6.5.2. Often (not
all the time) I get the following messages while executing my program and
I've been trying to figure out what the problem is and how to fix it.

An I/O error occured while reading from backend -
java.io.InterruptedIOException: Interrupted system call
at postgresql.PG_Stream.ReceiveChar(Compiled Code)
at postgresql.Connection.ExecSQL(Compiled Code)
at postgresql.jdbc2.Connection.commit(Compiled Code)
at DB.deleteService(Compiled Code)
at Impl.deleteService(Compiled Code)
at java.lang.reflect.Method.invoke(Native Method)
at sun.rmi.server.UnicastServerRef.dispatch(Compiled Code)
at sun.rmi.transport.Transport$1.run(Compiled Code)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Compiled Code)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(Compiled Code)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Compiled Code)
at java.lang.Thread.run(Compiled Code)

I've updated my Postgres server and JDBC to 7.0.2, but seems like the
problem still exists. Is this some bug or I'm missing something I need to do
in my program? Any suggestion will be very appreciated.

Thank you!