BiTel

server 02-10/13:25:13 ERROR ["http-bio-/0.0.0.0-8080"-exec-5] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.PreparedStatement@5b134abd: SELECT * FROM contract WHERE id=218661
com.mysql.jdbc.JDBC4PreparedStatement@4c92ff9f: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.JDBC4PreparedStatement@302c66ed: UPDATE log_session_1_201502 SET lid=24641 WHERE id IN ( 9391,15135,24809,28225,40013,43769,54251,57805,86125,99137,107551,144811,162629,187669,191841,199143,241045,281943,293463,301013,315155,317859,332447,338343,344307,353983,369203,400781,410127 )
com.mysql.jdbc.JDBC4PreparedStatement@4992c465: UPDATE session_detail_1_201502 SET cid=220381 WHERE session_id IN ( 9391,15135,24809,28225,40013,43769,54251,57805,86125,99137,107551,144811,162629,187669,191841,199143,241045,281943,293463,301013,315155,317859,332447,338343,344307,353983,369203,400781,410127 )
com.mysql.jdbc.PreparedStatement@474f265c: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.JDBC4PreparedStatement@4af7afb2: UPDATE log_session_21_201502 SET lid=32305 WHERE id IN ( 8543,8545,16469,16471,34237,34239,38157,38159,49321,49323,52681,52683,61379,61381,64301,64303,104403,104405,114857,114859,119915,119917,167927,167929,193353,193355,226811,226813,230963,230965,239021,239023,296017,296019,355011,355013,375139,375141,386101,386103,403821,403823,406877,406879,428833,428835,438507,438509,446843,446845,459993,459995,478489,478491,526581,526583,537331,537333 )
com.mysql.jdbc.JDBC4PreparedStatement@39a32927: UPDATE session_detail_21_201502 SET cid=220381 WHERE session_id IN ( 8543,8545,16469,16471,34237,34239,38157,38159,49321,49323,52681,52683,61379,61381,64301,64303,104403,104405,114857,114859,119915,119917,167927,167929,193353,193355,226811,226813,230963,230965,239021,239023,296017,296019,355011,355013,375139,375141,386101,386103,403821,403823,406877,406879,428833,428835,438507,438509,446843,446845,459993,459995,478489,478491,526581,526583,537331,537333 )
com.mysql.jdbc.PreparedStatement@6ec9411: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@6c1fdbb7: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@4606780a: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@290a4854: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@5bceef97: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@6863c1b: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@5f89e72e: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@1338004f: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@3db1f304: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@49cefd40: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@14ee8fda: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@285bbe31: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@1ec302f0: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@79fc2959: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@41bf432c: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@3225d543: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@15602d09: SELECT * FROM contract WHERE id=220381
com.mysql.jdbc.PreparedStatement@2bd866cf: SELECT * FROM contract WHERE id=218669
com.mysql.jdbc.JDBC4PreparedStatement@4624cd8b: SELECT * FROM contract WHERE id=220383
com.mysql.jdbc.PreparedStatement@db053eb: SELECT * FROM contract WHERE id=220383
com.mysql.jdbc.JDBC4PreparedStatement@5a63373b: SELECT * FROM inet_serv_option_30 WHERE servId=6111
com.mysql.jdbc.JDBC4PreparedStatement@26ae9257: SELECT * FROM inet_serv_30 WHERE parentId=6105 ORDER BY id
com.mysql.jdbc.JDBC4PreparedStatement@406fc2fb: SELECT * FROM inet_serv_type_30 WHERE id=1
com.mysql.jdbc.JDBC4PreparedStatement@31af3d30: SELECT deviceTypeId FROM inet_serv_type_device_type_link_30 WHERE inetServId=1
com.mysql.jdbc.JDBC4PreparedStatement@267e89b1: SELECT deviceGroupId FROM inet_serv_type_device_group_link_30 WHERE inetServId=1
com.mysql.jdbc.JDBC4PreparedStatement@4503ac05: SELECT serv.*, contract.scid, contract.sub_mode FROM inet_serv_30 AS serv LEFT JOIN contract ON serv.contractId=contract.id WHERE serv.id=6111
com.mysql.jdbc.JDBC4PreparedStatement@368f5b3: SELECT inet_device_30.*, entity.entitySpecId, entity.title as entityTitle FROM inet_device_30 LEFT JOIN entity ON entity.id=inet_device_30.entityId WHERE inet_device_30.id=6
com.mysql.jdbc.JDBC4PreparedStatement@118eaf46: SELECT deviceGroupId FROM inv_device_group_link_30 WHERE deviceId=6
com.mysql.jdbc.JDBC4PreparedStatement@5803cf7e: SELECT * FROM inet_device_type_30 WHERE id=3
com.mysql.jdbc.PreparedStatement@53116f6: SELECT * FROM contract WHERE id=220395
com.mysql.jdbc.JDBC4PreparedStatement@68920a68: SELECT * FROM inv_device_port_subscription_30 WHERE deviceId=6 AND (3647=-1 OR port=3647) AND (dateFrom IS NULL OR null IS NULL OR dateFrom<=null) AND (dateTo IS NULL OR '2015-02-01 00:00:00' IS NULL OR dateTo>='2015-02-01 00:00:00') ORDER BY port
com.mysql.jdbc.PreparedStatement@444a3d1b: SELECT * FROM inet_serv_30 WHERE parentId=6271 ORDER BY id
com.mysql.jdbc.JDBC4PreparedStatement@1fea5809: SELECT * FROM inet_accounting_period_30 WHERE contractId=218679 ORDER BY dateFrom
com.mysql.jdbc.JDBC4PreparedStatement@675739ca: SELECT * FROM inet_accounting_period_30 WHERE id=63029
com.mysql.jdbc.PreparedStatement@3c5dbf38: SELECT * FROM contract WHERE id=220383
com.mysql.jdbc.PreparedStatement@5bc609c3: SELECT * FROM contract WHERE id=220383
com.mysql.jdbc.PreparedStatement@7123407c: SELECT * FROM contract WHERE id=220383
...
com.mysql.jdbc.PreparedStatement@66b6cb03: SELECT * FROM contract WHERE id=220383
com.mysql.jdbc.PreparedStatement@41dbdaab: SELECT * FROM contract WHERE id=220383
com.mysql.jdbc.PreparedStatement@1ec5819: SELECT * FROM contract WHERE id=220383
com.mysql.jdbc.PreparedStatement@70cbeafa: SELECT * FROM contract WHERE id=218671
com.mysql.jdbc.JDBC4PreparedStatement@544159a0: SELECT * FROM contract WHERE id=220385
com.mysql.jdbc.PreparedStatement@30c8fdb9: SELECT * FROM contract WHERE id=220385
com.mysql.jdbc.JDBC4PreparedStatement@2a21b095: SELECT * FROM inet_serv_30 WHERE parentId=6107 ORDER BY id
com.mysql.jdbc.PreparedStatement@6f8c2b19: SELECT * FROM contract WHERE id=220385
com.mysql.jdbc.PreparedStatement@c2520c7: SELECT * FROM contract WHERE id=220385
com.mysql.jdbc.PreparedStatement@37b4e0f5: SELECT * FROM contract WHERE id=220385
...
com.mysql.jdbc.PreparedStatement@7280d173: SELECT * FROM contract WHERE id=220385
com.mysql.jdbc.PreparedStatement@4a3f7bc1: SELECT * FROM contract WHERE id=218675
com.mysql.jdbc.JDBC4PreparedStatement@7ee82386: SELECT * FROM contract WHERE id=220387
com.mysql.jdbc.PreparedStatement@431c726b: SELECT * FROM contract WHERE id=220387
com.mysql.jdbc.PreparedStatement@16b7b11b: SELECT * FROM contract WHERE id=220387
com.mysql.jdbc.PreparedStatement@2b01f64d: SELECT * FROM contract WHERE id=220387
com.mysql.jdbc.PreparedStatement@1cfb4904: SELECT * FROM contract WHERE id=220387
com.mysql.jdbc.PreparedStatement@19ef1b4b: SELECT * FROM contract WHERE id=220387
com.mysql.jdbc.PreparedStatement@4cd5f6e7: SELECT * FROM contract WHERE id=220387
com.mysql.jdbc.PreparedStatement@79e178a3: SELECT * FROM contract WHERE id=220387
com.mysql.jdbc.PreparedStatement@53f1a3fa: SELECT * FROM contract WHERE id=220387
com.mysql.jdbc.PreparedStatement@2d1f27c4: SELECT * FROM contract WHERE id=220387
com.mysql.jdbc.PreparedStatement@ea2cd2c: SELECT * FROM contract WHERE id=220387
com.mysql.jdbc.PreparedStatement@561dcfc3: SELECT * FROM contract WHERE id=220387
com.mysql.jdbc.PreparedStatement@1b6bab3: SELECT * FROM contract WHERE id=220387
com.mysql.jdbc.PreparedStatement@56e3c58e: SELECT * FROM contract WHERE id=218663
com.mysql.jdbc.PreparedStatement@42902ce4: SELECT * FROM contract WHERE id=220389
com.mysql.jdbc.PreparedStatement@7f07324d: SELECT * FROM contract WHERE id=218665
com.mysql.jdbc.JDBC4PreparedStatement@24915dbf: SELECT * FROM contract WHERE id=220391
com.mysql.jdbc.JDBC4PreparedStatement@2d5ecc04: UPDATE log_session_1_201502 SET lid=24643 WHERE id IN ( 341,45957,92423,144091,190135,231359,274623,317325,359733,403215 )
com.mysql.jdbc.JDBC4PreparedStatement@1c6c0a6: UPDATE session_detail_1_201502 SET cid=220391 WHERE session_id IN ( 341,45957,92423,144091,190135,231359,274623,317325,359733,403215 )
com.mysql.jdbc.PreparedStatement@44f3851d: SELECT * FROM contract WHERE id=220391
java.lang.RuntimeException
        at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:494)
        at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:47)
        at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:274)
        at ru.bitel.bgbilling.kernel.base.server.DefaultContext.destroy(DefaultContext.java:37)
        at ru.bitel.bgbilling.kernel.container.managed.ServerContext.destroy(ServerContext.java:406)
        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 ru.dsi.bgbilling.web.filter.XDFilter.doFilter(XDFilter.java:56)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        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)

ServerContext context = ServerContext.get();
ContractService cs;
TariffOptionService tos;
try {
   cs = context.getService(ContractService.class, 0);
   tos = context.getService(TariffOptionService.class, 24);
} catch(BGException e) {
   logger.error("Невозможно получить сервис", e);
   return;
}
...
while(rs.next()) {
   cs.contractGroupAdd(contractId, 21);
   tos.contractTariffOptionActivate(contractId, OPTION_ID, MODE_ID, false);
}

04-21/15:13:50 ERROR [pool-1-thread-81] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[110114] - SELECT * FROM global_script_link WHERE id=1
com.mysql.jdbc.ServerPreparedStatement[110117] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<='2015-04-21') AND (date2 IS NULL OR '2015-04-21'<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110120] - SELECT * FROM contract WHERE id=16903
com.mysql.jdbc.ServerPreparedStatement[110132] - SELECT * FROM contract WHERE id=9852
com.mysql.jdbc.ServerPreparedStatement[110133] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110147] - SELECT * FROM contract WHERE id=9862
com.mysql.jdbc.ServerPreparedStatement[110148] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110162] - SELECT * FROM contract WHERE id=9863
com.mysql.jdbc.ServerPreparedStatement[110163] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110177] - SELECT * FROM contract WHERE id=9864
com.mysql.jdbc.ServerPreparedStatement[110178] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110192] - SELECT * FROM contract WHERE id=9865
com.mysql.jdbc.ServerPreparedStatement[110193] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110206] - SELECT * FROM contract WHERE id=9867
com.mysql.jdbc.ServerPreparedStatement[110207] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110221] - SELECT * FROM contract WHERE id=9879
com.mysql.jdbc.ServerPreparedStatement[110222] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110235] - SELECT * FROM contract WHERE id=9880
com.mysql.jdbc.ServerPreparedStatement[110236] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110250] - SELECT * FROM contract WHERE id=9893
com.mysql.jdbc.ServerPreparedStatement[110251] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110265] - SELECT * FROM contract WHERE id=9905
com.mysql.jdbc.ServerPreparedStatement[110266] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110280] - SELECT * FROM contract WHERE id=9913
com.mysql.jdbc.ServerPreparedStatement[110281] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110295] - SELECT * FROM contract WHERE id=9932
com.mysql.jdbc.ServerPreparedStatement[110296] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110310] - SELECT * FROM contract WHERE id=9936
com.mysql.jdbc.ServerPreparedStatement[110311] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110325] - SELECT * FROM contract WHERE id=9944
com.mysql.jdbc.ServerPreparedStatement[110326] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110340] - SELECT * FROM contract WHERE id=9945
com.mysql.jdbc.ServerPreparedStatement[110341] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110355] - SELECT * FROM contract WHERE id=9960
com.mysql.jdbc.ServerPreparedStatement[110356] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110370] - SELECT * FROM contract WHERE id=9967
com.mysql.jdbc.ServerPreparedStatement[110371] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110385] - SELECT * FROM contract WHERE id=9970
com.mysql.jdbc.ServerPreparedStatement[110386] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110399] - SELECT * FROM contract WHERE id=9971
com.mysql.jdbc.ServerPreparedStatement[110400] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110414] - SELECT * FROM contract WHERE id=9982
com.mysql.jdbc.ServerPreparedStatement[110415] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110429] - SELECT * FROM contract WHERE id=9984
com.mysql.jdbc.ServerPreparedStatement[110430] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110444] - SELECT * FROM contract WHERE id=9986
com.mysql.jdbc.ServerPreparedStatement[110445] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110459] - SELECT * FROM contract WHERE id=9987
com.mysql.jdbc.ServerPreparedStatement[110460] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110473] - SELECT * FROM contract WHERE id=9993
com.mysql.jdbc.ServerPreparedStatement[110474] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110488] - SELECT * FROM contract WHERE id=9994
com.mysql.jdbc.ServerPreparedStatement[110489] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110502] - SELECT * FROM contract WHERE id=9999
com.mysql.jdbc.ServerPreparedStatement[110503] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110517] - SELECT * FROM contract WHERE id=10001
com.mysql.jdbc.ServerPreparedStatement[110518] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110532] - SELECT * FROM contract WHERE id=10035
com.mysql.jdbc.ServerPreparedStatement[110533] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110546] - SELECT * FROM contract WHERE id=10045
com.mysql.jdbc.ServerPreparedStatement[110547] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110561] - SELECT * FROM contract WHERE id=10048
com.mysql.jdbc.ServerPreparedStatement[110562] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110576] - SELECT * FROM contract WHERE id=10049
com.mysql.jdbc.ServerPreparedStatement[110577] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110591] - SELECT * FROM contract WHERE id=10055
com.mysql.jdbc.ServerPreparedStatement[110592] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110606] - SELECT * FROM contract WHERE id=10056
com.mysql.jdbc.ServerPreparedStatement[110607] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110626] - SELECT * FROM contract WHERE id=10069
com.mysql.jdbc.ServerPreparedStatement[110627] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110639] - SELECT * FROM contract WHERE id=10079
com.mysql.jdbc.ServerPreparedStatement[110640] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110654] - SELECT * FROM contract WHERE id=10080
com.mysql.jdbc.ServerPreparedStatement[110655] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110669] - SELECT * FROM contract WHERE id=10081
com.mysql.jdbc.ServerPreparedStatement[110670] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110684] - SELECT * FROM contract WHERE id=10082
com.mysql.jdbc.ServerPreparedStatement[110685] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110697] - SELECT * FROM contract WHERE id=10084
com.mysql.jdbc.ServerPreparedStatement[110698] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110712] - SELECT * FROM contract WHERE id=10086
com.mysql.jdbc.ServerPreparedStatement[110713] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110727] - SELECT * FROM contract WHERE id=10096
com.mysql.jdbc.ServerPreparedStatement[110728] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110742] - SELECT * FROM contract WHERE id=10100
com.mysql.jdbc.ServerPreparedStatement[110743] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110757] - SELECT * FROM contract WHERE id=10109
com.mysql.jdbc.ServerPreparedStatement[110758] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110772] - SELECT * FROM contract WHERE id=10113
com.mysql.jdbc.ServerPreparedStatement[110773] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110787] - SELECT * FROM contract WHERE id=10114
com.mysql.jdbc.ServerPreparedStatement[110788] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110802] - SELECT * FROM contract WHERE id=10134
com.mysql.jdbc.ServerPreparedStatement[110803] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110816] - SELECT * FROM contract WHERE id=10137
com.mysql.jdbc.ServerPreparedStatement[110817] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110831] - SELECT * FROM contract WHERE id=10147
com.mysql.jdbc.ServerPreparedStatement[110832] - SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[110846] - SELECT * FROM contract WHERE id=10152

java.lang.RuntimeException
        at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:417)
        at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:47)
        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:406)
        at ru.bitel.common.worker.ThreadContext.pop(ThreadContext.java:54)
        at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:84)
        at ru.bitel.bgbilling.kernel.task.server.TaskBase.startTask(TaskBase.java:135)
        at bitel.billing.server.task.TaskBaseRunner.executeTask(TaskBaseRunner.java:72)
        at bitel.billing.server.task.bean.RunTask.run(RunTask.java:41)
        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)
04-21/15:13:50  INFO [pool-1-thread-81] GlobalScriptTimer - Task finished time=520710 ms.
04-21/15:13:50  INFO [pool-1-thread-81] GlobalScriptTimer - task time : 0 d 00:08:40
04-21/15:13:50  INFO [pool-1-thread-81] GlobalScriptTimer - RunTask finished time=520715 ms.

Error Code: 1461 Can't create more than max_prepared_stmt_count statements (current value: 16382)

show processlist

set global_log=ON;

SELECT * FROM  tariff_option  WHERE (date1 IS NULL OR date1<=null) AND (date2 IS NULL OR null<=date2) ORDER BY title

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:208)
<------>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:242)
<------>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:236)
<------>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:335)
<------>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:288)
<------>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)

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

Клиент: вер. 6.2.714 / 25.05.2015 17:27:15
    os: Windows 7; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_45
  Сервер: вер. 6.2.881 / 22.05.2015 17:56:55
    os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_45

  npay: вер. 6.2.167 / 14.05.2015 16:49:47
  ru.bitel.bgbilling.plugins.cashcheck: вер. 6.2.87 / 31.03.2015 17:29:57
  ru.bitel.bgbilling.plugins.cladr: вер. 6.2.104 / 31.03.2015 17:29:58

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

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

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

server 05-28/15:34:54 ERROR [http-bio-0.0.0.0-8080-exec-7] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[36] - SELECT * FROM contract WHERE id=300
com.mysql.jdbc.ServerPreparedStatement[7516] - SELECT * FROM contract WHERE id=300
com.mysql.jdbc.ServerPreparedStatement[7528] - SELECT * FROM address_street WHERE (0 OR cityid=1) AND (0 OR title LIKE 'мкр. 9-й%') ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[7525] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7549] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7550] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7551] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7552] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7553] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7554] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7555] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7556] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7557] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7558] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7559] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7560] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7561] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7562] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7563] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7564] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7565] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7566] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7567] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7568] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7569] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7570] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7571] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7572] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7573] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7574] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7575] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7576] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7577] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7578] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7579] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7580] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7581] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7582] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7583] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7584] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7585] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7586] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7587] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7588] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7589] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7590] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7591] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7592] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7593] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7594] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7595] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7596] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7597] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7598] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7599] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7600] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7601] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7602] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7603] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7604] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7605] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7606] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7607] - SELECT * FROM contract WHERE id=201
com.mysql.jdbc.ServerPreparedStatement[7644] - SELECT * FROM address_street WHERE (0 OR cityid=1) AND (0 OR title LIKE 'мкр. 9-й%') ORDER BY title
com.mysql.jdbc.ServerPreparedStatement[7641] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7665] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7666] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7667] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7668] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7669] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7670] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7671] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7672] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7673] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7674] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7675] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7676] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7677] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7678] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7679] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7680] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7681] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7682] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7683] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7684] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7685] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7686] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7687] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7688] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7689] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7690] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7691] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7692] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7693] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7694] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7695] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7696] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7697] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7698] - SELECT * FROM contract WHERE id=202
com.mysql.jdbc.ServerPreparedStatement[7699] - SELECT * FROM contract WHERE id=202

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:208)
<------>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:242)
<------>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:236)
<------>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:335)
<------>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:288)
<------>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)

Клиент: вер. 6.2.715 / 28.05.2015 16:17:27
    os: Windows 7; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_45
  Сервер: вер. 6.2.882 / 28.05.2015 16:17:37
    os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.8.0_45

  npay: вер. 6.2.167 / 14.05.2015 16:49:47
  ru.bitel.bgbilling.plugins.cashcheck: вер. 6.2.87 / 31.03.2015 17:29:57
  ru.bitel.bgbilling.plugins.cladr: вер. 6.2.104 / 31.03.2015 17:29:58

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