BiTel

Форум BiTel
bgbilling.ru     docs.bitel.ru     wiki.bitel.ru     dbinfo.bitel.ru     bgcrm.ru     billing.bitel.ru     bitel.ru    
Текущее время: 23 июн 2025, 21:19

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




Начать новую тему Ответить на тему  [ Сообщений: 5 ] 
Автор Сообщение
 Заголовок сообщения: [5.2] Many statements was open at connection close
СообщениеДобавлено: 12 июл 2012, 16:51 
Не в сети

Зарегистрирован: 16 ноя 2011, 18:30
Сообщения: 115
Карма: 0
В логах сервера и RADIUS периодически вываливаются вот такие ошибки:

Цитата:
07-12/14:47:33 ERROR ["http-bio-/0.0.0.0-8080"-exec-7] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[163] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=720
com.mysql.jdbc.ServerPreparedStatement[164] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=719
com.mysql.jdbc.ServerPreparedStatement[165] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=44
com.mysql.jdbc.ServerPreparedStatement[166] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=12
com.mysql.jdbc.ServerPreparedStatement[167] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=13
com.mysql.jdbc.ServerPreparedStatement[168] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=1
com.mysql.jdbc.ServerPreparedStatement[169] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=6
com.mysql.jdbc.ServerPreparedStatement[170] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=32
com.mysql.jdbc.ServerPreparedStatement[171] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=38
com.mysql.jdbc.ServerPreparedStatement[172] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=36
com.mysql.jdbc.ServerPreparedStatement[173] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=39
com.mysql.jdbc.ServerPreparedStatement[174] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=3
com.mysql.jdbc.ServerPreparedStatement[175] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=8
com.mysql.jdbc.ServerPreparedStatement[176] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=4
com.mysql.jdbc.ServerPreparedStatement[177] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=7
com.mysql.jdbc.ServerPreparedStatement[178] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=5
com.mysql.jdbc.ServerPreparedStatement[179] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=14
com.mysql.jdbc.ServerPreparedStatement[180] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=15
com.mysql.jdbc.ServerPreparedStatement[181] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=18
com.mysql.jdbc.ServerPreparedStatement[182] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=25
com.mysql.jdbc.ServerPreparedStatement[183] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=22
com.mysql.jdbc.ServerPreparedStatement[184] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=27
com.mysql.jdbc.ServerPreparedStatement[185] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=23
com.mysql.jdbc.ServerPreparedStatement[186] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=26
com.mysql.jdbc.ServerPreparedStatement[187] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=24
com.mysql.jdbc.ServerPreparedStatement[188] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=347
com.mysql.jdbc.ServerPreparedStatement[189] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=348
com.mysql.jdbc.ServerPreparedStatement[190] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=10
com.mysql.jdbc.ServerPreparedStatement[191] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=459
com.mysql.jdbc.ServerPreparedStatement[192] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=489
com.mysql.jdbc.ServerPreparedStatement[193] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=491
com.mysql.jdbc.ServerPreparedStatement[194] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=488
com.mysql.jdbc.ServerPreparedStatement[195] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=490
com.mysql.jdbc.ServerPreparedStatement[196] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=677
com.mysql.jdbc.ServerPreparedStatement[197] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=477
com.mysql.jdbc.ServerPreparedStatement[198] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=678
com.mysql.jdbc.ServerPreparedStatement[199] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=679
com.mysql.jdbc.ServerPreparedStatement[200] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=680
com.mysql.jdbc.ServerPreparedStatement[201] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=681
com.mysql.jdbc.ServerPreparedStatement[202] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=676
com.mysql.jdbc.ServerPreparedStatement[203] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=709
com.mysql.jdbc.ServerPreparedStatement[204] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=390
com.mysql.jdbc.ServerPreparedStatement[205] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=405
com.mysql.jdbc.ServerPreparedStatement[206] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=391
com.mysql.jdbc.ServerPreparedStatement[207] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=403
com.mysql.jdbc.ServerPreparedStatement[208] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=392
com.mysql.jdbc.ServerPreparedStatement[209] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=404
com.mysql.jdbc.ServerPreparedStatement[210] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=393
com.mysql.jdbc.ServerPreparedStatement[211] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=402
com.mysql.jdbc.ServerPreparedStatement[212] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=316
com.mysql.jdbc.ServerPreparedStatement[213] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=500
com.mysql.jdbc.ServerPreparedStatement[214] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=604
com.mysql.jdbc.ServerPreparedStatement[215] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=629
com.mysql.jdbc.ServerPreparedStatement[216] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=630
com.mysql.jdbc.ServerPreparedStatement[217] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=631
com.mysql.jdbc.ServerPreparedStatement[218] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=632
com.mysql.jdbc.ServerPreparedStatement[219] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=289
com.mysql.jdbc.ServerPreparedStatement[220] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=603
com.mysql.jdbc.ServerPreparedStatement[221] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=810
com.mysql.jdbc.ServerPreparedStatement[222] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=90
com.mysql.jdbc.ServerPreparedStatement[223] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=210
com.mysql.jdbc.ServerPreparedStatement[224] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=143
com.mysql.jdbc.ServerPreparedStatement[225] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=173
com.mysql.jdbc.ServerPreparedStatement[226] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=144
com.mysql.jdbc.ServerPreparedStatement[227] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=174
com.mysql.jdbc.ServerPreparedStatement[228] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=145
com.mysql.jdbc.ServerPreparedStatement[229] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=175
com.mysql.jdbc.ServerPreparedStatement[230] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=146
com.mysql.jdbc.ServerPreparedStatement[231] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=176
com.mysql.jdbc.ServerPreparedStatement[232] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=346
com.mysql.jdbc.ServerPreparedStatement[233] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=345
com.mysql.jdbc.ServerPreparedStatement[234] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=262
com.mysql.jdbc.ServerPreparedStatement[235] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=263
com.mysql.jdbc.ServerPreparedStatement[236] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=151
com.mysql.jdbc.ServerPreparedStatement[237] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=133
com.mysql.jdbc.ServerPreparedStatement[238] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=135
com.mysql.jdbc.ServerPreparedStatement[239] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=293
com.mysql.jdbc.ServerPreparedStatement[240] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=115
com.mysql.jdbc.ServerPreparedStatement[241] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=114
com.mysql.jdbc.ServerPreparedStatement[242] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=131
com.mysql.jdbc.ServerPreparedStatement[243] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=129
com.mysql.jdbc.ServerPreparedStatement[244] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=96
com.mysql.jdbc.ServerPreparedStatement[245] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=98
com.mysql.jdbc.ServerPreparedStatement[246] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=141
com.mysql.jdbc.ServerPreparedStatement[247] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=455
com.mysql.jdbc.ServerPreparedStatement[248] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=29
com.mysql.jdbc.ServerPreparedStatement[249] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=31
com.mysql.jdbc.ServerPreparedStatement[250] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=252
com.mysql.jdbc.ServerPreparedStatement[251] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=75
com.mysql.jdbc.ServerPreparedStatement[252] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=95
com.mysql.jdbc.ServerPreparedStatement[253] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=112
com.mysql.jdbc.ServerPreparedStatement[254] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=11
com.mysql.jdbc.ServerPreparedStatement[255] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=111
com.mysql.jdbc.ServerPreparedStatement[256] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=30
com.mysql.jdbc.ServerPreparedStatement[257] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=110
com.mysql.jdbc.ServerPreparedStatement[258] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=644
com.mysql.jdbc.ServerPreparedStatement[259] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=21
com.mysql.jdbc.ServerPreparedStatement[260] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=33
com.mysql.jdbc.ServerPreparedStatement[261] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=34
com.mysql.jdbc.ServerPreparedStatement[262] - SELECT * FROM module_tariff_tree as t1 JOIN tariff_plan as t2 ON t1.tree_id=t2.tree_id WHERE mid=-1 and t2.id=192

java.lang.RuntimeException
at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:480)
at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:47)
at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:261)
at ru.bitel.bgbilling.kernel.base.server.DefaultContext.destroy(DefaultContext.java:37)
at ru.bitel.bgbilling.kernel.container.managed.ServerContext.destroy(ServerContext.java:235)
at bitel.billing.server.ActionBase.freeConnection(ActionBase.java:181)
at bitel.billing.server.Executer.doModule(Unknown Source)
at bitel.billing.server.Executer$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at bitel.billing.server.Executer.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)


Запросы разные.
Это нормально?
Насколько я понимаю, оно так ругается, когда закрывается соединение с незакрытыми стейтментами.
Как убрать?


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: [5.2] Many statements was open at connection close
СообщениеДобавлено: 12 июл 2012, 16:56 
Не в сети

Зарегистрирован: 16 ноя 2011, 18:30
Сообщения: 115
Карма: 0
Пример ошибки из RadiusDialup

Цитата:
processor 07-12/14:39:26 ERROR [pool-2-thread-1] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.JDBC4PreparedStatement@7746df77: SELECT * FROM contract WHERE id=14298
com.mysql.jdbc.JDBC4PreparedStatement@2583d260: SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tariff.tpid=tariff_plan.id WHERE cid=14298 AND ((emid=0 AND eid=0) OR (emid=0 AND eid=0)) AND ( isNull(date2) OR date2='0000-00-00' OR date2>='2012-07-01' ) UNION SELECT tree_id, date1, date2, emid, eid, 0, pos FROM contract_tree_link WHERE cid=14298 AND ((emid=0 AND eid=0) OR (emid=0 AND eid=0)) AND (date2 IS NULL OR date2>='2012-07-01') ORDER BY 4 DESC, 5 DESC, 6 ASC, 7 ASC
com.mysql.jdbc.JDBC4PreparedStatement@44091520: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=14298 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1
com.mysql.jdbc.StatementImpl@19fcbac1
com.mysql.jdbc.StatementImpl@6c97f621
com.mysql.jdbc.StatementImpl@60487c5f
com.mysql.jdbc.StatementImpl@4799a84f
com.mysql.jdbc.StatementImpl@57e2793d
com.mysql.jdbc.StatementImpl@1d2b9f14
com.mysql.jdbc.StatementImpl@63220fd1
com.mysql.jdbc.StatementImpl@43422d0b
com.mysql.jdbc.StatementImpl@77b9e7fc
com.mysql.jdbc.StatementImpl@514f2bd7
com.mysql.jdbc.StatementImpl@1be2f6b0
com.mysql.jdbc.StatementImpl@51b1ab1d
com.mysql.jdbc.StatementImpl@17510d96
com.mysql.jdbc.StatementImpl@4a52fecf
com.mysql.jdbc.StatementImpl@ed6ee28
com.mysql.jdbc.StatementImpl@7b8353cf
com.mysql.jdbc.StatementImpl@5a335053
com.mysql.jdbc.StatementImpl@5edea768
com.mysql.jdbc.StatementImpl@3ef3c5c4
com.mysql.jdbc.StatementImpl@763ce725
com.mysql.jdbc.StatementImpl@21913751
com.mysql.jdbc.StatementImpl@9866417
com.mysql.jdbc.StatementImpl@11cdc190
com.mysql.jdbc.StatementImpl@31455cf4
com.mysql.jdbc.StatementImpl@1547a16f
com.mysql.jdbc.StatementImpl@409bad4f
com.mysql.jdbc.StatementImpl@10b173c3
com.mysql.jdbc.StatementImpl@72270fc4
com.mysql.jdbc.StatementImpl@32bed1fd
com.mysql.jdbc.StatementImpl@5b08ea49
com.mysql.jdbc.StatementImpl@46eff545
com.mysql.jdbc.StatementImpl@67a4076
com.mysql.jdbc.StatementImpl@3a4c585f
com.mysql.jdbc.StatementImpl@6a3de2df
com.mysql.jdbc.StatementImpl@11e3c2c6
com.mysql.jdbc.StatementImpl@85e57
com.mysql.jdbc.StatementImpl@61335b86
com.mysql.jdbc.StatementImpl@72bdec44
com.mysql.jdbc.StatementImpl@190a0d51
com.mysql.jdbc.StatementImpl@62f04dae
com.mysql.jdbc.StatementImpl@26a150e
com.mysql.jdbc.StatementImpl@48a84b47
com.mysql.jdbc.StatementImpl@6e659812
com.mysql.jdbc.StatementImpl@4fe2fe5d
com.mysql.jdbc.StatementImpl@32552379
com.mysql.jdbc.StatementImpl@3f8771dc
com.mysql.jdbc.StatementImpl@6e94124f
com.mysql.jdbc.StatementImpl@3b3e3940
com.mysql.jdbc.StatementImpl@67afe460
com.mysql.jdbc.StatementImpl@28fe53cf
com.mysql.jdbc.StatementImpl@3ad8326d
com.mysql.jdbc.StatementImpl@5fcfad77
com.mysql.jdbc.StatementImpl@593f5a2f
com.mysql.jdbc.StatementImpl@12539a92
com.mysql.jdbc.StatementImpl@ef1df6
com.mysql.jdbc.StatementImpl@529801f4
com.mysql.jdbc.StatementImpl@2b1bed2
com.mysql.jdbc.StatementImpl@45d18084
com.mysql.jdbc.StatementImpl@3d4c7deb
com.mysql.jdbc.StatementImpl@2bbef4c6
com.mysql.jdbc.StatementImpl@272b72f4
com.mysql.jdbc.StatementImpl@15880543
com.mysql.jdbc.StatementImpl@16ff6348
com.mysql.jdbc.StatementImpl@4b01ea1e
com.mysql.jdbc.StatementImpl@4ecd200f
com.mysql.jdbc.StatementImpl@7cf3e133
com.mysql.jdbc.StatementImpl@63ae2c6f
com.mysql.jdbc.StatementImpl@6eef9525
com.mysql.jdbc.StatementImpl@4e695527
com.mysql.jdbc.StatementImpl@575e6691
com.mysql.jdbc.StatementImpl@7bcf6f61
com.mysql.jdbc.StatementImpl@6f9988c7
com.mysql.jdbc.StatementImpl@6a301bf5
com.mysql.jdbc.StatementImpl@1a659078
com.mysql.jdbc.StatementImpl@1efc3d2
com.mysql.jdbc.StatementImpl@7862af46
com.mysql.jdbc.StatementImpl@56ab436d
com.mysql.jdbc.StatementImpl@1d05a248
com.mysql.jdbc.StatementImpl@45135cd9
com.mysql.jdbc.StatementImpl@20bf9a12
com.mysql.jdbc.StatementImpl@1f4b52aa
com.mysql.jdbc.StatementImpl@44dd20b6
com.mysql.jdbc.StatementImpl@2ec7ecd5
com.mysql.jdbc.StatementImpl@26137fea
com.mysql.jdbc.StatementImpl@42b7141a
com.mysql.jdbc.StatementImpl@3f6a5bcb
com.mysql.jdbc.StatementImpl@3ff5d699
com.mysql.jdbc.StatementImpl@655d7752
com.mysql.jdbc.StatementImpl@15ec4535
com.mysql.jdbc.StatementImpl@4ab3a5d1
com.mysql.jdbc.StatementImpl@2688e83d
com.mysql.jdbc.StatementImpl@6647108e
com.mysql.jdbc.StatementImpl@132c08c7
com.mysql.jdbc.StatementImpl@4af6ae1c
com.mysql.jdbc.StatementImpl@76bcfa38
com.mysql.jdbc.StatementImpl@70cfaf6e
com.mysql.jdbc.StatementImpl@3f610944

java.lang.RuntimeException
at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:480)
at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:47)
at ru.bitel.bgbilling.server.util.ServerUtils.closeConnection(ServerUtils.java:566)
at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas.restoreConnectionsImpl(DialUpNas.java:971)
at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas.access$7(DialUpNas.java:739)
at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas$2.call(DialUpNas.java:733)
at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas$2.call(DialUpNas.java:1)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: [5.2] Many statements was open at connection close
СообщениеДобавлено: 12 июл 2012, 18:42 
Не в сети
Разработчик
Аватара пользователя

Зарегистрирован: 19 дек 2006, 21:04
Сообщения: 5970
Карма: 256
Цитата:
Насколько я понимаю, оно так ругается, когда закрывается соединение с незакрытыми стейтментами.
Да, в этом ничего страшного, но может плохо повлиять в некоторых случаях на производительность, потому сделали такой вывод в лог. Будем периодически выкладывать новые билды "Освобождение ресурсов".
В том числе это может решить проблему с Can't create more than max_prepared_stmt_count statements при useServerPrepStmts=true&cachePrepStmts=true.
По этим скоро выложим. При обновлениии не забывайте делать бэкап библиотек.


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: [5.2] Many statements was open at connection close
СообщениеДобавлено: 13 июл 2012, 10:21 
Не в сети
Разработчик

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


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: [5.2] Many statements was open at connection close
СообщениеДобавлено: 19 июл 2012, 15:46 
Не в сети
Клиент
Аватара пользователя

Зарегистрирован: 15 июл 2011, 12:20
Сообщения: 201
Откуда: Челябинск
Карма: 0
у меня подобное началось, вот только не иногда, а всегда в BGInetAccounting:
Код:
accounting 07-19/13:00:47 ERROR [accwrkr-1-p-11-t-1] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.JDBC4PreparedStatement@4eefaabd: SELECT * FROM inet_accounting_period_2 WHERE contractId=40033 AND (dateTo IS NULL OR dateTo>='2012-07-19') ORDER BY dateFrom
com.mysql.jdbc.JDBC4PreparedStatement@74fcca98: SELECT * FROM inet_accounting_period_2 WHERE contractId=12950 AND (dateTo IS NULL OR dateTo>='2012-07-19') ORDER BY dateFrom
com.mysql.jdbc.JDBC4PreparedStatement@52548eec: SELECT * FROM inet_accounting_period_2 WHERE contractId=14768 AND (dateTo IS NULL OR dateTo>='2012-07-19') ORDER BY dateFrom

[skiped many lines]

com.mysql.jdbc.JDBC4PreparedStatement@71bbb3ae: SELECT * FROM inet_accounting_period_2 WHERE contractId=32794 AND (dateTo IS NULL OR dateTo>='2012-07-19') ORDER BY dateFrom

java.lang.RuntimeException
   at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:480)
   at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:47)
   at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:261)
   at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:205)
   at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:103)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
   at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
   at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180)
   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
   at java.lang.Thread.run(Thread.java:662)
   at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40)

Обновлися до последнего билда - беда такая же, раз в минуту-две такое валит уже сутки.
Kernel version 5.2 build 1239 from 18.07.2012 12:57:10
Inet version 5.2 build 932 from 17.07.2012 14:25:38

_________________
Клиент: 7.2.395 / 27.08.2020 04:26:27
Сервер: 7.2.1268 / 27.08.2020 04:26:38


Вернуться к началу
 Профиль  
 
Показать сообщения за:  Поле сортировки  
Начать новую тему Ответить на тему  [ Сообщений: 5 ] 

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


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

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


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

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