You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Rafal Markut <ra...@mediawave.de> on 2006/07/11 15:20:52 UTC
Problem with DB connection
Hello,
I use Turbine 2.3.2 and Torque 3.1.1, Tomcat and MySQL 4.1.7.
Very often I got the exception:
Caused by: org.apache.torque.TorqueException: java.sql.SQLException: Lost
connection to server during query
or
java.net.SocketException: Software caused connection abort: recv failed.
When I make first DB operation (in this case takes user-data from the DB
during loggin) then it comes one of these exceptions.
It happens always in the morning - when application was not used ca. 12-15h.
When the application is used then everything works perfectly. But ... when
it isn't used some time (like 5-10h) and then somebody make first DB
operation ... then this exception appears.
When after that I restart the tomcat then everything works fine.
MySQL must be OK because other software is using it and there are no
problems.
I made 2 different applications, both of them are on differend servers and
both have this same problem.
I don't think that it's a bug in the turbine or torque because I couldn't
find any info about it.
Maybe my configuration is wrong ?
What is strange ... when I put jar with MySQL driver into /WEB-INF/lib then
I got exception that it cannot find a driver. I had to place it under:
tomcat/common/endorsed.
I tried with following MySQL drivers: mm.mysql-2.0.4.jar and
mysql-connector-java-3.1.13.zip.
I'd very greateful for any help. I really don't know what can I do with it.
Below there are that exception and parts of my configuration files.
Caused by: org.apache.torque.TorqueException: java.sql.SQLException: Lost
connection to server during query
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
org.apache.turbine.om.security.peer.TurbineUserPeer.doSelect(TurbineUserPeer.java:383)
at
org.apache.turbine.om.security.peer.TurbineUserPeer.doSelect(TurbineUserPeer.java:347)
at
org.apache.turbine.services.security.db.DBUserManager.accountExists(DBUserManager.java:104)
... 42 more
Caused by: java.sql.SQLException: Lost connection to server during query
at org.gjt.mm.mysql.Connection.execSQL(Connection.java:889)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
at org.gjt.mm.mysql.Connection.setAutoCommit(Connection.java:463)
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)
... 48 more
or
Caused by: org.apache.torque.TorqueException:
com.mysql.jdbc.CommunicationsException: Communications link failure due to
underlying exception:
** 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
com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
at
com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
at
com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1931)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2380)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4959)
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
org.apache.turbine.om.security.peer.TurbineUserPeer.doSelect(TurbineUserPeer.java:383)
at
org.apache.turbine.om.security.peer.TurbineUserPeer.doSelect(TurbineUserPeer.java:347)
at
org.apache.turbine.services.security.db.DBUserManager.accountExists(DBUserManager.java:104)
at
org.apache.turbine.services.security.BaseSecurityService.accountExists(BaseSecurityService.java:672)
at
org.apache.turbine.services.security.TurbineSecurity.accountExists(TurbineSecurity.java:244)
at
de.mediawave.citrix.dashboard.modules.actions.LoginUserAction.doLogin(LoginUserAction.java:40)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.apache.turbine.util.velocity.VelocityActionEvent.executeEvents(VelocityActionEvent.java:135)
at
org.apache.turbine.util.velocity.VelocityActionEvent.perform(VelocityActionEvent.java:78)
at
org.apache.turbine.modules.actions.VelocityAction.perform(VelocityAction.java:72)
at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:99)
at
org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:113)
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 org.apache.turbine.Turbine.doPost(Turbine.java:884)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
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 **
Last packet sent to the server was 16 ms ago.
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
org.apache.turbine.om.security.peer.TurbineUserPeer.doSelect(TurbineUserPeer.java:383)
at
org.apache.turbine.om.security.peer.TurbineUserPeer.doSelect(TurbineUserPeer.java:347)
at
org.apache.turbine.services.security.db.DBUserManager.accountExists(DBUserManager.java:104)
... 42 more
Torque.properties:
torque.database.default = myapp
torque.database.myapp.adapter = mysql
# Using commons-dbcp
torque.dsfactory.myapp.factory =
org.apache.torque.dsfactory.SharedPoolDataSourceFactory
torque.dsfactory.myapp.connection.driver = org.gjt.mm.mysql.Driver
torque.dsfactory.myapp.connection.url =
jdbc:mysql://localhost/dashboard?useUnicode\=true&characterEncoding\=UTF-8
torque.dsfactory.myapp.connection.user = myappuser
torque.dsfactory.myapp.connection.password = myapppassword
Part of TurbineResources.properties:
services.ComponentService.name = torque
services.ComponentService.torque.classname = org.apache.torque.Torque
services.ComponentService.torque.config = /WEB-INF/conf/Torque.properties
with best regards,
Rafal
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Problem with DB connection
Posted by Siegfried Goeschl <si...@it20one.at>.
Hi Rafal,
+) a mySQL connection times out during a long period of inactivity
whereas the default value of 'wait_timeout' is 8 hours (pelase refer to
the mySQL manual and check your local settings)
+) have you enabled a connection is alive check when getting it from the
pool this should solve your problem ... :-)
Cheers,
Siegfried Goeschl
Rafal Markut wrote:
> Hello,
>
> I use Turbine 2.3.2 and Torque 3.1.1, Tomcat and MySQL 4.1.7.
>
> Very often I got the exception:
> Caused by: org.apache.torque.TorqueException: java.sql.SQLException: Lost
> connection to server during query
> or
> java.net.SocketException: Software caused connection abort: recv failed.
>
> When I make first DB operation (in this case takes user-data from the DB
> during loggin) then it comes one of these exceptions.
> It happens always in the morning - when application was not used ca.
> 12-15h.
> When the application is used then everything works perfectly. But ... when
> it isn't used some time (like 5-10h) and then somebody make first DB
> operation ... then this exception appears.
> When after that I restart the tomcat then everything works fine.
>
> MySQL must be OK because other software is using it and there are no
> problems.
>
> I made 2 different applications, both of them are on differend servers and
> both have this same problem.
> I don't think that it's a bug in the turbine or torque because I couldn't
> find any info about it.
> Maybe my configuration is wrong ?
>
> What is strange ... when I put jar with MySQL driver into /WEB-INF/lib then
> I got exception that it cannot find a driver. I had to place it under:
> tomcat/common/endorsed.
>
> I tried with following MySQL drivers: mm.mysql-2.0.4.jar and
> mysql-connector-java-3.1.13.zip.
>
> I'd very greateful for any help. I really don't know what can I do with it.
>
> Below there are that exception and parts of my configuration files.
>
> Caused by: org.apache.torque.TorqueException: java.sql.SQLException: Lost
> connection to server during query
> 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
> org.apache.turbine.om.security.peer.TurbineUserPeer.doSelect(TurbineUserPeer.java:383)
>
> at
> org.apache.turbine.om.security.peer.TurbineUserPeer.doSelect(TurbineUserPeer.java:347)
>
> at
> org.apache.turbine.services.security.db.DBUserManager.accountExists(DBUserManager.java:104)
>
> ... 42 more
> Caused by: java.sql.SQLException: Lost connection to server during query
> at org.gjt.mm.mysql.Connection.execSQL(Connection.java:889)
> at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
> at org.gjt.mm.mysql.Connection.setAutoCommit(Connection.java:463)
> 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)
> ... 48 more
>
>
>
> or
>
>
>
> Caused by: org.apache.torque.TorqueException:
> com.mysql.jdbc.CommunicationsException: Communications link failure due to
> underlying exception:
>
> ** 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
> com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
>
> at
> com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
>
> at
> com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
>
> at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1931)
> at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2380)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
> at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4959)
> 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
> org.apache.turbine.om.security.peer.TurbineUserPeer.doSelect(TurbineUserPeer.java:383)
>
> at
> org.apache.turbine.om.security.peer.TurbineUserPeer.doSelect(TurbineUserPeer.java:347)
>
> at
> org.apache.turbine.services.security.db.DBUserManager.accountExists(DBUserManager.java:104)
>
> at
> org.apache.turbine.services.security.BaseSecurityService.accountExists(BaseSecurityService.java:672)
>
> at
> org.apache.turbine.services.security.TurbineSecurity.accountExists(TurbineSecurity.java:244)
>
> at
> de.mediawave.citrix.dashboard.modules.actions.LoginUserAction.doLogin(LoginUserAction.java:40)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> at java.lang.reflect.Method.invoke(Method.java:324)
> at
> org.apache.turbine.util.velocity.VelocityActionEvent.executeEvents(VelocityActionEvent.java:135)
>
> at
> org.apache.turbine.util.velocity.VelocityActionEvent.perform(VelocityActionEvent.java:78)
>
> at
> org.apache.turbine.modules.actions.VelocityAction.perform(VelocityAction.java:72)
>
> at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:99)
> at
> org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:113)
> 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 org.apache.turbine.Turbine.doPost(Turbine.java:884)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> 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 **
>
>
>
> Last packet sent to the server was 16 ms ago.
> 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
> org.apache.turbine.om.security.peer.TurbineUserPeer.doSelect(TurbineUserPeer.java:383)
>
> at
> org.apache.turbine.om.security.peer.TurbineUserPeer.doSelect(TurbineUserPeer.java:347)
>
> at
> org.apache.turbine.services.security.db.DBUserManager.accountExists(DBUserManager.java:104)
>
> ... 42 more
>
>
> Torque.properties:
>
> torque.database.default = myapp
> torque.database.myapp.adapter = mysql
>
> # Using commons-dbcp
> torque.dsfactory.myapp.factory =
> org.apache.torque.dsfactory.SharedPoolDataSourceFactory
> torque.dsfactory.myapp.connection.driver = org.gjt.mm.mysql.Driver
> torque.dsfactory.myapp.connection.url =
> jdbc:mysql://localhost/dashboard?useUnicode\=true&characterEncoding\=UTF-8
> torque.dsfactory.myapp.connection.user = myappuser
> torque.dsfactory.myapp.connection.password = myapppassword
>
>
>
>
> Part of TurbineResources.properties:
>
> services.ComponentService.name = torque
> services.ComponentService.torque.classname = org.apache.torque.Torque
> services.ComponentService.torque.config = /WEB-INF/conf/Torque.properties
>
> with best regards,
> Rafal
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org