у меня такая ситуация наблюдается в одно и тоже время, которое совпадает с бэкапом базы по percona xtrabackup, я думаю - конкуретные локи....
но больще напрягает вот такой-вот выхлоп:
Код:
server 10-19/14:38:55 ERROR ["http-bio-/0.0.0.0-8080"-exec-8] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[108782] - SELECT * FROM ip_resource_range_1 WHERE (date1 IS NULL OR date1<='2013-10-19') AND (date2 IS NULL OR date1>='2013-10-19')
com.mysql.jdbc.ServerPreparedStatement[108783] - SELECT * FROM ipn_user_range_1 WHERE resource_id=1 AND (date1 IS NULL OR date1<='2013-10-19') AND (date2 IS NULL OR date2>='2013-10-19') ORDER BY addr1
com.mysql.jdbc.ServerPreparedStatement[108784] - SELECT * FROM ipn_user_range_1 WHERE resource_id=88 AND (date1 IS NULL OR date1<='2013-10-19') AND (date2 IS NULL OR date2>='2013-10-19') ORDER BY addr1
.......
и кол-во таких строчек с "ServerPreparedStatement" равно кол-ву юзеров, оставшихся на страром модуле ipn ( а их к сожалению ещё много
Или вот такой:
Код:
server 10-23/00:23:50 ERROR ["http-bio-/0.0.0.0-8080"-exec-4] XSLManager -
ClientAbortException: java.net.SocketException: Broken pipe
at org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:333)
at org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:299)
at org.apache.catalina.connector.CoyoteOutputStream.flush(CoyoteOutputStream.java:103)
at ru.bitel.bgbilling.kernel.container.web.action.XSLManager.transform(XSLManager.java:310)
at bitel.billing.server.WebExecuter.doPost(WebExecuter.java:339)
at bitel.billing.server.WebExecuter.doGet(WebExecuter.java:79)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at ru.bitel.server.servlet.filters.MultipartFilter.doFilter(MultipartFilter.java:42)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at ru.bitel.server.servlet.filters.XSSFilter.doFilter(XSSFilter.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at bitel.billing.server.filters.BGAuthFilter.doFilter(BGAuthFilter.java:296)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:218)
at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:437)
at org.apache.coyote.http11.InternalOutputBuffer.flush(InternalOutputBuffer.java:121)
at org.apache.coyote.http11.AbstractHttp11Processor.action(AbstractHttp11Processor.java:738)
at org.apache.coyote.Response.action(Response.java:170)
at org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:328)
без всяких видимых причин, при этом у оператора отваливается ГУЙ... ( на некоторое время )