forum.bitel.ru http://forum.bitel.ru/ |
|
Незакрытые preparedStatement (CRM) http://forum.bitel.ru/viewtopic.php?f=22&t=7369 |
Страница 10 из 12 |
Автор: | aleontyev [ 22 мар 2016, 14:10 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
stark писал(а): тут проблема у вас . Вы скорее всего много раз вызываете метод ContractLink. Либо передавайте туда cm либо внутри после использования вызывайте cm.recycle(); Спасибо за информацию. Да, вызывается часто. Подумаем, что с этим делать. |
Автор: | stark [ 22 мар 2016, 14:18 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
aleontyev писал(а): stark писал(а): тут проблема у вас . Вы скорее всего много раз вызываете метод ContractLink. Либо передавайте туда cm либо внутри после использования вызывайте cm.recycle(); Спасибо за информацию. Да, вызывается часто. Подумаем, что с этим делать. Тут не то чтобы часто, а на одном соединении если вызывается пока оно не закрыто. |
Автор: | aleontyev [ 22 мар 2016, 14:34 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
stark писал(а): aleontyev писал(а): stark писал(а): тут проблема у вас . Вы скорее всего много раз вызываете метод ContractLink. Либо передавайте туда cm либо внутри после использования вызывайте cm.recycle(); Спасибо за информацию. Да, вызывается часто. Подумаем, что с этим делать. Тут не то чтобы часто, а на одном соединении если вызывается пока оно не закрыто. Блин Значит я вас правильно понял в первый раз |
Автор: | Phricker [ 10 май 2016, 14:53 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
7.0 Код: server 05-10/11:49:23 ERROR [http-bio-127.0.0.1-8080-exec-10] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[2043] - SELECT * FROM contract WHERE id=158492 com.mysql.jdbc.ServerPreparedStatement[2183] - SELECT * FROM tariff_group WHERE id=39 com.mysql.jdbc.ServerPreparedStatement[2184] - SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=39 com.mysql.jdbc.ServerPreparedStatement[2185] - SELECT * FROM tariff_group WHERE id=39 com.mysql.jdbc.ServerPreparedStatement[2186] - SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=39 com.mysql.jdbc.ServerPreparedStatement[2187] - SELECT * FROM tariff_group WHERE id=39 com.mysql.jdbc.ServerPreparedStatement[2188] - SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=39 com.mysql.jdbc.ServerPreparedStatement[2189] - SELECT * FROM tariff_group WHERE id=39 com.mysql.jdbc.ServerPreparedStatement[2190] - SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=39 |
Автор: | stark [ 10 май 2016, 15:02 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Phricker писал(а): 7.0 Код: server 05-10/11:49:23 ERROR [http-bio-127.0.0.1-8080-exec-10] DefaultServerSetup - Many statements was open at connection close: com.mysql.jdbc.ServerPreparedStatement[2043] - SELECT * FROM contract WHERE id=158492 com.mysql.jdbc.ServerPreparedStatement[2183] - SELECT * FROM tariff_group WHERE id=39 com.mysql.jdbc.ServerPreparedStatement[2184] - SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=39 com.mysql.jdbc.ServerPreparedStatement[2185] - SELECT * FROM tariff_group WHERE id=39 com.mysql.jdbc.ServerPreparedStatement[2186] - SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=39 com.mysql.jdbc.ServerPreparedStatement[2187] - SELECT * FROM tariff_group WHERE id=39 com.mysql.jdbc.ServerPreparedStatement[2188] - SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=39 com.mysql.jdbc.ServerPreparedStatement[2189] - SELECT * FROM tariff_group WHERE id=39 com.mysql.jdbc.ServerPreparedStatement[2190] - SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=39 Вы TariffGroupDao в своих скриптах нее используете ? |
Автор: | Phricker [ 10 май 2016, 15:33 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Первый - глобальный скрипт разово добавивший на договора тарифные группы. Второй - глобальный скрипт разово создавший тарифные группы для всех контрагентов. Не запускались уже очень давно. |
Автор: | Phricker [ 10 май 2016, 16:22 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Код: ava.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369
at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:426) at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48) at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:272) at ru.bitel.bgbilling.kernel.base.server.DefaultContext.destroy(DefaultContext.java:37) at ru.bitel.bgbilling.kernel.container.managed.ServerContext.destroy(ServerContext.java:400) at bitel.billing.server.ActionBase.freeConnection(ActionBase.java:180) at bitel.billing.server.Executer.doModule(SourceFile:649) at bitel.billing.server.Executer$1.run(SourceFile:199) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at bitel.billing.server.Executer.doPost(SourceFile:193) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at ru.bitel.common.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) |
Автор: | stark [ 10 май 2016, 16:36 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Нашли одно место, исправили . В следующем обновлении будет. |
Автор: | Phricker [ 19 май 2016, 01:30 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Код: server 05-18/22:25:45 ERROR [http-bio-127.0.0.1-8080-exec-2] DefaultServerSetup - Many statements was open at connection close: com.mysql.jdbc.PreparedStatement@9826202: SELECT * FROM contract WHERE id=151942 com.mysql.jdbc.JDBC42PreparedStatement@7cd108e9: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.JDBC42PreparedStatement@383987f5: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@5bf97bf8: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@513462c9: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@212076c1: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@5271ee44: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@4ec32fb7: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@92650d3: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@72d7e58f: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@5aa21a0a: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@607da114: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@c9774e7: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@827c3c5: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@24edb953: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@4a235b22: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@6a909263: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@510cc931: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@7dc77ef7: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@444c37d0: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@63182d38: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@31d23d79: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@6ef48463: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@9dcc27: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@27e67fc8: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@7ab83f0f: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@58f2b2b3: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@1247461b: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@545fa0c: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@52b444b8: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@19947288: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@37c7b398: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@d6f65d: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@f4e769f: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@53878d07: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@14568e88: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@acd7681: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@4f7e996e: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@cfcf39d: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@31927ef6: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@3722dcdc: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@2712be48: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@fefc97: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@4df51f6c: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@593895cd: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@4232d738: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@614483f7: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@4ee86bcf: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@533b16eb: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@5a83135: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@27b1b963: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@4bc30fed: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@5fe180ca: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@6bf43e6f: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@1983bc78: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@7590b871: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@798afb86: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@276db98b: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@14b8f3fc: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@1efec2f3: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@4d3fa94d: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@742c5196: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@5950d89c: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@2d812052: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@4e0cc084: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@2a3dd7d1: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@54dcd248: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@75855b1c: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@76ad8996: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@418796ba: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@7de5c0b9: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@56691e18: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@45d4f189: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@2965cfd6: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@6b0d0fc: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@77053fbf: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@46bfd777: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@3824d0ef: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@5747a8bc: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@440dfa7c: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@1372cd5a: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@31630738: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@17e85f8: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@15982a5a: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@63ade9b8: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@24ddb850: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@75f9aed2: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@604811f9: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@727e1768: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@4fb9ec45: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@360004e2: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@137fb17: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@7e922393: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@3cfcbf6c: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@1a3fc678: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@3153b524: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@48b3e32a: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@38d0018b: SELECT * FROM tariff_group WHERE id=88 com.mysql.jdbc.PreparedStatement@67c2cc14: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88 com.mysql.jdbc.PreparedStatement@77939399: SELECT * FROM tariff_group WHERE id=88 java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369 at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:426) at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48) at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:272) at ru.bitel.bgbilling.kernel.base.server.DefaultContext.destroy(DefaultContext.java:37) at ru.bitel.bgbilling.kernel.container.managed.ServerContext.destroy(ServerContext.java:400) at bitel.billing.server.ActionBase.freeConnection(ActionBase.java:187) at bitel.billing.server.Executer.doModule(SourceFile:649) at bitel.billing.server.Executer$1.run(SourceFile:199) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at bitel.billing.server.Executer.doPost(SourceFile:193) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at ru.bitel.common.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Код: Клиент: вер. 7.0.810 / 16.05.2016 17:16:53
os: Windows 8.1; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_91 Сервер: вер. 7.0.1039 / 16.05.2016 17:18:36 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_91 |
Автор: | Phricker [ 19 май 2016, 01:52 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Ошибка возникает в момент когда нажимаешь кнопку + в глобальных тарифах на договоре. У нас используются тарифные группы и установлены все три галочки включая "Фильтр по группе тарифа". |
Автор: | stark [ 19 май 2016, 12:39 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Phricker писал(а): Код: Клиент: вер. 7.0.810 / 16.05.2016 17:16:53 os: Windows 8.1; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_91 Сервер: вер. 7.0.1039 / 16.05.2016 17:18:36 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_91 Странно, как раз это место вроде и исправляли. И выложили 12-го числа. |
Автор: | stark [ 19 май 2016, 12:50 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
не совсем правильно исправили. Будет еще одно обновление. |
Автор: | Phricker [ 19 май 2016, 13:02 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
stark писал(а): не совсем правильно исправили. Будет еще одно обновление. Как и в прошлый раз отвалится поиск договоров для контрагентов или можно безопасно обновляться? |
Автор: | stark [ 19 май 2016, 13:04 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Исправлено. обновление выкладывается. Будет минут через 10 . |
Автор: | stark [ 19 май 2016, 13:21 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Phricker писал(а): stark писал(а): не совсем правильно исправили. Будет еще одно обновление. Как и в прошлый раз отвалится поиск договоров для контрагентов или можно безопасно обновляться? в этот раз там только sbrf менялся и данная ошибка исправлена |
Автор: | Phricker [ 19 май 2016, 13:22 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Спасибо, чисто в логе |
Автор: | Phricker [ 19 май 2016, 18:06 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
На темы с CRM быстрее внимание обращают |
Автор: | Phricker [ 23 май 2016, 16:55 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Есть подозрение на начисление абонплат примерно в это время. Код: mq 05-23/00:17:04 ERROR [ActiveMQ Session Task] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.PreparedStatement@a3f4f23: SELECT * FROM contract WHERE id=182727 com.mysql.jdbc.PreparedStatement@649441eb: SELECT * FROM contract WHERE id=182727 com.mysql.jdbc.PreparedStatement@7e484267: SELECT * FROM tariff_plan WHERE id=645 com.mysql.jdbc.PreparedStatement@d3dde69: SELECT * FROM contract WHERE id=182734 com.mysql.jdbc.PreparedStatement@501f276b: SELECT * FROM contract WHERE id=182734 com.mysql.jdbc.PreparedStatement@5bf89e41: SELECT * FROM tariff_plan WHERE id=645 com.mysql.jdbc.PreparedStatement@4183792f: SELECT * FROM contract WHERE id=182738 com.mysql.jdbc.PreparedStatement@51aa1697: SELECT * FROM contract WHERE id=182738 com.mysql.jdbc.PreparedStatement@4ef05fc9: SELECT * FROM tariff_plan WHERE id=903 com.mysql.jdbc.PreparedStatement@7bb33169: SELECT * FROM contract WHERE id=182755 com.mysql.jdbc.PreparedStatement@3023f0ac: SELECT * FROM contract WHERE id=182755 com.mysql.jdbc.PreparedStatement@74003f0d: SELECT * FROM tariff_plan WHERE id=393 com.mysql.jdbc.PreparedStatement@31b19117: SELECT * FROM contract WHERE id=182772 com.mysql.jdbc.PreparedStatement@1ca1d4f8: SELECT * FROM contract WHERE id=182772 com.mysql.jdbc.PreparedStatement@8d882e3: SELECT * FROM tariff_plan WHERE id=782 com.mysql.jdbc.PreparedStatement@363c5807: SELECT * FROM contract WHERE id=182773 com.mysql.jdbc.PreparedStatement@34baca3: SELECT * FROM contract WHERE id=182773 com.mysql.jdbc.PreparedStatement@16882ae6: SELECT * FROM tariff_plan WHERE id=889 com.mysql.jdbc.PreparedStatement@681e4d81: SELECT * FROM contract WHERE id=182777 com.mysql.jdbc.PreparedStatement@7118dc75: SELECT * FROM contract WHERE id=182777 com.mysql.jdbc.PreparedStatement@230ec037: SELECT * FROM tariff_plan WHERE id=1036 com.mysql.jdbc.PreparedStatement@7b3ae2d6: SELECT * FROM contract WHERE id=182805 com.mysql.jdbc.PreparedStatement@ac8532b: SELECT * FROM contract WHERE id=182805 com.mysql.jdbc.PreparedStatement@7dbc9327: SELECT * FROM tariff_plan WHERE id=873 com.mysql.jdbc.PreparedStatement@15889e57: SELECT * FROM contract WHERE id=182817 com.mysql.jdbc.PreparedStatement@25ed8faa: SELECT * FROM contract WHERE id=182817 com.mysql.jdbc.PreparedStatement@271c3a7a: SELECT * FROM tariff_plan WHERE id=645 com.mysql.jdbc.PreparedStatement@4aca2d91: SELECT * FROM contract WHERE id=182821 com.mysql.jdbc.PreparedStatement@453da7df: SELECT * FROM contract WHERE id=182821 com.mysql.jdbc.PreparedStatement@253aaf2: SELECT * FROM tariff_plan WHERE id=889 com.mysql.jdbc.PreparedStatement@3c8d217d: SELECT * FROM contract WHERE id=182826 com.mysql.jdbc.PreparedStatement@e815bee: SELECT * FROM contract WHERE id=182826 com.mysql.jdbc.PreparedStatement@271af749: SELECT * FROM tariff_plan WHERE id=889 com.mysql.jdbc.PreparedStatement@3eaa631e: SELECT * FROM contract WHERE id=182839 com.mysql.jdbc.PreparedStatement@113f46fc: SELECT * FROM contract WHERE id=182839 com.mysql.jdbc.PreparedStatement@280f31be: SELECT * FROM tariff_plan WHERE id=727 com.mysql.jdbc.PreparedStatement@1286ea0f: SELECT * FROM contract WHERE id=182844 com.mysql.jdbc.PreparedStatement@6fe55dae: SELECT * FROM contract WHERE id=182844 com.mysql.jdbc.PreparedStatement@2f48edab: SELECT * FROM tariff_plan WHERE id=393 com.mysql.jdbc.PreparedStatement@effc9b9: SELECT * FROM contract WHERE id=182854 com.mysql.jdbc.PreparedStatement@59b776fc: SELECT * FROM contract WHERE id=182854 com.mysql.jdbc.PreparedStatement@36b1027c: SELECT * FROM tariff_plan WHERE id=761 com.mysql.jdbc.PreparedStatement@20106e98: SELECT * FROM contract WHERE id=182859 com.mysql.jdbc.PreparedStatement@62e6ff7e: SELECT * FROM contract WHERE id=182859 com.mysql.jdbc.PreparedStatement@33b15144: SELECT * FROM tariff_plan WHERE id=645 com.mysql.jdbc.PreparedStatement@1e8e1e74: SELECT * FROM contract WHERE id=182872 com.mysql.jdbc.PreparedStatement@23427cd: SELECT * FROM contract WHERE id=182872 com.mysql.jdbc.PreparedStatement@322e9733: SELECT * FROM tariff_plan WHERE id=889 com.mysql.jdbc.PreparedStatement@7623f345: SELECT * FROM contract WHERE id=182882 com.mysql.jdbc.PreparedStatement@420b8634: SELECT * FROM contract WHERE id=182882 com.mysql.jdbc.PreparedStatement@10a281a6: SELECT * FROM tariff_plan WHERE id=889 |
Автор: | stark [ 23 май 2016, 17:04 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Phricker писал(а): Есть подозрение на начисление абонплат примерно в это время. Планировщик или сервер ? |
Автор: | Phricker [ 23 май 2016, 17:13 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
server.error.log |
Автор: | stark [ 23 май 2016, 17:46 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
а начисление абонплат обычно на планировщике отрабатывает. |
Автор: | Phricker [ 23 май 2016, 17:47 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Ну значит не абонплаты. Просто в это время больше вроде ничего не отрабатывает |
Автор: | stark [ 23 май 2016, 18:04 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Phricker писал(а): Ну значит не абонплаты. Просто в это время больше вроде ничего не отрабатывает Можно посмотреть какие были запросы на сервер в это время . Вряд ли в это время (00:17) или чуть раньше( на случай если выполнялось долго) было много запросов. Может отчет какой запускали . |
Автор: | Phricker [ 23 май 2016, 19:08 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
stark писал(а): Можно посмотреть какие были запросы на сервер в это время . Кроме отчетов только просмотр договоров. Отчеты сидел упорно тыкал - не повторяется. Код: mq 05-23/00:13:53 ERROR [event-proc-p-2-t-1] DefaultServerSetup - Many statements was open at connection close: mq 05-23/00:13:56 ERROR [event-proc-p-2-t-1] DefaultServerSetup - Many statements was open at connection close: mq 05-23/00:13:58 ERROR [ActiveMQ Session Task] DefaultServerSetup - Many statements was open at connection close: mq 05-23/00:14:00 ERROR [event-proc-p-2-t-1] DefaultServerSetup - Many statements was open at connection close: mq 05-23/00:14:02 ERROR [ActiveMQ Session Task] DefaultServerSetup - Many statements was open at connection close: И в таком же роде долго и упорно. Код: java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369 at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:426) at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48) at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:272) at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:370) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:71) at ru.bitel.bgbilling.kernel.event.EventListenerThreadContext$2.rejectedExecution(EventListenerThreadContext.java:88) at java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:823) at java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1369) at ru.bitel.bgbilling.kernel.event.Consumer.onMessage(Consumer.java:159) at org.apache.activemq.ActiveMQMessageConsumer.dispatch(ActiveMQMessageConsumer.java:1229) at org.apache.activemq.ActiveMQSessionExecutor.dispatch(ActiveMQSessionExecutor.java:134) at org.apache.activemq.ActiveMQSessionExecutor.iterate(ActiveMQSessionExecutor.java:205) at org.apache.activemq.thread.PooledTaskRunner.runTask(PooledTaskRunner.java:122) at org.apache.activemq.thread.PooledTaskRunner$1.run(PooledTaskRunner.java:43) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Код: java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369
at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:426) at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48) at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:272) at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:370) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:103) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:46) |
Автор: | Villian [ 25 май 2016, 17:34 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
АП |
Автор: | vkulakov [ 03 июн 2016, 13:13 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Игрался с отчётом по должникам, а потом в логах навалило: Код: server 06-02/16:29:44 ERROR [http-bio-127.0.0.1-8080-exec-10] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[1156] - SELECT summa1, summa1 + summa2 - summa3 - summa4 FROM contract_balance WHERE cid=21382 AND yy=2016 AND mm=05 com.mysql.jdbc.ServerPreparedStatement[1157] - SELECT summa1 + summa2 - summa3 - summa4 FROM contract_balance WHERE cid=21382 AND (yy<2016 OR (yy=2016 AND mm<=05)) ORDER BY yy DESC, mm DESC com.mysql.jdbc.ServerPreparedStatement[1158] - SELECT t1.val as phone, t2.val as fio, t3.address as address FROM contract LEFT JOIN contract_parameter_type_1 as t1 ON contract.id=t1.cid AND t1.pid=1 LEFT JOIN contract_parameter_type_1 as t2 ON contract.id=t2.cid AND t2.pid=2 LEFT JOIN contract_parameter_type_2 as t3 ON contract.id=t3.cid AND t3.pid=3 WHERE contract.id=21382 com.mysql.jdbc.ServerPreparedStatement[1159] - SELECT SUM(summa) FROM contract_payment WHERE cid=null AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<TO_DAYS('2016-05-01') com.mysql.jdbc.ServerPreparedStatement[1160] - SELECT SUM(summa) FROM contract_payment WHERE cid=21382 AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') AND pt!=0 com.mysql.jdbc.ServerPreparedStatement[1161] - SELECT SUM(summa) FROM contract_payment WHERE cid=21382 AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') AND pt=0 com.mysql.jdbc.ServerPreparedStatement[1162] - SELECT id, title, comment, scid, sub_list, sub_mode FROM contract WHERE gr&6088299485643521727>0 ORDER BY contract.title com.mysql.jdbc.ServerPreparedStatement[1163] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17499,17500,17501,17502,26158,26167) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1165] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (5052) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1167] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (39039,39048) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1169] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (38780,38782) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1171] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (39022,39023) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1173] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (6500,28532,29191) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1175] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (38881) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1177] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (3257,3272,3273,5004,8510,16919,17307,21321,21457,22241,23571,24351,24693,25107,25179,26834,26936,27523,27993,28159,28514,28612,28626,30098,30208,30209,30255,30522,31723,32074,32452,32464,32691,33102,34450,34637,35878,36154,36454,37273,37381,37455,38338,38349,38412,38422,38786,38964,39396,39466,43812,43990,44292,44543,44647,44666,44667) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1179] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (589,2131,5676) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1181] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (1559,10915) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1183] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (264,265,266,1031,1043) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1185] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (951,1095,3341,4215,18250,18251,18252,18253,18254,18255,23466) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1187] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4921,6780,13209) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1189] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4452,6573) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1191] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (34714) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1193] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (2210) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1195] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17693) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1197] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (2699) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1199] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (24607,24608) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1201] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (29318) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1203] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (11629) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1205] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (33559) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1207] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (33918) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1209] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (25269) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1211] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (25350) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1213] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (267,268,20172,22771) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1215] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17199,17201,17503,17505,18408,19583,20819,22802,42035) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1217] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (28965) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1219] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (5996) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1221] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (948,950,937) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1223] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (24439,24440,24441,24442,24443) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1225] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (34604) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1227] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30326,30327) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1229] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30663) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1231] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30781,30782) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1233] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30791,30792) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1235] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30834) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1237] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30873,30874) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1239] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (31192,31193) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1241] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (34006,34972) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1243] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (31696) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1245] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32013,32014) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1247] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32742,32743) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1249] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32808,32809) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1251] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32821,32822) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1253] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32827,32828) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1255] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32857,32858) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1257] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32956,32957) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1259] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32986,32987) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1261] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (33119,33120) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1263] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17099,17102,29243,29246) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1265] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4001,4152,11093,17103) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1267] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (3390,3817,4057,5138,17850,39683) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1269] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (33741,33742,33743,33744,34277,34610) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1271] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (16277) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1273] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4726,11772,16025,16026) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1275] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (11904) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1277] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (22108) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1279] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (11597) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1281] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (7184,9700) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1283] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4401,4402,4403,4404,4405,4406,4407,4408,4409,4410,4411,4412,4413,4414,4415,4416,4417,4418,17617,33403) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1285] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4980) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1287] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (20346) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1289] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (6250,16824,17107,17108) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1291] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4465,4466,4467,4468) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1293] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (28970,28971,28972,28973,28974,28975) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1295] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (28543) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1297] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4252,4531,4532,23090) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1299] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4905,11624,11625) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1301] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (2543,20246,20248) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1303] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4874,4875,6471,9445,11857) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1305] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (14557) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1307] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (35271) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1309] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4968) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1311] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (18329,18331,33627,33629) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1313] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (25463) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1315] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (22440) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1317] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (18093) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1319] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (10287,10581,10592,23895) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1321] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (8251,17120) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1323] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17109) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1325] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (6788,6793,6794,6795,6797) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1327] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (15865,15866,16276,41616) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1329] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (34087) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1331] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (8660,8661,8667,11097,17121) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1333] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (11464) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1335] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (11379) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1337] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (7366,7367,11268,12049,12318) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1339] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17196) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1341] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (33406) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1343] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (36722) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1345] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (8044,41617) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') com.mysql.jdbc.ServerPreparedStatement[1347] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (24600) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369 at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:426) at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48) at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:272) at ru.bitel.bgbilling.kernel.base.server.DefaultContext.destroy(DefaultContext.java:37) at ru.bitel.bgbilling.kernel.container.managed.ServerContext.destroy(ServerContext.java:400) at bitel.billing.server.ActionBase.freeConnection(ActionBase.java:180) at bitel.billing.server.Executer.doModule(SourceFile:649) at bitel.billing.server.Executer$1.run(SourceFile:199) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at bitel.billing.server.Executer.doPost(SourceFile:193) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at ru.bitel.common.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) |
Автор: | stark [ 03 июн 2016, 13:58 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
vkulakov писал(а): Игрался с отчётом по должникам, а потом в логах навалило: Исправлено в 7.0/6.2 . Будет в следующем обновлении . |
Автор: | Ping333 [ 14 июл 2016, 19:22 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Добрый день! Незнаю, наверное тоже в эту тему, не могу понять откуда сыпятся. беру номера поинтов по ним ищу параметры договора привязанные на поинт Клиент: вер. 6.2.829 / 13.07.2016 17:30:26 os: Windows 7; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_73 Сервер: вер. 6.2.1087 / 14.07.2016 16:43:16 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_91 bill: вер. 6.2.87 / 10.06.2016 13:28:18 card: вер. 6.2.39 / 26.05.2016 14:50:45 dialup: вер. 6.2.315 / 01.03.2016 00:17:59 inet: вер. 6.2.670 / 13.07.2016 17:31:59 ipn: вер. 6.2.259 / 06.07.2016 19:29:33 npay: вер. 6.2.195 / 24.06.2016 16:25:14 pay: вер. ? phone: вер. 6.2.279 / 06.06.2016 12:50:07 reports: вер. 6.2.209 / 06.06.2016 12:43:49 rscm: вер. 6.2.177 / 10.06.2016 13:40:20 ru.bitel.bgbilling.plugins.dispatch: вер. 6.2.85 / 11.07.2016 17:32:00 ru.bitel.bgbilling.plugins.documents: вер. 6.2.171 / 11.07.2016 17:46:28 ru.bitel.bgbilling.plugins.helpdesk: вер. 6.2.181 / 14.06.2016 14:50:40 trayinfo: вер. 6.2.170 / 02.02.2016 17:42:09 voiceip: вер. 6.2.190 / 03.03.2016 18:32:27 Код: 07-14/20:21:15 DEBUG [http-bio-0.0.0.0-8080-exec-3] CommonExecutor - executing bitel.billing.server.admin.action.ActionCommand; time => 1 ms.
07-14/20:21:15 DEBUG [http-bio-0.0.0.0-8080-exec-3] CommonExecutor - <?xml version="1.0" encoding="UTF-8"?><data status="ok"/> 07-14/20:21:16 DEBUG [http-bio-0.0.0.0-8080-exec-3] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.updateSource; time => 5 ms. 07-14/20:21:16 DEBUG [http-bio-0.0.0.0-8080-exec-3] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getDynamicClasses; time => 23 ms. 07-14/20:21:16 DEBUG [http-bio-0.0.0.0-8080-exec-3] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getSource; time => 2 ms. 07-14/20:21:16 DEBUG [http-bio-0.0.0.0-8080-exec-3] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getSource; time => 1 ms. 07-14/20:21:17 DEBUG [http-bio-0.0.0.0-8080-exec-3] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.compile; time => 335 ms. 07-14/20:21:17 DEBUG [http-bio-0.0.0.0-8080-exec-14] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getDynamicClasses; time => 217 ms. 07-14/20:21:17 DEBUG [http-bio-0.0.0.0-8080-exec-14] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getSource; time => 2 ms. 07-14/20:21:17 DEBUG [http-bio-0.0.0.0-8080-exec-14] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getSource; time => 1 ms. 07-14/20:21:18 DEBUG [http-bio-0.0.0.0-8080-exec-12] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.run; time => 833 ms. 07-14/20:21:18 ERROR [http-bio-0.0.0.0-8080-exec-12] DefaultServerSetup - Many statements was open at connection close: com.mysql.jdbc.ServerPreparedStatement[620] - SELECT * FROM contract WHERE id=3620 com.mysql.jdbc.ServerPreparedStatement[647] - SELECT * FROM contract WHERE id=3620 com.mysql.jdbc.ServerPreparedStatement[648] - SELECT * FROM contract WHERE id=231 com.mysql.jdbc.ServerPreparedStatement[649] - SELECT * FROM contract WHERE id=3620 com.mysql.jdbc.ServerPreparedStatement[650] - SELECT * FROM contract WHERE id=3620 com.mysql.jdbc.ServerPreparedStatement[651] - SELECT * FROM contract WHERE id=2761 com.mysql.jdbc.ServerPreparedStatement[652] - SELECT * FROM contract WHERE id=3831 com.mysql.jdbc.ServerPreparedStatement[653] - SELECT * FROM contract WHERE id=3915 com.mysql.jdbc.ServerPreparedStatement[654] - SELECT * FROM contract WHERE id=2427 com.mysql.jdbc.ServerPreparedStatement[655] - SELECT * FROM contract WHERE id=3949 com.mysql.jdbc.ServerPreparedStatement[656] - SELECT * FROM contract WHERE id=2303 com.mysql.jdbc.ServerPreparedStatement[657] - SELECT * FROM contract WHERE id=2090 com.mysql.jdbc.ServerPreparedStatement[658] - SELECT * FROM contract WHERE id=3438 com.mysql.jdbc.ServerPreparedStatement[659] - SELECT * FROM contract WHERE id=191 com.mysql.jdbc.ServerPreparedStatement[660] - SELECT * FROM contract WHERE id=2181 com.mysql.jdbc.ServerPreparedStatement[661] - SELECT * FROM contract WHERE id=2226 com.mysql.jdbc.ServerPreparedStatement[662] - SELECT * FROM contract WHERE id=1673 com.mysql.jdbc.ServerPreparedStatement[663] - SELECT * FROM contract WHERE id=179 com.mysql.jdbc.ServerPreparedStatement[664] - SELECT * FROM contract WHERE id=2309 com.mysql.jdbc.ServerPreparedStatement[665] - SELECT * FROM contract WHERE id=4017 com.mysql.jdbc.ServerPreparedStatement[666] - SELECT * FROM contract WHERE id=4017 com.mysql.jdbc.ServerPreparedStatement[667] - SELECT * FROM contract WHERE id=4017 com.mysql.jdbc.ServerPreparedStatement[668] - SELECT * FROM contract WHERE id=3677 com.mysql.jdbc.ServerPreparedStatement[669] - SELECT * FROM contract WHERE id=2077 com.mysql.jdbc.ServerPreparedStatement[670] - SELECT * FROM contract WHERE id=4017 com.mysql.jdbc.ServerPreparedStatement[671] - SELECT * FROM contract WHERE id=3438 com.mysql.jdbc.ServerPreparedStatement[672] - SELECT * FROM contract WHERE id=3438 com.mysql.jdbc.ServerPreparedStatement[673] - SELECT * FROM contract WHERE id=2449 com.mysql.jdbc.ServerPreparedStatement[674] - SELECT * FROM contract WHERE id=2106 com.mysql.jdbc.ServerPreparedStatement[675] - SELECT * FROM contract WHERE id=2115 com.mysql.jdbc.ServerPreparedStatement[676] - SELECT * FROM contract WHERE id=2283 com.mysql.jdbc.ServerPreparedStatement[677] - SELECT * FROM contract WHERE id=3717 com.mysql.jdbc.ServerPreparedStatement[678] - SELECT * FROM contract WHERE id=4024 com.mysql.jdbc.ServerPreparedStatement[679] - SELECT * FROM contract WHERE id=2069 com.mysql.jdbc.ServerPreparedStatement[680] - SELECT * FROM contract WHERE id=3901 com.mysql.jdbc.ServerPreparedStatement[681] - SELECT * FROM contract WHERE id=3438 com.mysql.jdbc.ServerPreparedStatement[682] - SELECT * FROM contract WHERE id=2076 com.mysql.jdbc.ServerPreparedStatement[683] - SELECT * FROM contract WHERE id=3668 com.mysql.jdbc.ServerPreparedStatement[684] - SELECT * FROM contract WHERE id=3948 com.mysql.jdbc.ServerPreparedStatement[685] - SELECT * FROM contract WHERE id=4017 com.mysql.jdbc.ServerPreparedStatement[686] - SELECT * FROM contract WHERE id=2440 com.mysql.jdbc.ServerPreparedStatement[687] - SELECT * FROM contract WHERE id=3438 com.mysql.jdbc.ServerPreparedStatement[688] - SELECT * FROM contract WHERE id=2288 com.mysql.jdbc.ServerPreparedStatement[689] - SELECT * FROM contract WHERE id=1671 com.mysql.jdbc.ServerPreparedStatement[690] - SELECT * FROM contract WHERE id=3936 com.mysql.jdbc.ServerPreparedStatement[691] - SELECT * FROM contract WHERE id=2154 com.mysql.jdbc.ServerPreparedStatement[692] - SELECT * FROM contract WHERE id=3686 com.mysql.jdbc.ServerPreparedStatement[693] - SELECT * FROM contract WHERE id=2260 com.mysql.jdbc.ServerPreparedStatement[694] - SELECT * FROM contract WHERE id=2128 com.mysql.jdbc.ServerPreparedStatement[695] - SELECT * FROM contract WHERE id=3686 com.mysql.jdbc.ServerPreparedStatement[696] - SELECT * FROM contract WHERE id=2262 com.mysql.jdbc.ServerPreparedStatement[697] - SELECT * FROM contract WHERE id=2064 com.mysql.jdbc.ServerPreparedStatement[698] - SELECT * FROM contract WHERE id=231 com.mysql.jdbc.ServerPreparedStatement[699] - SELECT * FROM contract WHERE id=2453 com.mysql.jdbc.ServerPreparedStatement[700] - SELECT * FROM contract WHERE id=3438 com.mysql.jdbc.ServerPreparedStatement[701] - SELECT * FROM contract WHERE id=2422 com.mysql.jdbc.ServerPreparedStatement[702] - SELECT * FROM contract WHERE id=3438 com.mysql.jdbc.ServerPreparedStatement[703] - SELECT * FROM contract WHERE id=231 com.mysql.jdbc.ServerPreparedStatement[704] - SELECT * FROM contract WHERE id=231 com.mysql.jdbc.ServerPreparedStatement[705] - SELECT * FROM contract WHERE id=3438 com.mysql.jdbc.ServerPreparedStatement[706] - SELECT * FROM contract WHERE id=2206 com.mysql.jdbc.ServerPreparedStatement[707] - SELECT * FROM contract WHERE id=3831 com.mysql.jdbc.ServerPreparedStatement[708] - SELECT * FROM contract WHERE id=4017 com.mysql.jdbc.ServerPreparedStatement[709] - SELECT * FROM contract WHERE id=3438 com.mysql.jdbc.ServerPreparedStatement[710] - SELECT * FROM contract WHERE id=2289 com.mysql.jdbc.ServerPreparedStatement[711] - SELECT * FROM contract WHERE id=2031 com.mysql.jdbc.ServerPreparedStatement[712] - SELECT * FROM contract WHERE id=1576 com.mysql.jdbc.ServerPreparedStatement[713] - SELECT * FROM contract WHERE id=2819 com.mysql.jdbc.ServerPreparedStatement[714] - SELECT * FROM contract WHERE id=4046 com.mysql.jdbc.ServerPreparedStatement[715] - SELECT * FROM contract WHERE id=180 com.mysql.jdbc.ServerPreparedStatement[716] - SELECT * FROM contract WHERE id=1576 com.mysql.jdbc.ServerPreparedStatement[717] - SELECT * FROM contract WHERE id=2892 com.mysql.jdbc.ServerPreparedStatement[718] - SELECT * FROM contract WHERE id=3438 com.mysql.jdbc.ServerPreparedStatement[719] - SELECT * FROM contract WHERE id=2134 com.mysql.jdbc.ServerPreparedStatement[720] - SELECT * FROM contract WHERE id=3948 com.mysql.jdbc.ServerPreparedStatement[721] - SELECT * FROM contract WHERE id=3831 com.mysql.jdbc.ServerPreparedStatement[722] - SELECT * FROM contract WHERE id=1687 com.mysql.jdbc.ServerPreparedStatement[723] - SELECT * FROM contract WHERE id=2032 com.mysql.jdbc.ServerPreparedStatement[724] - SELECT * FROM contract WHERE id=2227 com.mysql.jdbc.ServerPreparedStatement[725] - SELECT * FROM contract WHERE id=2266 com.mysql.jdbc.ServerPreparedStatement[726] - SELECT * FROM contract WHERE id=2087 com.mysql.jdbc.ServerPreparedStatement[727] - SELECT * FROM contract WHERE id=2423 com.mysql.jdbc.ServerPreparedStatement[728] - SELECT * FROM contract WHERE id=2150 com.mysql.jdbc.ServerPreparedStatement[729] - SELECT * FROM contract WHERE id=2224 com.mysql.jdbc.ServerPreparedStatement[730] - SELECT * FROM contract WHERE id=2936 com.mysql.jdbc.ServerPreparedStatement[731] - SELECT * FROM contract WHERE id=1706 com.mysql.jdbc.ServerPreparedStatement[732] - SELECT * FROM contract WHERE id=3438 com.mysql.jdbc.ServerPreparedStatement[733] - SELECT * FROM contract WHERE id=3131 com.mysql.jdbc.ServerPreparedStatement[734] - SELECT * FROM contract WHERE id=2197 com.mysql.jdbc.ServerPreparedStatement[735] - SELECT * FROM contract WHERE id=231 com.mysql.jdbc.ServerPreparedStatement[736] - SELECT * FROM contract WHERE id=3145 com.mysql.jdbc.ServerPreparedStatement[737] - SELECT * FROM contract WHERE id=3135 com.mysql.jdbc.ServerPreparedStatement[738] - SELECT * FROM contract WHERE id=3786 com.mysql.jdbc.ServerPreparedStatement[739] - SELECT * FROM contract WHERE id=3141 com.mysql.jdbc.ServerPreparedStatement[740] - SELECT * FROM contract WHERE id=2019 com.mysql.jdbc.ServerPreparedStatement[741] - SELECT * FROM contract WHERE id=3438 com.mysql.jdbc.ServerPreparedStatement[742] - SELECT * FROM contract WHERE id=231 com.mysql.jdbc.ServerPreparedStatement[743] - SELECT * FROM contract WHERE id=2040 com.mysql.jdbc.ServerPreparedStatement[744] - SELECT * FROM contract WHERE id=2290 com.mysql.jdbc.ServerPreparedStatement[745] - SELECT * FROM contract WHERE id=231 java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369 at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:426) at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48) at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:272) at ru.bitel.bgbilling.kernel.base.server.DefaultContext.destroy(DefaultContext.java:37) at ru.bitel.bgbilling.kernel.container.managed.ServerContext.destroy(ServerContext.java:400) at ru.bitel.bgbilling.kernel.container.ws.server.AbstractJaxWsHandler.invoke0(AbstractJaxWsHandler.java:233) at ru.bitel.bgbilling.kernel.container.ws.server.AbstractJaxWsHandler.access$000(AbstractJaxWsHandler.java:47) at ru.bitel.bgbilling.kernel.container.ws.server.AbstractJaxWsHandler$1.run(AbstractJaxWsHandler.java:267) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at ru.bitel.bgbilling.kernel.container.ws.server.AbstractJaxWsHandler.invoke(AbstractJaxWsHandler.java:261) at ru.bitel.bgbilling.kernel.container.ws.server.JaxWsHandler.invoke(JaxWsHandler.java:315) at ru.bitel.bgbilling.kernel.container.ws.server.AbstractJaxWsHandler$ServiceInstanceResolver$1.invoke(AbstractJaxWsHandler.java:366) at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:150) at com.sun.xml.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:261) at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:100) at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:641) at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:600) at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:585) at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:482) at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:314) at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:608) at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:259) at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:162) at ru.bitel.bgbilling.kernel.container.ws.server.JaxWSAdapter.handle(JaxWSAdapter.java:290) at bitel.billing.server.Executer.doPost(SourceFile:163) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) 07-14/20:21:19 DEBUG [http-bio-0.0.0.0-8080-exec-12] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getDynamicClasses; time => 21 ms. 07-14/20:21:19 DEBUG [http-bio-0.0.0.0-8080-exec-12] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getSource; time => 1 ms. 07-14/20:21:19 DEBUG [http-bio-0.0.0.0-8080-exec-12] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getSource; time => 1 ms. |
Автор: | dimOn [ 14 июл 2016, 21:15 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
в смысле это вы в своём динкоде делаете? |
Автор: | Ping333 [ 14 июл 2016, 21:43 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Ага, в дин коде |
Страница 10 из 12 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |