This is very common problem. It occur in random time. It is also occuring with Database and Pure socket connection. Can we handle the situation. I have attached following thread dump impression. How to avoid it. Please reply as soon as possible if you know anything. Your help is appreciated.
The connection is made between mysql and java. and Connection Pooling concept is used. select query is fired with following dump.
"Thread-6" (TID:0xb4973f58, sys_thread_t:0x8bab7f8, state:CW) prio=5 at java.net.SocketInputStream.socketRead(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:86) at java.net.SocketInputStream.read(SocketInputStream.java:102) at org.gjt.mm.mysql.MysqlIO.readPacket(MysqlIO.java:881) at org.gjt.mm.mysql.MysqlIO.clearAllReceive(MysqlIO.java:998) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:549) at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:636) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:924) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:857) at org.gjt.mm.mysql.Connection.setAutoCommit(Connection.java:474)
Narendra Shah -- SCJP 5
subject: SocketnputStream hangs the running thread