"Connection Reset by Peer "error (1012 Views)
Reply
Frequent Advisor
Posts: 39
Registered: ‎01-03-2005
Message 1 of 2 (1,012 Views)
Accepted Solution

"Connection Reset by Peer "error

Hello,

I have a very long data exchange process I need to run (approx 14 hours), and am getting the following errors all through the import log file:

JDBC error 0: Connection reset by peer: socket write error, SQL state: 08S01 for query: SELECT COUNT(*) AS C0
FROM ( itsm_persons T1
LEFT OUTER JOIN rep_accounts T2 ON (T2.acc_oid = T1.per_acc_oid))
WHERE T2.acc_loginname LIKE ?
Values:
E0104246com.inet.tds.SQLException: Connection reset by peer: socket write error

while processing attribute ACCOUNT


The SQL seems to be different for each of the errors though.

Does anyone know why this moght be occurring? The data exchange seems to have worked mostly, though some data items are missing for the ID's where this error was received.

Thanks,
Adrian Collins
Honored Contributor
Posts: 423
Registered: ‎11-28-2004
Message 2 of 2 (1,012 Views)

Re: "Connection Reset by Peer "error

Hi,

There are a few things cause that error.

- Your network quality between app server and database.
- Bug in jdbc driver?
- Database timeout settings (no timeout is default as far as i know)

My suggestion is to open a command prompt on application server and type "ping -t dbserver" and then start data exchange process. Next day, when data exchange task finishes, break ping process and check if there is any packet loss. If there is not, your network is probably ok, or one of the components involved may require a "keep alive" function.

Also try to set your server's network card's transmit and receive buffers to 1024, which are 128 or 256 by default.

If you are using windows, optimizing tcp/ip settings may give you an exit.

http://rdweb.cns.vt.edu/public/notes/win2k-tcpip.htm

If all above do not solve your problem, try to increase database and application server connection pool count. If all connections in database pool will be occupied after a while, when app. server tries to open more connections, you can have socket write errors.
What's right is right, whether or not God exists
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.