forum.bitel.ru http://forum.bitel.ru/ |
|
[5.2] Many statements was open at connection close http://forum.bitel.ru/viewtopic.php?f=22&t=6959 |
Страница 1 из 1 |
Автор: | afedorov [ 12 июл 2012, 16:51 ] |
Заголовок сообщения: | [5.2] Many statements was open at connection close |
В логах сервера и RADIUS периодически вываливаются вот такие ошибки: Цитата: 07-12/14:47:33 ERROR ["http-bio-/0.0.0.0-8080"-exec-7] DefaultServerSetup - Many statements was open at connection close: com.mysql.jdbc.ServerPreparedStatement[163] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=720 com.mysql.jdbc.ServerPreparedStatement[164] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=719 com.mysql.jdbc.ServerPreparedStatement[165] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=44 com.mysql.jdbc.ServerPreparedStatement[166] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=12 com.mysql.jdbc.ServerPreparedStatement[167] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=13 com.mysql.jdbc.ServerPreparedStatement[168] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=1 com.mysql.jdbc.ServerPreparedStatement[169] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=6 com.mysql.jdbc.ServerPreparedStatement[170] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=32 com.mysql.jdbc.ServerPreparedStatement[171] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=38 com.mysql.jdbc.ServerPreparedStatement[172] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=36 com.mysql.jdbc.ServerPreparedStatement[173] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=39 com.mysql.jdbc.ServerPreparedStatement[174] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=3 com.mysql.jdbc.ServerPreparedStatement[175] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=8 com.mysql.jdbc.ServerPreparedStatement[176] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=4 com.mysql.jdbc.ServerPreparedStatement[177] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=7 com.mysql.jdbc.ServerPreparedStatement[178] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=5 com.mysql.jdbc.ServerPreparedStatement[179] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=14 com.mysql.jdbc.ServerPreparedStatement[180] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=15 com.mysql.jdbc.ServerPreparedStatement[181] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=18 com.mysql.jdbc.ServerPreparedStatement[182] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=25 com.mysql.jdbc.ServerPreparedStatement[183] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=22 com.mysql.jdbc.ServerPreparedStatement[184] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=27 com.mysql.jdbc.ServerPreparedStatement[185] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=23 com.mysql.jdbc.ServerPreparedStatement[186] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=26 com.mysql.jdbc.ServerPreparedStatement[187] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=24 com.mysql.jdbc.ServerPreparedStatement[188] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=347 com.mysql.jdbc.ServerPreparedStatement[189] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=348 com.mysql.jdbc.ServerPreparedStatement[190] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=10 com.mysql.jdbc.ServerPreparedStatement[191] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=459 com.mysql.jdbc.ServerPreparedStatement[192] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=489 com.mysql.jdbc.ServerPreparedStatement[193] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=491 com.mysql.jdbc.ServerPreparedStatement[194] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=488 com.mysql.jdbc.ServerPreparedStatement[195] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=490 com.mysql.jdbc.ServerPreparedStatement[196] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=677 com.mysql.jdbc.ServerPreparedStatement[197] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=477 com.mysql.jdbc.ServerPreparedStatement[198] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=678 com.mysql.jdbc.ServerPreparedStatement[199] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=679 com.mysql.jdbc.ServerPreparedStatement[200] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=680 com.mysql.jdbc.ServerPreparedStatement[201] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=681 com.mysql.jdbc.ServerPreparedStatement[202] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=676 com.mysql.jdbc.ServerPreparedStatement[203] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=709 com.mysql.jdbc.ServerPreparedStatement[204] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=390 com.mysql.jdbc.ServerPreparedStatement[205] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=405 com.mysql.jdbc.ServerPreparedStatement[206] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=391 com.mysql.jdbc.ServerPreparedStatement[207] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=403 com.mysql.jdbc.ServerPreparedStatement[208] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=392 com.mysql.jdbc.ServerPreparedStatement[209] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=404 com.mysql.jdbc.ServerPreparedStatement[210] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=393 com.mysql.jdbc.ServerPreparedStatement[211] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=402 com.mysql.jdbc.ServerPreparedStatement[212] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=316 com.mysql.jdbc.ServerPreparedStatement[213] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=500 com.mysql.jdbc.ServerPreparedStatement[214] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=604 com.mysql.jdbc.ServerPreparedStatement[215] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=629 com.mysql.jdbc.ServerPreparedStatement[216] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=630 com.mysql.jdbc.ServerPreparedStatement[217] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=631 com.mysql.jdbc.ServerPreparedStatement[218] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=632 com.mysql.jdbc.ServerPreparedStatement[219] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=289 com.mysql.jdbc.ServerPreparedStatement[220] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=603 com.mysql.jdbc.ServerPreparedStatement[221] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=810 com.mysql.jdbc.ServerPreparedStatement[222] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=90 com.mysql.jdbc.ServerPreparedStatement[223] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=210 com.mysql.jdbc.ServerPreparedStatement[224] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=143 com.mysql.jdbc.ServerPreparedStatement[225] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=173 com.mysql.jdbc.ServerPreparedStatement[226] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=144 com.mysql.jdbc.ServerPreparedStatement[227] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=174 com.mysql.jdbc.ServerPreparedStatement[228] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=145 com.mysql.jdbc.ServerPreparedStatement[229] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=175 com.mysql.jdbc.ServerPreparedStatement[230] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=146 com.mysql.jdbc.ServerPreparedStatement[231] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=176 com.mysql.jdbc.ServerPreparedStatement[232] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=346 com.mysql.jdbc.ServerPreparedStatement[233] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=345 com.mysql.jdbc.ServerPreparedStatement[234] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=262 com.mysql.jdbc.ServerPreparedStatement[235] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=263 com.mysql.jdbc.ServerPreparedStatement[236] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=151 com.mysql.jdbc.ServerPreparedStatement[237] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=133 com.mysql.jdbc.ServerPreparedStatement[238] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=135 com.mysql.jdbc.ServerPreparedStatement[239] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=293 com.mysql.jdbc.ServerPreparedStatement[240] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=115 com.mysql.jdbc.ServerPreparedStatement[241] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=114 com.mysql.jdbc.ServerPreparedStatement[242] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=131 com.mysql.jdbc.ServerPreparedStatement[243] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=129 com.mysql.jdbc.ServerPreparedStatement[244] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=96 com.mysql.jdbc.ServerPreparedStatement[245] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=98 com.mysql.jdbc.ServerPreparedStatement[246] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=141 com.mysql.jdbc.ServerPreparedStatement[247] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=455 com.mysql.jdbc.ServerPreparedStatement[248] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=29 com.mysql.jdbc.ServerPreparedStatement[249] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=31 com.mysql.jdbc.ServerPreparedStatement[250] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=252 com.mysql.jdbc.ServerPreparedStatement[251] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=75 com.mysql.jdbc.ServerPreparedStatement[252] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=95 com.mysql.jdbc.ServerPreparedStatement[253] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=112 com.mysql.jdbc.ServerPreparedStatement[254] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=11 com.mysql.jdbc.ServerPreparedStatement[255] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=111 com.mysql.jdbc.ServerPreparedStatement[256] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=30 com.mysql.jdbc.ServerPreparedStatement[257] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=110 com.mysql.jdbc.ServerPreparedStatement[258] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=644 com.mysql.jdbc.ServerPreparedStatement[259] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=21 com.mysql.jdbc.ServerPreparedStatement[260] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=33 com.mysql.jdbc.ServerPreparedStatement[261] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=34 com.mysql.jdbc.ServerPreparedStatement[262] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=192 java.lang.RuntimeException at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:480) at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:47) at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:261) at ru.bitel.bgbilling.kernel.base.server.DefaultContext.destroy(DefaultContext.java:37) at ru.bitel.bgbilling.kernel.container.managed.ServerContext.destroy(ServerContext.java:235) at bitel.billing.server.ActionBase.freeConnection(ActionBase.java:181) at bitel.billing.server.Executer.doModule(Unknown Source) at bitel.billing.server.Executer$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:396) at bitel.billing.server.Executer.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) 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 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:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Запросы разные. Это нормально? Насколько я понимаю, оно так ругается, когда закрывается соединение с незакрытыми стейтментами. Как убрать? |
Автор: | afedorov [ 12 июл 2012, 16:56 ] |
Заголовок сообщения: | Re: [5.2] Many statements was open at connection close |
Пример ошибки из RadiusDialup Цитата: processor 07-12/14:39:26 ERROR [pool-2-thread-1] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.JDBC4PreparedStatement@7746df77: SELECT * FROM contract WHERE id=14298 com.mysql.jdbc.JDBC4PreparedStatement@2583d260: SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tariff.tpid=tariff_plan.id WHERE cid=14298 AND ((emid=0 AND eid=0) OR (emid=0 AND eid=0)) AND ( isNull(date2) OR date2='0000-00-00' OR date2>='2012-07-01' ) UNION SELECT tree_id, date1, date2, emid, eid, 0, pos FROM contract_tree_link WHERE cid=14298 AND ((emid=0 AND eid=0) OR (emid=0 AND eid=0)) AND (date2 IS NULL OR date2>='2012-07-01') ORDER BY 4 DESC, 5 DESC, 6 ASC, 7 ASC com.mysql.jdbc.JDBC4PreparedStatement@44091520: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=14298 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1 com.mysql.jdbc.StatementImpl@19fcbac1 com.mysql.jdbc.StatementImpl@6c97f621 com.mysql.jdbc.StatementImpl@60487c5f com.mysql.jdbc.StatementImpl@4799a84f com.mysql.jdbc.StatementImpl@57e2793d com.mysql.jdbc.StatementImpl@1d2b9f14 com.mysql.jdbc.StatementImpl@63220fd1 com.mysql.jdbc.StatementImpl@43422d0b com.mysql.jdbc.StatementImpl@77b9e7fc com.mysql.jdbc.StatementImpl@514f2bd7 com.mysql.jdbc.StatementImpl@1be2f6b0 com.mysql.jdbc.StatementImpl@51b1ab1d com.mysql.jdbc.StatementImpl@17510d96 com.mysql.jdbc.StatementImpl@4a52fecf com.mysql.jdbc.StatementImpl@ed6ee28 com.mysql.jdbc.StatementImpl@7b8353cf com.mysql.jdbc.StatementImpl@5a335053 com.mysql.jdbc.StatementImpl@5edea768 com.mysql.jdbc.StatementImpl@3ef3c5c4 com.mysql.jdbc.StatementImpl@763ce725 com.mysql.jdbc.StatementImpl@21913751 com.mysql.jdbc.StatementImpl@9866417 com.mysql.jdbc.StatementImpl@11cdc190 com.mysql.jdbc.StatementImpl@31455cf4 com.mysql.jdbc.StatementImpl@1547a16f com.mysql.jdbc.StatementImpl@409bad4f com.mysql.jdbc.StatementImpl@10b173c3 com.mysql.jdbc.StatementImpl@72270fc4 com.mysql.jdbc.StatementImpl@32bed1fd com.mysql.jdbc.StatementImpl@5b08ea49 com.mysql.jdbc.StatementImpl@46eff545 com.mysql.jdbc.StatementImpl@67a4076 com.mysql.jdbc.StatementImpl@3a4c585f com.mysql.jdbc.StatementImpl@6a3de2df com.mysql.jdbc.StatementImpl@11e3c2c6 com.mysql.jdbc.StatementImpl@85e57 com.mysql.jdbc.StatementImpl@61335b86 com.mysql.jdbc.StatementImpl@72bdec44 com.mysql.jdbc.StatementImpl@190a0d51 com.mysql.jdbc.StatementImpl@62f04dae com.mysql.jdbc.StatementImpl@26a150e com.mysql.jdbc.StatementImpl@48a84b47 com.mysql.jdbc.StatementImpl@6e659812 com.mysql.jdbc.StatementImpl@4fe2fe5d com.mysql.jdbc.StatementImpl@32552379 com.mysql.jdbc.StatementImpl@3f8771dc com.mysql.jdbc.StatementImpl@6e94124f com.mysql.jdbc.StatementImpl@3b3e3940 com.mysql.jdbc.StatementImpl@67afe460 com.mysql.jdbc.StatementImpl@28fe53cf com.mysql.jdbc.StatementImpl@3ad8326d com.mysql.jdbc.StatementImpl@5fcfad77 com.mysql.jdbc.StatementImpl@593f5a2f com.mysql.jdbc.StatementImpl@12539a92 com.mysql.jdbc.StatementImpl@ef1df6 com.mysql.jdbc.StatementImpl@529801f4 com.mysql.jdbc.StatementImpl@2b1bed2 com.mysql.jdbc.StatementImpl@45d18084 com.mysql.jdbc.StatementImpl@3d4c7deb com.mysql.jdbc.StatementImpl@2bbef4c6 com.mysql.jdbc.StatementImpl@272b72f4 com.mysql.jdbc.StatementImpl@15880543 com.mysql.jdbc.StatementImpl@16ff6348 com.mysql.jdbc.StatementImpl@4b01ea1e com.mysql.jdbc.StatementImpl@4ecd200f com.mysql.jdbc.StatementImpl@7cf3e133 com.mysql.jdbc.StatementImpl@63ae2c6f com.mysql.jdbc.StatementImpl@6eef9525 com.mysql.jdbc.StatementImpl@4e695527 com.mysql.jdbc.StatementImpl@575e6691 com.mysql.jdbc.StatementImpl@7bcf6f61 com.mysql.jdbc.StatementImpl@6f9988c7 com.mysql.jdbc.StatementImpl@6a301bf5 com.mysql.jdbc.StatementImpl@1a659078 com.mysql.jdbc.StatementImpl@1efc3d2 com.mysql.jdbc.StatementImpl@7862af46 com.mysql.jdbc.StatementImpl@56ab436d com.mysql.jdbc.StatementImpl@1d05a248 com.mysql.jdbc.StatementImpl@45135cd9 com.mysql.jdbc.StatementImpl@20bf9a12 com.mysql.jdbc.StatementImpl@1f4b52aa com.mysql.jdbc.StatementImpl@44dd20b6 com.mysql.jdbc.StatementImpl@2ec7ecd5 com.mysql.jdbc.StatementImpl@26137fea com.mysql.jdbc.StatementImpl@42b7141a com.mysql.jdbc.StatementImpl@3f6a5bcb com.mysql.jdbc.StatementImpl@3ff5d699 com.mysql.jdbc.StatementImpl@655d7752 com.mysql.jdbc.StatementImpl@15ec4535 com.mysql.jdbc.StatementImpl@4ab3a5d1 com.mysql.jdbc.StatementImpl@2688e83d com.mysql.jdbc.StatementImpl@6647108e com.mysql.jdbc.StatementImpl@132c08c7 com.mysql.jdbc.StatementImpl@4af6ae1c com.mysql.jdbc.StatementImpl@76bcfa38 com.mysql.jdbc.StatementImpl@70cfaf6e com.mysql.jdbc.StatementImpl@3f610944 java.lang.RuntimeException at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:480) at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:47) at ru.bitel.bgbilling.server.util.ServerUtils.closeConnection(ServerUtils.java:566) at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas.restoreConnectionsImpl(DialUpNas.java:971) at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas.access$7(DialUpNas.java:739) at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas$2.call(DialUpNas.java:733) at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas$2.call(DialUpNas.java:1) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) |
Автор: | Amir [ 12 июл 2012, 18:42 ] |
Заголовок сообщения: | Re: [5.2] Many statements was open at connection close |
Цитата: Насколько я понимаю, оно так ругается, когда закрывается соединение с незакрытыми стейтментами. Да, в этом ничего страшного, но может плохо повлиять в некоторых случаях на производительность, потому сделали такой вывод в лог. Будем периодически выкладывать новые билды "Освобождение ресурсов".В том числе это может решить проблему с Can't create more than max_prepared_stmt_count statements при useServerPrepStmts=true&cachePrepStmts=true. По этим скоро выложим. При обновлениии не забывайте делать бэкап библиотек. |
Автор: | stark [ 13 июл 2012, 10:21 ] |
Заголовок сообщения: | Re: [5.2] Many statements was open at connection close |
Обновление выложено |
Автор: | Дмитрий [ 19 июл 2012, 15:46 ] |
Заголовок сообщения: | Re: [5.2] Many statements was open at connection close |
у меня подобное началось, вот только не иногда, а всегда в BGInetAccounting: Код: accounting 07-19/13:00:47 ERROR [accwrkr-1-p-11-t-1] DefaultServerSetup - Many statements was open at connection close: com.mysql.jdbc.JDBC4PreparedStatement@4eefaabd: SELECT * FROM inet_accounting_period_2 WHERE contractId=40033 AND (dateTo IS NULL OR dateTo>='2012-07-19') ORDER BY dateFrom com.mysql.jdbc.JDBC4PreparedStatement@74fcca98: SELECT * FROM inet_accounting_period_2 WHERE contractId=12950 AND (dateTo IS NULL OR dateTo>='2012-07-19') ORDER BY dateFrom com.mysql.jdbc.JDBC4PreparedStatement@52548eec: SELECT * FROM inet_accounting_period_2 WHERE contractId=14768 AND (dateTo IS NULL OR dateTo>='2012-07-19') ORDER BY dateFrom [skiped many lines] com.mysql.jdbc.JDBC4PreparedStatement@71bbb3ae: SELECT * FROM inet_accounting_period_2 WHERE contractId=32794 AND (dateTo IS NULL OR dateTo>='2012-07-19') ORDER BY dateFrom java.lang.RuntimeException at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:480) at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:47) at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:261) at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:205) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:103) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) Обновлися до последнего билда - беда такая же, раз в минуту-две такое валит уже сутки. Kernel version 5.2 build 1239 from 18.07.2012 12:57:10 Inet version 5.2 build 932 from 17.07.2012 14:25:38 |
Страница 1 из 1 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |