You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Rafal Markut <ra...@mediawave.de> on 2006/05/30 17:05:05 UTC

SocketException, underlying cause: Software caused connection abort: recv failed

Hello,

I use Turbine 2.3.2 and Torque 3.1.1 and MySQL 4.0.18.

Very often on the first page I get following exception (I have also other 
applications on this same application server and database and there are no 
problems):

Horrible Exception: org.apache.torque.TorqueException: 
java.sql.SQLException: Communication link failure: java.net.SocketException, 
underlying cause: Software caused connection abort: recv failed

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: recv failed

STACKTRACE:

java.net.SocketException: Software caused connection abort: recv failed
 at java.net.SocketInputStream.socketRead0(Native Method)
 at java.net.SocketInputStream.read(SocketInputStream.java:129)
 at java.io.BufferedInputStream.fill(BufferedInputStream.java:183)
 at java.io.BufferedInputStream.read1(BufferedInputStream.java:222)
 at java.io.BufferedInputStream.read(BufferedInputStream.java:277)
 at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1391)
 at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1538)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1929)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
 at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2244)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2204)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2185)
 at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:546)
 at 
org.apache.commons.dbcp.cpdsadapter.ConnectionImpl.setAutoCommit(ConnectionImpl.java:325)
 at 
org.apache.commons.dbcp.datasources.SharedPoolDataSource.setupDefaults(SharedPoolDataSource.java:212)
 at 
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:654)
 at 
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:615)
 at org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:705)
 at org.apache.torque.Torque.getConnection(Torque.java:268)
 at org.apache.torque.util.Transaction.beginOptional(Transaction.java:80)
 at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1195)
 at 
de.mediawave.offersystem.db.BaseOfferPeer.doSelectVillageRecords(BaseOfferPeer.java:518)
 at 
de.mediawave.offersystem.db.BaseOfferPeer.doSelectVillageRecords(BaseOfferPeer.java:481)
 at 
de.mediawave.offersystem.db.BaseOfferPeer.doSelect(BaseOfferPeer.java:450)
 at de.mediawave.offersystem.db.OfferPeer.search(OfferPeer.java:103)
 at 
de.mediawave.offersystem.modules.screens.offer.Search.doBuildTemplate(Search.java:80)
 at 
org.apache.turbine.modules.screens.VelocitySecureScreen.doBuildTemplate(VelocitySecureScreen.java:64)
 at 
org.apache.turbine.modules.screens.TemplateScreen.doBuild(TemplateScreen.java:100)
 at org.apache.turbine.modules.Screen.build(Screen.java:57)
 at org.apache.turbine.modules.ScreenLoader.eval(ScreenLoader.java:107)
 at 
org.apache.turbine.modules.layouts.VelocityOnlyLayout.doBuild(VelocityOnlyLayout.java:92)
 at org.apache.turbine.modules.Layout.build(Layout.java:53)
 at org.apache.turbine.modules.LayoutLoader.exec(LayoutLoader.java:101)
 at 
org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:146)
 at org.apache.turbine.modules.Page.build(Page.java:53)
 at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:101)
 at org.apache.turbine.Turbine.doGet(Turbine.java:789)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
 at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
 at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
 at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at 
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
 at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
 at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
 at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
 at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
 at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
 at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
 at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
 at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
 at 
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
 at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
 at java.lang.Thread.run(Thread.java:534)


** END NESTED EXCEPTION **


 at org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:717)
 at org.apache.torque.Torque.getConnection(Torque.java:268)
 at org.apache.torque.util.Transaction.beginOptional(Transaction.java:80)
 at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1195)
 at 
de.mediawave.offersystem.db.BaseOfferPeer.doSelectVillageRecords(BaseOfferPeer.java:518)
 at 
de.mediawave.offersystem.db.BaseOfferPeer.doSelectVillageRecords(BaseOfferPeer.java:481)
 at 
de.mediawave.offersystem.db.BaseOfferPeer.doSelect(BaseOfferPeer.java:450)
 at de.mediawave.offersystem.db.OfferPeer.search(OfferPeer.java:103)
 at 
de.mediawave.offersystem.modules.screens.offer.Search.doBuildTemplate(Search.java:80)
 at 
org.apache.turbine.modules.screens.VelocitySecureScreen.doBuildTemplate(VelocitySecureScreen.java:64)
 at 
org.apache.turbine.modules.screens.TemplateScreen.doBuild(TemplateScreen.java:100)
 at org.apache.turbine.modules.Screen.build(Screen.java:57)
 at org.apache.turbine.modules.ScreenLoader.eval(ScreenLoader.java:107)
 at 
org.apache.turbine.modules.layouts.VelocityOnlyLayout.doBuild(VelocityOnlyLayout.java:92)
 at org.apache.turbine.modules.Layout.build(Layout.java:53)
 at org.apache.turbine.modules.LayoutLoader.exec(LayoutLoader.java:101)
 at 
org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:146)
 at org.apache.turbine.modules.Page.build(Page.java:53)
 at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:101)
 at org.apache.turbine.Turbine.doGet(Turbine.java:789)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
 at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
 at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
 at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at 
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
 at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
 at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
 at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
 at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
 at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
 at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
 at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
 at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
 at 
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
 at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
 at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: Communication link failure: 
java.net.SocketException, underlying cause: Software caused connection 
abort: recv failed

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: recv failed

STACKTRACE:

java.net.SocketException: Software caused connection abort: recv failed
 at java.net.SocketInputStream.socketRead0(Native Method)
 at java.net.SocketInputStream.read(SocketInputStream.java:129)
 at java.io.BufferedInputStream.fill(BufferedInputStream.java:183)
 at java.io.BufferedInputStream.read1(BufferedInputStream.java:222)
 at java.io.BufferedInputStream.read(BufferedInputStream.java:277)
 at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1391)
 at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1538)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1929)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
 at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2244)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2204)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2185)
 at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:546)
 at 
org.apache.commons.dbcp.cpdsadapter.ConnectionImpl.setAutoCommit(ConnectionImpl.java:325)
 at 
org.apache.commons.dbcp.datasources.SharedPoolDataSource.setupDefaults(SharedPoolDataSource.java:212)
 at 
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:654)
 at 
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:615)
 at org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:705)
 at org.apache.torque.Torque.getConnection(Torque.java:268)
 at org.apache.torque.util.Transaction.beginOptional(Transaction.java:80)
 at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1195)
 at 
de.mediawave.offersystem.db.BaseOfferPeer.doSelectVillageRecords(BaseOfferPeer.java:518)
 at 
de.mediawave.offersystem.db.BaseOfferPeer.doSelectVillageRecords(BaseOfferPeer.java:481)
 at 
de.mediawave.offersystem.db.BaseOfferPeer.doSelect(BaseOfferPeer.java:450)
 at de.mediawave.offersystem.db.OfferPeer.search(OfferPeer.java:103)
 at 
de.mediawave.offersystem.modules.screens.offer.Search.doBuildTemplate(Search.java:80)
 at 
org.apache.turbine.modules.screens.VelocitySecureScreen.doBuildTemplate(VelocitySecureScreen.java:64)
 at 
org.apache.turbine.modules.screens.TemplateScreen.doBuild(TemplateScreen.java:100)
 at org.apache.turbine.modules.Screen.build(Screen.java:57)
 at org.apache.turbine.modules.ScreenLoader.eval(ScreenLoader.java:107)
 at 
org.apache.turbine.modules.layouts.VelocityOnlyLayout.doBuild(VelocityOnlyLayout.java:92)
 at org.apache.turbine.modules.Layout.build(Layout.java:53)
 at org.apache.turbine.modules.LayoutLoader.exec(LayoutLoader.java:101)
 at 
org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:146)
 at org.apache.turbine.modules.Page.build(Page.java:53)
 at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:101)
 at org.apache.turbine.Turbine.doGet(Turbine.java:789)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
 at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
 at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
 at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at 
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
 at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
 at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
 at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
 at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
 at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
 at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
 at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
 at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
 at 
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
 at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
 at java.lang.Thread.run(Thread.java:534)


** END NESTED EXCEPTION **


 at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1713)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1929)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
 at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2244)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2204)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2185)
 at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:546)
 at 
org.apache.commons.dbcp.cpdsadapter.ConnectionImpl.setAutoCommit(ConnectionImpl.java:325)
 at 
org.apache.commons.dbcp.datasources.SharedPoolDataSource.setupDefaults(SharedPoolDataSource.java:212)
 at 
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:654)
 at 
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:615)
 at org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:705)
 ... 45 more

Dis somebody have such problem ?

with best regards,
Rafal 


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org