求大神指导tomcat服务器挂掉问题

江戸川乱歩 发布于 2016/10/10 15:36
阅读 585
收藏 0

最近新上线一个功能。但是Tomcat每隔几日就不明不白地挂掉。看了日志也找不出原因:

DEBUG - Returning JDBC Connection to DataSource
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@2342d884 [managed: 15, unused: 13, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@52a9fd96)
DEBUG - Creating a new SqlSession
DEBUG - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6ffb4c60] was not registered for synchronization because synchronization is not active
DEBUG - Fetching JDBC Connection from DataSource
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@2342d884 [managed: 15, unused: 13, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@52a9fd96)
DEBUG - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@41db7ba0] will not be managed by Spring
DEBUG - ==>  Preparing: select * from betting_record where VILLAGE_ID=? and BUY_CODE=?
DEBUG - ==> Parameters: 1390(Long), 47(Integer)
DEBUG - <==      Total: 0
DEBUG - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6ffb4c60]
DEBUG - Returning JDBC Connection to DataSource
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@2342d884 [managed: 15, unused: 13, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@52a9fd96)
DEBUG - Creating a new SqlSession
DEBUG - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7cfc34dc] was not registered for synchronization because synchronization is not active
DEBUG - Fetching JDBC Connection from DataSource
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@2342d884 [managed: 15, unused: 13, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@52a9fd96)
DEBUG - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@4dc050ed] will not be managed by Spring
DEBUG - ==>  Preparing: select * from betting_record where VILLAGE_ID=? and BUY_CODE=?
DEBUG - ==> Parameters: 1390(Long), 48(Integer)
DEBUG - <==      Total: 0
DEBUG - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7cfc34dc]
DEBUG - Returning JDBC Connection to DataSource
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@2342d884 [managed: 15, unused: 13, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@52a9fd96)
DEBUG - Creating a new SqlSession
DEBUG - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6d71220a] was not registered for synchronization because synchronization is not active
DEBUG - Fetching JDBC Connection from DataSource
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@2342d884 [managed: 15, unused: 13, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@52a9fd96)
DEBUG - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@4bf89f35] will not be managed by Spring
DEBUG - ==>  Preparing: select * from betting_record where VILLAGE_ID=? and BUY_CODE=?
DEBUG - ==> Parameters: 1390(Long), 49(Integer)
DEBUG - <==      Total: 0
DEBUG - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6d71220a]
DEBUG - Returning JDBC Connection to DataSource
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@2342d884 [managed: 15, unused: 13, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@52a9fd96)
DEBUG - Creating a new SqlSession
DEBUG - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5fb1aeac] was not registered for synchronization because synchronization is not active
DEBUG - Fetching JDBC Connection from DataSource
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@2342d884 [managed: 15, unused: 13, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@52a9fd96)
DEBUG - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@2836c6e2] will not be managed by Spring
DEBUG - ==>  Preparing: select * from betting_record where VILLAGE_ID=? and BUY_CODE=?
DEBUG - ==> Parameters: 1390(Long), 50(Integer)
DEBUG - <==      Total: 0
DEBUG - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5fb1aeac]
DEBUG - Returning JDBC Connection to DataSource
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@2342d884 [managed: 15, unused: 13, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@52a9fd96)
DEBUG - Creating a new SqlSession
DEBUG - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@d77b07] was not registered for synchronization because synchronization is not active
DEBUG - Fetching JDBC Connection from DataSource
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@2342d884 [managed: 15, unused: 13, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@52a9fd96)
DEBUG - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@64b0bf9c] will not be managed by Spring
DEBUG - ==>  Preparing: select * from betting_record where PLAYER_ID=? and VILLAGE_ID=?
DEBUG - ==> Parameters: 70515(Long), 1390(Long)
DEBUG - <==      Total: 0
DEBUG - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@d77b07]
DEBUG - Returning JDBC Connection to DataSource
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@2342d884 [managed: 15, unused: 13, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@52a9fd96)
INFO - 222
DEBUG - Null ModelAndView returned to DispatcherServlet with name 'mvc': assuming HandlerAdapter completed request handling
DEBUG - Successfully completed request
DEBUG - Returning cached instance of singleton bean 'sqlSessionFactory'

小弟是新手,求指导

加载中
0
物是人非_
物是人非_
以前遇到过这样的问题,日志没有关闭,产生大量垃圾数据,隔段时间服务器就挂掉,后来查服务器上单个文件的大小,发现log文件一个10G还多..
江戸川乱歩
果然是这个问题,改了日志之后还没有挂。
0
youthflies
youthflies

线上还开debug日志?

0
钛元素
钛元素
看到第一行我就觉得是查询数据库出问题了,检查代码看看:select * from betting_record where VILLAGE_ID=? and BUY_CODE=? 附近相关
返回顶部
顶部