Re: MySQL java.net.SocketException: Broken pipe

[suda Murali]

Hello,

Have anyone got the solution. I am having the similar problem on my production server. But, I am unable to figure out the exact cause.

2009-11-23 22:52:54,432 [http-80-Processor18] ERROR org.hibernate.util.JDBCExceptionReporter - Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Broken pipe
STACKTRACE:
java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutpu tStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStrea m.java:136)
at java.io.BufferedOutputStream.flushBuffer(BufferedOu tputStream.java:65)
at java.io.BufferedOutputStream.flush(BufferedOutputSt ream.java:123)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2739)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2650)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:158 1)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java: 1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3 004)
at com.mysql.jdbc.PreparedStatement.executeInternal(Pr eparedStatement.java:1128)
at com.mysql.jdbc.PreparedStatement.executeQuery(Prepa redStatement.java:1222)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement. executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(Abs tractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.jav a:1778)
at org.hibernate.loader.Loader.doQuery(Loader.java:662 )
at org.hibernate.loader.Loader.doQueryAndInitializeNon LazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2211 )
at org.hibernate.loader.Loader.listUsingQueryCache(Loa der.java:2127)
at org.hibernate.loader.Loader.list(Loader.java:2087)
at org.hibernate.loader.criteria.CriteriaLoader.list(C riteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.jav a:1569)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.j ava:283)
at org.hibernate.impl.CriteriaImpl.uniqueResult(Criter iaImpl.java:305)
at com.sre.db.hibernate.impl.CampaignDAOImpl.getCampai gn(CampaignDAOImpl.java:472)
at com.sre.biz.impl.CampaignServiceImpl.getCampaign(Ca mpaignServiceImpl.java:89)
at com.sre.servlet.CampaignServlet.doPost(CampaignServ let.java:60)
at com.sre.servlet.CampaignServlet.doGet(CampaignServl et.java:33)
at javax.servlet.http.HttpServlet.service(HttpServlet. java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet. java:803)
at org.apache.catalina.core.ApplicationFilterChain.int ernalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doF ilter(ApplicationFilterChain.java:188)
at com.sre.filter.HibernateSessionCloseFilter.doFilter (HibernateSessionCloseFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.int ernalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doF ilter(ApplicationFilterChain.java:188)
at com.sre.filter.CampaignFilter.doFilter(CampaignFilt er.java:186)
at org.apache.catalina.core.ApplicationFilterChain.int ernalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doF ilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invok e(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invok e(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase .invoke(AuthenticatorBase.java:525)
at org.apache.catalina.core.StandardHostValve.invoke(S tandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke( ErrorReportValve.java:117)
at org.apache.catalina.valves.FastCommonAccessLogValve .invoke(FastCommonAccessLogValve.java:482)
at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Ht tp11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11C onnectionHandler.processConnection(Http11BaseProto col.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processS ocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThre ad.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRu nnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
************************************************** *********************************


Any help will be appreciated.


Thanks a lot.