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

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

From
Kal Chung
Date:
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