最近遇到個比較奇怪的問題,用戶的網(wǎng)站百萬級訪問量,最近沒有修改程序,也沒有改過其他地方,最近總是運行20幾個小時左右tomcat就假死一次,訪問無響應!!經(jīng)常過檢查?日志發(fā)現(xiàn)?里面報了一個錯誤

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

com.alibaba.druid.pool.GetConnectionTimeoutException: loopWaitCount?0, wait millis?60000 ????at com.alibaba.druid.pool.DruidDataSource.pollLast(DruidDataSource.java:1076) ????at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:756) ????at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:644) ????at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4530) ????at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:659) ????at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4526) ????at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:626) ????at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:618) ????at com.sanyuan.dao.DBConnection.getConnection(DBConnection.java:267) ????at com.sanyuan.dao.DBAccess.setPreparedSQL(DBAccess.java:65) ????at com.clsoftware.sms.manager.SmsSenderLogManager.getTop1LogListByCondition(SmsSenderLogManager.java:641) ????at org.apache.jsp.superadmin.sms.autoCheckInfor_jsp._jspService(autoCheckInfor_jsp.java:72) ????at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) ????at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) ????at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388) ????at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) ????at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) ????at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) ????at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) ????at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) ????at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:413) ????at com.clsoftware.filter.MyFilterDispatcher.doFilter(MyFilterDispatcher.java:162) ????at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) ????at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) ????at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) ????at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) ????at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) ????at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) ????at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) ????at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) ????at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) ????at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) ????at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776) ????at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705) ????at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898) ????at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) ????at java.lang.Thread.run(Thread.java:619)

?

loopWaitCount?0,?wait?millis?60000??一看字面意思就是數(shù)據(jù)庫有問題了....找了N久才發(fā)現(xiàn)不是數(shù)據(jù)庫的問題...

?

原來用戶用了數(shù)據(jù)庫連接池,由于我們的誒個虛擬主機都有數(shù)據(jù)庫并發(fā)的限制,用戶把數(shù)據(jù)庫連接池最大連接數(shù)設(shè)置為50?,?造成了數(shù)據(jù)庫連接池不夠用,通知用戶,增加數(shù)據(jù)庫連接池后,重啟tomcat恢復正常!!

?

與50位技術(shù)專家面對面20年技術(shù)見證，附贈技術(shù)全景圖

總結(jié)

以上是生活随笔為你收集整理的关于mysql报 loopWaitCount 0, wait millis 60000 错误的解决办法的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。