Незакрытые preparedStatement (CRM)

Основная часть программы и общие вопросы по модулям. Установка и настройка BGBillingServer, BGBillingClient.

Re: Незакрытые preparedStatement (CRM)

Сообщение abu » 31 июл 2017, 11:25

Обновился 27.07, получил 29.07 preparedStatement в логах. Ошибка появилась один раз, во время отработки задачи "Начисление NPay абонплат" планировщиком, после этого более не появлялась. У абонентов подключен древний скрипт "Определение суммы минимального платежа". Скрипт и лог - в приложении.
$this->bbcode_second_pass_quote('', '
')Информация о версии:

Клиент: вер. 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
Вложения
log.txt
(2.3 КБ) Скачиваний: 165
script.txt
(4.73 КБ) Скачиваний: 157
abu
Клиент
 
Сообщения: 336
Зарегистрирован: 10 окт 2012, 17:00

Re: Незакрытые preparedStatement (CRM)

Сообщение Ildar » 31 июл 2017, 12:15

С 6.2 TariffPlanManager депрекейнут. Используйте TariffPlanDao. А после использования закрывайте.

Это же касается ContractTariffPlanManager. Но там чуть проще, так как утечка не возможна, пока.
Аватара пользователя
Ildar
Разработчик
 
Сообщения: 424
Зарегистрирован: 05 сен 2012, 18:20

Re: Незакрытые preparedStatement (CRM)

Сообщение abu » 31 июл 2017, 12:46

Так-то оно все работало достаточно давно на 6.2. Спасибо за объяснения, буду разбираться.
abu
Клиент
 
Сообщения: 336
Зарегистрирован: 10 окт 2012, 17:00

Re: Незакрытые preparedStatement (CRM)

Сообщение Ildar » 31 июл 2017, 13:16

Да, это наш косяк. Не совсем верно депрекейтнули, но теперь уже не вижу смысла воротить назад. Так как использовать данные классы все равно уже не желательно.
Если у вас есть сложности с перепиской скрипта, то могу сам вам переписать.
Аватара пользователя
Ildar
Разработчик
 
Сообщения: 424
Зарегистрирован: 05 сен 2012, 18:20

Re: Незакрытые preparedStatement (CRM)

Сообщение abu » 31 июл 2017, 13:22

Нет, пока не нужно, спасибо, попробую сам. Если что, еще раз обращусь (:
abu
Клиент
 
Сообщения: 336
Зарегистрирован: 10 окт 2012, 17:00

Re: Незакрытые preparedStatement (CRM)

Сообщение ok-2004 » 09 авг 2017, 16:45

ДВС!
Сегодня в server.error.log словил :
$this->bbcode_second_pass_code('', '
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
"Все правые - в резерве!" (c) (translate.google.ru/#en/ru/all%20rigths%20reserved)
ok-2004
Клиент
 
Сообщения: 599
Зарегистрирован: 21 май 2008, 10:54
Откуда: 50-й рег.

Re: Незакрытые preparedStatement (CRM)

Сообщение stark » 25 сен 2017, 12:04

$this->bbcode_second_pass_quote('ok-2004', '')ВС!
Сегодня в server.error.log словил :
$this->bbcode_second_pass_code('', '
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
Разработчик
 
Сообщения: 8343
Зарегистрирован: 08 ноя 2007, 01:05
Откуда: Уфа

Re: Незакрытые preparedStatement (CRM)

Сообщение stark » 25 сен 2017, 12:13

Накатили исправление на 6.2. Будет в следующем обновлении.
stark
Разработчик
 
Сообщения: 8343
Зарегистрирован: 08 ноя 2007, 01:05
Откуда: Уфа

Re: Незакрытые preparedStatement (CRM)

Сообщение Cromeshnic » 01 ноя 2017, 12:10

Похоже при переобсчёте предыдущего месяца в модуле Inet в error.log:

$this->bbcode_second_pass_code('', '
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
Клиент
 
Сообщения: 3061
Зарегистрирован: 20 апр 2009, 12:03
Откуда: Иркутск

Re: Незакрытые preparedStatement (CRM)

Сообщение Cromeshnic » 25 дек 2017, 14:23

rscm: вер. 7.0.186 / 04.08.2017 17:35:05

RSCMContractServiceManager.updateContractService(...)
- тут не закрывается ps
Аватара пользователя
Cromeshnic
Клиент
 
Сообщения: 3061
Зарегистрирован: 20 апр 2009, 12:03
Откуда: Иркутск

Re: Незакрытые preparedStatement (CRM)

Сообщение borin » 18 апр 2018, 16:31

Добрый день!
В связи с печатью карточек к договору, у сервера стали быстро заканчиваться соединения, по совету с телеграм канала включил дебаг.
Там куча вот таких соединений:
$this->bbcode_second_pass_code('', '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)
')
$this->bbcode_second_pass_code('', 'Клиент: вер. 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')
$this->bbcode_second_pass_code('', '
Клиент: вер. 6.2.874 / 05.02.2018 12:48:36
os: Windows 7; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_151
Сервер: вер. 6.2.1203 / 05.02.2018 12:50:34
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_45
')
Аватара пользователя
borin
 
Сообщения: 319
Зарегистрирован: 12 июл 2010, 21:22

Re: Незакрытые preparedStatement (CRM)

Сообщение Amir » 18 апр 2018, 18:34

Выложили обновление для 6.2 "Kernel: Утечка соединения при использовании DynCodeExecuter в XSLT.".
В 7.0 это место было уже переписано, там нет проблемы.
Аватара пользователя
Amir
Разработчик
 
Сообщения: 5940
Зарегистрирован: 19 дек 2006, 21:04

Re: Незакрытые preparedStatement (CRM)

Сообщение borin » 19 апр 2018, 10:17

$this->bbcode_second_pass_quote('Amir', '')ыложили обновление для 6.2 "Kernel: Утечка соединения при использовании DynCodeExecuter в XSLT.".
В 7.0 это место было уже переписано, там нет проблемы.

Спасибо, вот теперь красота )
$this->bbcode_second_pass_code('', '
Клиент: вер. 6.2.874 / 05.02.2018 12:48:36
os: Windows 7; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_151
Сервер: вер. 6.2.1203 / 05.02.2018 12:50:34
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_45
')
Аватара пользователя
borin
 
Сообщения: 319
Зарегистрирован: 12 июл 2010, 21:22
Вернуться к началу

Re: Незакрытые preparedStatement (CRM)

Сообщение Dog » 31 июл 2018, 18:04

$this->bbcode_second_pass_code('', '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)
')
Dog
Клиент
 
Сообщения: 835
Зарегистрирован: 21 сен 2009, 13:01
Откуда: Москва

Re: Незакрытые preparedStatement (CRM)

Сообщение Artur » 01 авг 2018, 14:11

В какой момент это произошло?
С уважением, Гареев Артур. Вежливый разработчик ООО "Бител".
Аватара пользователя
Artur
Разработчик
 
Сообщения: 940
Зарегистрирован: 27 янв 2010, 16:12
Откуда: Уфа

Re: Незакрытые preparedStatement (CRM)

Сообщение Dog » 01 авг 2018, 16:39

без понятия, вот что было до и после:

$this->bbcode_second_pass_code('', '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
Клиент
 
Сообщения: 835
Зарегистрирован: 21 сен 2009, 13:01
Откуда: Москва

Re: Незакрытые preparedStatement (CRM)

Сообщение Dog » 01 авг 2018, 16:40

$this->bbcode_second_pass_code('', '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
')
Dog
Клиент
 
Сообщения: 835
Зарегистрирован: 21 сен 2009, 13:01
Откуда: Москва

Re: Незакрытые preparedStatement (CRM)

Сообщение Cromeshnic » 01 сен 2018, 12:57

В RSCMContractServiceManager не закрывается ps:

$this->bbcode_second_pass_code('', '
...
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)
...
')

-

$this->bbcode_second_pass_code('', '
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
Клиент
 
Сообщения: 3061
Зарегистрирован: 20 апр 2009, 12:03
Откуда: Иркутск

Re: Незакрытые preparedStatement (CRM)

Сообщение Cromeshnic » 01 сен 2018, 15:03

При пересчёте в модуле Inet за прошлый месяц:

$this->bbcode_second_pass_code('', '
...
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
Аватара пользователя
Cromeshnic
Клиент
 
Сообщения: 3061
Зарегистрирован: 20 апр 2009, 12:03
Откуда: Иркутск

Re: Незакрытые preparedStatement (CRM)

Сообщение spectrum » 01 окт 2018, 16:39

$this->bbcode_second_pass_quote('spectrum', '')ыполняется следующий код:
$this->bbcode_second_pass_code('', '
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, ""));
}

')


В логах:
$this->bbcode_second_pass_code('', '
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:
$this->bbcode_second_pass_code('', '
Информация о версии:

Клиент: вер. 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. Это и в переведенном отрывке видно.


Ошибки так до сих пор и валятся после запуска:
$this->bbcode_second_pass_code('', '
new RunTaskDataManager(vars.con)
.addTask(new Recalculator(NPAY_MID, Calendar.getInstance(), email, serviceSet, cids, ""));
')


cids - это String с большим количеством cid. Например таким:
"5117,5118,5132,5133,5134,5139....". 145 штук договоров.

Сегодня при использовании этого метода произошла очень неприятная ситуация - почему-то было произведено начисление вообще по всем договорам, а не только из списка.
spectrum
 
Сообщения: 365
Зарегистрирован: 29 янв 2014, 11:32
Вернуться к началу

Re: Незакрытые preparedStatement (CRM)

Сообщение dimOn » 01 окт 2018, 18:14

ну версия у вас очень старая, там давно могли уже исправить. прежде всего обновиться до последних билдов.

$this->bbcode_second_pass_quote('', '')егодня при использовании этого метода произошла очень неприятная ситуация - почему-то было произведено начисление вообще по всем договорам, а не только из списка.

ну это с описываемым не связано.
может просто кто-то руками тупо переобсчёт запустил из клиента, не выбрав конкретный договор ткнули кнопку начисление
потому что код такой тоже не мог к такому привести. там cids напрямую во всех sql-запросах используется в калькуляторе.
dimOn
 
Сообщения: 5918
Зарегистрирован: 30 май 2008, 15:51
Вернуться к началу

Re: Незакрытые preparedStatement (CRM)

Сообщение spectrum » 01 окт 2018, 19:03

Версия сейчас такая:
$this->bbcode_second_pass_code('', '
Клиент: вер. 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
')
spectrum
 
Сообщения: 365
Зарегистрирован: 29 янв 2014, 11:32

Re: Незакрытые preparedStatement (CRM)

Сообщение dimOn » 07 окт 2018, 01:10

ну так это ваш код или как?

new RunTaskDataManager(vars.con)
.addTask(new Recalculator(NPAY_MID, Calendar.getInstance(), email, serviceSet, cids, ""));

что такое vars.con, откуда оно бёрется? этот коннекшен потом закрывается корректно?
dimOn
 
Сообщения: 5918
Зарегистрирован: 30 май 2008, 15:51

Re: Незакрытые preparedStatement (CRM)

Сообщение spectrum » 16 окт 2018, 19:11

Да, это коннекшен: vars.con = connectionSet.getConnection();
Его необходимо закрывать?

Этот метод
new RunTaskDataManager(vars.con).addTask(new Recalculator(NPAY_MID, Calendar.getInstance(), email, serviceSet, cids, ""));
вызывается только один раз в скрипте в конце исполнения, но в cids много договоров, около 150 шт за раз.
spectrum
 
Сообщения: 365
Зарегистрирован: 29 янв 2014, 11:32

Re: Незакрытые preparedStatement (CRM)

Сообщение [LTC]Dimonyga » 27 дек 2018, 19:21

$this->bbcode_second_pass_quote('', 'c')om.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

$this->bbcode_second_pass_quote('', '
')Java version is 1.8 (1.8.0_121)
BGBillingServer v 7.1.1078 / 26.12.2018 12:39:55
[LTC]Dimonyga
Клиент
 
Сообщения: 56
Зарегистрирован: 12 янв 2012, 16:12
Откуда: г. Новосибирск
Вернуться к началу

Re: Незакрытые preparedStatement (CRM)

Сообщение Phricker » 29 янв 2019, 09:46

$this->bbcode_second_pass_code('', ' Сервер: вер. 7.2.932 / 27.01.2019 11:30:23
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_191')
$this->bbcode_second_pass_code('', '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)
')
Цитаты великих людей :umnik:
Напишите в helpdesk © stark
повторяю: => хелпдеск => доработка => профит © dimOn
свершилось... © skn
Мой код изящен, лёгок, оригинален, краток. Как прохладный весенний ветерок, как звонкий ручей! © dimOn
Вежливый разработчик © Artur
Эти баги тоже исправлены, как и те, которые еще не написаны © Artur
ну т.е. существует воркэраунд, ок © dimOn
Аватара пользователя
Phricker
Клиент
 
Сообщения: 5775
Зарегистрирован: 29 мар 2010, 23:11

Re: Незакрытые preparedStatement (CRM)

Сообщение U.Alex » 21 фев 2019, 05:24

добрый день, у меня после обновления с 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
U.Alex
 
Сообщения: 1
Зарегистрирован: 13 авг 2018, 06:45

Re: Незакрытые preparedStatement (CRM)

Сообщение Amir » 26 фев 2019, 15:48

$this->bbcode_second_pass_quote('', '')обрый день, у меня после обновления с 6.2 на 7.0 появляются подобные логи при "Начисление NPay абонплат"
Добрый день. Выложим обновление в ближайшее время. Не должно быть критично
Аватара пользователя
Amir
Разработчик
 
Сообщения: 5940
Зарегистрирован: 19 дек 2006, 21:04
Вернуться к началу

Re: Незакрытые preparedStatement (CRM)

Сообщение barguzin2 » 04 май 2019, 15:20

Сервер: вер. 7.1.1114 / 18.03.2019 21:32:01

$this->bbcode_second_pass_code('', '
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
')
barguzin2
Клиент
 
Сообщения: 1080
Зарегистрирован: 09 фев 2011, 15:28

Пред.

Вернуться в Ядро системы

Кто сейчас на конференции

Сейчас этот форум просматривают: Google [Bot] и гости: 1