BiTel

...
server 07-22/16:57:26 ERROR ["http-bio-/0.0.0.0-8080"-exec-5] CommonKernelEventProcessor - org.apache.commons.dbcp.DelegatingPreparedStatement with address: "com.mysql.jdbc.ServerPreparedStatement[181] - statement has been closed, no further internal information available" is closed.
java.sql.SQLException: org.apache.commons.dbcp.DelegatingPreparedStatement with address: "com.mysql.jdbc.ServerPreparedStatement[181] - statement has been closed, no further internal information available" is closed.
        at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:137)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.setInt(DelegatingPreparedStatement.java:120)
        at bitel.billing.server.voiceip.bean.VoiceIpLoginManager.recalcAfterMove(VoiceIpLoginManager.java:279)
        at bitel.billing.server.call.Module.moduleAction(Module.java:166)
        at bitel.billing.server.voiceip.Module.moduleAction(Module.java:119)
        at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEventProcessor.java:160)
        at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEventProcessor.java:1)
        at ru.bitel.bgbilling.kernel.event.LocalEventProcessor.request(LocalEventProcessor.java:240)
        at ru.bitel.bgbilling.kernel.event.EventProcessor.request(EventProcessor.java:869)
        at ru.bitel.bgbilling.kernel.event.EventProcessor.request(EventProcessor.java:838)
        at bitel.billing.server.contract.action.ActionWrapContract.contractCopy(ActionWrapContract.java:244)
        at bitel.billing.server.contract.action.ActionWrapContract.doAction(ActionWrapContract.java:96)
        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)
...

server 07-22/16:57:25 ERROR ["http-bio-/0.0.0.0-8080"-exec-5] LoggingPrintStream - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bgbilling.session_account_23_201212' doesn't exist

server 07-22/16:56:24 ERROR ["http-bio-/0.0.0.0-8080"-exec-2] CommonKernelEventProcessor - org.apache.commons.dbcp.DelegatingPreparedStatement with address: "com.mysql.jdbc.ServerPreparedStatement[424] - statement has been closed, no further internal information available" is closed.
java.sql.SQLException: org.apache.commons.dbcp.DelegatingPreparedStatement with address: "com.mysql.jdbc.ServerPreparedStatement[424] - statement has been closed, no further internal information available" is closed.
        at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:137)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.setInt(DelegatingPreparedStatement.java:120)
        at bitel.billing.server.voiceip.bean.VoiceIpLoginManager.recalcAfterMove(VoiceIpLoginManager.java:279)
        at bitel.billing.server.call.Module.moduleAction(Module.java:166)
        at bitel.billing.server.voiceip.Module.moduleAction(Module.java:119)
        at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEventProcessor.java:160)
        at ru.bitel.bgbilling.kernel.event.processors.CommonKernelEventProcessor.notify(CommonKernelEventProcessor.java:1)
        at ru.bitel.bgbilling.kernel.event.LocalEventProcessor.request(LocalEventProcessor.java:240)
        at ru.bitel.bgbilling.kernel.event.EventProcessor.request(EventProcessor.java:869)
        at ru.bitel.bgbilling.kernel.event.EventProcessor.request(EventProcessor.java:838)
        at bitel.billing.server.contract.action.ActionWrapContract.contractCopy(ActionWrapContract.java:244)
        at bitel.billing.server.contract.action.ActionWrapContract.doAction(ActionWrapContract.java:96)
        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.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:140)
        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)
...

server 07-22/16:57:26 ERROR ["http-bio-/0.0.0.0-8080"-exec-5] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[4] - SELECT * FROM contract WHERE id=191468
com.mysql.jdbc.ServerPreparedStatement[30] - SELECT * FROM contract WHERE id=191468
com.mysql.jdbc.JDBC4PreparedStatement@1b0c5b3: SELECT sid, SUM(summa) FROM session_account_1_201201 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1ed13d9: SELECT sid, SUM(summa) FROM session_account_1_201201 WHERE cid=192135 GROUP BY sid

...

com.mysql.jdbc.ServerPreparedStatement[166] - SELECT * FROM inv_device_port_subscription_26 WHERE deviceId=3 AND (0=-1 OR port=0) AND (dateFrom IS NULL OR null IS NULL OR dateFrom<=null) AND (dateTo IS NULL OR '2013-07-19 00:00:00' IS NULL OR dateTo>='2013-07-19 00:00:00') ORDER BY port
com.mysql.jdbc.ServerPreparedStatement[168] - SELECT * FROM inet_serv_26 WHERE parentId=5 ORDER BY id
com.mysql.jdbc.ServerPreparedStatement[175] - SELECT * FROM inet_accounting_period_26 WHERE contractId=191468 ORDER BY dateFrom
com.mysql.jdbc.ServerPreparedStatement[176] - SELECT * FROM inet_accounting_period_26 WHERE id=2

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: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 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.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:140)
        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)

server 07-23/09:36:28 ERROR ["http-bio-/0.0.0.0-8080"-exec-6] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[37] - SELECT * FROM contract WHERE id=191468
com.mysql.jdbc.ServerPreparedStatement[57] - SELECT * FROM inet_serv_type_25 ORDER BY id
com.mysql.jdbc.ServerPreparedStatement[58] - SELECT deviceTypeId FROM inet_serv_type_device_type_link_25 WHERE inetServId=6
com.mysql.jdbc.ServerPreparedStatement[59] - SELECT deviceGroupId FROM inet_serv_type_device_group_link_25 WHERE inetServId=6
com.mysql.jdbc.ServerPreparedStatement[68] - SELECT * FROM contract WHERE id=191468
com.mysql.jdbc.JDBC4PreparedStatement@f3e7ab: SELECT sid, SUM(summa) FROM session_account_1_201201 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@3af383: SELECT sid, SUM(summa) FROM session_account_1_201201 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@18355aa: SELECT sid, SUM(summa) FROM session_account_1_201203 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1c03044: SELECT sid, SUM(summa) FROM session_account_1_201203 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@19cb1a8: SELECT sid, SUM(summa) FROM session_account_1_201204 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1cb6e54: SELECT sid, SUM(summa) FROM session_account_1_201204 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1ea8d74: SELECT sid, SUM(summa) FROM session_account_1_201205 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@13f9b54: SELECT sid, SUM(summa) FROM session_account_1_201205 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@153df31: SELECT sid, SUM(summa) FROM session_account_1_201206 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@d7a270: SELECT sid, SUM(summa) FROM session_account_1_201206 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@10910a1: SELECT sid, SUM(summa) FROM session_account_1_201207 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@9ff1d3: SELECT sid, SUM(summa) FROM session_account_1_201207 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1266fce: SELECT sid, SUM(summa) FROM session_account_1_201208 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1d34001: SELECT sid, SUM(summa) FROM session_account_1_201208 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1207d43: SELECT sid, SUM(summa) FROM session_account_1_201209 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@82a431: SELECT sid, SUM(summa) FROM session_account_1_201209 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1d55d9: SELECT sid, SUM(summa) FROM session_account_1_201210 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1ac4ca1: SELECT sid, SUM(summa) FROM session_account_1_201210 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1a1c0d1: SELECT sid, SUM(summa) FROM session_account_1_201211 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@148d5b2: SELECT sid, SUM(summa) FROM session_account_1_201211 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@180cea1: SELECT sid, SUM(summa) FROM session_account_1_201212 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@871b47: SELECT sid, SUM(summa) FROM session_account_1_201212 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@a4156c: SELECT sid, SUM(summa) FROM session_account_1_201301 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@fe1e30: SELECT sid, SUM(summa) FROM session_account_1_201301 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1701f63: SELECT sid, SUM(summa) FROM session_account_1_201302 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@dc42ab: SELECT sid, SUM(summa) FROM session_account_1_201302 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.ServerPreparedStatement[157] - SELECT * FROM inet_serv_option_25 WHERE servId=33
com.mysql.jdbc.ServerPreparedStatement[160] - SELECT * FROM inet_serv_type_25 WHERE id=2
com.mysql.jdbc.ServerPreparedStatement[161] - SELECT deviceTypeId FROM inet_serv_type_device_type_link_25 WHERE inetServId=2
com.mysql.jdbc.ServerPreparedStatement[162] - SELECT deviceGroupId FROM inet_serv_type_device_group_link_25 WHERE inetServId=2
com.mysql.jdbc.ServerPreparedStatement[163] - SELECT serv.*, contract.scid, contract.sub_mode FROM inet_serv_25 AS serv LEFT JOIN contract ON serv.contractId=contract.id WHERE serv.id=33
com.mysql.jdbc.ServerPreparedStatement[165] - SELECT inet_device_25.*, entity.entitySpecId, entity.title as entityTitle FROM inet_device_25 LEFT JOIN entity ON entity.id=inet_device_25.entityId WHERE inet_device_25.id=15
com.mysql.jdbc.ServerPreparedStatement[166] - SELECT deviceGroupId FROM inv_device_group_link_25 WHERE deviceId=15
com.mysql.jdbc.ServerPreparedStatement[167] - SELECT * FROM inet_device_type_25 WHERE id=3
com.mysql.jdbc.ServerPreparedStatement[169] - SELECT * FROM entity_spec WHERE id=0
com.mysql.jdbc.ServerPreparedStatement[134] - SELECT * FROM contract WHERE id=192136
com.mysql.jdbc.ServerPreparedStatement[176] - SELECT * FROM inv_device_port_subscription_25 WHERE deviceId=15 AND (2=-1 OR port=2) AND (dateFrom IS NULL OR '2013-07-18' IS NULL OR dateFrom<='2013-07-18') AND (dateTo IS NULL OR '2013-07-18 00:00:00' IS NULL OR dateTo>='2013-07-18 00:00:00') ORDER BY port
com.mysql.jdbc.ServerPreparedStatement[178] - SELECT * FROM inet_serv_25 WHERE parentId=46 ORDER BY id
com.mysql.jdbc.ServerPreparedStatement[184] - SELECT * FROM inet_accounting_period_25 WHERE contractId=191468 ORDER BY dateFrom
com.mysql.jdbc.JDBC4PreparedStatement@5a86e1: SELECT sid, SUM(summa) FROM session_account_23_201205 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1cdf052: SELECT sid, SUM(summa) FROM session_account_23_201205 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@183901c: SELECT sid, SUM(summa) FROM session_account_23_201206 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@bfea42: SELECT sid, SUM(summa) FROM session_account_23_201206 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1db0032: SELECT sid, SUM(summa) FROM session_account_23_201207 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1b343e9: SELECT sid, SUM(summa) FROM session_account_23_201207 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1c90acb: SELECT sid, SUM(summa) FROM session_account_23_201208 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1211f6d: SELECT sid, SUM(summa) FROM session_account_23_201208 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@19a5b0: SELECT sid, SUM(summa) FROM session_account_23_201209 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1051743: SELECT sid, SUM(summa) FROM session_account_23_201209 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@9ad559: SELECT sid, SUM(summa) FROM session_account_23_201210 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@172f7c3: SELECT sid, SUM(summa) FROM session_account_23_201210 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1278640: SELECT sid, SUM(summa) FROM session_account_23_201211 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@10069c3: SELECT sid, SUM(summa) FROM session_account_23_201211 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1702cfb: SELECT sid, SUM(summa) FROM session_account_23_201212 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@8da92: SELECT sid, SUM(summa) FROM session_account_23_201212 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@d6b576: SELECT sid, SUM(summa) FROM session_account_23_201301 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@870fb: SELECT sid, SUM(summa) FROM session_account_23_201301 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@38584c: SELECT sid, SUM(summa) FROM session_account_23_201302 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@269ced: SELECT sid, SUM(summa) FROM session_account_23_201302 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@19ba407: SELECT sid, SUM(summa) FROM session_account_21_201201 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1afcb90: SELECT sid, SUM(summa) FROM session_account_21_201201 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1a77dcf: SELECT sid, SUM(summa) FROM session_account_21_201203 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1e043a8: SELECT sid, SUM(summa) FROM session_account_21_201203 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@28b43: SELECT sid, SUM(summa) FROM session_account_21_201204 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@f6fd93: SELECT sid, SUM(summa) FROM session_account_21_201204 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@749cf8: SELECT sid, SUM(summa) FROM session_account_21_201205 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@139a1e2: SELECT sid, SUM(summa) FROM session_account_21_201205 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@76e596: SELECT sid, SUM(summa) FROM session_account_21_201206 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@15960dd: SELECT sid, SUM(summa) FROM session_account_21_201206 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1c63a8: SELECT sid, SUM(summa) FROM session_account_21_201207 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@4157d2: SELECT sid, SUM(summa) FROM session_account_21_201207 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@62bc77: SELECT sid, SUM(summa) FROM session_account_21_201208 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@88097e: SELECT sid, SUM(summa) FROM session_account_21_201208 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1bdacbe: SELECT sid, SUM(summa) FROM session_account_21_201209 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@c76ec3: SELECT sid, SUM(summa) FROM session_account_21_201209 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@102ffa: SELECT sid, SUM(summa) FROM session_account_21_201210 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@b7531e: SELECT sid, SUM(summa) FROM session_account_21_201210 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@3157a8: SELECT sid, SUM(summa) FROM session_account_21_201211 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@134139f: SELECT sid, SUM(summa) FROM session_account_21_201211 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@ff51f1: SELECT sid, SUM(summa) FROM session_account_21_201212 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1c137c7: SELECT sid, SUM(summa) FROM session_account_21_201212 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@f8288e: SELECT sid, SUM(summa) FROM session_account_21_201301 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@4b4dd9: SELECT sid, SUM(summa) FROM session_account_21_201301 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@b421a2: SELECT sid, SUM(summa) FROM session_account_21_201302 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1019f2a: SELECT sid, SUM(summa) FROM session_account_21_201302 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.ServerPreparedStatement[188] - SELECT * FROM contract WHERE id=191468
com.mysql.jdbc.ServerPreparedStatement[219] - DELETE FROM contract_account WHERE cid IN (191468, 192136) AND yy=null AND mm=null AND sid IN ( 33,234,236,84,153,72,73,80,292,124,79,76,139,166,138,167,268,269)
com.mysql.jdbc.ServerPreparedStatement[221] - SELECT * FROM inet_serv_option_26 WHERE servId=1
com.mysql.jdbc.ServerPreparedStatement[224] - SELECT * FROM inet_serv_type_26 WHERE id=1
com.mysql.jdbc.ServerPreparedStatement[225] - SELECT deviceTypeId FROM inet_serv_type_device_type_link_26 WHERE inetServId=1
com.mysql.jdbc.ServerPreparedStatement[226] - SELECT deviceGroupId FROM inet_serv_type_device_group_link_26 WHERE inetServId=1
com.mysql.jdbc.ServerPreparedStatement[227] - SELECT serv.*, contract.scid, contract.sub_mode FROM inet_serv_26 AS serv LEFT JOIN contract ON serv.contractId=contract.id WHERE serv.id=1
com.mysql.jdbc.ServerPreparedStatement[228] - SELECT inet_device_26.*, entity.entitySpecId, entity.title as entityTitle FROM inet_device_26 LEFT JOIN entity ON entity.id=inet_device_26.entityId WHERE inet_device_26.id=3
com.mysql.jdbc.ServerPreparedStatement[229] - SELECT deviceGroupId FROM inv_device_group_link_26 WHERE deviceId=3
com.mysql.jdbc.ServerPreparedStatement[230] - SELECT * FROM inet_device_type_26 WHERE id=3

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: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 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.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:140)
        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)

server 07-24/10:10:10 ERROR ["http-bio-/0.0.0.0-8080"-exec-2] AbstractJaxWsHandler -
java.lang.NullPointerException
        at ru.bitel.bgbilling.modules.inet.api.server.service.InetSessionServiceImpl.sessionInfoList(InetSessionServiceImpl.java:566)
        at ru.bitel.bgbilling.modules.inet.api.server.service.InetSessionServiceImpl.inetSessionDetail(InetSessionServiceImpl.java:533)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at ru.bitel.bgbilling.kernel.container.service.server.ServiceInfo.invoke(ServiceInfo.java:102)
        at ru.bitel.bgbilling.kernel.container.ws.server.AbstractJaxWsHandler.invoke(AbstractJaxWsHandler.java:192)
        at ru.bitel.bgbilling.kernel.container.ws.server.JaxWsHandler.access$1(JaxWsHandler.java:1)
        at ru.bitel.bgbilling.kernel.container.ws.server.JaxWsHandler$2.run(JaxWsHandler.java:309)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:396)
        at ru.bitel.bgbilling.kernel.container.ws.server.JaxWsHandler.invoke(JaxWsHandler.java:303)
        at ru.bitel.bgbilling.kernel.container.ws.server.AbstractJaxWsHandler$ServiceInstanceResolver$1.invoke(AbstractJaxWsHandler.java:304)
        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.common.server.JaxWSAdapter.handle(JaxWSAdapter.java:374)
        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)

07-25/08:44:44 ERROR ["http-bio-/0.0.0.0-8080"-exec-1] RequestLogServiceImpl - ru.bitel.bgbilling.kernel.event.EventProcessorException: java.lang.NullPointerException: null
java.util.concurrent.ExecutionException: ru.bitel.bgbilling.kernel.event.EventProcessorException: java.lang.NullPointerException: null
        at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
        at java.util.concurrent.FutureTask.get(FutureTask.java:83)
        at ru.bitel.bgbilling.modules.inet.api.server.service.RequestLogServiceImpl.inetConnectionLog(RequestLogServiceImpl.java:100)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at ru.bitel.bgbilling.kernel.container.service.server.ServiceInfo.invoke(ServiceInfo.java:102)
        at ru.bitel.bgbilling.kernel.container.ws.server.AbstractJaxWsHandler.invoke(AbstractJaxWsHandler.java:192)
        at ru.bitel.bgbilling.kernel.container.ws.server.JaxWsHandler.access$1(JaxWsHandler.java:1)
        at ru.bitel.bgbilling.kernel.container.ws.server.JaxWsHandler$2.run(JaxWsHandler.java:309)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:396)
        at ru.bitel.bgbilling.kernel.container.ws.server.JaxWsHandler.invoke(JaxWsHandler.java:303)
        at ru.bitel.bgbilling.kernel.container.ws.server.AbstractJaxWsHandler$ServiceInstanceResolver$1.invoke(AbstractJaxWsHandler.java:304)
        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.common.server.JaxWSAdapter.handle(JaxWSAdapter.java:374)
        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:895)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
        at java.lang.Thread.run(Thread.java:662)
Caused by: ru.bitel.bgbilling.kernel.event.EventProcessorException: java.lang.NullPointerException: null
        at ru.bitel.bgbilling.kernel.event.Producer.onMessage(Producer.java:111)
        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)
        ... 3 more

Время   С адреса   С порта   На адрес   На порт   Байт   С интерфейса   На интерфейс   Протокол
25.07.2013 9:27   172.16.9.254   67   255.255.255.255   68   328   0   1901   0

Время   С адреса   С порта   На адрес   На порт   Байт   С интерфейса   На интерфейс
23.07.2013 9:26   172.16.9.254   67   255.255.255.255   68   328   0   1901
23.07.2013 9:59   172.16.9.254   67   255.255.255.255   68   328   0   1901

radius 07-29/11:00:35  INFO [rdsLstnr-p-8-t-3] InetRadiusProcessor - REQUEST_AFTER_PREPROCESS:
Packet type: Accounting-Request
Identifier: 131
Authenticator: {58 21 1D 9F 17 C9 56 9E 53 9F 14 18 87 81 6D B3}
Attributes:
  User-Name=nas-port:xxx.xxx.xxx.xxx:0/0/0/255.1112
  NAS-IP-Address=xxx.xxx.xxx.xxx
  NAS-Port=129595
  Service-Type=2
  Framed-Protocol=1
  UNKNOWN[-1-196]={00 00 00 CB}
  UNKNOWN[-1-198]={00 00 00 00}
  UNKNOWN[-1-193]={00 00 00 00}
  UNKNOWN[-1-192]={00 00 00 00}
  NAS-Port-Id=0/0/0/255.1112
  UNKNOWN[-1-151]={33 33 34 45 41 45 43 30}
  NAS-Identifier=xxx.xxx.xxx.xxx
  Acct-Input-Octets=0
  Acct-Output-Octets=0
  Acct-Status-Type=3
  Acct-Delay-Time=0
  Acct-Session-Time=501014
  Acct-Input-Packets=0
  Acct-Session-Id=800000000001FA3B
  Acct-Authentic=1
  Acct-Output-Packets=0
  UNKNOWN[-1-190]={00 00 00 00}
  Event-Timestamp=1375063314
  UNKNOWN[-1-191]={00 00 00 00}
  NAS-Port-Type=34
  cisco-avpair=connect-progress=Auth Open
  cisco-NAS-Port=0/0/0/255.1112
  cisco-SSG-Control-Info=I0;0
  cisco-SSG-Control-Info=O0;0
Common options: {macAddress=0/0/0/255.1112, interfaceId=0}
radius 07-29/11:00:35  INFO [rdsLstnr-p-8-t-3] InetNas - Search serv on deviceId=3; interfaceId=0
radius 07-29/11:00:35  WARN [rdsLstnr-p-8-t-3] InetRadiusProcessor - Creating NasConnection from accounting packet [statusType=3]
radius 07-29/11:00:35 ERROR [rdsLstnr-p-8-t-3] InetRadiusProcessor - Session ip address not found in packet!
radius 07-29/11:00:35  WARN [rdsLstnr-p-8-t-3] InetNas - NasConnection not found
radius 07-29/11:00:35  INFO [rdsLstnr-p-8-t-3] update - RESPONSE:
Packet type: Accounting-Response
Identifier: 131
Authenticator: {BA 84 58 43 62 D2 46 55 2E 73 1C D1 12 C6 80 FF}
Attributes:

Process time update: 218

...
      if (inetAddress != null)
      {
        connection.setInetAddressBytes(inetAddress.address);
      }
      else if (statusType != 1)
      {
        logger.error("Session ip address not found in packet!");
        return null;
      }
...