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

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

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

Сообщение aleontyev » 22 мар 2016, 14:10

$this->bbcode_second_pass_quote('stark', '')ут проблема у вас . Вы скорее всего много раз вызываете метод ContractLink. Либо передавайте туда cm либо внутри после использования вызывайте cm.recycle();


Спасибо за информацию. Да, вызывается часто. Подумаем, что с этим делать.
aleontyev
 
Сообщения: 13
Зарегистрирован: 18 мар 2016, 11:50

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

Сообщение stark » 22 мар 2016, 14:18

$this->bbcode_second_pass_quote('aleontyev', '')$this->bbcode_second_pass_quote('stark', '')ут проблема у вас . Вы скорее всего много раз вызываете метод ContractLink. Либо передавайте туда cm либо внутри после использования вызывайте cm.recycle();


Спасибо за информацию. Да, вызывается часто. Подумаем, что с этим делать.


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

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

Сообщение aleontyev » 22 мар 2016, 14:34

$this->bbcode_second_pass_quote('stark', '')$this->bbcode_second_pass_quote('aleontyev', '')$this->bbcode_second_pass_quote('stark', '')ут проблема у вас . Вы скорее всего много раз вызываете метод ContractLink. Либо передавайте туда cm либо внутри после использования вызывайте cm.recycle();


Спасибо за информацию. Да, вызывается часто. Подумаем, что с этим делать.


Тут не то чтобы часто, а на одном соединении если вызывается пока оно не закрыто.


Блин :) Значит я вас правильно понял в первый раз :D
aleontyev
 
Сообщения: 13
Зарегистрирован: 18 мар 2016, 11:50
Вернуться к началу

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

Сообщение Phricker » 10 май 2016, 14:53

7.0
$this->bbcode_second_pass_code('', 'server 05-10/11:49:23 ERROR [http-bio-127.0.0.1-8080-exec-10] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[2043] - SELECT * FROM contract WHERE id=158492
com.mysql.jdbc.ServerPreparedStatement[2183] - SELECT * FROM tariff_group WHERE id=39
com.mysql.jdbc.ServerPreparedStatement[2184] - SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=39
com.mysql.jdbc.ServerPreparedStatement[2185] - SELECT * FROM tariff_group WHERE id=39
com.mysql.jdbc.ServerPreparedStatement[2186] - SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=39
com.mysql.jdbc.ServerPreparedStatement[2187] - SELECT * FROM tariff_group WHERE id=39
com.mysql.jdbc.ServerPreparedStatement[2188] - SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=39
com.mysql.jdbc.ServerPreparedStatement[2189] - SELECT * FROM tariff_group WHERE id=39
com.mysql.jdbc.ServerPreparedStatement[2190] - SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=39
')
Цитаты великих людей :umnik:
Напишите в helpdesk © stark
повторяю: => хелпдеск => доработка => профит © dimOn
свершилось... © skn
Мой код изящен, лёгок, оригинален, краток. Как прохладный весенний ветерок, как звонкий ручей! © dimOn
Вежливый разработчик © Artur
Эти баги тоже исправлены, как и те, которые еще не написаны © Artur
ну т.е. существует воркэраунд, ок © dimOn
Аватара пользователя
Phricker
Клиент
 
Сообщения: 5775
Зарегистрирован: 29 мар 2010, 23:11

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

Сообщение stark » 10 май 2016, 15:02

$this->bbcode_second_pass_quote('Phricker', '7').0
$this->bbcode_second_pass_code('', 'server 05-10/11:49:23 ERROR [http-bio-127.0.0.1-8080-exec-10] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[2043] - SELECT * FROM contract WHERE id=158492
com.mysql.jdbc.ServerPreparedStatement[2183] - SELECT * FROM tariff_group WHERE id=39
com.mysql.jdbc.ServerPreparedStatement[2184] - SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=39
com.mysql.jdbc.ServerPreparedStatement[2185] - SELECT * FROM tariff_group WHERE id=39
com.mysql.jdbc.ServerPreparedStatement[2186] - SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=39
com.mysql.jdbc.ServerPreparedStatement[2187] - SELECT * FROM tariff_group WHERE id=39
com.mysql.jdbc.ServerPreparedStatement[2188] - SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=39
com.mysql.jdbc.ServerPreparedStatement[2189] - SELECT * FROM tariff_group WHERE id=39
com.mysql.jdbc.ServerPreparedStatement[2190] - SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=39
')



Вы TariffGroupDao в своих скриптах нее используете ?
stark
Разработчик
 
Сообщения: 8343
Зарегистрирован: 08 ноя 2007, 01:05
Откуда: Уфа
Вернуться к началу

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

Сообщение Phricker » 10 май 2016, 15:33

Изображение
Первый - глобальный скрипт разово добавивший на договора тарифные группы.
Второй - глобальный скрипт разово создавший тарифные группы для всех контрагентов.
Не запускались уже очень давно.
Цитаты великих людей :umnik:
Напишите в helpdesk © stark
повторяю: => хелпдеск => доработка => профит © dimOn
свершилось... © skn
Мой код изящен, лёгок, оригинален, краток. Как прохладный весенний ветерок, как звонкий ручей! © dimOn
Вежливый разработчик © Artur
Эти баги тоже исправлены, как и те, которые еще не написаны © Artur
ну т.е. существует воркэраунд, ок © dimOn
Аватара пользователя
Phricker
Клиент
 
Сообщения: 5775
Зарегистрирован: 29 мар 2010, 23:11

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

Сообщение Phricker » 10 май 2016, 16:22

$this->bbcode_second_pass_code('', 'ava.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369
at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:426)
at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48)
at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:272)
at ru.bitel.bgbilling.kernel.base.server.DefaultContext.destroy(DefaultContext.java:37)
at ru.bitel.bgbilling.kernel.container.managed.ServerContext.destroy(ServerContext.java:400)
at bitel.billing.server.ActionBase.freeConnection(ActionBase.java:180)
at bitel.billing.server.Executer.doModule(SourceFile:649)
at bitel.billing.server.Executer$1.run(SourceFile:199)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:422)
at bitel.billing.server.Executer.doPost(SourceFile:193)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at ru.bitel.common.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:54)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
')
Цитаты великих людей :umnik:
Напишите в helpdesk © stark
повторяю: => хелпдеск => доработка => профит © dimOn
свершилось... © skn
Мой код изящен, лёгок, оригинален, краток. Как прохладный весенний ветерок, как звонкий ручей! © dimOn
Вежливый разработчик © Artur
Эти баги тоже исправлены, как и те, которые еще не написаны © Artur
ну т.е. существует воркэраунд, ок © dimOn
Аватара пользователя
Phricker
Клиент
 
Сообщения: 5775
Зарегистрирован: 29 мар 2010, 23:11

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

Сообщение stark » 10 май 2016, 16:36

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

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

Сообщение Phricker » 19 май 2016, 01:30

$this->bbcode_second_pass_code('', 'server 05-18/22:25:45 ERROR [http-bio-127.0.0.1-8080-exec-2] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.PreparedStatement@9826202: SELECT * FROM contract WHERE id=151942
com.mysql.jdbc.JDBC42PreparedStatement@7cd108e9: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.JDBC42PreparedStatement@383987f5: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@5bf97bf8: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@513462c9: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@212076c1: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@5271ee44: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@4ec32fb7: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@92650d3: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@72d7e58f: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@5aa21a0a: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@607da114: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@c9774e7: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@827c3c5: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@24edb953: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@4a235b22: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@6a909263: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@510cc931: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@7dc77ef7: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@444c37d0: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@63182d38: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@31d23d79: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@6ef48463: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@9dcc27: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@27e67fc8: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@7ab83f0f: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@58f2b2b3: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@1247461b: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@545fa0c: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@52b444b8: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@19947288: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@37c7b398: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@d6f65d: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@f4e769f: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@53878d07: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@14568e88: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@acd7681: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@4f7e996e: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@cfcf39d: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@31927ef6: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@3722dcdc: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@2712be48: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@fefc97: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@4df51f6c: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@593895cd: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@4232d738: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@614483f7: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@4ee86bcf: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@533b16eb: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@5a83135: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@27b1b963: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@4bc30fed: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@5fe180ca: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@6bf43e6f: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@1983bc78: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@7590b871: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@798afb86: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@276db98b: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@14b8f3fc: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@1efec2f3: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@4d3fa94d: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@742c5196: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@5950d89c: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@2d812052: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@4e0cc084: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@2a3dd7d1: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@54dcd248: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@75855b1c: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@76ad8996: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@418796ba: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@7de5c0b9: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@56691e18: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@45d4f189: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@2965cfd6: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@6b0d0fc: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@77053fbf: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@46bfd777: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@3824d0ef: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@5747a8bc: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@440dfa7c: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@1372cd5a: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@31630738: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@17e85f8: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@15982a5a: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@63ade9b8: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@24ddb850: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@75f9aed2: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@604811f9: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@727e1768: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@4fb9ec45: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@360004e2: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@137fb17: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@7e922393: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@3cfcbf6c: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@1a3fc678: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@3153b524: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@48b3e32a: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@38d0018b: SELECT * FROM tariff_group WHERE id=88
com.mysql.jdbc.PreparedStatement@67c2cc14: SELECT `group`.tpid, tariff.title, `group`.date1, `group`.date2 FROM tariff_group_tariff as `group` LEFT JOIN tariff_plan as `tariff` ON tariff.id=`group`.tpid WHERE `group`.tgid=88
com.mysql.jdbc.PreparedStatement@77939399: SELECT * FROM tariff_group WHERE id=88

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

$this->bbcode_second_pass_code('', ' Клиент: вер. 7.0.810 / 16.05.2016 17:16:53
os: Windows 8.1; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_91
Сервер: вер. 7.0.1039 / 16.05.2016 17:18:36
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_91')
Цитаты великих людей :umnik:
Напишите в helpdesk © stark
повторяю: => хелпдеск => доработка => профит © dimOn
свершилось... © skn
Мой код изящен, лёгок, оригинален, краток. Как прохладный весенний ветерок, как звонкий ручей! © dimOn
Вежливый разработчик © Artur
Эти баги тоже исправлены, как и те, которые еще не написаны © Artur
ну т.е. существует воркэраунд, ок © dimOn
Аватара пользователя
Phricker
Клиент
 
Сообщения: 5775
Зарегистрирован: 29 мар 2010, 23:11

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

Сообщение Phricker » 19 май 2016, 01:52

Ошибка возникает в момент когда нажимаешь кнопку + в глобальных тарифах на договоре.
У нас используются тарифные группы и установлены все три галочки включая "Фильтр по группе тарифа".
Цитаты великих людей :umnik:
Напишите в helpdesk © stark
повторяю: => хелпдеск => доработка => профит © dimOn
свершилось... © skn
Мой код изящен, лёгок, оригинален, краток. Как прохладный весенний ветерок, как звонкий ручей! © dimOn
Вежливый разработчик © Artur
Эти баги тоже исправлены, как и те, которые еще не написаны © Artur
ну т.е. существует воркэраунд, ок © dimOn
Аватара пользователя
Phricker
Клиент
 
Сообщения: 5775
Зарегистрирован: 29 мар 2010, 23:11

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

Сообщение stark » 19 май 2016, 12:39

$this->bbcode_second_pass_quote('Phricker', '
')$this->bbcode_second_pass_code('', ' Клиент: вер. 7.0.810 / 16.05.2016 17:16:53
os: Windows 8.1; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_91
Сервер: вер. 7.0.1039 / 16.05.2016 17:18:36
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_91')


Странно, как раз это место вроде и исправляли. И выложили 12-го числа.
stark
Разработчик
 
Сообщения: 8343
Зарегистрирован: 08 ноя 2007, 01:05
Откуда: Уфа
Вернуться к началу

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

Сообщение stark » 19 май 2016, 12:50

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

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

Сообщение Phricker » 19 май 2016, 13:02

$this->bbcode_second_pass_quote('stark', '')е совсем правильно исправили. Будет еще одно обновление.

Как и в прошлый раз отвалится поиск договоров для контрагентов или можно безопасно обновляться? :D
Цитаты великих людей :umnik:
Напишите в helpdesk © stark
повторяю: => хелпдеск => доработка => профит © dimOn
свершилось... © skn
Мой код изящен, лёгок, оригинален, краток. Как прохладный весенний ветерок, как звонкий ручей! © dimOn
Вежливый разработчик © Artur
Эти баги тоже исправлены, как и те, которые еще не написаны © Artur
ну т.е. существует воркэраунд, ок © dimOn
Аватара пользователя
Phricker
Клиент
 
Сообщения: 5775
Зарегистрирован: 29 мар 2010, 23:11
Вернуться к началу

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

Сообщение stark » 19 май 2016, 13:04

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

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

Сообщение stark » 19 май 2016, 13:21

$this->bbcode_second_pass_quote('Phricker', '[')offtop]$this->bbcode_second_pass_quote('stark', '')е совсем правильно исправили. Будет еще одно обновление.

Как и в прошлый раз отвалится поиск договоров для контрагентов или можно безопасно обновляться? :D[/offtop]


в этот раз там только sbrf менялся и данная ошибка исправлена
stark
Разработчик
 
Сообщения: 8343
Зарегистрирован: 08 ноя 2007, 01:05
Откуда: Уфа
Вернуться к началу

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

Сообщение Phricker » 19 май 2016, 13:22

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

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

Сообщение Phricker » 19 май 2016, 18:06

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

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

Сообщение Phricker » 23 май 2016, 16:55

Есть подозрение на начисление абонплат примерно в это время.
$this->bbcode_second_pass_code('', 'mq 05-23/00:17:04 ERROR [ActiveMQ Session Task] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.PreparedStatement@a3f4f23: SELECT * FROM contract WHERE id=182727
com.mysql.jdbc.PreparedStatement@649441eb: SELECT * FROM contract WHERE id=182727
com.mysql.jdbc.PreparedStatement@7e484267: SELECT * FROM tariff_plan WHERE id=645
com.mysql.jdbc.PreparedStatement@d3dde69: SELECT * FROM contract WHERE id=182734
com.mysql.jdbc.PreparedStatement@501f276b: SELECT * FROM contract WHERE id=182734
com.mysql.jdbc.PreparedStatement@5bf89e41: SELECT * FROM tariff_plan WHERE id=645
com.mysql.jdbc.PreparedStatement@4183792f: SELECT * FROM contract WHERE id=182738
com.mysql.jdbc.PreparedStatement@51aa1697: SELECT * FROM contract WHERE id=182738
com.mysql.jdbc.PreparedStatement@4ef05fc9: SELECT * FROM tariff_plan WHERE id=903
com.mysql.jdbc.PreparedStatement@7bb33169: SELECT * FROM contract WHERE id=182755
com.mysql.jdbc.PreparedStatement@3023f0ac: SELECT * FROM contract WHERE id=182755
com.mysql.jdbc.PreparedStatement@74003f0d: SELECT * FROM tariff_plan WHERE id=393
com.mysql.jdbc.PreparedStatement@31b19117: SELECT * FROM contract WHERE id=182772
com.mysql.jdbc.PreparedStatement@1ca1d4f8: SELECT * FROM contract WHERE id=182772
com.mysql.jdbc.PreparedStatement@8d882e3: SELECT * FROM tariff_plan WHERE id=782
com.mysql.jdbc.PreparedStatement@363c5807: SELECT * FROM contract WHERE id=182773
com.mysql.jdbc.PreparedStatement@34baca3: SELECT * FROM contract WHERE id=182773
com.mysql.jdbc.PreparedStatement@16882ae6: SELECT * FROM tariff_plan WHERE id=889
com.mysql.jdbc.PreparedStatement@681e4d81: SELECT * FROM contract WHERE id=182777
com.mysql.jdbc.PreparedStatement@7118dc75: SELECT * FROM contract WHERE id=182777
com.mysql.jdbc.PreparedStatement@230ec037: SELECT * FROM tariff_plan WHERE id=1036
com.mysql.jdbc.PreparedStatement@7b3ae2d6: SELECT * FROM contract WHERE id=182805
com.mysql.jdbc.PreparedStatement@ac8532b: SELECT * FROM contract WHERE id=182805
com.mysql.jdbc.PreparedStatement@7dbc9327: SELECT * FROM tariff_plan WHERE id=873
com.mysql.jdbc.PreparedStatement@15889e57: SELECT * FROM contract WHERE id=182817
com.mysql.jdbc.PreparedStatement@25ed8faa: SELECT * FROM contract WHERE id=182817
com.mysql.jdbc.PreparedStatement@271c3a7a: SELECT * FROM tariff_plan WHERE id=645
com.mysql.jdbc.PreparedStatement@4aca2d91: SELECT * FROM contract WHERE id=182821
com.mysql.jdbc.PreparedStatement@453da7df: SELECT * FROM contract WHERE id=182821
com.mysql.jdbc.PreparedStatement@253aaf2: SELECT * FROM tariff_plan WHERE id=889
com.mysql.jdbc.PreparedStatement@3c8d217d: SELECT * FROM contract WHERE id=182826
com.mysql.jdbc.PreparedStatement@e815bee: SELECT * FROM contract WHERE id=182826
com.mysql.jdbc.PreparedStatement@271af749: SELECT * FROM tariff_plan WHERE id=889
com.mysql.jdbc.PreparedStatement@3eaa631e: SELECT * FROM contract WHERE id=182839
com.mysql.jdbc.PreparedStatement@113f46fc: SELECT * FROM contract WHERE id=182839
com.mysql.jdbc.PreparedStatement@280f31be: SELECT * FROM tariff_plan WHERE id=727
com.mysql.jdbc.PreparedStatement@1286ea0f: SELECT * FROM contract WHERE id=182844
com.mysql.jdbc.PreparedStatement@6fe55dae: SELECT * FROM contract WHERE id=182844
com.mysql.jdbc.PreparedStatement@2f48edab: SELECT * FROM tariff_plan WHERE id=393
com.mysql.jdbc.PreparedStatement@effc9b9: SELECT * FROM contract WHERE id=182854
com.mysql.jdbc.PreparedStatement@59b776fc: SELECT * FROM contract WHERE id=182854
com.mysql.jdbc.PreparedStatement@36b1027c: SELECT * FROM tariff_plan WHERE id=761
com.mysql.jdbc.PreparedStatement@20106e98: SELECT * FROM contract WHERE id=182859
com.mysql.jdbc.PreparedStatement@62e6ff7e: SELECT * FROM contract WHERE id=182859
com.mysql.jdbc.PreparedStatement@33b15144: SELECT * FROM tariff_plan WHERE id=645
com.mysql.jdbc.PreparedStatement@1e8e1e74: SELECT * FROM contract WHERE id=182872
com.mysql.jdbc.PreparedStatement@23427cd: SELECT * FROM contract WHERE id=182872
com.mysql.jdbc.PreparedStatement@322e9733: SELECT * FROM tariff_plan WHERE id=889
com.mysql.jdbc.PreparedStatement@7623f345: SELECT * FROM contract WHERE id=182882
com.mysql.jdbc.PreparedStatement@420b8634: SELECT * FROM contract WHERE id=182882
com.mysql.jdbc.PreparedStatement@10a281a6: SELECT * FROM tariff_plan WHERE id=889
')
Цитаты великих людей :umnik:
Напишите в helpdesk © stark
повторяю: => хелпдеск => доработка => профит © dimOn
свершилось... © skn
Мой код изящен, лёгок, оригинален, краток. Как прохладный весенний ветерок, как звонкий ручей! © dimOn
Вежливый разработчик © Artur
Эти баги тоже исправлены, как и те, которые еще не написаны © Artur
ну т.е. существует воркэраунд, ок © dimOn
Аватара пользователя
Phricker
Клиент
 
Сообщения: 5775
Зарегистрирован: 29 мар 2010, 23:11

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

Сообщение stark » 23 май 2016, 17:04

$this->bbcode_second_pass_quote('Phricker', '')сть подозрение на начисление абонплат примерно в это время.


Планировщик или сервер ?
stark
Разработчик
 
Сообщения: 8343
Зарегистрирован: 08 ноя 2007, 01:05
Откуда: Уфа
Вернуться к началу

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

Сообщение Phricker » 23 май 2016, 17:13

server.error.log
Цитаты великих людей :umnik:
Напишите в helpdesk © stark
повторяю: => хелпдеск => доработка => профит © dimOn
свершилось... © skn
Мой код изящен, лёгок, оригинален, краток. Как прохладный весенний ветерок, как звонкий ручей! © dimOn
Вежливый разработчик © Artur
Эти баги тоже исправлены, как и те, которые еще не написаны © Artur
ну т.е. существует воркэраунд, ок © dimOn
Аватара пользователя
Phricker
Клиент
 
Сообщения: 5775
Зарегистрирован: 29 мар 2010, 23:11

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

Сообщение stark » 23 май 2016, 17:46

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

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

Сообщение Phricker » 23 май 2016, 17:47

Ну значит не абонплаты. Просто в это время больше вроде ничего не отрабатывает :)
Цитаты великих людей :umnik:
Напишите в helpdesk © stark
повторяю: => хелпдеск => доработка => профит © dimOn
свершилось... © skn
Мой код изящен, лёгок, оригинален, краток. Как прохладный весенний ветерок, как звонкий ручей! © dimOn
Вежливый разработчик © Artur
Эти баги тоже исправлены, как и те, которые еще не написаны © Artur
ну т.е. существует воркэраунд, ок © dimOn
Аватара пользователя
Phricker
Клиент
 
Сообщения: 5775
Зарегистрирован: 29 мар 2010, 23:11

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

Сообщение stark » 23 май 2016, 18:04

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


Можно посмотреть какие были запросы на сервер в это время . Вряд ли в это время (00:17) или чуть раньше( на случай если выполнялось долго) было много запросов.
Может отчет какой запускали .
stark
Разработчик
 
Сообщения: 8343
Зарегистрирован: 08 ноя 2007, 01:05
Откуда: Уфа
Вернуться к началу

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

Сообщение Phricker » 23 май 2016, 19:08

$this->bbcode_second_pass_quote('stark', '
')Можно посмотреть какие были запросы на сервер в это время .

Кроме отчетов только просмотр договоров.
Отчеты сидел упорно тыкал - не повторяется.

$this->bbcode_second_pass_code('', 'mq 05-23/00:13:53 ERROR [event-proc-p-2-t-1] DefaultServerSetup - Many statements was open at connection close:

mq 05-23/00:13:56 ERROR [event-proc-p-2-t-1] DefaultServerSetup - Many statements was open at connection close:

mq 05-23/00:13:58 ERROR [ActiveMQ Session Task] DefaultServerSetup - Many statements was open at connection close:

mq 05-23/00:14:00 ERROR [event-proc-p-2-t-1] DefaultServerSetup - Many statements was open at connection close:

mq 05-23/00:14:02 ERROR [ActiveMQ Session Task] DefaultServerSetup - Many statements was open at connection close:')
И в таком же роде долго и упорно.


$this->bbcode_second_pass_code('', 'java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369
at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:426)
at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48)
at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:272)
at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:370)
at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:71)
at ru.bitel.bgbilling.kernel.event.EventListenerThreadContext$2.rejectedExecution(EventListenerThreadContext.java:88)
at java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:823)
at java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:1369)
at ru.bitel.bgbilling.kernel.event.Consumer.onMessage(Consumer.java:159)
at org.apache.activemq.ActiveMQMessageConsumer.dispatch(ActiveMQMessageConsumer.java:1229)
at org.apache.activemq.ActiveMQSessionExecutor.dispatch(ActiveMQSessionExecutor.java:134)
at org.apache.activemq.ActiveMQSessionExecutor.iterate(ActiveMQSessionExecutor.java:205)
at org.apache.activemq.thread.PooledTaskRunner.runTask(PooledTaskRunner.java:122)
at org.apache.activemq.thread.PooledTaskRunner$1.run(PooledTaskRunner.java:43)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)')
$this->bbcode_second_pass_code('', 'java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369
at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:426)
at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48)
at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:272)
at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:370)
at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:103)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:46)')
Цитаты великих людей :umnik:
Напишите в helpdesk © stark
повторяю: => хелпдеск => доработка => профит © dimOn
свершилось... © skn
Мой код изящен, лёгок, оригинален, краток. Как прохладный весенний ветерок, как звонкий ручей! © dimOn
Вежливый разработчик © Artur
Эти баги тоже исправлены, как и те, которые еще не написаны © Artur
ну т.е. существует воркэраунд, ок © dimOn
Аватара пользователя
Phricker
Клиент
 
Сообщения: 5775
Зарегистрирован: 29 мар 2010, 23:11
Вернуться к началу

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

Сообщение Villian » 25 май 2016, 17:34

АП
Villian
 
Сообщения: 116
Зарегистрирован: 30 ноя 2010, 14:22

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

Сообщение vkulakov » 03 июн 2016, 13:13

Игрался с отчётом по должникам, а потом в логах навалило:
$this->bbcode_second_pass_code('', '
server 06-02/16:29:44 ERROR [http-bio-127.0.0.1-8080-exec-10] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[1156] - SELECT summa1, summa1 + summa2 - summa3 - summa4 FROM contract_balance WHERE cid=21382 AND yy=2016 AND mm=05
com.mysql.jdbc.ServerPreparedStatement[1157] - SELECT summa1 + summa2 - summa3 - summa4 FROM contract_balance WHERE cid=21382 AND (yy<2016 OR (yy=2016 AND mm<=05)) ORDER BY yy DESC, mm DESC
com.mysql.jdbc.ServerPreparedStatement[1158] - SELECT t1.val as phone, t2.val as fio, t3.address as address FROM contract LEFT JOIN contract_parameter_type_1 as t1 ON contract.id=t1.cid AND t1.pid=1 LEFT JOIN contract_parameter_type_1 as t2 ON contract.id=t2.cid AND t2.pid=2 LEFT JOIN contract_parameter_type_2 as t3 ON contract.id=t3.cid AND t3.pid=3 WHERE contract.id=21382
com.mysql.jdbc.ServerPreparedStatement[1159] - SELECT SUM(summa) FROM contract_payment WHERE cid=null AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<TO_DAYS('2016-05-01')
com.mysql.jdbc.ServerPreparedStatement[1160] - SELECT SUM(summa) FROM contract_payment WHERE cid=21382 AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') AND pt!=0
com.mysql.jdbc.ServerPreparedStatement[1161] - SELECT SUM(summa) FROM contract_payment WHERE cid=21382 AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') AND pt=0
com.mysql.jdbc.ServerPreparedStatement[1162] - SELECT id, title, comment, scid, sub_list, sub_mode FROM contract WHERE gr&6088299485643521727>0 ORDER BY contract.title
com.mysql.jdbc.ServerPreparedStatement[1163] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17499,17500,17501,17502,26158,26167) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1165] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (5052) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1167] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (39039,39048) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1169] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (38780,38782) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1171] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (39022,39023) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1173] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (6500,28532,29191) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1175] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (38881) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1177] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (3257,3272,3273,5004,8510,16919,17307,21321,21457,22241,23571,24351,24693,25107,25179,26834,26936,27523,27993,28159,28514,28612,28626,30098,30208,30209,30255,30522,31723,32074,32452,32464,32691,33102,34450,34637,35878,36154,36454,37273,37381,37455,38338,38349,38412,38422,38786,38964,39396,39466,43812,43990,44292,44543,44647,44666,44667) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1179] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (589,2131,5676) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1181] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (1559,10915) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1183] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (264,265,266,1031,1043) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1185] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (951,1095,3341,4215,18250,18251,18252,18253,18254,18255,23466) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1187] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4921,6780,13209) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1189] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4452,6573) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1191] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (34714) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1193] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (2210) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1195] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17693) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1197] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (2699) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1199] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (24607,24608) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1201] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (29318) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1203] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (11629) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1205] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (33559) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1207] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (33918) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1209] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (25269) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1211] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (25350) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1213] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (267,268,20172,22771) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1215] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17199,17201,17503,17505,18408,19583,20819,22802,42035) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1217] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (28965) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1219] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (5996) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1221] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (948,950,937) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1223] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (24439,24440,24441,24442,24443) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1225] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (34604) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1227] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30326,30327) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1229] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30663) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1231] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30781,30782) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1233] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30791,30792) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1235] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30834) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1237] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30873,30874) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1239] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (31192,31193) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1241] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (34006,34972) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1243] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (31696) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1245] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32013,32014) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1247] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32742,32743) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1249] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32808,32809) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1251] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32821,32822) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1253] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32827,32828) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1255] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32857,32858) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1257] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32956,32957) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1259] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32986,32987) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1261] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (33119,33120) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1263] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17099,17102,29243,29246) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1265] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4001,4152,11093,17103) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1267] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (3390,3817,4057,5138,17850,39683) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1269] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (33741,33742,33743,33744,34277,34610) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1271] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (16277) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1273] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4726,11772,16025,16026) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1275] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (11904) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1277] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (22108) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1279] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (11597) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1281] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (7184,9700) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1283] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4401,4402,4403,4404,4405,4406,4407,4408,4409,4410,4411,4412,4413,4414,4415,4416,4417,4418,17617,33403) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1285] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4980) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1287] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (20346) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1289] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (6250,16824,17107,17108) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1291] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4465,4466,4467,4468) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1293] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (28970,28971,28972,28973,28974,28975) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1295] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (28543) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1297] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4252,4531,4532,23090) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1299] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4905,11624,11625) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1301] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (2543,20246,20248) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1303] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4874,4875,6471,9445,11857) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1305] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (14557) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1307] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (35271) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1309] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4968) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1311] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (18329,18331,33627,33629) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1313] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (25463) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1315] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (22440) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1317] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (18093) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1319] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (10287,10581,10592,23895) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1321] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (8251,17120) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1323] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17109) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1325] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (6788,6793,6794,6795,6797) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1327] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (15865,15866,16276,41616) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1329] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (34087) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1331] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (8660,8661,8667,11097,17121) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1333] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (11464) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1335] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (11379) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1337] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (7366,7367,11268,12049,12318) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1339] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17196) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1341] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (33406) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1343] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (36722) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1345] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (8044,41617) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1347] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (24600) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')

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

Клиент: вер. 6.2.873 / 04.12.2017 19:38:11
os: Windows 7; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_65
Сервер: вер. 6.2.1202 / 04.12.2017 19:39:21
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_91
vkulakov
Клиент
 
Сообщения: 932
Зарегистрирован: 07 мар 2012, 15:02
Откуда: Воронеж

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

Сообщение stark » 03 июн 2016, 13:58

$this->bbcode_second_pass_quote('vkulakov', '')грался с отчётом по должникам, а потом в логах навалило:


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

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

Сообщение Ping333 » 14 июл 2016, 19:22

Добрый день!
Незнаю, наверное тоже в эту тему, не могу понять откуда сыпятся.
беру номера поинтов по ним ищу параметры договора привязанные на поинт

Клиент: вер. 6.2.829 / 13.07.2016 17:30:26
os: Windows 7; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_73
Сервер: вер. 6.2.1087 / 14.07.2016 16:43:16
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_91

bill: вер. 6.2.87 / 10.06.2016 13:28:18
card: вер. 6.2.39 / 26.05.2016 14:50:45
dialup: вер. 6.2.315 / 01.03.2016 00:17:59
inet: вер. 6.2.670 / 13.07.2016 17:31:59
ipn: вер. 6.2.259 / 06.07.2016 19:29:33
npay: вер. 6.2.195 / 24.06.2016 16:25:14
pay: вер. ?
phone: вер. 6.2.279 / 06.06.2016 12:50:07
reports: вер. 6.2.209 / 06.06.2016 12:43:49
rscm: вер. 6.2.177 / 10.06.2016 13:40:20
ru.bitel.bgbilling.plugins.dispatch: вер. 6.2.85 / 11.07.2016 17:32:00
ru.bitel.bgbilling.plugins.documents: вер. 6.2.171 / 11.07.2016 17:46:28
ru.bitel.bgbilling.plugins.helpdesk: вер. 6.2.181 / 14.06.2016 14:50:40
trayinfo: вер. 6.2.170 / 02.02.2016 17:42:09
voiceip: вер. 6.2.190 / 03.03.2016 18:32:27

$this->bbcode_second_pass_code('', '
07-14/20:21:15 DEBUG [http-bio-0.0.0.0-8080-exec-3] CommonExecutor - executing bitel.billing.server.admin.action.ActionCommand; time => 1 ms.
07-14/20:21:15 DEBUG [http-bio-0.0.0.0-8080-exec-3] CommonExecutor - <?xml version="1.0" encoding="UTF-8"?><data status="ok"/>
07-14/20:21:16 DEBUG [http-bio-0.0.0.0-8080-exec-3] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.updateSource; time => 5 ms.
07-14/20:21:16 DEBUG [http-bio-0.0.0.0-8080-exec-3] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getDynamicClasses; time => 23 ms.
07-14/20:21:16 DEBUG [http-bio-0.0.0.0-8080-exec-3] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getSource; time => 2 ms.
07-14/20:21:16 DEBUG [http-bio-0.0.0.0-8080-exec-3] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getSource; time => 1 ms.
07-14/20:21:17 DEBUG [http-bio-0.0.0.0-8080-exec-3] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.compile; time => 335 ms.
07-14/20:21:17 DEBUG [http-bio-0.0.0.0-8080-exec-14] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getDynamicClasses; time => 217 ms.
07-14/20:21:17 DEBUG [http-bio-0.0.0.0-8080-exec-14] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getSource; time => 2 ms.
07-14/20:21:17 DEBUG [http-bio-0.0.0.0-8080-exec-14] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getSource; time => 1 ms.
07-14/20:21:18 DEBUG [http-bio-0.0.0.0-8080-exec-12] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.run; time => 833 ms.
07-14/20:21:18 ERROR [http-bio-0.0.0.0-8080-exec-12] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[620] - SELECT * FROM contract WHERE id=3620
com.mysql.jdbc.ServerPreparedStatement[647] - SELECT * FROM contract WHERE id=3620
com.mysql.jdbc.ServerPreparedStatement[648] - SELECT * FROM contract WHERE id=231
com.mysql.jdbc.ServerPreparedStatement[649] - SELECT * FROM contract WHERE id=3620
com.mysql.jdbc.ServerPreparedStatement[650] - SELECT * FROM contract WHERE id=3620
com.mysql.jdbc.ServerPreparedStatement[651] - SELECT * FROM contract WHERE id=2761
com.mysql.jdbc.ServerPreparedStatement[652] - SELECT * FROM contract WHERE id=3831
com.mysql.jdbc.ServerPreparedStatement[653] - SELECT * FROM contract WHERE id=3915
com.mysql.jdbc.ServerPreparedStatement[654] - SELECT * FROM contract WHERE id=2427
com.mysql.jdbc.ServerPreparedStatement[655] - SELECT * FROM contract WHERE id=3949
com.mysql.jdbc.ServerPreparedStatement[656] - SELECT * FROM contract WHERE id=2303
com.mysql.jdbc.ServerPreparedStatement[657] - SELECT * FROM contract WHERE id=2090
com.mysql.jdbc.ServerPreparedStatement[658] - SELECT * FROM contract WHERE id=3438
com.mysql.jdbc.ServerPreparedStatement[659] - SELECT * FROM contract WHERE id=191
com.mysql.jdbc.ServerPreparedStatement[660] - SELECT * FROM contract WHERE id=2181
com.mysql.jdbc.ServerPreparedStatement[661] - SELECT * FROM contract WHERE id=2226
com.mysql.jdbc.ServerPreparedStatement[662] - SELECT * FROM contract WHERE id=1673
com.mysql.jdbc.ServerPreparedStatement[663] - SELECT * FROM contract WHERE id=179
com.mysql.jdbc.ServerPreparedStatement[664] - SELECT * FROM contract WHERE id=2309
com.mysql.jdbc.ServerPreparedStatement[665] - SELECT * FROM contract WHERE id=4017
com.mysql.jdbc.ServerPreparedStatement[666] - SELECT * FROM contract WHERE id=4017
com.mysql.jdbc.ServerPreparedStatement[667] - SELECT * FROM contract WHERE id=4017
com.mysql.jdbc.ServerPreparedStatement[668] - SELECT * FROM contract WHERE id=3677
com.mysql.jdbc.ServerPreparedStatement[669] - SELECT * FROM contract WHERE id=2077
com.mysql.jdbc.ServerPreparedStatement[670] - SELECT * FROM contract WHERE id=4017
com.mysql.jdbc.ServerPreparedStatement[671] - SELECT * FROM contract WHERE id=3438
com.mysql.jdbc.ServerPreparedStatement[672] - SELECT * FROM contract WHERE id=3438
com.mysql.jdbc.ServerPreparedStatement[673] - SELECT * FROM contract WHERE id=2449
com.mysql.jdbc.ServerPreparedStatement[674] - SELECT * FROM contract WHERE id=2106
com.mysql.jdbc.ServerPreparedStatement[675] - SELECT * FROM contract WHERE id=2115
com.mysql.jdbc.ServerPreparedStatement[676] - SELECT * FROM contract WHERE id=2283
com.mysql.jdbc.ServerPreparedStatement[677] - SELECT * FROM contract WHERE id=3717
com.mysql.jdbc.ServerPreparedStatement[678] - SELECT * FROM contract WHERE id=4024
com.mysql.jdbc.ServerPreparedStatement[679] - SELECT * FROM contract WHERE id=2069
com.mysql.jdbc.ServerPreparedStatement[680] - SELECT * FROM contract WHERE id=3901
com.mysql.jdbc.ServerPreparedStatement[681] - SELECT * FROM contract WHERE id=3438
com.mysql.jdbc.ServerPreparedStatement[682] - SELECT * FROM contract WHERE id=2076
com.mysql.jdbc.ServerPreparedStatement[683] - SELECT * FROM contract WHERE id=3668
com.mysql.jdbc.ServerPreparedStatement[684] - SELECT * FROM contract WHERE id=3948
com.mysql.jdbc.ServerPreparedStatement[685] - SELECT * FROM contract WHERE id=4017
com.mysql.jdbc.ServerPreparedStatement[686] - SELECT * FROM contract WHERE id=2440
com.mysql.jdbc.ServerPreparedStatement[687] - SELECT * FROM contract WHERE id=3438
com.mysql.jdbc.ServerPreparedStatement[688] - SELECT * FROM contract WHERE id=2288
com.mysql.jdbc.ServerPreparedStatement[689] - SELECT * FROM contract WHERE id=1671
com.mysql.jdbc.ServerPreparedStatement[690] - SELECT * FROM contract WHERE id=3936
com.mysql.jdbc.ServerPreparedStatement[691] - SELECT * FROM contract WHERE id=2154
com.mysql.jdbc.ServerPreparedStatement[692] - SELECT * FROM contract WHERE id=3686
com.mysql.jdbc.ServerPreparedStatement[693] - SELECT * FROM contract WHERE id=2260
com.mysql.jdbc.ServerPreparedStatement[694] - SELECT * FROM contract WHERE id=2128
com.mysql.jdbc.ServerPreparedStatement[695] - SELECT * FROM contract WHERE id=3686
com.mysql.jdbc.ServerPreparedStatement[696] - SELECT * FROM contract WHERE id=2262
com.mysql.jdbc.ServerPreparedStatement[697] - SELECT * FROM contract WHERE id=2064
com.mysql.jdbc.ServerPreparedStatement[698] - SELECT * FROM contract WHERE id=231
com.mysql.jdbc.ServerPreparedStatement[699] - SELECT * FROM contract WHERE id=2453
com.mysql.jdbc.ServerPreparedStatement[700] - SELECT * FROM contract WHERE id=3438
com.mysql.jdbc.ServerPreparedStatement[701] - SELECT * FROM contract WHERE id=2422
com.mysql.jdbc.ServerPreparedStatement[702] - SELECT * FROM contract WHERE id=3438
com.mysql.jdbc.ServerPreparedStatement[703] - SELECT * FROM contract WHERE id=231
com.mysql.jdbc.ServerPreparedStatement[704] - SELECT * FROM contract WHERE id=231
com.mysql.jdbc.ServerPreparedStatement[705] - SELECT * FROM contract WHERE id=3438
com.mysql.jdbc.ServerPreparedStatement[706] - SELECT * FROM contract WHERE id=2206
com.mysql.jdbc.ServerPreparedStatement[707] - SELECT * FROM contract WHERE id=3831
com.mysql.jdbc.ServerPreparedStatement[708] - SELECT * FROM contract WHERE id=4017
com.mysql.jdbc.ServerPreparedStatement[709] - SELECT * FROM contract WHERE id=3438
com.mysql.jdbc.ServerPreparedStatement[710] - SELECT * FROM contract WHERE id=2289
com.mysql.jdbc.ServerPreparedStatement[711] - SELECT * FROM contract WHERE id=2031
com.mysql.jdbc.ServerPreparedStatement[712] - SELECT * FROM contract WHERE id=1576
com.mysql.jdbc.ServerPreparedStatement[713] - SELECT * FROM contract WHERE id=2819
com.mysql.jdbc.ServerPreparedStatement[714] - SELECT * FROM contract WHERE id=4046
com.mysql.jdbc.ServerPreparedStatement[715] - SELECT * FROM contract WHERE id=180
com.mysql.jdbc.ServerPreparedStatement[716] - SELECT * FROM contract WHERE id=1576
com.mysql.jdbc.ServerPreparedStatement[717] - SELECT * FROM contract WHERE id=2892
com.mysql.jdbc.ServerPreparedStatement[718] - SELECT * FROM contract WHERE id=3438
com.mysql.jdbc.ServerPreparedStatement[719] - SELECT * FROM contract WHERE id=2134
com.mysql.jdbc.ServerPreparedStatement[720] - SELECT * FROM contract WHERE id=3948
com.mysql.jdbc.ServerPreparedStatement[721] - SELECT * FROM contract WHERE id=3831
com.mysql.jdbc.ServerPreparedStatement[722] - SELECT * FROM contract WHERE id=1687
com.mysql.jdbc.ServerPreparedStatement[723] - SELECT * FROM contract WHERE id=2032
com.mysql.jdbc.ServerPreparedStatement[724] - SELECT * FROM contract WHERE id=2227
com.mysql.jdbc.ServerPreparedStatement[725] - SELECT * FROM contract WHERE id=2266
com.mysql.jdbc.ServerPreparedStatement[726] - SELECT * FROM contract WHERE id=2087
com.mysql.jdbc.ServerPreparedStatement[727] - SELECT * FROM contract WHERE id=2423
com.mysql.jdbc.ServerPreparedStatement[728] - SELECT * FROM contract WHERE id=2150
com.mysql.jdbc.ServerPreparedStatement[729] - SELECT * FROM contract WHERE id=2224
com.mysql.jdbc.ServerPreparedStatement[730] - SELECT * FROM contract WHERE id=2936
com.mysql.jdbc.ServerPreparedStatement[731] - SELECT * FROM contract WHERE id=1706
com.mysql.jdbc.ServerPreparedStatement[732] - SELECT * FROM contract WHERE id=3438
com.mysql.jdbc.ServerPreparedStatement[733] - SELECT * FROM contract WHERE id=3131
com.mysql.jdbc.ServerPreparedStatement[734] - SELECT * FROM contract WHERE id=2197
com.mysql.jdbc.ServerPreparedStatement[735] - SELECT * FROM contract WHERE id=231
com.mysql.jdbc.ServerPreparedStatement[736] - SELECT * FROM contract WHERE id=3145
com.mysql.jdbc.ServerPreparedStatement[737] - SELECT * FROM contract WHERE id=3135
com.mysql.jdbc.ServerPreparedStatement[738] - SELECT * FROM contract WHERE id=3786
com.mysql.jdbc.ServerPreparedStatement[739] - SELECT * FROM contract WHERE id=3141
com.mysql.jdbc.ServerPreparedStatement[740] - SELECT * FROM contract WHERE id=2019
com.mysql.jdbc.ServerPreparedStatement[741] - SELECT * FROM contract WHERE id=3438
com.mysql.jdbc.ServerPreparedStatement[742] - SELECT * FROM contract WHERE id=231
com.mysql.jdbc.ServerPreparedStatement[743] - SELECT * FROM contract WHERE id=2040
com.mysql.jdbc.ServerPreparedStatement[744] - SELECT * FROM contract WHERE id=2290
com.mysql.jdbc.ServerPreparedStatement[745] - SELECT * FROM contract WHERE id=231

java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369
at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:426)
at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48)
at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:272)
at ru.bitel.bgbilling.kernel.base.server.DefaultContext.destroy(DefaultContext.java:37)
at ru.bitel.bgbilling.kernel.container.managed.ServerContext.destroy(ServerContext.java:400)
at ru.bitel.bgbilling.kernel.container.ws.server.AbstractJaxWsHandler.invoke0(AbstractJaxWsHandler.java:233)
at ru.bitel.bgbilling.kernel.container.ws.server.AbstractJaxWsHandler.access$000(AbstractJaxWsHandler.java:47)
at ru.bitel.bgbilling.kernel.container.ws.server.AbstractJaxWsHandler$1.run(AbstractJaxWsHandler.java:267)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:422)
at ru.bitel.bgbilling.kernel.container.ws.server.AbstractJaxWsHandler.invoke(AbstractJaxWsHandler.java:261)
at ru.bitel.bgbilling.kernel.container.ws.server.JaxWsHandler.invoke(JaxWsHandler.java:315)
at ru.bitel.bgbilling.kernel.container.ws.server.AbstractJaxWsHandler$ServiceInstanceResolver$1.invoke(AbstractJaxWsHandler.java:366)
at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:150)
at com.sun.xml.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:261)
at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:100)
at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:641)
at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:600)
at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:585)
at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:482)
at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:314)
at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:608)
at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:259)
at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:162)
at ru.bitel.bgbilling.kernel.container.ws.server.JaxWSAdapter.handle(JaxWSAdapter.java:290)
at bitel.billing.server.Executer.doPost(SourceFile:163)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
07-14/20:21:19 DEBUG [http-bio-0.0.0.0-8080-exec-12] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getDynamicClasses; time => 21 ms.
07-14/20:21:19 DEBUG [http-bio-0.0.0.0-8080-exec-12] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getSource; time => 1 ms.
07-14/20:21:19 DEBUG [http-bio-0.0.0.0-8080-exec-12] AbstractJaxWsHandler - executing ru.bitel.bgbilling.kernel.dynamic.server.DynamicCodeServiceImpl.getSource; time => 1 ms.


')
Ping333
Клиент
 
Сообщения: 243
Зарегистрирован: 29 мар 2013, 11:54
Откуда: Краснодар

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

Сообщение dimOn » 14 июл 2016, 21:15

в смысле это вы в своём динкоде делаете?
dimOn
 
Сообщения: 5918
Зарегистрирован: 30 май 2008, 15:51

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

Сообщение Ping333 » 14 июл 2016, 21:43

Ага, в дин коде
Ping333
Клиент
 
Сообщения: 243
Зарегистрирован: 29 мар 2013, 11:54
Откуда: Краснодар

Пред.След.

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

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

Сейчас этот форум просматривают: нет зарегистрированных пользователей и гости: 1

cron