Q> Regarding incomplete startup packet & I/O back-end error

I've run into a problem which I'm having a hard time fixing... quite
recently I've switched from a jsp reporting scheme to one using
datavision. I've field tested it for a few weeks and it was ok.
However, quite recently when writing a very complex script it started
creating errors on the client side which came up something like:

Could not create Connection: Cannot create PoolableConnectionFactory (
An I/O error occured while reading from backend - Exception:
java.net.SocketException:
Connection reset Stack Trace: java.net.SocketException:
Connection reset at java.net.SocketInputStream.read(Unknown
Source) at
java.io.BufferedInputStream.fill(Unknown Source) at
java.io.BufferedInputStream.read(Unknown Source) at
org.postgresql.core.PGStream.ReceiveChar(PGStream.java:166) at

org.postgresql.jdbc1.AbstractJdbc1Connection.openConnectionV3(AbstractJdbc1Connection.java:291)
at

org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:213)
at
org.postgresql.Driver.connect(Driver.java:139) at
.....

At first, I thought maybe it was my script... so I tried running the
script from PgAdmin (at this point I haven't done anything with the
connection) and the script ran fine... so I tried restarting
postmaster.. which didn't work. After which I tried restarting the
server, this seemed to have remedied the problem. This was a couple of
days ago... now I get this message almost every time and restarting
doesn't seem to help, PgAdmin likewise cannot access the database as
well. I've been looking around and initially thought it may be just a
jdbc problem... however when I took a look at the postmaster logs I got...

2005-04-29 20:18:56 LOG: database system was shut down at
2005-04-29 20:18:34 China Standard Time
2005-04-29 20:18:56 LOG: checkpoint record is at 0/201A178
2005-04-29 20:18:56 LOG: redo record is at 0/201A178; undo
record is at 0/0; shutdown TRUE
2005-04-29 20:18:56 LOG: next transaction ID: 6344; next
OID: 18598
2005-04-29 20:18:56 LOG: database system is ready
2005-04-29 20:23:47 LOG: could not receive data from
client: An operation was attempted on something that is not a socket.
2005-04-29 20:23:47 LOG: incomplete startup packet
2005-04-29 20:23:48 LOG: could not receive data from
client: An operation was attempted on something that is not a socket.
2005-04-29 20:23:48 LOG: incomplete startup packet

I am unsure if my complex scripts had anything to do with this, however,
I don't believe this that was the root of the problem. Has anyone
encountered similar scenarios?

--

Regards,

Kal Chung
//