Hi Rafal,
I can only state the obvious
+) your connection breaks somehow
Some things to consider
+) do you have other Java apps running with the same JDBC
driver and
mySQL? I recently had a similar problem with a mySQL JDBC
driver using a
Java-based database frontend.
+) do you have configured the connection pool to check the
validity of
the conenction
Cheers,
Siegfried Goeschl
Rafal Markut wrote:
> 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:18
3)
> at
java.io.BufferedInputStream.read1(BufferedInputStream.java:2
22)
> at
java.io.BufferedInputStream.read(BufferedInputStream.java:27
7)
> 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.setAutoCo
mmit(ConnectionImpl.java:325)
>
> at
>
org.apache.commons.dbcp.datasources.SharedPoolDataSource.set
upDefaults(SharedPoolDataSource.java:212)
>
> at
>
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.ge
tConnection(InstanceKeyDataSource.java:654)
>
> at
>
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.ge
tConnection(InstanceKeyDataSource.java:615)
>
> at
org.apache.torque.TorqueInstance.getConnection(TorqueInstanc
e.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.doSelectVillageRec
ords(BaseOfferPeer.java:518)
>
> at
>
de.mediawave.offersystem.db.BaseOfferPeer.doSelectVillageRec
ords(BaseOfferPeer.java:481)
>
> at
>
de.mediawave.offersystem.db.BaseOfferPeer.doSelect(BaseOffer
Peer.java:450)
> at
de.mediawave.offersystem.db.OfferPeer.search(OfferPeer.java:
103)
> at
>
de.mediawave.offersystem.modules.screens.offer.Search.doBuil
dTemplate(Search.java:80)
>
> at
>
org.apache.turbine.modules.screens.VelocitySecureScreen.doBu
ildTemplate(VelocitySecureScreen.java:64)
>
> at
>
org.apache.turbine.modules.screens.TemplateScreen.doBuild(Te
mplateScreen.java:100)
>
> at
org.apache.turbine.modules.Screen.build(Screen.java:57)
> at
org.apache.turbine.modules.ScreenLoader.eval(ScreenLoader.ja
va:107)
> at
>
org.apache.turbine.modules.layouts.VelocityOnlyLayout.doBuil
d(VelocityOnlyLayout.java:92)
>
> at
org.apache.turbine.modules.Layout.build(Layout.java:53)
> at
org.apache.turbine.modules.LayoutLoader.exec(LayoutLoader.ja
va:101)
> at
>
org.apache.turbine.modules.pages.DefaultPage.doBuild(Default
Page.java:146)
> at org.apache.turbine.modules.Page.build(Page.java:53)
> at
org.apache.turbine.modules.PageLoader.exec(PageLoader.java:1
01)
> 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.internalDoFi
lter(ApplicationFilterChain.java:237)
>
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(App
licationFilterChain.java:157)
>
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(Standar
dWrapperValve.java:214)
>
> at
>
org.apache.catalina.core.StandardValveContext.invokeNext(Sta
ndardValveContext.java:104)
>
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPip
eline.java:520)
> at
>
org.apache.catalina.core.StandardContextValve.invokeInternal
(StandardContextValve.java:198)
>
> at
>
org.apache.catalina.core.StandardContextValve.invoke(Standar
dContextValve.java:152)
>
> at
>
org.apache.catalina.core.StandardValveContext.invokeNext(Sta
ndardValveContext.java:104)
>
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPip
eline.java:520)
> at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHo
stValve.java:137)
>
> at
>
org.apache.catalina.core.StandardValveContext.invokeNext(Sta
ndardValveContext.java:104)
>
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo
rtValve.java:118)
>
> at
>
org.apache.catalina.core.StandardValveContext.invokeNext(Sta
ndardValveContext.java:102)
>
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPip
eline.java:520)
> at
>
org.apache.catalina.core.StandardEngineValve.invoke(Standard
EngineValve.java:109)
>
> at
>
org.apache.catalina.core.StandardValveContext.invokeNext(Sta
ndardValveContext.java:104)
>
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPip
eline.java:520)
> at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.
java:929)
> at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapte
r.java:160)
> at
>
org.apache.coyote.http11.Http11Processor.process(Http11Proce
ssor.java:799)
> at
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand
ler.processConnection(Http11Protocol.java:705)
>
> at
>
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp
oint.java:577)
> at
>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru
n(ThreadPool.java:683)
>
> at java.lang.Thread.run(Thread.java:534)
>
>
> ** END NESTED EXCEPTION **
>
>
> at
org.apache.torque.TorqueInstance.getConnection(TorqueInstanc
e.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.doSelectVillageRec
ords(BaseOfferPeer.java:518)
>
> at
>
de.mediawave.offersystem.db.BaseOfferPeer.doSelectVillageRec
ords(BaseOfferPeer.java:481)
>
> at
>
de.mediawave.offersystem.db.BaseOfferPeer.doSelect(BaseOffer
Peer.java:450)
> at
de.mediawave.offersystem.db.OfferPeer.search(OfferPeer.java:
103)
> at
>
de.mediawave.offersystem.modules.screens.offer.Search.doBuil
dTemplate(Search.java:80)
>
> at
>
org.apache.turbine.modules.screens.VelocitySecureScreen.doBu
ildTemplate(VelocitySecureScreen.java:64)
>
> at
>
org.apache.turbine.modules.screens.TemplateScreen.doBuild(Te
mplateScreen.java:100)
>
> at
org.apache.turbine.modules.Screen.build(Screen.java:57)
> at
org.apache.turbine.modules.ScreenLoader.eval(ScreenLoader.ja
va:107)
> at
>
org.apache.turbine.modules.layouts.VelocityOnlyLayout.doBuil
d(VelocityOnlyLayout.java:92)
>
> at
org.apache.turbine.modules.Layout.build(Layout.java:53)
> at
org.apache.turbine.modules.LayoutLoader.exec(LayoutLoader.ja
va:101)
> at
>
org.apache.turbine.modules.pages.DefaultPage.doBuild(Default
Page.java:146)
> at org.apache.turbine.modules.Page.build(Page.java:53)
> at
org.apache.turbine.modules.PageLoader.exec(PageLoader.java:1
01)
> 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.internalDoFi
lter(ApplicationFilterChain.java:237)
>
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(App
licationFilterChain.java:157)
>
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(Standar
dWrapperValve.java:214)
>
> at
>
org.apache.catalina.core.StandardValveContext.invokeNext(Sta
ndardValveContext.java:104)
>
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPip
eline.java:520)
> at
>
org.apache.catalina.core.StandardContextValve.invokeInternal
(StandardContextValve.java:198)
>
> at
>
org.apache.catalina.core.StandardContextValve.invoke(Standar
dContextValve.java:152)
>
> at
>
org.apache.catalina.core.StandardValveContext.invokeNext(Sta
ndardValveContext.java:104)
>
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPip
eline.java:520)
> at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHo
stValve.java:137)
>
> at
>
org.apache.catalina.core.StandardValveContext.invokeNext(Sta
ndardValveContext.java:104)
>
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo
rtValve.java:118)
>
> at
>
org.apache.catalina.core.StandardValveContext.invokeNext(Sta
ndardValveContext.java:102)
>
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPip
eline.java:520)
> at
>
org.apache.catalina.core.StandardEngineValve.invoke(Standard
EngineValve.java:109)
>
> at
>
org.apache.catalina.core.StandardValveContext.invokeNext(Sta
ndardValveContext.java:104)
>
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPip
eline.java:520)
> at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.
java:929)
> at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapte
r.java:160)
> at
>
org.apache.coyote.http11.Http11Processor.process(Http11Proce
ssor.java:799)
> at
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand
ler.processConnection(Http11Protocol.java:705)
>
> at
>
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp
oint.java:577)
> at
>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru
n(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:18
3)
> at
java.io.BufferedInputStream.read1(BufferedInputStream.java:2
22)
> at
java.io.BufferedInputStream.read(BufferedInputStream.java:27
7)
> 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.setAutoCo
mmit(ConnectionImpl.java:325)
>
> at
>
org.apache.commons.dbcp.datasources.SharedPoolDataSource.set
upDefaults(SharedPoolDataSource.java:212)
>
> at
>
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.ge
tConnection(InstanceKeyDataSource.java:654)
>
> at
>
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.ge
tConnection(InstanceKeyDataSource.java:615)
>
> at
org.apache.torque.TorqueInstance.getConnection(TorqueInstanc
e.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.doSelectVillageRec
ords(BaseOfferPeer.java:518)
>
> at
>
de.mediawave.offersystem.db.BaseOfferPeer.doSelectVillageRec
ords(BaseOfferPeer.java:481)
>
> at
>
de.mediawave.offersystem.db.BaseOfferPeer.doSelect(BaseOffer
Peer.java:450)
> at
de.mediawave.offersystem.db.OfferPeer.search(OfferPeer.java:
103)
> at
>
de.mediawave.offersystem.modules.screens.offer.Search.doBuil
dTemplate(Search.java:80)
>
> at
>
org.apache.turbine.modules.screens.VelocitySecureScreen.doBu
ildTemplate(VelocitySecureScreen.java:64)
>
> at
>
org.apache.turbine.modules.screens.TemplateScreen.doBuild(Te
mplateScreen.java:100)
>
> at
org.apache.turbine.modules.Screen.build(Screen.java:57)
> at
org.apache.turbine.modules.ScreenLoader.eval(ScreenLoader.ja
va:107)
> at
>
org.apache.turbine.modules.layouts.VelocityOnlyLayout.doBuil
d(VelocityOnlyLayout.java:92)
>
> at
org.apache.turbine.modules.Layout.build(Layout.java:53)
> at
org.apache.turbine.modules.LayoutLoader.exec(LayoutLoader.ja
va:101)
> at
>
org.apache.turbine.modules.pages.DefaultPage.doBuild(Default
Page.java:146)
> at org.apache.turbine.modules.Page.build(Page.java:53)
> at
org.apache.turbine.modules.PageLoader.exec(PageLoader.java:1
01)
> 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.internalDoFi
lter(ApplicationFilterChain.java:237)
>
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(App
licationFilterChain.java:157)
>
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(Standar
dWrapperValve.java:214)
>
> at
>
org.apache.catalina.core.StandardValveContext.invokeNext(Sta
ndardValveContext.java:104)
>
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPip
eline.java:520)
> at
>
org.apache.catalina.core.StandardContextValve.invokeInternal
(StandardContextValve.java:198)
>
> at
>
org.apache.catalina.core.StandardContextValve.invoke(Standar
dContextValve.java:152)
>
> at
>
org.apache.catalina.core.StandardValveContext.invokeNext(Sta
ndardValveContext.java:104)
>
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPip
eline.java:520)
> at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHo
stValve.java:137)
>
> at
>
org.apache.catalina.core.StandardValveContext.invokeNext(Sta
ndardValveContext.java:104)
>
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo
rtValve.java:118)
>
> at
>
org.apache.catalina.core.StandardValveContext.invokeNext(Sta
ndardValveContext.java:102)
>
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPip
eline.java:520)
> at
>
org.apache.catalina.core.StandardEngineValve.invoke(Standard
EngineValve.java:109)
>
> at
>
org.apache.catalina.core.StandardValveContext.invokeNext(Sta
ndardValveContext.java:104)
>
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPip
eline.java:520)
> at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.
java:929)
> at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapte
r.java:160)
> at
>
org.apache.coyote.http11.Http11Processor.process(Http11Proce
ssor.java:799)
> at
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand
ler.processConnection(Http11Protocol.java:705)
>
> at
>
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp
oint.java:577)
> at
>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru
n(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.setAutoCo
mmit(ConnectionImpl.java:325)
>
> at
>
org.apache.commons.dbcp.datasources.SharedPoolDataSource.set
upDefaults(SharedPoolDataSource.java:212)
>
> at
>
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.ge
tConnection(InstanceKeyDataSource.java:654)
>
> at
>
org.apache.commons.dbcp.datasources.InstanceKeyDataSource.ge
tConnection(InstanceKeyDataSource.java:615)
>
> at
org.apache.torque.TorqueInstance.getConnection(TorqueInstanc
e.java:705)
> ... 45 more
>
> Dis somebody have such problem ?
>
> with best regards,
> Rafal
>
>
------------------------------------------------------------
---------
> To unsubscribe, e-mail: turbine-user-unsubscribe jakarta.apache.org
> For additional commands, e-mail: turbine-user-helpjakarta.apache.org
>
>
>
------------------------------------------------------------
---------
To unsubscribe, e-mail: turbine-user-unsubscribejakarta.apache.org
For additional commands, e-mail: turbine-user-helpjakarta.apache.org
|