BiTel

Форум BiTel
bgbilling.ru     docs.bitel.ru     wiki.bitel.ru     dbinfo.bitel.ru     bgcrm.ru     billing.bitel.ru     bitel.ru    
Текущее время: 28 мар 2024, 15:36

Часовой пояс: UTC + 5 часов [ Летнее время ]




Начать новую тему Ответить на тему  [ Сообщений: 359 ]  На страницу Пред.  1 ... 8, 9, 10, 11, 12
Автор Сообщение
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 31 июл 2017, 11:25 
Не в сети
Клиент

Зарегистрирован: 10 окт 2012, 17:00
Сообщения: 339
Карма: 0
Обновился 27.07, получил 29.07 preparedStatement в логах. Ошибка появилась один раз, во время отработки задачи "Начисление NPay абонплат" планировщиком, после этого более не появлялась. У абонентов подключен древний скрипт "Определение суммы минимального платежа". Скрипт и лог - в приложении.
Цитата:
Информация о версии:

Клиент: вер. 6.2.870 / 25.07.2017 14:32:01
os: Linux; java: Java HotSpot(TM) Server VM, v.1.8.0_74
Сервер: вер. 6.2.1196 / 25.07.2017 14:33:13
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_74

assist: вер. 6.2.90 / 25.07.2017 14:34:39
bill: вер. 6.2.109 / 25.07.2017 14:34:42
card: вер. 6.2.44 / 25.07.2017 14:34:50
dba: вер. 6.2.164 / 25.07.2017 14:35:12
enaza: вер. 6.2.61 / 25.07.2017 14:35:16
gorod: вер. 6.2.165 / 25.07.2017 14:35:18
inet: вер. 6.2.731 / 25.07.2017 17:16:36
mps: вер. 6.2.226 / 25.07.2017 14:35:26
npay: вер. 6.2.202 / 25.07.2017 14:35:29
paylinks: вер. 6.2.33 / 25.07.2017 14:35:32
paymaster: вер. 6.2.56 / 25.07.2017 14:35:33
qiwi: вер. 6.2.53 / 25.07.2017 14:35:49
rentsoft: вер. 6.2.64 / 25.07.2017 14:35:53
reports: вер. 6.2.218 / 25.07.2017 14:35:55
rscm: вер. 6.2.180 / 25.07.2017 14:35:59
ru.bitel.bgbilling.plugins.cladr: вер. 6.2.120 / 25.07.2017 14:35:11
ru.bitel.bgbilling.plugins.dispatch: вер. 6.2.98 / 25.07.2017 14:35:13
trayinfo: вер. 6.2.172 / 03.07.2017 15:47:40
tv: вер. 6.2.243 / 25.07.2017 14:34:21
wellpay: вер. ?
wm: вер. 6.2.190 / 25.07.2017 14:36:18
yamoney: вер. 6.2.59 / 25.07.2017 14:36:19

Окружение:

Клиент:
os: Linux i386, 3.13-1-amd64
java: Java HotSpot(TM) Server VM, v.1.8.0_74
jre home: /opt/java/jdk1.8.0_74/jre
default tz: 31.07.2017 14:23 YAKT +0900 (Asia/Yakutsk)
user tz: 31.07.2017 14:23 YAKT +0900 (Asia/Yakutsk)
locale: ru_RU
Сервер:
os: Linux amd64, 2.6.32-el-smp-alt27
java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_74
jre home: /opt/java/jdk1.8.0_74/jre
default tz: 31.07.2017 14:23 YAKT +0900 (Asia/Yakutsk)
db time: master: 31.07.2017 14:23 YAKT
db charset: connection: utf8(utf8_general_ci), database: cp1251(cp1251_general_ci)
locale: en_US
uptime: Started: 27.07.2017 17:47:36 Uptime: 3 d 20:35:43


Вложения:
log.txt [2.3 КБ]
Скачиваний: 596
script.txt [4.73 КБ]
Скачиваний: 609
Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 31 июл 2017, 12:15 
Не в сети
Разработчик
Аватара пользователя

Зарегистрирован: 05 сен 2012, 18:20
Сообщения: 457
Карма: 27
С 6.2 TariffPlanManager депрекейнут. Используйте TariffPlanDao. А после использования закрывайте.

Это же касается ContractTariffPlanManager. Но там чуть проще, так как утечка не возможна, пока.


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 31 июл 2017, 12:46 
Не в сети
Клиент

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


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 31 июл 2017, 13:16 
Не в сети
Разработчик
Аватара пользователя

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


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 31 июл 2017, 13:22 
Не в сети
Клиент

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


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 09 авг 2017, 16:45 
Не в сети
Клиент

Зарегистрирован: 21 май 2008, 10:54
Сообщения: 599
Откуда: 50-й рег.
Карма: 40
ДВС!
Сегодня в server.error.log словил :
Код:
server 08-09/11:17:53 ERROR [http-bio-0.0.0.0-8080-exec-9] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.JDBC4PreparedStatement@55a87ec8: SELECT * FROM tariff_plan ORDER BY title
com.mysql.jdbc.JDBC4PreparedStatement@74cc1d17: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.JDBC4PreparedStatement@11633c62: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@226de06d: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@4219e1dd: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@1cba9ccf: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@41acc3b1: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@5b58019: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@4cafe63e: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@7cc02d9d: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@31b93d6a: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@4d775600: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@2105633b: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@6390e9d: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@2d9e0d68: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@567dde79: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@c3aaf7a: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@18918dee: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@10a82a75: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@420aa3b8: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@3738a9af: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@6e8fc55f: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@77131cf2: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@4e6343ed: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@7038684b: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@3fae44cd: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@abdd4b8: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@4b9fe3eb: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@30863a65: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@619587b7: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@56ccc728: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@4ce33c28: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@572a74f3: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@1540d056: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@783f695: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@5e18669a: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@1cbd79d8: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@3da51dce: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@7e9d481: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@7466c042: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@26133c71: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@34a3c216: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@45cc1d49: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@50aa4f88: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@61c70a7d: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@70ec8c75: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@6799b178: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@61c235cc: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@71dbd08: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@4331c3a0: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@4926c36b: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@1ebdc5b8: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@52d9ee10: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@3bb00382: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@5864425d: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@60ca3ac5: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@5502ebf0: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@4a9215d0: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@5ab8d8f0: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@4b2907eb: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@4183b23d: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@6f1daeb3: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@3784e56d: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@18681661: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@45c077c6: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@4cff9307: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@3da6fe49: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@2d22d185: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@67568f63: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@7e42236d: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@55ec2065: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@225a1c92: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@60d4c0bc: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@30d85da8: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@3dedd462: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@33fc160b: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@1d21f395: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@4bee7a12: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@4b025097: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@2d280266: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@77966a2a: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@c3da0ae: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@1e005788: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@32b8941f: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@289e066d: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@66ac0be4: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@53b32e49: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@36a1cc8f: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@23ddb895: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@2465de55: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@65025eca: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@25832eaf: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@7f2dca34: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@400400fb: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@6011cca2: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@5cb9eefa: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@e0fb61a: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@31b579fc: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.PreparedStatement@685b02fe: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=7
com.mysql.jdbc.PreparedStatement@5a937c70: SELECT * FROM tariff_group WHERE id=7

java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369
        at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:426)
        at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48)
        at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:272)
        at ru.bitel.bgbilling.kernel.base.server.DefaultContext.destroy(DefaultContext.java:37)
        at ru.bitel.bgbilling.kernel.container.managed.ServerContext.destroy(ServerContext.java:400)
        at bitel.billing.server.ActionBase.freeConnection(ActionBase.java:180)
        at bitel.billing.server.Executer.doModule(SourceFile:649)
        at bitel.billing.server.Executer$1.run(SourceFile:199)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:422)
        at bitel.billing.server.Executer.doPost(SourceFile:193)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at ru.bitel.common.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:54)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:748)

==========================
Информация о версии:

Клиент: вер. 6.2.862 / 30.05.2017 03:57:55
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_131
Сервер: вер. 6.2.1184 / 30.05.2017 04:17:11
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_131

bill: вер. 6.2.103 / 12.05.2017 18:50:32
card: вер. 6.2.43 / 16.03.2017 23:47:47
dialup: вер. 6.2.316 / 12.05.2017 18:52:28
drweb: вер. 6.2.71 / 09.03.2016 11:43:11
email: вер. 6.2.177 / 14.12.2016 14:27:42
inet: вер. 6.2.720 / 30.05.2017 03:55:47
ipn: вер. 6.2.264 / 09.01.2017 16:41:56
mps: вер. 6.2.225 / 17.05.2017 18:35:37
npay: вер. 6.2.200 / 30.05.2017 04:17:18
payonline: вер. 6.2.65 / 01.06.2017 15:55:49
rentsoft: вер. 6.2.63 / 04.10.2016 19:16:26
reports: вер. 6.2.217 / 02.05.2017 12:37:22
ru.bitel.bgbilling.plugins.crm: вер. 6.2.195 / 04.10.2016 19:16:05
ru.bitel.bgbilling.plugins.dispatch: вер. 6.2.97 / 12.05.2017 18:50:40
ru.bitel.bgbilling.plugins.documents: вер. 6.2.176 / 14.12.2016 14:33:16
ru.bitel.bgbilling.plugins.helpdesk: вер. 6.2.182 / 04.10.2016 19:16:06
trayinfo: вер. 6.2.171 / 10.03.2017 18:11:41
voiceip: вер. 6.2.192 / 12.05.2017 18:50:31
wm: вер. 6.2.189 / 04.10.2016 19:16:46
yamoney: вер. 6.2.58 / 04.10.2016 19:16:49

Окружение:

Клиент:
os: Linux amd64, 4.10.0-30-generic
java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_131
jre home: /home/oleg/BGBillingClient_6.2/jdk1.8.0_131/jre
default tz: 09.08.2017 13:42 MSK +0300 (Europe/Moscow)
user tz: 09.08.2017 13:42 MSK +0300 (Europe/Moscow)
locale: ru_RU
Сервер:
os: Linux amd64, 4.4.0-78-generic
java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_131
jre home: /opt/java/jdk1.8.0_131/jre
default tz: 09.08.2017 13:42 MSK +0300 (Europe/Moscow)
db time: master: 09.08.2017 13:42 MSK
db charset: connection: utf8(utf8_unicode_ci), database: utf8(utf8_unicode_ci)
locale: en_US
uptime: Started: 11.06.2017 08:18:27 Uptime: 59 d 05:24:01

_________________
"Все правые - в резерве!" (c) (translate.google.ru/#en/ru/all%20rigths%20reserved)


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 25 сен 2017, 12:04 
Не в сети
Разработчик

Зарегистрирован: 08 ноя 2007, 01:05
Сообщения: 8343
Откуда: Уфа
Карма: 238
ok-2004 писал(а):
ДВС!
Сегодня в server.error.log словил :
Код:
server 08-09/11:17:53 ERROR [http-bio-0.0.0.0-8080-exec-9] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.JDBC4PreparedStatement@55a87ec8: SELECT * FROM tariff_plan ORDER BY title
com.mysql.jdbc.JDBC4PreparedStatement@74cc1d17: SELECT * FROM tariff_group WHERE id=7
com.mysql.jdbc.JDBC4PreparedStatement@11633c62: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON [/quote]




Какая версия ? 6.2 ? Эту утечку исправили начиная с 7.0.


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 25 сен 2017, 12:13 
Не в сети
Разработчик

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


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 01 ноя 2017, 12:10 
Не в сети
Клиент
Аватара пользователя

Зарегистрирован: 20 апр 2009, 12:03
Сообщения: 3092
Откуда: Иркутск
Карма: 338
Похоже при переобсчёте предыдущего месяца в модуле Inet в error.log:

Код:
recalculate 11-01/06:32:08 ERROR [worker-p-49-t-3] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.JDBC42PreparedStatement@4244659d: INSERT INTO inet_session_log_account_30_201710 (amount, account, contractId, sessionId, serviceId) VALUES (6967491449,0.00000,165811,14370941,701)  ON DUPLICATE KEY UPDATE  amount = 6967491449, account = 0.00000
com.mysql.jdbc.JDBC42PreparedStatement@4c4b3d5: UPDATE inet_session_log_30_201710  SET sessionCost=0.00000 WHERE id=14368545
com.mysql.jdbc.JDBC42PreparedStatement@3ad1cacf: UPDATE inet_tariff_traffic_max_30 SET amountMax = 39835680360 , amount1 = 39835680360, amount2 = 5464262760, counter = counter + 1 WHERE contractId = 160622 AND treeNodeId = 914828279535 AND maxKey = 144115188208041993  AND yy =2017 AND mm=10 AND  (@counter:=counter) IS NOT NULL
com.mysql.jdbc.JDBC42PreparedStatement@5594bd7c: INSERT INTO inet_tariff_traffic_max_30 ( contractId, treeNodeId, maxKey, amountMax, amount1, amount2, yy, mm, counter )  VALUES (** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,1)
com.mysql.jdbc.JDBC42PreparedStatement@341d42de: UPDATE inet_tariff_traffic_range_30 SET amount = 39835680360, maxAmount = 298844160000,  counter = counter + 1 WHERE contractId = 160622 AND treeNodeId = 914828279533 AND rangeKey = 144115188208041993  AND yy =2017 AND mm=10 AND (@counter:=counter) IS NOT NULL
com.mysql.jdbc.JDBC42PreparedStatement@15e60593: INSERT INTO inet_tariff_traffic_range_30 ( contractId, treeNodeId, rangeKey, amount, yy, mm, counter, maxAmount )  VALUES (** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,1,** NOT SPECIFIED **)
com.mysql.jdbc.JDBC42PreparedStatement@2dbc4ae0: INSERT INTO inet_tariff_traffic_max_detail_30_201710 ( contractId, treeNodeId, maxKey, day, amountMax, amount1, amount2  )  VALUES (** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **)
com.mysql.jdbc.JDBC42PreparedStatement@4fef55b3: UPDATE inet_tariff_traffic_max_detail_30_201710 SET  amountMax = 2708035893, amount1 = 2708035893, amount2 = 211808795   WHERE  contractId = 160622 AND treeNodeId = 914828279535 AND maxKey = 144115188208041993 AND day = 31
com.mysql.jdbc.JDBC42PreparedStatement@dc516f9: INSERT INTO inet_tariff_traffic_range_detail_30_201710 ( contractId, treeNodeId, rangeKey, day, amount  )  VALUES (** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **)
...


Kernel version 7.0.1263 / 13.09.2017 20:33:05
Inet version 7.0.772 / 05.09.2017 19:44:59


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 25 дек 2017, 14:23 
Не в сети
Клиент
Аватара пользователя

Зарегистрирован: 20 апр 2009, 12:03
Сообщения: 3092
Откуда: Иркутск
Карма: 338
rscm: вер. 7.0.186 / 04.08.2017 17:35:05

RSCMContractServiceManager.updateContractService(...)
- тут не закрывается ps


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 18 апр 2018, 16:31 
Не в сети
Аватара пользователя

Зарегистрирован: 12 июл 2010, 21:22
Сообщения: 319
Карма: 11
Добрый день!
В связи с печатью карточек к договору, у сервера стали быстро заканчиваться соединения, по совету с телеграм канала включил дебаг.
Там куча вот таких соединений:
Код:
jdbc:mysql://127.0.0.1/bgbilling?useUnicode=true&characterEncoding=UTF-8&connectionCollation=utf8_unicode_ci&allowUrlInLocalInfile=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&elideSetAutoCommits=true&cachePrepStmts=true&useCursorFetch=true&queryTimeoutKillsConnection=true&connectTimeout=1000, UserName=bill@localhost, MySQL Connector Java
        at ru.bitel.bgbilling.server.util.DefaultServerSetup$1.borrowObject(DefaultServerSetup.java:337)
        at ru.bitel.bgbilling.server.util.DatabaseConnectionPool$1.getConnection(DatabaseConnectionPool.java:30)
        at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:588)
        at bitel.billing.server.util.exslt.DynCodeExecuter.execute(DynCodeExecuter.java:38)
        at bitel.billing.server.util.exslt.DynCodeExecuter.execute(DynCodeExecuter.java:85)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at org.apache.xalan.extensions.ExtensionHandlerJavaClass.callFunction(ExtensionHandlerJavaClass.java:284)
        at org.apache.xalan.extensions.ExtensionHandlerJavaClass.callFunction(ExtensionHandlerJavaClass.java:440)
        at org.apache.xalan.extensions.ExtensionsTable.extFunction(ExtensionsTable.java:222)
        at org.apache.xalan.transformer.TransformerImpl.extFunction(TransformerImpl.java:473)
        at org.apache.xpath.functions.FuncExtFunction.execute(FuncExtFunction.java:208)
        at org.apache.xpath.Expression.executeCharsToContentHandler(Expression.java:313)
        at org.apache.xalan.templates.ElemValueOf.execute(ElemValueOf.java:274)
        at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400)
        at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:1376)
        at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400)
        at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:1376)
        at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400)
        at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:1376)
        at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400)
        at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:1376)
        at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400)
        at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:1376)
        at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400)
        at org.apache.xalan.templates.ElemTemplate.execute(ElemTemplate.java:394)
        at org.apache.xalan.templates.ElemCallTemplate.execute(ElemCallTemplate.java:248)
        at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400)
        at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:1376)
        at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400)
        at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:1376)
        at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400)
        at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:1376)
        at org.apache.xalan.templates.ElemApplyTemplates.transformSelectedNodes(ElemApplyTemplates.java:395)
        at org.apache.xalan.templates.ElemApplyTemplates.execute(ElemApplyTemplates.java:178)
        at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2400)
        at org.apache.xalan.transformer.TransformerImpl.applyTemplateToNode(TransformerImpl.java:2270)
        at org.apache.xalan.transformer.TransformerImpl.transformNode(TransformerImpl.java:1356)
        at org.apache.xalan.transformer.TransformerImpl.transform(TransformerImpl.java:709)
        at org.apache.xalan.transformer.TransformerImpl.transform(TransformerImpl.java:1273)
        at org.apache.xalan.transformer.TransformerImpl.transform(TransformerImpl.java:1251)
        at ru.bitel.bgbilling.kernel.container.web.action.XSLManager.transform(XSLManager.java:226)
        at bitel.billing.server.contract.action.ActionContractCard2.doAction(ActionContractCard2.java:126)
        at bitel.billing.server.Executer.doModule(SourceFile:600)
        at bitel.billing.server.Executer$1.run(SourceFile:199)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:422)
        at bitel.billing.server.Executer.doPost(SourceFile:193)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at ru.bitel.common.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:54)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:745)

Код:
Клиент: вер. 6.2.874 / 05.02.2018 12:48:36
    os: Windows 10; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_161
  Сервер: вер. 6.2.1203 / 05.02.2018 12:50:34
    os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_45

_________________
Код:
    Клиент: вер. 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


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 18 апр 2018, 18:34 
Не в сети
Разработчик
Аватара пользователя

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


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 19 апр 2018, 10:17 
Не в сети
Аватара пользователя

Зарегистрирован: 12 июл 2010, 21:22
Сообщения: 319
Карма: 11
Amir писал(а):
Выложили обновление для 6.2 "Kernel: Утечка соединения при использовании DynCodeExecuter в XSLT.".
В 7.0 это место было уже переписано, там нет проблемы.

Спасибо, вот теперь красота )

_________________
Код:
    Клиент: вер. 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


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 31 июл 2018, 18:04 
Не в сети
Клиент

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


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 01 авг 2018, 14:11 
Не в сети
Аватара пользователя

Зарегистрирован: 27 янв 2010, 16:12
Сообщения: 941
Откуда: Уфа
Карма: 124
В какой момент это произошло?

_________________
С уважением, Гареев Артур. Вежливый разработчик ООО "Бител".


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 01 авг 2018, 16:39 
Не в сети
Клиент

Зарегистрирован: 21 сен 2009, 13:01
Сообщения: 835
Откуда: Москва
Карма: 15
без понятия, вот что было до и после:

Код:
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.


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 01 авг 2018, 16:40 
Не в сети
Клиент

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


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 01 сен 2018, 12:57 
Не в сети
Клиент
Аватара пользователя

Зарегистрирован: 20 апр 2009, 12:03
Сообщения: 3092
Откуда: Иркутск
Карма: 338
В RSCMContractServiceManager не закрывается ps:

Код:
...
com.mysql.jdbc.PreparedStatement@3e72346d: INSERT INTO rscm_service_account_5 SET sid=885, date='2018-09-01', amount=1, comment='', cid=149407
com.mysql.jdbc.PreparedStatement@6db49867: INSERT INTO rscm_service_account_5 SET sid=885, date='2018-09-01', amount=1, comment='', cid=283207

java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369
        at ru.bitel.bgbilling.server.dbcp.DbcpPoolableConnection.close(DbcpPoolableConnection.java:53)
        at ru.bitel.bgbilling.server.dbcp.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48)
...


-

Код:
 public void updateContractService(RSCMContractService contractService)
    throws BGException
  {
    try
    {
      PreparedStatement ps = null;
      Date month = contractService.getDate();
      if (contractService.getId() > 0)
      {
        ps = this.con.prepareStatement("UPDATE " + this.tableName + " SET sid=?, date=?, amount=?, comment=? WHERE id=?");
        ps.setInt(5, contractService.getId());
      }
      else
      {
        ps = this.con.prepareStatement("INSERT INTO " + this.tableName + " SET sid=?, date=?, amount=?, comment=?, cid=?", 1);
       
        ps.setInt(5, contractService.getContractId());
      }
      ps.setInt(1, contractService.getServiceId());
      ps.setDate(2, TimeUtils.convertDateToSqlDate(month));
      ps.setLong(3, contractService.getAmount());
      ps.setString(4, contractService.getComment());
     
      ps.executeUpdate();
      if (contractService.getId() <= 0) {
        contractService.setId(ServerUtils.lastInsertId(ps));
      }
    }
    catch (SQLException ex)
    {
      throw new BGException(ex);
    }
  }


rscm: вер. 7.0.190 / 31.05.2018 15:53:23


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 01 сен 2018, 15:03 
Не в сети
Клиент
Аватара пользователя

Зарегистрирован: 20 апр 2009, 12:03
Сообщения: 3092
Откуда: Иркутск
Карма: 338
При пересчёте в модуле Inet за прошлый месяц:

Код:
...
com.mysql.jdbc.JDBC42PreparedStatement@68728705: UPDATE inet_tariff_traffic_range_30 SET amount = 8606648065, maxAmount = 15728640000,  counter = counter + 1 WHERE contractId = 201354 AND treeNodeId = 914828279511 AND rangeKey = 144115188208107527  AND yy =2018 AND mm=8 AND (@counter:=counter) IS NOT NULL
com.mysql.jdbc.JDBC42PreparedStatement@30fb182: INSERT INTO inet_tariff_traffic_range_30 ( contractId, treeNodeId, rangeKey, amount, yy, mm, counter, maxAmount )  VALUES (** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,1,** NOT SPECIFIED **)
com.mysql.jdbc.JDBC42PreparedStatement@4a0e0743: INSERT INTO inet_tariff_traffic_max_detail_30_201808 ( contractId, treeNodeId, maxKey, day, amountMax, amount1, amount2  )  VALUES (** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **)
com.mysql.jdbc.JDBC42PreparedStatement@28e5beb3: UPDATE inet_tariff_traffic_max_detail_30_201808 SET  amountMax = ** NOT SPECIFIED **, amount1 = ** NOT SPECIFIED **, amount2 = ** NOT SPECIFIED **   WHERE  contractId = ** NOT SPECIFIED ** AND treeNodeId = ** NOT SPECIFIED ** AND maxKey = ** NOT SPECIFIED ** AND day = ** NOT SPECIFIED **
com.mysql.jdbc.JDBC42PreparedStatement@3163a9c5: INSERT INTO inet_tariff_traffic_range_detail_30_201808 ( contractId, treeNodeId, rangeKey, day, amount  )  VALUES (** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **)
com.mysql.jdbc.JDBC42PreparedStatement@3476997c: UPDATE inet_tariff_traffic_range_detail_30_201808 SET  amount=582209241 WHERE  contractId = 201354 AND treeNodeId = 914828279511 AND rangeKey = 144115188208107527 AND day = 31

java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369
        at ru.bitel.bgbilling.server.dbcp.DbcpPoolableConnection.close(DbcpPoolableConnection.java:53)
        at ru.bitel.bgbilling.server.dbcp.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48)
...


inet: вер. 7.0.928 / 07.08.2018 19:50:48


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 01 окт 2018, 16:39 
Не в сети

Зарегистрирован: 29 янв 2014, 11:32
Сообщения: 365
Карма: 10
spectrum писал(а):
Выполняется следующий код:
Код:
public void chargeNpay(Vars vars, ArrayList<Integer> chargingContractsList) {
      String email = null;      
      int serviceSet = 0;
      String cids = chargingContractsList.get(0).toString();
//Формируем строку из списка договоров. Количество около 300 шт
      if (chargingContractsList.size() > 1) {
         for (int i = 1; i < chargingContractsList.size(); i++) {
            cids = cids + "," + chargingContractsList.get(i).toString();
         }
      }      
      new RunTaskDataManager(vars.con)
            .addTask(new Recalculator(NPAY_MID, Calendar.getInstance(), email, serviceSet, cids, ""));
}




В логах:
Код:
06-01/12:01:11  INFO [Thread-12] RunTaskDataManager - get next tasks: new task id=22483 bitel.billing.server.npay.Recalculator@1f1c8a6
06-01/12:01:11  INFO [Thread-12] TaskRunProcessor - Running Task: bitel.billing.server.npay.Recalculator@1f1c8a6
06-01/12:01:11  INFO [pool-1-thread-8] Recalculator - PaymentRecalculator time: 01.06.2017 23
06-01/12:01:11  INFO [pool-1-thread-8] Calculator - Memory total: 68 157 440; max: 239 075 328; free: 20 726 096
Memory pools:
  Non-heap memory[Code Cache]: max: 251 658 240; used: 29 536 704; peek: 29 548 352
  Non-heap memory[Metaspace]: max: -1; used: 30 984 232; peek: 30 984 232
  Non-heap memory[Compressed Class Space]: max: 1 073 741 824; used: 3 321 064; peek: 3 342 288
  Heap memory[PS Eden Space]: max: 84 934 656; used: 3 044 768; peek: 52 953 088
  Heap memory[PS Survivor Space]: max: 2 097 152; used: 229 376; peek: 8 646 240
  Heap memory[PS Old Gen]: max: 179 306 496; used: 44 157 200; peek: 59 567 016
Thread count: 55
06-01/12:01:13  INFO [pool-2-thread-7] LoggingPrintStream - FractionalChrageNpay end
06-01/12:01:13 ERROR [pool-2-thread-7] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[25] - SELECT * FROM global_script_link WHERE id=8
com.mysql.jdbc.PreparedStatement@3f4858e8: SELECT * FROM contract WHERE id=5118
com.mysql.jdbc.PreparedStatement@195f3364: SELECT * FROM contract WHERE id=4610
com.mysql.jdbc.PreparedStatement@2538e770: SELECT * FROM contract WHERE id=4610
com.mysql.jdbc.PreparedStatement@4916910b: SELECT * FROM contract WHERE id=4610

Плюс много таких строк
.
.
.
java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369
        at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:426)
        at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48)
        at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:272)
        at ru.bitel.bgbilling.kernel.base.server.DefaultContext.destroy(DefaultContext.java:37)
        at ru.bitel.bgbilling.kernel.container.managed.ServerContext.destroy(ServerContext.java:400)
        at ru.bitel.common.worker.ThreadContext.pop(ThreadContext.java:54)
        at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:90)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
06-01/12:01:13  INFO [pool-2-thread-7] GlobalScriptTimer - Task finished time=13181 ms.
06-01/12:01:15  INFO [pool-1-thread-8] Calculator - Setting balances for independ and subs..
06-01/12:01:15  INFO [pool-1-thread-8] Calculator - Selected.
06-01/12:01:21  INFO [pool-1-thread-8] Calculator - Selecting sub account
06-01/12:01:21  INFO [pool-1-thread-8] Calculator - Selected.
06-01/12:01:21  INFO [pool-1-thread-8] Calculator - Setting balance for super..
06-01/12:01:21  INFO [pool-1-thread-8] Calculator - Selected.
06-01/12:01:21  INFO [pool-1-thread-8] Calculator - Task finished time=9818 ms.
06-01/12:01:21  INFO [pool-1-thread-8] Recalculator - RunTask finished time=9818 ms.



About:
Код:
Информация о версии:

  Клиент: вер. 6.2.855 / 20.03.2017 20:56:51
    os: Windows 7; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_121
  Сервер: вер. 6.2.1169 / 21.03.2017 18:23:05
    os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_60

  bvcom: вер. 6.2.95 / 14.07.2016 14:11:19
  card: вер. 6.2.43 / 16.03.2017 23:47:47
  enaza: вер. 6.2.60 / 10.03.2017 18:11:30
  gorod: вер. 6.2.164 / 01.03.2016 00:18:32
  inet: вер. 6.2.714 / 20.03.2017 20:51:11
  mps: вер. 6.2.223 / 21.03.2017 16:41:20
  npay: вер. 6.2.198 / 03.02.2017 21:00:04
  rentsoft: вер. 6.2.63 / 04.10.2016 19:16:26
  reports: вер. 6.2.216 / 15.03.2017 19:48:19

  Сервер:
    os: Linux amd64, 3.10.0-229.11.1.el7.x86_64
    java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_60
    jre home: /opt/jdk1.8.0_60/jre
    default tz: 01.06.2017 14:23 MSK +0300 (Europe/Moscow)
    db time: master: 01.06.2017 14:23 MSK
    db charset: connection: utf8(utf8_unicode_ci), database: utf8(utf8_unicode_ci)
    locale: ru_RU
    uptime: Started: 12.05.2017 06:48:24 Uptime: 20 d 07:35:19


Чем чревата эта ошибка и как исправить?

UPD: кстати, в SELECT много повторяющихся строк с одним и тем же id. Это и в переведенном отрывке видно.


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



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

Сегодня при использовании этого метода произошла очень неприятная ситуация - почему-то было произведено начисление вообще по всем договорам, а не только из списка.


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 01 окт 2018, 18:14 
Не в сети
Аватара пользователя

Зарегистрирован: 30 май 2008, 15:51
Сообщения: 6055
Карма: 244
ну версия у вас очень старая, там давно могли уже исправить. прежде всего обновиться до последних билдов.

Цитата:
Сегодня при использовании этого метода произошла очень неприятная ситуация - почему-то было произведено начисление вообще по всем договорам, а не только из списка.

ну это с описываемым не связано.
может просто кто-то руками тупо переобсчёт запустил из клиента, не выбрав конкретный договор ткнули кнопку начисление
потому что код такой тоже не мог к такому привести. там cids напрямую во всех sql-запросах используется в калькуляторе.

_________________
I'm clever. I've got a computer.


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 01 окт 2018, 19:03 
Не в сети

Зарегистрирован: 29 янв 2014, 11:32
Сообщения: 365
Карма: 10
Версия сейчас такая:
Код:
Клиент: вер. 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


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 07 окт 2018, 01:10 
Не в сети
Аватара пользователя

Зарегистрирован: 30 май 2008, 15:51
Сообщения: 6055
Карма: 244
ну так это ваш код или как?

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

что такое vars.con, откуда оно бёрется? этот коннекшен потом закрывается корректно?

_________________
I'm clever. I've got a computer.


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 16 окт 2018, 19:11 
Не в сети

Зарегистрирован: 29 янв 2014, 11:32
Сообщения: 365
Карма: 10
Да, это коннекшен: vars.con = connectionSet.getConnection();
Его необходимо закрывать?

Этот метод
new RunTaskDataManager(vars.con).addTask(new Recalculator(NPAY_MID, Calendar.getInstance(), email, serviceSet, cids, ""));
вызывается только один раз в скрипте в конце исполнения, но в cids много договоров, около 150 шт за раз.


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 27 дек 2018, 19:21 
Не в сети
Клиент

Зарегистрирован: 12 янв 2012, 16:12
Сообщения: 56
Откуда: г. Новосибирск
Карма: 8
Цитата:
com.mysql.cj.jdbc.ServerPreparedStatement[935]: SELECT mid FROM contract_module WHERE cid=** NOT SPECIFIED AND mid= NOT SPECIFIED ** FOR UPDATE

java.lang.RuntimeException: viewtopic.php?t=7369
at ru.bitel.bgbilling.server.dbcp.DbcpPoolableConnection.close(DbcpPoolableConnection.java:53)
at ru.bitel.bgbilling.server.dbcp.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48)

Только только обновил 7.0 на 7.1

Цитата:
Java version is 1.8 (1.8.0_121)
BGBillingServer v 7.1.1078 / 26.12.2018 12:39:55


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 29 янв 2019, 09:46 
Не в сети
Клиент
Аватара пользователя

Зарегистрирован: 29 мар 2010, 23:11
Сообщения: 5854
Карма: 472
Код:
  Сервер: вер. 7.2.932 / 27.01.2019 11:30:23
    os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_191

Код:
server 01-29/06:09:06 ERROR [http-nio-127.0.0.1-8080-exec-7] LoggingPrintStream - Warning: Could not get charToByteConverterClass!
mq 01-29/06:23:25 ERROR [event-proc-p-2-t-1] DbcpPoolableConnection - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[168937] - SELECT mid FROM contract_module WHERE cid=null AND mid=null FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[168962] - SELECT mid FROM contract_module WHERE cid=null AND mid=null FOR UPDATE


java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369
   at ru.bitel.bgbilling.server.dbcp.DbcpPoolableConnection.close(DbcpPoolableConnection.java:53)
   at ru.bitel.bgbilling.server.dbcp.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48)
   at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:308)
   at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:405)
   at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:104)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
   at java.lang.Thread.run(Thread.java:748)
   at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:46)

_________________
Цитаты великих людей :umnik:
Напишите в helpdesk © stark
повторяю: => хелпдеск => доработка => профит © dimOn
свершилось... © skn
Мой код изящен, лёгок, оригинален, краток. Как прохладный весенний ветерок, как звонкий ручей! © dimOn
Вежливый разработчик © Artur
Эти баги тоже исправлены, как и те, которые еще не написаны © Artur
ну т.е. существует воркэраунд, ок © dimOn


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 21 фев 2019, 05:24 
Не в сети

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


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 26 фев 2019, 15:48 
Не в сети
Разработчик
Аватара пользователя

Зарегистрирован: 19 дек 2006, 21:04
Сообщения: 5970
Карма: 256
Цитата:
добрый день, у меня после обновления с 6.2 на 7.0 появляются подобные логи при "Начисление NPay абонплат"
Добрый день. Выложим обновление в ближайшее время. Не должно быть критично


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Незакрытые preparedStatement (CRM)
СообщениеДобавлено: 04 май 2019, 15:20 
Не в сети
Клиент

Зарегистрирован: 09 фев 2011, 15:28
Сообщения: 1092
Карма: 135
Сервер: вер. 7.1.1114 / 18.03.2019 21:32:01

Код:
java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369
        at ru.bitel.bgbilling.server.dbcp.DbcpPoolableConnection.close(DbcpPoolableConnection.java:53)
        at ru.bitel.bgbilling.server.dbcp.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48)
        at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:308)
        at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:405)
        at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:72)
        at ru.bitel.bgbilling.kernel.event.EventListenerThreadContext$2.rejectedExecution(EventListenerThreadContext.java:91)
        at java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:830)
        at java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1379)
        at ru.bitel.bgbilling.kernel.event.Consumer.onMessage(Consumer.java:159)
        at org.apache.activemq.ActiveMQMessageConsumer.dispatch(ActiveMQMessageConsumer.java:1401)
        at org.apache.activemq.ActiveMQSessionExecutor.dispatch(ActiveMQSessionExecutor.java:131)
        at org.apache.activemq.ActiveMQSessionExecutor.iterate(ActiveMQSessionExecutor.java:202)
        at org.apache.activemq.thread.PooledTaskRunner.runTask(PooledTaskRunner.java:133)
        at org.apache.activemq.thread.PooledTaskRunner$1.run(PooledTaskRunner.java:48)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
mq 05-03/00:15:14 ERROR [ActiveMQ Session Task-2267] DbcpPoolableConnection - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[3199] - SELECT * FROM voice_account_port_2 WHERE accountId=213 ORDER BY port
com.mysql.jdbc.ServerPreparedStatement[3289] - SELECT * FROM voice_account_port_2 WHERE accountId=183 ORDER BY port
com.mysql.jdbc.ServerPreparedStatement[3313] - SELECT * FROM voice_account_port_2 WHERE accountId=210 ORDER BY port


Вернуться к началу
 Профиль  
 
Показать сообщения за:  Поле сортировки  
Начать новую тему Ответить на тему  [ Сообщений: 359 ]  На страницу Пред.  1 ... 8, 9, 10, 11, 12

Часовой пояс: UTC + 5 часов [ Летнее время ]


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

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


Вы не можете начинать темы
Вы не можете отвечать на сообщения
Вы не можете редактировать свои сообщения
Вы не можете удалять свои сообщения
Вы не можете добавлять вложения

Найти:
Перейти:  
cron
POWERED_BY
Русская поддержка phpBB
[ Time : 0.113s | 79 Queries | GZIP : On ]