BiTel

server 07-30/13:20:18 ERROR ["http-bio-/0.0.0.0-8080"-exec-4] AbstractJaxWsHandler - java.sql.SQLException: No value specified for parameter 2
ru.bitel.bgbilling.common.BGException: java.sql.SQLException: No value specified for parameter 2
        at ru.bitel.bgbilling.modules.inet.api.server.bean.InetServMoveManager.moveSessionData(InetServMoveManager.java:179)
        at ru.bitel.bgbilling.modules.inet.api.server.service.InetServServiceImpl.inetServMove(InetServServiceImpl.java:939)
        at ru.bitel.bgbilling.modules.inet.api.server.service.InetServServiceImpl.inetServWrap(InetServServiceImpl.java:998)
        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.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)
Caused by: java.sql.SQLException: No value specified for parameter 2
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2578)
        at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2554)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2401)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2345)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2330)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at ru.bitel.bgbilling.modules.inet.api.server.bean.InetServMoveManager.moveSessionData(InetServMoveManager.java:160)
        ... 52 more

mysql> select count(*) from inet_connection_30 where deviceId in (20,21,23,26,28,30,31);
+----------+
| count(*) |
+----------+
|       54 |
+----------+

mysql> select count(*) from inet_session_log_30_201307;
+----------+
| count(*) |
+----------+
|   205936 |
+----------+

mysql> select count(*) from inet_session_log_detail_30_201307;
+----------+
| count(*) |
+----------+
|  6187967 |
+----------+

mysql> select count(*) from inet_session_log_30_201307 where deviceId in (20,21,23,26,28,30,31);
+----------+
| count(*) |
+----------+
|    62083 |
+----------+
1 row in set (3.07 sec)

mysql> select count(*) from inet_session_log_detail_30_201307 where deviceId in (20,21,23,26,28,30,31);
+----------+
| count(*) |
+----------+
|   145581 |
+----------+

mysql> select avg(sessionTime) from inet_session_log_30_201307 where deviceId in (20,21,23,26,28,30,31);
+------------------+
| avg(sessionTime) |
+------------------+
|        1003.0590 |
+------------------+

mysql> select avg(sessionTime) from inet_session_log_30_201307 where not deviceId in (20,21,23,26,28,30,31);
+------------------+
| avg(sessionTime) |
+------------------+
|       81980.5107 |
+------------------+

      if ((addressFrom == null) || (addressFrom.length == 0))
      {
        InetServType servType = this.servService.inetServTypeGet(inetServ.getTypeId());
        if (servType.isAddressAllInterface())
        {
          addressFrom = (byte[])null;
          addressTo = (byte[])null;
        }
        else
        {
          logger.warn("Address range not found for detail (inetServ:" + inetServ.getId() + ", session:" + sessionLog.getId() + "). Skipping");
          continue;
        }
      }

      InetDeviceMap.InetDeviceMapItem device = inetDeviceMap.get(sessionLog.getDeviceId());

      for (Map.Entry e : device.getFlowAgentIfaceMap().entrySet())
      {
        Integer agentDeviceId = (Integer)e.getKey();
        Set ifaces = new HashSet((Collection)e.getValue());

        Date timeFrom = sessionLog.getSessionStart();
        Date timeTo = sessionLog.getSessionStop();
        if (timeTo == null)
        {
          timeTo = new Date();
        }

        sessionInfoList.add(new InetDetailCreateEvent.SessionInfo(timeFrom, timeTo, agentDeviceId.intValue(), ifaces, new IpAddress(addressFrom),
          new IpAddress(addressTo), null));
      }

accounting 08-14/13:24:57 ERROR [pool-9-thread-2] SessionFlushingManager - Cannot find session with id=301126in DB!
accounting 08-14/13:24:58 ERROR [pool-9-thread-2] SessionFlushingManager - Cannot find session with id=265583in DB!
accounting 08-14/13:25:06  INFO [pool-9-thread-2] SessionFlushingManager - Flushed 4565 sessions for 178413(178370) ms.
collector 08-14/13:26:54  INFO [hrlydtlggr-p-9-t-1] HourlyDataLoggerTracker - Checking data log files to close [hours=2]...
radius 08-14/13:27:05  INFO [hrlydtlggr-p-7-t-1] HourlyDataLoggerTracker - Checking data log files to close [hours=2]...
 08-14/13:29:06  INFO [Thread-12] EventProcessor - Shutdown EventProcessor...

#трекер (обработка сессий без наработки):
#пауза между заданиями трекинга
accounting.worker.1.tracking.1.delay=5
#максимальное количество проверенных соединений за задание
accounting.worker.1.tracking.1.batchSize=500