Skip site navigation (1) Skip section navigation (2)

RE: Interrupted system call and JDBC

From: Peter Mount <petermount(at)maidstone(dot)gov(dot)uk>
To: "'Tsuchiya, Mitsy'" <Mitsy(dot)Tsuchiya(at)echostar(dot)com>, "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: RE: Interrupted system call and JDBC
Date: 2000-10-18 08:29:32
Message-ID: 1B3D5E532D18D311861A00600865478CF1B445@exchange1.nt.maidstone.gov.uk (view raw or flat)
Thread:
Lists: pgsql-interfaces
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!

pgsql-interfaces by date

Next:From: Scott HolmesDate: 2000-10-18 16:54:25
Subject: Transactions and Errors with ODBC
Previous:From: Joseph ShraibmanDate: 2000-10-18 01:14:02
Subject: Re: 2 computers 1hd 2 postgres daemons. Is it possible?]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group