forum.bitel.ru http://forum.bitel.ru/ |
|
Незакрытые preparedStatement (CRM) http://forum.bitel.ru/viewtopic.php?f=22&t=7369 |
Страница 12 из 12 |
Автор: | abu [ 31 июл 2017, 11:25 ] | |||
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) | |||
Обновился 27.07, получил 29.07 preparedStatement в логах. Ошибка появилась один раз, во время отработки задачи "Начисление NPay абонплат" планировщиком, после этого более не появлялась. У абонентов подключен древний скрипт "Определение суммы минимального платежа". Скрипт и лог - в приложении. Цитата: Информация о версии:
Клиент: вер. 6.2.870 / 25.07.2017 14:32:01 os: Linux; java: Java HotSpot(TM) Server VM, v.1.8.0_74 Сервер: вер. 6.2.1196 / 25.07.2017 14:33:13 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_74 assist: вер. 6.2.90 / 25.07.2017 14:34:39 bill: вер. 6.2.109 / 25.07.2017 14:34:42 card: вер. 6.2.44 / 25.07.2017 14:34:50 dba: вер. 6.2.164 / 25.07.2017 14:35:12 enaza: вер. 6.2.61 / 25.07.2017 14:35:16 gorod: вер. 6.2.165 / 25.07.2017 14:35:18 inet: вер. 6.2.731 / 25.07.2017 17:16:36 mps: вер. 6.2.226 / 25.07.2017 14:35:26 npay: вер. 6.2.202 / 25.07.2017 14:35:29 paylinks: вер. 6.2.33 / 25.07.2017 14:35:32 paymaster: вер. 6.2.56 / 25.07.2017 14:35:33 qiwi: вер. 6.2.53 / 25.07.2017 14:35:49 rentsoft: вер. 6.2.64 / 25.07.2017 14:35:53 reports: вер. 6.2.218 / 25.07.2017 14:35:55 rscm: вер. 6.2.180 / 25.07.2017 14:35:59 ru.bitel.bgbilling.plugins.cladr: вер. 6.2.120 / 25.07.2017 14:35:11 ru.bitel.bgbilling.plugins.dispatch: вер. 6.2.98 / 25.07.2017 14:35:13 trayinfo: вер. 6.2.172 / 03.07.2017 15:47:40 tv: вер. 6.2.243 / 25.07.2017 14:34:21 wellpay: вер. ? wm: вер. 6.2.190 / 25.07.2017 14:36:18 yamoney: вер. 6.2.59 / 25.07.2017 14:36:19 Окружение: Клиент: os: Linux i386, 3.13-1-amd64 java: Java HotSpot(TM) Server VM, v.1.8.0_74 jre home: /opt/java/jdk1.8.0_74/jre default tz: 31.07.2017 14:23 YAKT +0900 (Asia/Yakutsk) user tz: 31.07.2017 14:23 YAKT +0900 (Asia/Yakutsk) locale: ru_RU Сервер: os: Linux amd64, 2.6.32-el-smp-alt27 java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_74 jre home: /opt/java/jdk1.8.0_74/jre default tz: 31.07.2017 14:23 YAKT +0900 (Asia/Yakutsk) db time: master: 31.07.2017 14:23 YAKT db charset: connection: utf8(utf8_general_ci), database: cp1251(cp1251_general_ci) locale: en_US uptime: Started: 27.07.2017 17:47:36 Uptime: 3 d 20:35:43
|
Автор: | Ildar [ 31 июл 2017, 12:15 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
С 6.2 TariffPlanManager депрекейнут. Используйте TariffPlanDao. А после использования закрывайте. Это же касается ContractTariffPlanManager. Но там чуть проще, так как утечка не возможна, пока. |
Автор: | abu [ 31 июл 2017, 12:46 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Так-то оно все работало достаточно давно на 6.2. Спасибо за объяснения, буду разбираться. |
Автор: | Ildar [ 31 июл 2017, 13:16 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Да, это наш косяк. Не совсем верно депрекейтнули, но теперь уже не вижу смысла воротить назад. Так как использовать данные классы все равно уже не желательно. Если у вас есть сложности с перепиской скрипта, то могу сам вам переписать. |
Автор: | abu [ 31 июл 2017, 13:22 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Нет, пока не нужно, спасибо, попробую сам. Если что, еще раз обращусь (: |
Автор: | ok-2004 [ 09 авг 2017, 16:45 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
ДВС! Сегодня в server.error.log словил : Код: server 08-09/11:17:53 ERROR [http-bio-0.0.0.0-8080-exec-9] DefaultServerSetup - Many statements was open at connection close: com.mysql.jdbc.JDBC4PreparedStatement@55a87ec8: SELECT * FROM tariff_plan ORDER BY title com.mysql.jdbc.JDBC4PreparedStatement@74cc1d17: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.JDBC4PreparedStatement@11633c62: 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=7 com.mysql.jdbc.PreparedStatement@226de06d: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@4219e1dd: 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=7 com.mysql.jdbc.PreparedStatement@1cba9ccf: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@41acc3b1: 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=7 com.mysql.jdbc.PreparedStatement@5b58019: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@4cafe63e: 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=7 com.mysql.jdbc.PreparedStatement@7cc02d9d: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@31b93d6a: 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=7 com.mysql.jdbc.PreparedStatement@4d775600: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@2105633b: 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=7 com.mysql.jdbc.PreparedStatement@6390e9d: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@2d9e0d68: 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=7 com.mysql.jdbc.PreparedStatement@567dde79: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@c3aaf7a: 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=7 com.mysql.jdbc.PreparedStatement@18918dee: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@10a82a75: 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=7 com.mysql.jdbc.PreparedStatement@420aa3b8: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@3738a9af: 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=7 com.mysql.jdbc.PreparedStatement@6e8fc55f: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@77131cf2: 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=7 com.mysql.jdbc.PreparedStatement@4e6343ed: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@7038684b: 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=7 com.mysql.jdbc.PreparedStatement@3fae44cd: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@abdd4b8: 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=7 com.mysql.jdbc.PreparedStatement@4b9fe3eb: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@30863a65: 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=7 com.mysql.jdbc.PreparedStatement@619587b7: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@56ccc728: 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=7 com.mysql.jdbc.PreparedStatement@4ce33c28: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@572a74f3: 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=7 com.mysql.jdbc.PreparedStatement@1540d056: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@783f695: 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=7 com.mysql.jdbc.PreparedStatement@5e18669a: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@1cbd79d8: 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=7 com.mysql.jdbc.PreparedStatement@3da51dce: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@7e9d481: 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=7 com.mysql.jdbc.PreparedStatement@7466c042: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@26133c71: 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=7 com.mysql.jdbc.PreparedStatement@34a3c216: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@45cc1d49: 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=7 com.mysql.jdbc.PreparedStatement@50aa4f88: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@61c70a7d: 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=7 com.mysql.jdbc.PreparedStatement@70ec8c75: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@6799b178: 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=7 com.mysql.jdbc.PreparedStatement@61c235cc: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@71dbd08: 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=7 com.mysql.jdbc.PreparedStatement@4331c3a0: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@4926c36b: 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=7 com.mysql.jdbc.PreparedStatement@1ebdc5b8: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@52d9ee10: 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=7 com.mysql.jdbc.PreparedStatement@3bb00382: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@5864425d: 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=7 com.mysql.jdbc.PreparedStatement@60ca3ac5: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@5502ebf0: 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=7 com.mysql.jdbc.PreparedStatement@4a9215d0: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@5ab8d8f0: 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=7 com.mysql.jdbc.PreparedStatement@4b2907eb: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@4183b23d: 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=7 com.mysql.jdbc.PreparedStatement@6f1daeb3: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@3784e56d: 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=7 com.mysql.jdbc.PreparedStatement@18681661: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@45c077c6: 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=7 com.mysql.jdbc.PreparedStatement@4cff9307: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@3da6fe49: 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=7 com.mysql.jdbc.PreparedStatement@2d22d185: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@67568f63: 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=7 com.mysql.jdbc.PreparedStatement@7e42236d: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@55ec2065: 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=7 com.mysql.jdbc.PreparedStatement@225a1c92: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@60d4c0bc: 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=7 com.mysql.jdbc.PreparedStatement@30d85da8: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@3dedd462: 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=7 com.mysql.jdbc.PreparedStatement@33fc160b: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@1d21f395: 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=7 com.mysql.jdbc.PreparedStatement@4bee7a12: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@4b025097: 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=7 com.mysql.jdbc.PreparedStatement@2d280266: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@77966a2a: 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=7 com.mysql.jdbc.PreparedStatement@c3da0ae: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@1e005788: 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=7 com.mysql.jdbc.PreparedStatement@32b8941f: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@289e066d: 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=7 com.mysql.jdbc.PreparedStatement@66ac0be4: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@53b32e49: 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=7 com.mysql.jdbc.PreparedStatement@36a1cc8f: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@23ddb895: 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=7 com.mysql.jdbc.PreparedStatement@2465de55: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@65025eca: 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=7 com.mysql.jdbc.PreparedStatement@25832eaf: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@7f2dca34: 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=7 com.mysql.jdbc.PreparedStatement@400400fb: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@6011cca2: 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=7 com.mysql.jdbc.PreparedStatement@5cb9eefa: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@e0fb61a: 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=7 com.mysql.jdbc.PreparedStatement@31b579fc: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.PreparedStatement@685b02fe: 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=7 com.mysql.jdbc.PreparedStatement@5a937c70: SELECT * FROM tariff_group WHERE id=7 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:748) ========================== Информация о версии: Клиент: вер. 6.2.862 / 30.05.2017 03:57:55 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_131 Сервер: вер. 6.2.1184 / 30.05.2017 04:17:11 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_131 bill: вер. 6.2.103 / 12.05.2017 18:50:32 card: вер. 6.2.43 / 16.03.2017 23:47:47 dialup: вер. 6.2.316 / 12.05.2017 18:52:28 drweb: вер. 6.2.71 / 09.03.2016 11:43:11 email: вер. 6.2.177 / 14.12.2016 14:27:42 inet: вер. 6.2.720 / 30.05.2017 03:55:47 ipn: вер. 6.2.264 / 09.01.2017 16:41:56 mps: вер. 6.2.225 / 17.05.2017 18:35:37 npay: вер. 6.2.200 / 30.05.2017 04:17:18 payonline: вер. 6.2.65 / 01.06.2017 15:55:49 rentsoft: вер. 6.2.63 / 04.10.2016 19:16:26 reports: вер. 6.2.217 / 02.05.2017 12:37:22 ru.bitel.bgbilling.plugins.crm: вер. 6.2.195 / 04.10.2016 19:16:05 ru.bitel.bgbilling.plugins.dispatch: вер. 6.2.97 / 12.05.2017 18:50:40 ru.bitel.bgbilling.plugins.documents: вер. 6.2.176 / 14.12.2016 14:33:16 ru.bitel.bgbilling.plugins.helpdesk: вер. 6.2.182 / 04.10.2016 19:16:06 trayinfo: вер. 6.2.171 / 10.03.2017 18:11:41 voiceip: вер. 6.2.192 / 12.05.2017 18:50:31 wm: вер. 6.2.189 / 04.10.2016 19:16:46 yamoney: вер. 6.2.58 / 04.10.2016 19:16:49 Окружение: Клиент: os: Linux amd64, 4.10.0-30-generic java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_131 jre home: /home/oleg/BGBillingClient_6.2/jdk1.8.0_131/jre default tz: 09.08.2017 13:42 MSK +0300 (Europe/Moscow) user tz: 09.08.2017 13:42 MSK +0300 (Europe/Moscow) locale: ru_RU Сервер: os: Linux amd64, 4.4.0-78-generic java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_131 jre home: /opt/java/jdk1.8.0_131/jre default tz: 09.08.2017 13:42 MSK +0300 (Europe/Moscow) db time: master: 09.08.2017 13:42 MSK db charset: connection: utf8(utf8_unicode_ci), database: utf8(utf8_unicode_ci) locale: en_US uptime: Started: 11.06.2017 08:18:27 Uptime: 59 d 05:24:01 |
Автор: | stark [ 25 сен 2017, 12:04 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
ok-2004 писал(а): ДВС! Сегодня в server.error.log словил : Код: server 08-09/11:17:53 ERROR [http-bio-0.0.0.0-8080-exec-9] DefaultServerSetup - Many statements was open at connection close: com.mysql.jdbc.JDBC4PreparedStatement@55a87ec8: SELECT * FROM tariff_plan ORDER BY title com.mysql.jdbc.JDBC4PreparedStatement@74cc1d17: SELECT * FROM tariff_group WHERE id=7 com.mysql.jdbc.JDBC4PreparedStatement@11633c62: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON [/quote] Какая версия ? 6.2 ? Эту утечку исправили начиная с 7.0. |
Автор: | stark [ 25 сен 2017, 12:13 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Накатили исправление на 6.2. Будет в следующем обновлении. |
Автор: | Cromeshnic [ 01 ноя 2017, 12:10 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Похоже при переобсчёте предыдущего месяца в модуле Inet в error.log: Код: recalculate 11-01/06:32:08 ERROR [worker-p-49-t-3] DefaultServerSetup - Many statements was open at connection close: com.mysql.jdbc.JDBC42PreparedStatement@4244659d: INSERT INTO inet_session_log_account_30_201710 (amount, account, contractId, sessionId, serviceId) VALUES (6967491449,0.00000,165811,14370941,701) ON DUPLICATE KEY UPDATE amount = 6967491449, account = 0.00000 com.mysql.jdbc.JDBC42PreparedStatement@4c4b3d5: UPDATE inet_session_log_30_201710 SET sessionCost=0.00000 WHERE id=14368545 com.mysql.jdbc.JDBC42PreparedStatement@3ad1cacf: UPDATE inet_tariff_traffic_max_30 SET amountMax = 39835680360 , amount1 = 39835680360, amount2 = 5464262760, counter = counter + 1 WHERE contractId = 160622 AND treeNodeId = 914828279535 AND maxKey = 144115188208041993 AND yy =2017 AND mm=10 AND (@counter:=counter) IS NOT NULL com.mysql.jdbc.JDBC42PreparedStatement@5594bd7c: INSERT INTO inet_tariff_traffic_max_30 ( contractId, treeNodeId, maxKey, amountMax, amount1, amount2, yy, mm, counter ) VALUES (** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,1) com.mysql.jdbc.JDBC42PreparedStatement@341d42de: UPDATE inet_tariff_traffic_range_30 SET amount = 39835680360, maxAmount = 298844160000, counter = counter + 1 WHERE contractId = 160622 AND treeNodeId = 914828279533 AND rangeKey = 144115188208041993 AND yy =2017 AND mm=10 AND (@counter:=counter) IS NOT NULL com.mysql.jdbc.JDBC42PreparedStatement@15e60593: INSERT INTO inet_tariff_traffic_range_30 ( contractId, treeNodeId, rangeKey, amount, yy, mm, counter, maxAmount ) VALUES (** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,1,** NOT SPECIFIED **) com.mysql.jdbc.JDBC42PreparedStatement@2dbc4ae0: INSERT INTO inet_tariff_traffic_max_detail_30_201710 ( contractId, treeNodeId, maxKey, day, amountMax, amount1, amount2 ) VALUES (** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **) com.mysql.jdbc.JDBC42PreparedStatement@4fef55b3: UPDATE inet_tariff_traffic_max_detail_30_201710 SET amountMax = 2708035893, amount1 = 2708035893, amount2 = 211808795 WHERE contractId = 160622 AND treeNodeId = 914828279535 AND maxKey = 144115188208041993 AND day = 31 com.mysql.jdbc.JDBC42PreparedStatement@dc516f9: INSERT INTO inet_tariff_traffic_range_detail_30_201710 ( contractId, treeNodeId, rangeKey, day, amount ) VALUES (** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **) ... Kernel version 7.0.1263 / 13.09.2017 20:33:05 Inet version 7.0.772 / 05.09.2017 19:44:59 |
Автор: | Cromeshnic [ 25 дек 2017, 14:23 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
rscm: вер. 7.0.186 / 04.08.2017 17:35:05 RSCMContractServiceManager.updateContractService(...) - тут не закрывается ps |
Автор: | borin [ 18 апр 2018, 16:31 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Добрый день! В связи с печатью карточек к договору, у сервера стали быстро заканчиваться соединения, по совету с телеграм канала включил дебаг. Там куча вот таких соединений: Код: jdbc:mysql://127.0.0.1/bgbilling?useUnicode=true&characterEncoding=UTF-8&connectionCollation=utf8_unicode_ci&allowUrlInLocalInfile=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&elideSetAutoCommits=true&cachePrepStmts=true&useCursorFetch=true&queryTimeoutKillsConnection=true&connectTimeout=1000, UserName=bill@localhost, MySQL Connector Java at ru.bitel.bgbilling.server.util.DefaultServerSetup$1.borrowObject(DefaultServerSetup.java:337) at ru.bitel.bgbilling.server.util.DatabaseConnectionPool$1.getConnection(DatabaseConnectionPool.java:30) at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:588) at bitel.billing.server.util.exslt.DynCodeExecuter.execute(DynCodeExecuter.java:38) at bitel.billing.server.util.exslt.DynCodeExecuter.execute(DynCodeExecuter.java:85) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.apache.xalan.extensions.ExtensionHandlerJavaClass.callFunction(ExtensionHandlerJavaClass.java:284) at org.apache.xalan.extensions.ExtensionHandlerJavaClass.callFunction(ExtensionHandlerJavaClass.java:440) at org.apache.xalan.extensions.ExtensionsTable.extFunction(ExtensionsTable.java:222) at org.apache.xalan.transformer.TransformerImpl.extFunction(TransformerImpl.java:473) at org.apache.xpath.functions.FuncExtFunction.execute(FuncExtFunction.java:208) at org.apache.xpath.Expression.executeCharsToContentHandler(Expression.java:313) at org.apache.xalan.templates.ElemValueOf.execute(ElemValueOf.java:274) at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400) at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:1376) at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400) at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:1376) at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400) at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:1376) at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400) at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:1376) at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400) at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:1376) at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400) at org.apache.xalan.templates.ElemTemplate.execute(ElemTemplate.java:394) at org.apache.xalan.templates.ElemCallTemplate.execute(ElemCallTemplate.java:248) at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400) at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:1376) at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400) at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:1376) at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400) at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:1376) at org.apache.xalan.templates.ElemApplyTemplates.transformSelectedNodes(ElemApplyTemplates.java:395) at org.apache.xalan.templates.ElemApplyTemplates.execute(ElemApplyTemplates.java:178) at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400) at org.apache.xalan.transformer.TransformerImpl.applyTemplateToNode(TransformerImpl.java:2270) at org.apache.xalan.transformer.TransformerImpl.transformNode(TransformerImpl.java:1356) at org.apache.xalan.transformer.TransformerImpl.transform(TransformerImpl.java:709) at org.apache.xalan.transformer.TransformerImpl.transform(TransformerImpl.java:1273) at org.apache.xalan.transformer.TransformerImpl.transform(TransformerImpl.java:1251) at ru.bitel.bgbilling.kernel.container.web.action.XSLManager.transform(XSLManager.java:226) at bitel.billing.server.contract.action.ActionContractCard2.doAction(ActionContractCard2.java:126) at bitel.billing.server.Executer.doModule(SourceFile:600) 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: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) Код: Клиент: вер. 6.2.874 / 05.02.2018 12:48:36
os: Windows 10; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_161 Сервер: вер. 6.2.1203 / 05.02.2018 12:50:34 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_45 |
Автор: | Amir [ 18 апр 2018, 18:34 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Выложили обновление для 6.2 "Kernel: Утечка соединения при использовании DynCodeExecuter в XSLT.". В 7.0 это место было уже переписано, там нет проблемы. |
Автор: | borin [ 19 апр 2018, 10:17 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Amir писал(а): Выложили обновление для 6.2 "Kernel: Утечка соединения при использовании DynCodeExecuter в XSLT.". В 7.0 это место было уже переписано, там нет проблемы. Спасибо, вот теперь красота ) |
Автор: | Dog [ 31 июл 2018, 18:04 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Код: java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369
at ru.bitel.bgbilling.server.dbcp.DbcpPoolableConnection.close(DbcpPoolableConnection.java:53) at ru.bitel.bgbilling.server.dbcp.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48) at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:308) 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:651) 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) |
Автор: | Artur [ 01 авг 2018, 14:11 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
В какой момент это произошло? |
Автор: | Dog [ 01 авг 2018, 16:39 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
без понятия, вот что было до и после: Код: com.mysql.jdbc.ServerPreparedStatement[7252] - SELECT * FROM inet_serv_type_20 ORDER BY id
com.mysql.jdbc.ServerPreparedStatement[7253] - SELECT deviceTypeId FROM inet_serv_type_device_type_link_20 WHERE inetServId=5 com.mysql.jdbc.ServerPreparedStatement[7254] - SELECT deviceGroupId FROM inet_serv_type_device_group_link_20 WHERE inetServId=5 com.mysql.jdbc.ServerPreparedStatement[7255] - SELECT * FROM inet_serv_20 WHERE parentId=8979 ORDER BY id com.mysql.jdbc.ServerPreparedStatement[7265] - SELECT * FROM tv_account_22 WHERE parentId=319 ORDER BY id com.mysql.jdbc.ServerPreparedStatement[7266] - SELECT * FROM tv_account_22 WHERE id=319 com.mysql.jdbc.ServerPreparedStatement[7268] - SELECT * FROM inv_product WHERE contractId=6357 AND id=552 com.mysql.jdbc.ServerPreparedStatement[7270] - SELECT * FROM inv_service WHERE contractId=6357 AND productId=552 com.mysql.jdbc.ServerPreparedStatement[7272] - SELECT * FROM inv_product_period WHERE contractId=6357 AND productId=552 ORDER BY id com.mysql.jdbc.ServerPreparedStatement[7274] - SELECT mid FROM contract_module WHERE cid=null AND mid=null FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7280] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7291] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7295] - SELECT mid FROM contract_module WHERE cid=6357 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7284] - SELECT SUM(ROUND(contract_account.summa, 2)) FROM contract LEFT JOIN contract_account ON contract_account.cid=contract.id AND contract_account.yy=2014 AND contract_account.mm=9 WHERE contract.id=6357 OR (contract.scid=6357 AND contract.sub_mode=0) com.mysql.jdbc.ServerPreparedStatement[7285] - UPDATE contract_balance SET summa3='699.00' WHERE yy=2014 AND mm=9 AND cid=6357 com.mysql.jdbc.ServerPreparedStatement[7288] - SELECT yy, mm, summa1, (summa2 - summa3 - summa4) FROM contract_balance WHERE cid=6357 AND ( (yy=2014 AND mm>=9) OR yy>2014 ) ORDER BY yy, mm com.mysql.jdbc.ServerPreparedStatement[7289] - UPDATE contract_balance SET summa1='851.01' WHERE cid=6357 AND yy=2015 AND mm=8 com.mysql.jdbc.ServerPreparedStatement[7317] - SELECT mid FROM contract_module WHERE cid=null AND mid=null FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7320] - SELECT mid FROM contract_module WHERE cid=6357 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7334] - SELECT SUM(ROUND(contract_account.summa, 2)) FROM contract LEFT JOIN contract_account ON contract_account.cid=contract.id AND contract_account.yy=2014 AND contract_account.mm=12 WHERE contract.id=6357 OR (contract.scid=6357 AND contract.sub_mode=0) com.mysql.jdbc.ServerPreparedStatement[7335] - UPDATE contract_balance SET summa3='699.00' WHERE yy=2014 AND mm=12 AND cid=6357 com.mysql.jdbc.ServerPreparedStatement[7336] - SELECT yy, mm, summa1, (summa2 - summa3 - summa4) FROM contract_balance WHERE cid=6357 AND ( (yy=2014 AND mm>=12) OR yy>2014 ) ORDER BY yy, mm com.mysql.jdbc.ServerPreparedStatement[7337] - UPDATE contract_balance SET summa1='851.01' WHERE cid=6357 AND yy=2015 AND mm=8 com.mysql.jdbc.ServerPreparedStatement[7340] - SELECT mid FROM contract_module WHERE cid=6357 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7354] - SELECT SUM(ROUND(contract_account.summa, 2)) FROM contract LEFT JOIN contract_account ON contract_account.cid=contract.id AND contract_account.yy=2015 AND contract_account.mm=1 WHERE contract.id=6357 OR (contract.scid=6357 AND contract.sub_mode=0) com.mysql.jdbc.ServerPreparedStatement[7355] - UPDATE contract_balance SET summa3='699.00' WHERE yy=2015 AND mm=1 AND cid=6357 com.mysql.jdbc.ServerPreparedStatement[7356] - SELECT yy, mm, summa1, (summa2 - summa3 - summa4) FROM contract_balance WHERE cid=6357 AND ( (yy=2015 AND mm>=1) OR yy>2015 ) ORDER BY yy, mm com.mysql.jdbc.ServerPreparedStatement[7357] - UPDATE contract_balance SET summa1='851.01' WHERE cid=6357 AND yy=2015 AND mm=8 com.mysql.jdbc.ServerPreparedStatement[7360] - SELECT mid FROM contract_module WHERE cid=6357 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7374] - SELECT SUM(ROUND(contract_account.summa, 2)) FROM contract LEFT JOIN contract_account ON contract_account.cid=contract.id AND contract_account.yy=2015 AND contract_account.mm=2 WHERE contract.id=6357 OR (contract.scid=6357 AND contract.sub_mode=0) com.mysql.jdbc.ServerPreparedStatement[7375] - UPDATE contract_balance SET summa3='699.00' WHERE yy=2015 AND mm=2 AND cid=6357 com.mysql.jdbc.ServerPreparedStatement[7376] - SELECT yy, mm, summa1, (summa2 - summa3 - summa4) FROM contract_balance WHERE cid=6357 AND ( (yy=2015 AND mm>=2) OR yy>2015 ) ORDER BY yy, mm com.mysql.jdbc.ServerPreparedStatement[7377] - UPDATE contract_balance SET summa1='851.01' WHERE cid=6357 AND yy=2015 AND mm=8 com.mysql.jdbc.ServerPreparedStatement[7380] - SELECT mid FROM contract_module WHERE cid=6357 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7394] - SELECT SUM(ROUND(contract_account.summa, 2)) FROM contract LEFT JOIN contract_account ON contract_account.cid=contract.id AND contract_account.yy=2015 AND contract_account.mm=3 WHERE contract.id=6357 OR (contract.scid=6357 AND contract.sub_mode=0) com.mysql.jdbc.ServerPreparedStatement[7395] - UPDATE contract_balance SET summa3='699.00' WHERE yy=2015 AND mm=3 AND cid=6357 com.mysql.jdbc.ServerPreparedStatement[7396] - SELECT yy, mm, summa1, (summa2 - summa3 - summa4) FROM contract_balance WHERE cid=6357 AND ( (yy=2015 AND mm>=3) OR yy>2015 ) ORDER BY yy, mm com.mysql.jdbc.ServerPreparedStatement[7397] - UPDATE contract_balance SET summa1='851.01' WHERE cid=6357 AND yy=2015 AND mm=8 com.mysql.jdbc.ServerPreparedStatement[7400] - SELECT mid FROM contract_module WHERE cid=6357 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7414] - SELECT SUM(ROUND(contract_account.summa, 2)) FROM contract LEFT JOIN contract_account ON contract_account.cid=contract.id AND contract_account.yy=2015 AND contract_account.mm=4 WHERE contract.id=6357 OR (contract.scid=6357 AND contract.sub_mode=0) com.mysql.jdbc.ServerPreparedStatement[7415] - UPDATE contract_balance SET summa3='699.00' WHERE yy=2015 AND mm=4 AND cid=6357 com.mysql.jdbc.ServerPreparedStatement[7416] - SELECT yy, mm, summa1, (summa2 - summa3 - summa4) FROM contract_balance WHERE cid=6357 AND ( (yy=2015 AND mm>=4) OR yy>2015 ) ORDER BY yy, mm com.mysql.jdbc.ServerPreparedStatement[7417] - UPDATE contract_balance SET summa1='851.01' WHERE cid=6357 AND yy=2015 AND mm=8 com.mysql.jdbc.ServerPreparedStatement[7420] - SELECT mid FROM contract_module WHERE cid=6357 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7434] - SELECT SUM(ROUND(contract_account.summa, 2)) FROM contract LEFT JOIN contract_account ON contract_account.cid=contract.id AND contract_account.yy=2015 AND contract_account.mm=5 WHERE contract.id=6357 OR (contract.scid=6357 AND contract.sub_mode=0) com.mysql.jdbc.ServerPreparedStatement[7435] - UPDATE contract_balance SET summa3='699.00' WHERE yy=2015 AND mm=5 AND cid=6357 com.mysql.jdbc.ServerPreparedStatement[7436] - SELECT yy, mm, summa1, (summa2 - summa3 - summa4) FROM contract_balance WHERE cid=6357 AND ( (yy=2015 AND mm>=5) OR yy>2015 ) ORDER BY yy, mm com.mysql.jdbc.ServerPreparedStatement[7437] - UPDATE contract_balance SET summa1='851.01' WHERE cid=6357 AND yy=2015 AND mm=8 com.mysql.jdbc.ServerPreparedStatement[7440] - SELECT mid FROM contract_module WHERE cid=6357 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7454] - SELECT SUM(ROUND(contract_account.summa, 2)) FROM contract LEFT JOIN contract_account ON contract_account.cid=contract.id AND contract_account.yy=2015 AND contract_account.mm=6 WHERE contract.id=6357 OR (contract.scid=6357 AND contract.sub_mode=0) com.mysql.jdbc.ServerPreparedStatement[7455] - UPDATE contract_balance SET summa3='699.00' WHERE yy=2015 AND mm=6 AND cid=6357 com.mysql.jdbc.ServerPreparedStatement[7456] - SELECT yy, mm, summa1, (summa2 - summa3 - summa4) FROM contract_balance WHERE cid=6357 AND ( (yy=2015 AND mm>=6) OR yy>2015 ) ORDER BY yy, mm com.mysql.jdbc.ServerPreparedStatement[7457] - UPDATE contract_balance SET summa1='851.01' WHERE cid=6357 AND yy=2015 AND mm=8 com.mysql.jdbc.ServerPreparedStatement[7460] - SELECT mid FROM contract_module WHERE cid=6357 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7474] - SELECT SUM(ROUND(contract_account.summa, 2)) FROM contract LEFT JOIN contract_account ON contract_account.cid=contract.id AND contract_account.yy=2015 AND contract_account.mm=7 WHERE contract.id=6357 OR (contract.scid=6357 AND contract.sub_mode=0) com.mysql.jdbc.ServerPreparedStatement[7475] - UPDATE contract_balance SET summa3='699.00' WHERE yy=2015 AND mm=7 AND cid=6357 com.mysql.jdbc.ServerPreparedStatement[7476] - SELECT yy, mm, summa1, (summa2 - summa3 - summa4) FROM contract_balance WHERE cid=6357 AND ( (yy=2015 AND mm>=7) OR yy>2015 ) ORDER BY yy, mm com.mysql.jdbc.ServerPreparedStatement[7477] - UPDATE contract_balance SET summa1='851.01' WHERE cid=6357 AND yy=2015 AND mm=8 com.mysql.jdbc.ServerPreparedStatement[7480] - SELECT mid FROM contract_module WHERE cid=6357 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7494] - SELECT SUM(ROUND(contract_account.summa, 2)) FROM contract LEFT JOIN contract_account ON contract_account.cid=contract.id AND contract_account.yy=2015 AND contract_account.mm=8 WHERE contract.id=6357 OR (contract.scid=6357 AND contract.sub_mode=0) com.mysql.jdbc.ServerPreparedStatement[7495] - UPDATE contract_balance SET summa3='699.00' WHERE yy=2015 AND mm=8 AND cid=6357 com.mysql.jdbc.ServerPreparedStatement[7496] - SELECT yy, mm, summa1, (summa2 - summa3 - summa4) FROM contract_balance WHERE cid=6357 AND ( (yy=2015 AND mm>=8) OR yy>2015 ) ORDER BY yy, mm com.mysql.jdbc.ServerPreparedStatement[7497] - UPDATE contract_balance SET summa1=null WHERE cid=6357 AND yy=null AND mm=null com.mysql.jdbc.ServerPreparedStatement[7500] - SELECT mid FROM contract_module WHERE cid=6357 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7514] - SELECT SUM(ROUND(contract_account.summa, 2)) FROM contract LEFT JOIN contract_account ON contract_account.cid=contract.id AND contract_account.yy=2015 AND contract_account.mm=9 WHERE contract.id=6357 OR (contract.scid=6357 AND contract.sub_mode=0) com.mysql.jdbc.ServerPreparedStatement[7515] - UPDATE contract_balance SET summa3='0' WHERE yy=2015 AND mm=9 AND cid=6357 com.mysql.jdbc.ServerPreparedStatement[7516] - SELECT summa1 + summa2 - summa3 - summa4 FROM contract_balance WHERE cid=6357 AND (yy*12 + mm)<=24188 ORDER BY (yy*12 + mm) DESC LIMIT 1 com.mysql.jdbc.ServerPreparedStatement[7517] - INSERT INTO contract_balance (yy, mm, cid, summa1, summa3) VALUES (2015, 9, 6357, '152.01', '0') com.mysql.jdbc.ServerPreparedStatement[7518] - SELECT yy, mm, summa1, (summa2 - summa3 - summa4) FROM contract_balance WHERE cid=6357 AND ( (yy=2015 AND mm>=9) OR yy>2015 ) ORDER BY yy, mm com.mysql.jdbc.ServerPreparedStatement[7519] - UPDATE contract_balance SET summa1=null WHERE cid=6357 AND yy=null AND mm=null com.mysql.jdbc.ServerPreparedStatement[7522] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7532] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7536] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7540] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7544] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7548] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7552] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7556] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7560] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7564] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7568] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7572] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7576] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7580] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7584] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7588] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7592] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7596] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7600] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7604] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7608] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7612] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7616] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7620] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7624] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7628] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7632] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7636] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[7640] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369 at ru.bitel.bgbilling.server.dbcp.DbcpPoolableConnection.close(DbcpPoolableConnection.java:53) at ru.bitel.bgbilling.server.dbcp.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48) at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:308) 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:651) 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) 07-30/11:44:29 DEBUG [http-bio-0.0.0.0-8443-exec-6] CommonExecutor - executing bitel.billing.server.contract.action.ActionDeleteContract; time => 3178 ms. 07-30/11:44:31 DEBUG [http-bio-0.0.0.0-8443-exec-4] CommonExecutor - executing bitel.billing.server.admin.action.ActionCommand; time => 3 ms. 07-30/11:44:34 DEBUG [http-bio-0.0.0.0-8443-exec-3] ResourceManager - Inject to ru.bitel.oss.systems.inventory.resource.common.DeviceInterfaceService ru.bitel.bgbilling.modules.inet.api.server.service.InetDeviceServiceImpl.devicePortService ru.bitel.oss.systems.inventory.resource.server.DeviceInterfaceServiceImpl@4f565e0 07-30/11:44:34 DEBUG [http-bio-0.0.0.0-8443-exec-3] ResourceManager - Inject to ru.bitel.oss.systems.inventory.resource.common.ResourceService ru.bitel.bgbilling.modules.inet.api.server.service.InetServServiceImpl.wsResoure ru.bitel.oss.systems.inventory.resource.server.ResourceServiceImpl@33b4a7e2 07-30/11:44:34 DEBUG [http-bio-0.0.0.0-8443-exec-3] ResourceManager - Inject to ru.bitel.oss.systems.inventory.resource.common.DeviceInterfaceService ru.bitel.bgbilling.modules.inet.api.server.service.InetServServiceImpl.deviceInterfaceService ru.bitel.oss.systems.inventory.resource.server.DeviceInterfaceServiceImpl@4f565e0 07-30/11:44:34 DEBUG [http-bio-0.0.0.0-8443-exec-3] ResourceManager - Inject to ru.bitel.bgbilling.modules.inet.api.common.service.InetServService ru.bitel.bgbilling.modules.inet.api.server.service.InetDeviceServiceImpl.inetServService ru.bitel.bgbilling.modules.inet.api.server.service.InetServServiceImpl@277a5666 07-30/11:44:34 DEBUG [http-bio-0.0.0.0-8443-exec-3] AbstractJaxWsHandler - executing ru.bitel.bgbilling.modules.inet.api.server.service.InetDeviceServiceImpl.inetDeviceGet; time => 18 ms. |
Автор: | Dog [ 01 авг 2018, 16:40 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Код: com.mysql.jdbc.ServerPreparedStatement[4120] - SELECT * FROM inet_serv_type_20 ORDER BY id
com.mysql.jdbc.ServerPreparedStatement[4121] - SELECT deviceTypeId FROM inet_serv_type_device_type_link_20 WHERE inetServId=10 com.mysql.jdbc.ServerPreparedStatement[4122] - SELECT deviceGroupId FROM inet_serv_type_device_group_link_20 WHERE inetServId=10 com.mysql.jdbc.ServerPreparedStatement[4123] - SELECT * FROM inet_serv_20 WHERE parentId=14313 ORDER BY id com.mysql.jdbc.ServerPreparedStatement[4135] - SELECT * FROM tv_account_22 WHERE parentId=139 ORDER BY id com.mysql.jdbc.ServerPreparedStatement[4136] - SELECT * FROM tv_account_22 WHERE id=139 com.mysql.jdbc.ServerPreparedStatement[4138] - SELECT * FROM inv_product WHERE contractId=389 AND id=146 com.mysql.jdbc.ServerPreparedStatement[4140] - SELECT * FROM inv_service WHERE contractId=389 AND productId=146 com.mysql.jdbc.ServerPreparedStatement[4142] - SELECT * FROM inv_product_period WHERE contractId=389 AND productId=146 ORDER BY id com.mysql.jdbc.ServerPreparedStatement[4144] - SELECT mid FROM contract_module WHERE cid=null AND mid=null FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4150] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4159] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4163] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4167] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4171] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4175] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4179] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4183] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4187] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4191] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4195] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4199] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4203] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4207] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4211] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4215] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4219] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4223] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4227] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4231] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4235] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4239] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4243] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4249] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4253] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4257] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4261] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4265] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4269] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4273] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4277] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4281] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4285] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4289] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4293] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4297] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4301] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4305] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4309] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4313] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4317] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4321] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4325] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4329] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4333] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4337] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4341] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4345] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4349] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4353] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4357] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4361] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4365] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4369] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4373] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4377] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4381] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4385] - SELECT mid FROM contract_module WHERE cid=-1 AND mid=22 FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[4391] - SELECT serv.*, contract.scid, contract.sub_mode FROM inet_serv_20 AS serv LEFT JOIN contract ON serv.contractId=contract.id WHERE serv.id=14313 com.mysql.jdbc.ServerPreparedStatement[4395] - SELECT * FROM inet_serv_type_20 WHERE id=10 com.mysql.jdbc.ServerPreparedStatement[4397] - SELECT * FROM inv_ip_resource_subscription_20 WHERE id=61753 com.mysql.jdbc.ServerPreparedStatement[4419] - DELETE FROM contract WHERE id=389 com.mysql.jdbc.ServerPreparedStatement[4420] - DELETE FROM contract_service WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4421] - DELETE FROM contract_status WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4422] - DELETE FROM contract_module WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4423] - DELETE FROM contract_payment WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4424] - DELETE FROM contract_payment_deleted WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4425] - DELETE FROM contract_charge WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4426] - DELETE FROM contract_tariff WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4427] - DELETE FROM contract_balance WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4428] - DELETE FROM contract_account WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4429] - DELETE FROM contract_comment WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4430] - DELETE FROM contract_tariff_option WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4431] - DELETE FROM contract_script WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4432] - DELETE FROM contract_status_log WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4433] - DELETE FROM contract_tariff_group WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4436] - DELETE FROM contract_parameter_type_1 WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4437] - DELETE FROM contract_parameter_type_1_log WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4438] - DELETE FROM contract_parameter_type_2 WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4439] - DELETE FROM contract_parameter_type_2_log WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4440] - DELETE FROM contract_parameter_type_3 WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4441] - DELETE FROM contract_parameter_type_3_log WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4442] - DELETE FROM contract_parameter_type_4 WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4443] - DELETE FROM contract_parameter_type_4_log WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4444] - DELETE FROM contract_parameter_type_5 WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4445] - DELETE FROM contract_parameter_type_5_log WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4446] - DELETE FROM contract_parameter_type_6 WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4447] - DELETE FROM contract_parameter_type_6_log WHERE cid=389 com.mysql.jdbc.ServerPreparedStatement[4448] - DELETE FROM contract_parameter_type_7 WHERE cid=389 java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369 at ru.bitel.bgbilling.server.dbcp.DbcpPoolableConnection.close(DbcpPoolableConnection.java:53) at ru.bitel.bgbilling.server.dbcp.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48) at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:308) 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:651) 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) 07-30/11:45:22 DEBUG [http-bio-0.0.0.0-8443-exec-4] CommonExecutor - executing bitel.billing.server.contract.action.ActionDeleteContract; time => 1330 ms. 07-30/11:45:26 DEBUG [http-bio-0.0.0.0-8443-exec-5] ResourceManager - Inject to ru.bitel.oss.systems.inventory.resource.common.ResourceService ru.bitel.bgbilling.modules.inet.api.server.service.InetServServiceImpl.wsResoure ru.bitel.oss.systems.inventory.resource.server.ResourceServiceImpl@752ea18c 07-30/11:45:26 DEBUG [http-bio-0.0.0.0-8443-exec-5] ResourceManager - Inject to ru.bitel.oss.systems.inventory.resource.common.DeviceInterfaceService ru.bitel.bgbilling.modules.inet.api.server.service.InetServServiceImpl.deviceInterfaceService ru.bitel.oss.systems.inventory.resource.server.DeviceInterfaceServiceImpl@4ac05783 07-30/11:45:26 DEBUG [http-bio-0.0.0.0-8443-exec-5] AbstractJaxWsHandler - executing ru.bitel.bgbilling.modules.inet.api.server.service.InetServServiceImpl.inetServTypeList; time => 22 ms. 07-30/11:45:26 DEBUG [http-bio-0.0.0.0-8443-exec-3] PermissionChecker - Action InetServService:inetServOptionList not found in dictionary for module 20 07-30/11:45:26 DEBUG [http-bio-0.0.0.0-8443-exec-3] ResourceManager - Inject to ru.bitel.oss.systems.inventory.resource.common.ResourceService ru.bitel.bgbilling.modules.inet.api.server.service.InetServServiceImpl.wsResoure ru.bitel.oss.systems.inventory.resource.server.ResourceServiceImpl@492ce4d7 07-30/11:45:26 DEBUG [http-bio-0.0.0.0-8443-exec-3] ResourceManager - Inject to ru.bitel.oss.systems.inventory.resource.common.DeviceInterfaceService ru.bitel.bgbilling.modules.inet.api.server.service.InetServServiceImpl.deviceInterfaceService ru.bitel.oss.systems.inventory.resource.server.DeviceInterfaceServiceImpl@236a25ab |
Автор: | Cromeshnic [ 01 сен 2018, 12:57 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
В RSCMContractServiceManager не закрывается ps: Код: ... com.mysql.jdbc.PreparedStatement@3e72346d: INSERT INTO rscm_service_account_5 SET sid=885, date='2018-09-01', amount=1, comment='', cid=149407 com.mysql.jdbc.PreparedStatement@6db49867: INSERT INTO rscm_service_account_5 SET sid=885, date='2018-09-01', amount=1, comment='', cid=283207 java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369 at ru.bitel.bgbilling.server.dbcp.DbcpPoolableConnection.close(DbcpPoolableConnection.java:53) at ru.bitel.bgbilling.server.dbcp.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48) ... - Код: public void updateContractService(RSCMContractService contractService) throws BGException { try { PreparedStatement ps = null; Date month = contractService.getDate(); if (contractService.getId() > 0) { ps = this.con.prepareStatement("UPDATE " + this.tableName + " SET sid=?, date=?, amount=?, comment=? WHERE id=?"); ps.setInt(5, contractService.getId()); } else { ps = this.con.prepareStatement("INSERT INTO " + this.tableName + " SET sid=?, date=?, amount=?, comment=?, cid=?", 1); ps.setInt(5, contractService.getContractId()); } ps.setInt(1, contractService.getServiceId()); ps.setDate(2, TimeUtils.convertDateToSqlDate(month)); ps.setLong(3, contractService.getAmount()); ps.setString(4, contractService.getComment()); ps.executeUpdate(); if (contractService.getId() <= 0) { contractService.setId(ServerUtils.lastInsertId(ps)); } } catch (SQLException ex) { throw new BGException(ex); } } rscm: вер. 7.0.190 / 31.05.2018 15:53:23 |
Автор: | Cromeshnic [ 01 сен 2018, 15:03 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
При пересчёте в модуле Inet за прошлый месяц: Код: ... com.mysql.jdbc.JDBC42PreparedStatement@68728705: UPDATE inet_tariff_traffic_range_30 SET amount = 8606648065, maxAmount = 15728640000, counter = counter + 1 WHERE contractId = 201354 AND treeNodeId = 914828279511 AND rangeKey = 144115188208107527 AND yy =2018 AND mm=8 AND (@counter:=counter) IS NOT NULL com.mysql.jdbc.JDBC42PreparedStatement@30fb182: INSERT INTO inet_tariff_traffic_range_30 ( contractId, treeNodeId, rangeKey, amount, yy, mm, counter, maxAmount ) VALUES (** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,1,** NOT SPECIFIED **) com.mysql.jdbc.JDBC42PreparedStatement@4a0e0743: INSERT INTO inet_tariff_traffic_max_detail_30_201808 ( contractId, treeNodeId, maxKey, day, amountMax, amount1, amount2 ) VALUES (** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **) com.mysql.jdbc.JDBC42PreparedStatement@28e5beb3: UPDATE inet_tariff_traffic_max_detail_30_201808 SET amountMax = ** NOT SPECIFIED **, amount1 = ** NOT SPECIFIED **, amount2 = ** NOT SPECIFIED ** WHERE contractId = ** NOT SPECIFIED ** AND treeNodeId = ** NOT SPECIFIED ** AND maxKey = ** NOT SPECIFIED ** AND day = ** NOT SPECIFIED ** com.mysql.jdbc.JDBC42PreparedStatement@3163a9c5: INSERT INTO inet_tariff_traffic_range_detail_30_201808 ( contractId, treeNodeId, rangeKey, day, amount ) VALUES (** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **) com.mysql.jdbc.JDBC42PreparedStatement@3476997c: UPDATE inet_tariff_traffic_range_detail_30_201808 SET amount=582209241 WHERE contractId = 201354 AND treeNodeId = 914828279511 AND rangeKey = 144115188208107527 AND day = 31 java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369 at ru.bitel.bgbilling.server.dbcp.DbcpPoolableConnection.close(DbcpPoolableConnection.java:53) at ru.bitel.bgbilling.server.dbcp.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48) ... inet: вер. 7.0.928 / 07.08.2018 19:50:48 |
Автор: | spectrum [ 01 окт 2018, 16:39 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
spectrum писал(а): Выполняется следующий код: Код: public void chargeNpay(Vars vars, ArrayList<Integer> chargingContractsList) { String email = null; int serviceSet = 0; String cids = chargingContractsList.get(0).toString(); //Формируем строку из списка договоров. Количество около 300 шт if (chargingContractsList.size() > 1) { for (int i = 1; i < chargingContractsList.size(); i++) { cids = cids + "," + chargingContractsList.get(i).toString(); } } new RunTaskDataManager(vars.con) .addTask(new Recalculator(NPAY_MID, Calendar.getInstance(), email, serviceSet, cids, "")); } В логах: Код: 06-01/12:01:11 INFO [Thread-12] RunTaskDataManager - get next tasks: new task id=22483 bitel.billing.server.npay.Recalculator@1f1c8a6 06-01/12:01:11 INFO [Thread-12] TaskRunProcessor - Running Task: bitel.billing.server.npay.Recalculator@1f1c8a6 06-01/12:01:11 INFO [pool-1-thread-8] Recalculator - PaymentRecalculator time: 01.06.2017 23 06-01/12:01:11 INFO [pool-1-thread-8] Calculator - Memory total: 68 157 440; max: 239 075 328; free: 20 726 096 Memory pools: Non-heap memory[Code Cache]: max: 251 658 240; used: 29 536 704; peek: 29 548 352 Non-heap memory[Metaspace]: max: -1; used: 30 984 232; peek: 30 984 232 Non-heap memory[Compressed Class Space]: max: 1 073 741 824; used: 3 321 064; peek: 3 342 288 Heap memory[PS Eden Space]: max: 84 934 656; used: 3 044 768; peek: 52 953 088 Heap memory[PS Survivor Space]: max: 2 097 152; used: 229 376; peek: 8 646 240 Heap memory[PS Old Gen]: max: 179 306 496; used: 44 157 200; peek: 59 567 016 Thread count: 55 06-01/12:01:13 INFO [pool-2-thread-7] LoggingPrintStream - FractionalChrageNpay end 06-01/12:01:13 ERROR [pool-2-thread-7] DefaultServerSetup - Many statements was open at connection close: com.mysql.jdbc.ServerPreparedStatement[25] - SELECT * FROM global_script_link WHERE id=8 com.mysql.jdbc.PreparedStatement@3f4858e8: SELECT * FROM contract WHERE id=5118 com.mysql.jdbc.PreparedStatement@195f3364: SELECT * FROM contract WHERE id=4610 com.mysql.jdbc.PreparedStatement@2538e770: SELECT * FROM contract WHERE id=4610 com.mysql.jdbc.PreparedStatement@4916910b: SELECT * FROM contract WHERE id=4610 Плюс много таких строк . . . 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.common.worker.ThreadContext.pop(ThreadContext.java:54) at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:90) 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) 06-01/12:01:13 INFO [pool-2-thread-7] GlobalScriptTimer - Task finished time=13181 ms. 06-01/12:01:15 INFO [pool-1-thread-8] Calculator - Setting balances for independ and subs.. 06-01/12:01:15 INFO [pool-1-thread-8] Calculator - Selected. 06-01/12:01:21 INFO [pool-1-thread-8] Calculator - Selecting sub account 06-01/12:01:21 INFO [pool-1-thread-8] Calculator - Selected. 06-01/12:01:21 INFO [pool-1-thread-8] Calculator - Setting balance for super.. 06-01/12:01:21 INFO [pool-1-thread-8] Calculator - Selected. 06-01/12:01:21 INFO [pool-1-thread-8] Calculator - Task finished time=9818 ms. 06-01/12:01:21 INFO [pool-1-thread-8] Recalculator - RunTask finished time=9818 ms. About: Код: Информация о версии: Клиент: вер. 6.2.855 / 20.03.2017 20:56:51 os: Windows 7; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_121 Сервер: вер. 6.2.1169 / 21.03.2017 18:23:05 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_60 bvcom: вер. 6.2.95 / 14.07.2016 14:11:19 card: вер. 6.2.43 / 16.03.2017 23:47:47 enaza: вер. 6.2.60 / 10.03.2017 18:11:30 gorod: вер. 6.2.164 / 01.03.2016 00:18:32 inet: вер. 6.2.714 / 20.03.2017 20:51:11 mps: вер. 6.2.223 / 21.03.2017 16:41:20 npay: вер. 6.2.198 / 03.02.2017 21:00:04 rentsoft: вер. 6.2.63 / 04.10.2016 19:16:26 reports: вер. 6.2.216 / 15.03.2017 19:48:19 Сервер: os: Linux amd64, 3.10.0-229.11.1.el7.x86_64 java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_60 jre home: /opt/jdk1.8.0_60/jre default tz: 01.06.2017 14:23 MSK +0300 (Europe/Moscow) db time: master: 01.06.2017 14:23 MSK db charset: connection: utf8(utf8_unicode_ci), database: utf8(utf8_unicode_ci) locale: ru_RU uptime: Started: 12.05.2017 06:48:24 Uptime: 20 d 07:35:19 Чем чревата эта ошибка и как исправить? UPD: кстати, в SELECT много повторяющихся строк с одним и тем же id. Это и в переведенном отрывке видно. Ошибки так до сих пор и валятся после запуска: Код: new RunTaskDataManager(vars.con) .addTask(new Recalculator(NPAY_MID, Calendar.getInstance(), email, serviceSet, cids, "")); cids - это String с большим количеством cid. Например таким: "5117,5118,5132,5133,5134,5139....". 145 штук договоров. Сегодня при использовании этого метода произошла очень неприятная ситуация - почему-то было произведено начисление вообще по всем договорам, а не только из списка. |
Автор: | dimOn [ 01 окт 2018, 18:14 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
ну версия у вас очень старая, там давно могли уже исправить. прежде всего обновиться до последних билдов. Цитата: Сегодня при использовании этого метода произошла очень неприятная ситуация - почему-то было произведено начисление вообще по всем договорам, а не только из списка. ну это с описываемым не связано. может просто кто-то руками тупо переобсчёт запустил из клиента, не выбрав конкретный договор ткнули кнопку начисление потому что код такой тоже не мог к такому привести. там cids напрямую во всех sql-запросах используется в калькуляторе. |
Автор: | spectrum [ 01 окт 2018, 19:03 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Версия сейчас такая: Код: Клиент: вер. 7.1.114 / 06.07.2018 09:21:23
os: Windows 7; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_161 Сервер: вер. 7.1.991 / 06.07.2018 09:23:09 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_161 bvcom: вер. 7.0.99 / 14.03.2018 16:03:00 card: вер. 7.1.189 / 08.06.2018 11:12:58 enaza: вер. 7.1.43 / 21.03.2018 14:09:36 gorod: вер. 7.1.149 / 21.03.2018 14:09:42 inet: вер. 7.1.605 / 03.07.2018 17:58:03 mps: вер. 7.1.177 / 20.06.2018 19:22:00 npay: вер. 7.1.169 / 06.06.2018 16:25:24 rentsoft: вер. 7.1.39 / 20.04.2018 19:06:13 reports: вер. 7.1.188 / 22.06.2018 19:05:15 sberbank: вер. 7.1.26 / 06.06.2018 16:25:28 tv: вер. 7.1.185 / 22.06.2018 19:04:40 Окружение: Клиент: os: Windows 7 amd64, 6.1 java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_161 jre home: C:\Program Files\Java\jre1.8.0_161 memory (use/total/max): 202M/271M/455M default tz: 01.10.2018 15:59 MSK +0300 (Europe/Moscow) user tz: 01.10.2018 15:59 MSK +0300 (Europe/Moscow) locale: ru_RU Сервер: os: Linux amd64, 3.10.0-693.17.1.el7.x86_64 java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_161 jre home: /opt/jdk1.8.0_161/jre default tz: 01.10.2018 15:58 MSK +0300 (Europe/Moscow) memory (use/total/max): 325M/494M/494M db time: master: 01.10.2018 15:58 MSK db charset: connection: utf8(utf8_unicode_ci), database: utf8(utf8_unicode_ci) locale: ru_RU uptime: Started: 14.09.2018 17:32:16 Uptime: 16 d 22:26:02 |
Автор: | dimOn [ 07 окт 2018, 01:10 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
ну так это ваш код или как? new RunTaskDataManager(vars.con) .addTask(new Recalculator(NPAY_MID, Calendar.getInstance(), email, serviceSet, cids, "")); что такое vars.con, откуда оно бёрется? этот коннекшен потом закрывается корректно? |
Автор: | spectrum [ 16 окт 2018, 19:11 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Да, это коннекшен: vars.con = connectionSet.getConnection(); Его необходимо закрывать? Этот метод new RunTaskDataManager(vars.con).addTask(new Recalculator(NPAY_MID, Calendar.getInstance(), email, serviceSet, cids, "")); вызывается только один раз в скрипте в конце исполнения, но в cids много договоров, около 150 шт за раз. |
Автор: | [LTC]Dimonyga [ 27 дек 2018, 19:21 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Цитата: com.mysql.cj.jdbc.ServerPreparedStatement[935]: SELECT mid FROM contract_module WHERE cid=** NOT SPECIFIED AND mid= NOT SPECIFIED ** FOR UPDATE java.lang.RuntimeException: viewtopic.php?t=7369 at ru.bitel.bgbilling.server.dbcp.DbcpPoolableConnection.close(DbcpPoolableConnection.java:53) at ru.bitel.bgbilling.server.dbcp.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48) Только только обновил 7.0 на 7.1 Цитата: Java version is 1.8 (1.8.0_121)
BGBillingServer v 7.1.1078 / 26.12.2018 12:39:55 |
Автор: | Phricker [ 29 янв 2019, 09:46 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Код: Сервер: вер. 7.2.932 / 27.01.2019 11:30:23 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_191 Код: server 01-29/06:09:06 ERROR [http-nio-127.0.0.1-8080-exec-7] LoggingPrintStream - Warning: Could not get charToByteConverterClass!
mq 01-29/06:23:25 ERROR [event-proc-p-2-t-1] DbcpPoolableConnection - Many statements was open at connection close: com.mysql.jdbc.ServerPreparedStatement[168937] - SELECT mid FROM contract_module WHERE cid=null AND mid=null FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[168962] - SELECT mid FROM contract_module WHERE cid=null AND mid=null FOR UPDATE java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369 at ru.bitel.bgbilling.server.dbcp.DbcpPoolableConnection.close(DbcpPoolableConnection.java:53) at ru.bitel.bgbilling.server.dbcp.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48) at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:308) at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:405) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:104) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:46) |
Автор: | U.Alex [ 21 фев 2019, 05:24 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
добрый день, у меня после обновления с 6.2 на 7.0 появляются подобные логи при "Начисление NPay абонплат" mq 02-20/23:45:13 ERROR [event-proc-p-2-t-1] DbcpPoolableConnection - Many statements was open at connection close: com.mysql.jdbc.ServerPreparedStatement[810719] - SELECT mid FROM contract_module WHERE cid=null AND mid=null FOR UPDATE com.mysql.jdbc.ServerPreparedStatement[814349] - SELECT mid FROM contract_module WHERE cid=null AND mid=null FOR UPDATE com.mysql.jdbc.JDBC42PreparedStatement@1175e749: SELECT mid FROM contract_module WHERE cid=** NOT SPECIFIED ** AND mid=** NOT SPECIFIED ** FOR UPDATE com.mysql.jdbc.PreparedStatement@679eb342: SELECT mid FROM contract_module WHERE cid=** NOT SPECIFIED ** AND mid=** NOT SPECIFIED ** FOR UPDATE com.mysql.jdbc.PreparedStatement@17e7f273: SELECT mid FROM contract_module WHERE cid=** NOT SPECIFIED ** AND mid=** NOT SPECIFIED ** FOR UPDATE com.mysql.jdbc.PreparedStatement@2b4ab990: SELECT mid FROM contract_module WHERE cid=** NOT SPECIFIED ** AND mid=** NOT SPECIFIED ** FOR UPDATE com.mysql.jdbc.PreparedStatement@7e893dad: SELECT mid FROM contract_module WHERE cid=** NOT SPECIFIED ** AND mid=** NOT SPECIFIED ** FOR UPDATE com.mysql.jdbc.PreparedStatement@2db2984c: SELECT mid FROM contract_module WHERE cid=** NOT SPECIFIED ** AND mid=** NOT SPECIFIED ** FOR UPDATE com.mysql.jdbc.PreparedStatement@6f35af18: SELECT mid FROM contract_module WHERE cid=** NOT SPECIFIED ** AND mid=** NOT SPECIFIED ** FOR UPDATE com.mysql.jdbc.PreparedStatement@4b39bc9f: SELECT mid FROM contract_module WHERE cid=** NOT SPECIFIED ** AND mid=** NOT SPECIFIED ** FOR UPDATE com.mysql.jdbc.PreparedStatement@1bb7d0: SELECT mid FROM contract_module WHERE cid=** NOT SPECIFIED ** AND mid=** NOT SPECIFIED ** FOR UPDATE ....... Сервер: вер. 7.0.1444 / 08.02.2019 12:54:05 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_74 |
Автор: | Amir [ 26 фев 2019, 15:48 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Цитата: добрый день, у меня после обновления с 6.2 на 7.0 появляются подобные логи при "Начисление NPay абонплат" Добрый день. Выложим обновление в ближайшее время. Не должно быть критично
|
Автор: | barguzin2 [ 04 май 2019, 15:20 ] |
Заголовок сообщения: | Re: Незакрытые preparedStatement (CRM) |
Сервер: вер. 7.1.1114 / 18.03.2019 21:32:01 Код: java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369
at ru.bitel.bgbilling.server.dbcp.DbcpPoolableConnection.close(DbcpPoolableConnection.java:53) at ru.bitel.bgbilling.server.dbcp.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48) at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:308) at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:405) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:72) at ru.bitel.bgbilling.kernel.event.EventListenerThreadContext$2.rejectedExecution(EventListenerThreadContext.java:91) at java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:830) at java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1379) at ru.bitel.bgbilling.kernel.event.Consumer.onMessage(Consumer.java:159) at org.apache.activemq.ActiveMQMessageConsumer.dispatch(ActiveMQMessageConsumer.java:1401) at org.apache.activemq.ActiveMQSessionExecutor.dispatch(ActiveMQSessionExecutor.java:131) at org.apache.activemq.ActiveMQSessionExecutor.iterate(ActiveMQSessionExecutor.java:202) at org.apache.activemq.thread.PooledTaskRunner.runTask(PooledTaskRunner.java:133) at org.apache.activemq.thread.PooledTaskRunner$1.run(PooledTaskRunner.java:48) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) mq 05-03/00:15:14 ERROR [ActiveMQ Session Task-2267] DbcpPoolableConnection - Many statements was open at connection close: com.mysql.jdbc.ServerPreparedStatement[3199] - SELECT * FROM voice_account_port_2 WHERE accountId=213 ORDER BY port com.mysql.jdbc.ServerPreparedStatement[3289] - SELECT * FROM voice_account_port_2 WHERE accountId=183 ORDER BY port com.mysql.jdbc.ServerPreparedStatement[3313] - SELECT * FROM voice_account_port_2 WHERE accountId=210 ORDER BY port |
Страница 12 из 12 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |