BiTel

scheduler 07-22/20:11:16 ERROR [pool-1-thread-4] InetRecalculator -
ru.bitel.bgbilling.common.BGException: ru.bitel.bgbilling.common.BGException: Ошибка на acconting-сервере
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.task.InetRecalculator.calculate(InetRecalculator.java:319)
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.task.InetRecalculator.executeTask(InetRecalculator.java:129)
        at bitel.billing.server.task.bean.RunTask.run(RunTask.java:47)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:748)
Caused by: ru.bitel.bgbilling.common.BGException: Ошибка на acconting-сервере
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.task.InetRecalculator$AccountingEventSender.send(InetRecalculator.java:493)
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.task.InetRecalculator.calculateCurrentDay(InetRecalculator.java:351)
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.task.InetRecalculator.calculate(InetRecalculator.java:296)
        ... 5 more

recalculate 07-22/20:11:22 ERROR [worker-p-27-t-1] SessionRecalculateTarifficationManager - Duplicate entry '9268348-22-19-1' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '9268348-22-19-1' for key 'PRIMARY'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
        at com.mysql.jdbc.Util.getInstance(Util.java:387)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:932)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
        at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
        at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
        at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5094)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.day.current.SessionRecalculateCurrentDayTarifficationManager.initDetailPSAndRS(SessionRecalculateCurrentDayTarifficationManager.java:125)
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.recalculate(SessionRecalculateTarifficationManager.java:235)
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.run(SessionRecalculateTarifficationManager.java:148)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:748)
        at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:46)

show create table inet_session_detail_$mid

ALTER TABLE `inet_session_detail_$mid` DROP PRIMARY KEY , ADD PRIMARY KEY (`sessionId`, `day`, `hour`, `trafficTypeId`, `deviceId`);

 CREATE TABLE `inet_session_detail_10` (
  `sessionId` bigint(20) NOT NULL,
  `day` tinyint(4) NOT NULL,
  `hour` tinyint(4) NOT NULL,
  `trafficTypeId` int(11) NOT NULL,
  `deviceId` int(11) NOT NULL,
  `amount` bigint(20) NOT NULL,
  PRIMARY KEY (`sessionId`,`day`,`hour`,`trafficTypeId`,`deviceId`),
  KEY `sessionId` (`sessionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
/*!50100 PARTITION BY HASH ( sessionId)
PARTITIONS 8 */

mysql> select * from inet_session_log_detail_10_201707 where sessionid=9268348;
+-----------+-----+------+---------------+----------+--------+
| sessionId | day | hour | trafficTypeId | deviceId | amount |
+-----------+-----+------+---------------+----------+--------+
|   9268348 |  22 |   19 |             0 |        0 |   2965 |
|   9268348 |  22 |   19 |             1 |       25 |    652 |
|   9268348 |  22 |   19 |             2 |       25 |    967 |
|   9268348 |  22 |   20 |             0 |        0 |    670 |
+-----------+-----+------+---------------+----------+--------+
4 rows in set (0.00 sec)

mysql> select * from inet_session_log_10_201707 where id=9268348\G
*************************** 1. row ***************************
                id: 9268348
          parentId: 0
        splittedId: 0
      connectionId: 6542365
parentConnectionId: 0
          deviceId: 26
        devicePort: 11
     agentDeviceId: 0
     acctSessionId: NULL
          username: NULL
             realm: NULL
              type: 0
        accessCode: 0
            servId: 7586
   calledStationId: NULL
  callingStationId: NULL
      ipResourceId: 0
         ipAddress: NULL
   connectionStart: 2017-07-22 19:10:35
      sessionStart: 2017-07-22 19:10:35
       sessionStop: 2017-07-22 20:11:09
        lastActive: 2017-07-22 19:10:35
       deviceState: 1
     deviceOptions:
       sessionTime: 3635
       sessionCost: 0.00000
            status: 4
1 row in set (0.00 sec)