mq 11-01/11:02:02 ERROR [pool-1-thread-1] SessionRecalculateTarifficationManager - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS account  USING LEFT JOIN inet_session_log_1_201210 AS session  ON account.se' at line 1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS account  USING LEFT JOIN inet_session_log_1_201210 AS session  ON account.se' at line 1
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
   at com.mysql.jdbc.Util.getInstance(Util.java:386)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
   at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)
   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.accounting.recalculate.day.SessionRecalculateDayTarifficationManager.removeAllExtraData(SessionRecalculateDayTarifficationManager.java:246)
   at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.recalculate(SessionRecalculateTarifficationManager.java:428)
   at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.run(SessionRecalculateTarifficationManager.java:148)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
   at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
   at java.util.concurrent.FutureTask.run(FutureTask.java:138)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
   at java.lang.Thread.run(Thread.java:619)

mq 11-01/18:33:04 ERROR [pool-1-thread-1] SessionRecalculateTarifficationManager - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE  account.contractId = 45' at line 1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE  account.contractId = 45' at line 1
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
   at com.mysql.jdbc.Util.getInstance(Util.java:386)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
   at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)
   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.accounting.recalculate.day.SessionRecalculateDayTarifficationManager.removeAllExtraData(SessionRecalculateDayTarifficationManager.java:247)
   at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.recalculate(SessionRecalculateTarifficationManager.java:428)
   at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.run(SessionRecalculateTarifficationManager.java:148)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
   at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
   at java.util.concurrent.FutureTask.run(FutureTask.java:138)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
   at java.lang.Thread.run(Thread.java:619)

mq 11-02/23:56:00 ERROR [pool-1-thread-1] SessionRecalculateTarifficationManager - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE  account.contractId = 345' at line 1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE  account.contractId = 345' at line 1
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
   at com.mysql.jdbc.Util.getInstance(Util.java:386)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
   at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)
   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.accounting.recalculate.day.SessionRecalculateDayTarifficationManager.removeAllExtraData(SessionRecalculateDayTarifficationManager.java:247)
   at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.recalculate(SessionRecalculateTarifficationManager.java:428)
   at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.run(SessionRecalculateTarifficationManager.java:148)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
   at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
   at java.util.concurrent.FutureTask.run(FutureTask.java:138)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
   at java.lang.Thread.run(Thread.java:619)

  recalculate 04-23/09:10:14 ERROR [pool-8-thread-1] SessionRecalculateTarifficationManager - Unknown column 'yy' in 'where clause'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'yy' in 'where clause'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)
        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.accounting.recalculate.day.TrafficRangeRecalculateDayManager.removeAllExtraData(TrafficRangeRecalculateDayManager.java:168)
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.day.current.SessionRecalculateCurrentDayTarifficationManager.removeAllExtraData(SessionRecalculateCurrentDayTarifficationManager.java:396)
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.recalculate(SessionRecalculateTarifficationManager.java:487)
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.run(SessionRecalculateTarifficationManager.java:172)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
        at java.lang.Thread.run(Thread.java:662)

Сервер: вер. 6.0 сборка 1811 от 13.11.2014 18:45:59
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.6.0_45
inet вер. 6.0 сборка 1472 от 14.11.2014 18:59:34

show create table inet_tariff_traffic_range_{mid}

inet_tariff_traffic_range_1;CREATE TABLE `inet_tariff_traffic_range_1` (
  `contractId` int(11) NOT NULL,
  `treeNodeId` bigint(20) NOT NULL,
  `key` bigint(20) NOT NULL,
  `amount` bigint(20) NOT NULL,
  `counter` int(11) NOT NULL,
  `maxAmount` bigint(20) NOT NULL DEFAULT '-1',
  PRIMARY KEY (`contractId`,`treeNodeId`,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251
/*!50100 PARTITION BY HASH ( contractId)
PARTITIONS 8 */

./bg_installer.sh killhash m1

./bg_installer.sh update

inet вер. 6.0 сборка 1472 от 14.11.2014 18:59:34

Сервер: вер. 6.0 сборка 1848 от 22.04.2015 14:30:45
inet вер. 6.0 сборка 1498 от 21.04.2015 22:26:27

recalculate 04-24/08:18:31 ERROR [pool-5-thread-1] TrafficRangeTariffTreeNode - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'rangeKey' in 'where clause'
ru.bitel.bgbilling.common.BGException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'rangeKey' in 'where clause'
   at ru.bitel.bgbilling.modules.inet.accounting.recalculate.TrafficRangeTarrificationManager.getPrevMonthTraffic(TrafficRangeTarrificationManager.java:63)
   at ru.bitel.bgbilling.modules.inet.accounting.recalculate.TrafficRangeTarrificationManager.getRangedTraffic(TrafficRangeTarrificationManager.java:32)
   at ru.bitel.bgbilling.modules.inet.accounting.recalculate.day.TrafficRangeTarrificationDayManager.getRangedTraffic(TrafficRangeTarrificationDayManager.java:31)
   at ru.bitel.bgbilling.modules.inet.tariff.server.range.TrafficRangeManager.addRangedTraffic(TrafficRangeManager.java:169)
   at ru.bitel.bgbilling.modules.inet.tariff.server.range.TrafficRangeManager.addRangedTraffic(TrafficRangeManager.java:277)
   at ru.bitel.bgbilling.modules.inet.tariff.server.range.TrafficRangeTariffTreeNode.addRangedTraffic(TrafficRangeTariffTreeNode.java:448)
   at ru.bitel.bgbilling.modules.inet.tariff.server.range.TrafficRangeTariffTreeNode.execute(TrafficRangeTariffTreeNode.java:314)
   at ru.bitel.bgbilling.modules.inet.tariff.server.range.TrafficRangeTariffTreeNode.execute(TrafficRangeTariffTreeNode.java:1)
   at ru.bitel.bgbilling.kernel.tariff.tree.server.TariffTreeNodeHolder.execute(TariffTreeNodeHolder.java:34)
   at ru.bitel.bgbilling.kernel.tariff.tree.server.TariffTreeNode.executeChildren(TariffTreeNode.java:101)
   at ru.bitel.bgbilling.modules.inet.tariff.server.TrafficTypeTariffTreeNode.execute(TrafficTypeTariffTreeNode.java:78)
   at ru.bitel.bgbilling.modules.inet.tariff.server.TrafficTypeTariffTreeNode.execute(TrafficTypeTariffTreeNode.java:1)
   at ru.bitel.bgbilling.kernel.tariff.tree.server.TariffTreeNodeHolder.execute(TariffTreeNodeHolder.java:34)
   at ru.bitel.bgbilling.kernel.tariff.tree.server.TariffTreeNode.executeChildren(TariffTreeNode.java:101)
   at ru.bitel.bgbilling.kernel.tariff.tree.server.TariffTreeNode.execute(TariffTreeNode.java:116)
   at ru.bitel.bgbilling.kernel.tariff.tree.server.TariffTreeNodeHolder.execute(TariffTreeNodeHolder.java:34)
   at ru.bitel.bgbilling.kernel.tariff.tree.server.TariffModuleTree.execute(TariffModuleTree.java:77)
   at ru.bitel.bgbilling.modules.inet.accounting.SessionTarifficationManager.calculateHour(SessionTarifficationManager.java:474)
   at ru.bitel.bgbilling.modules.inet.accounting.SessionTarifficationManager.calculate(SessionTarifficationManager.java:319)
   at ru.bitel.bgbilling.modules.inet.accounting.SessionTarifficationManager.tarifficate(SessionTarifficationManager.java:171)
   at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.tarificateSessionHour(SessionRecalculateTarifficationManager.java:1354)
   at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.nextContract(SessionRecalculateTarifficationManager.java:670)
   at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.recalculate(SessionRecalculateTarifficationManager.java:501)
   at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.run(SessionRecalculateTarifficationManager.java:172)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
   at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
   at java.util.concurrent.FutureTask.run(FutureTask.java:138)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
   at java.lang.Thread.run(Thread.java:662)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'rangeKey' in 'where clause'
   at sun.reflect.GeneratedConstructorAccessor57.newInstance(Unknown Source)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
   at com.mysql.jdbc.Util.getInstance(Util.java:386)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
   at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
   at ru.bitel.common.sql.PreparedStatementCache.execute(PreparedStatementCache.java:131)
   at ru.bitel.bgbilling.modules.inet.accounting.recalculate.TrafficRangeTarrificationManager.getPrevMonthTraffic(TrafficRangeTarrificationManager.java:51)
   ... 29 more

 ALTER TABLE `inet_tariff_traffic_range_1`
CHANGE COLUMN `key` `rangeKey` BIGINT(20) NOT NULL ;

inet_tariff_traffic_range_1;CREATE TABLE `inet_tariff_traffic_range_1` (
  `contractId` int(11) NOT NULL,
  `treeNodeId` bigint(20) NOT NULL,
  `rangeKey` bigint(20) NOT NULL,
  `amount` bigint(20) NOT NULL,
  `counter` int(11) NOT NULL,
  `maxAmount` bigint(20) NOT NULL DEFAULT '-1',
  PRIMARY KEY (`contractId`,`treeNodeId`,`rangeKey`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251
/*!50100 PARTITION BY HASH ( contractId)
PARTITIONS 8 */

recalculate 04-24/10:04:10 ERROR [pool-15-thread-1] TrafficRangeTariffTreeNode - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'yy' in 'where clause'
ru.bitel.bgbilling.common.BGException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'yy' in 'where clause'
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.TrafficRangeTarrificationManager.getPrevMonthTraffic(TrafficRangeTarrificationManager.java:63)
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.TrafficRangeTarrificationManager.getRangedTraffic(TrafficRangeTarrificationManager.java:32)
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.day.TrafficRangeTarrificationDayManager.getRangedTraffic(TrafficRangeTarrificationDayManager.java:31)
        at ru.bitel.bgbilling.modules.inet.tariff.server.range.TrafficRangeManager.addRangedTraffic(TrafficRangeManager.java:169)
        at ru.bitel.bgbilling.modules.inet.tariff.server.range.TrafficRangeManager.addRangedTraffic(TrafficRangeManager.java:277)
        at ru.bitel.bgbilling.modules.inet.tariff.server.range.TrafficRangeTariffTreeNode.addRangedTraffic(TrafficRangeTariffTreeNode.java:448)
        at ru.bitel.bgbilling.modules.inet.tariff.server.range.TrafficRangeTariffTreeNode.execute(TrafficRangeTariffTreeNode.java:314)
        at ru.bitel.bgbilling.modules.inet.tariff.server.range.TrafficRangeTariffTreeNode.execute(TrafficRangeTariffTreeNode.java:1)
        at ru.bitel.bgbilling.kernel.tariff.tree.server.TariffTreeNodeHolder.execute(TariffTreeNodeHolder.java:34)
        at ru.bitel.bgbilling.kernel.tariff.tree.server.TariffTreeNode.executeChildren(TariffTreeNode.java:101)
        at ru.bitel.bgbilling.modules.inet.tariff.server.TrafficTypeTariffTreeNode.execute(TrafficTypeTariffTreeNode.java:78)
        at ru.bitel.bgbilling.modules.inet.tariff.server.TrafficTypeTariffTreeNode.execute(TrafficTypeTariffTreeNode.java:1)
        at ru.bitel.bgbilling.kernel.tariff.tree.server.TariffTreeNodeHolder.execute(TariffTreeNodeHolder.java:34)
        at ru.bitel.bgbilling.kernel.tariff.tree.server.TariffTreeNode.executeChildren(TariffTreeNode.java:101)
        at ru.bitel.bgbilling.kernel.tariff.tree.server.TariffTreeNode.execute(TariffTreeNode.java:116)
        at ru.bitel.bgbilling.kernel.tariff.tree.server.TariffTreeNodeHolder.execute(TariffTreeNodeHolder.java:34)
        at ru.bitel.bgbilling.kernel.tariff.tree.server.TariffModuleTree.execute(TariffModuleTree.java:77)
        at ru.bitel.bgbilling.modules.inet.accounting.SessionTarifficationManager.calculateHour(SessionTarifficationManager.java:474)
        at ru.bitel.bgbilling.modules.inet.accounting.SessionTarifficationManager.calculate(SessionTarifficationManager.java:319)
        at ru.bitel.bgbilling.modules.inet.accounting.SessionTarifficationManager.tarifficate(SessionTarifficationManager.java:171)
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.tarificateSessionHour(SessionRecalculateTarifficationManager.java:1354)
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.nextContract(SessionRecalculateTarifficationManager.java:670)
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.recalculate(SessionRecalculateTarifficationManager.java:501)
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.SessionRecalculateTarifficationManager.run(SessionRecalculateTarifficationManager.java:172)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
        at java.lang.Thread.run(Thread.java:662)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'yy' in 'where clause'
        at sun.reflect.GeneratedConstructorAccessor65.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at ru.bitel.common.sql.PreparedStatementCache.execute(PreparedStatementCache.java:131)
        at ru.bitel.bgbilling.modules.inet.accounting.recalculate.TrafficRangeTarrificationManager.getPrevMonthTraffic(TrafficRangeTarrificationManager.java:51)
        ... 29 more

./bg_installer.sh killhash m1

./bg_installer.sh killhash m1

 ./bg_installer.sh inet_6.0_1498.zip

Hash killing for m1 finished!

[root@billing60 BGBillingServer]# ./bg_installer.sh killhash m1
 04-24/10:47:10  INFO [main] DefaultServerSetup - Binding javax.jms.ConnectionFactory[org.apache.activemq.ActiveMQConnectionFactory@21a80a69] to java:comp/env/mq/connectionFactory
 04-24/10:47:10  INFO [main] DefaultServerSetup - Init DB connection pools
 04-24/10:47:10  INFO [main] DefaultServerSetup - Binding JDBC pool "master" to java:comp/env/jdbc/master
 04-24/10:47:10  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.server.util:type=DatabaseConnectionPool,name=master
 04-24/10:47:10  INFO [main] DefaultServerSetup - Init trash pools..
mq 04-24/10:47:10  INFO [EventProcessor-init] EventProcessor - Init EventProcessor MQ connection factory...
mq 04-24/10:47:10 DEBUG [EventProcessor-init] FailoverTransport - Reconnect was triggered but transport is not started yet. Wait for start to connect the transport.
mq 04-24/10:47:10 DEBUG [EventProcessor-init] FailoverTransport - Started.
mq 04-24/10:47:10 DEBUG [EventProcessor-init] FailoverTransport - Waking up reconnect task
mq 04-24/10:47:10 DEBUG [ActiveMQ Task] FailoverTransport - urlList connectionList:[nio://127.0.0.1:61616?socketBufferSize=1000000]
mq 04-24/10:47:10 DEBUG [ActiveMQ Task] FailoverTransport - Attempting connect to: nio://127.0.0.1:61616?socketBufferSize=1000000
mq 04-24/10:47:10 DEBUG [ActiveMQ Task] WireFormatNegotiator - Sending: WireFormatInfo { version=6, properties={CacheSize=1024, CacheEnabled=true, SizePrefixDisabled=false, MaxInactivityDurationInitalDelay=10000, TcpNoDelayEnabled=true, MaxInactivityDuration=30000, TightEncodingEnabled=true, StackTraceEnabled=true}, magic=[A,c,t,i,v,e,M,Q]}
mq 04-24/10:47:10 DEBUG [ActiveMQ NIO Worker] WireFormatNegotiator - Received WireFormat: WireFormatInfo { version=9, properties={CacheSize=1024, MaxFrameSize=9223372036854775807, CacheEnabled=true, SizePrefixDisabled=false, TcpNoDelayEnabled=true, MaxInactivityDurationInitalDelay=10000, MaxInactivityDuration=30000, TightEncodingEnabled=true, StackTraceEnabled=true}, magic=[A,c,t,i,v,e,M,Q]}
mq 04-24/10:47:10 DEBUG [ActiveMQ NIO Worker] WireFormatNegotiator - tcp:///127.0.0.1:61616 before negotiation: OpenWireFormat{version=6, cacheEnabled=false, stackTraceEnabled=false, tightEncodingEnabled=false, sizePrefixDisabled=false}
mq 04-24/10:47:10 DEBUG [ActiveMQ NIO Worker] WireFormatNegotiator - tcp:///127.0.0.1:61616 after negotiation: OpenWireFormat{version=6, cacheEnabled=true, stackTraceEnabled=true, tightEncodingEnabled=true, sizePrefixDisabled=false}
mq 04-24/10:47:10 DEBUG [ActiveMQ Task] FailoverTransport - Connection established
mq 04-24/10:47:10  INFO [ActiveMQ Task] FailoverTransport - Successfully connected to nio://127.0.0.1:61616?socketBufferSize=1000000
 04-24/10:47:10 DEBUG [main] EventProcessor - Add ru.bitel.bgbilling.server.util.Setup$1@6a1681ea to BG.Event.ru.bitel.bgbilling.kernel.event.events.system.ModuleConfigModifiedEvent
Hash killing for m1 finished!

[root@billing60 BGBillingServer]# ./bg_installer.sh inet_6.0_1498.zip
 04-24/10:48:07  INFO [main] DefaultServerSetup - Binding javax.jms.ConnectionFactory[org.apache.activemq.ActiveMQConnectionFactory@51b48197] to java:comp/env/mq/connectionFactory
 04-24/10:48:08  INFO [main] DefaultServerSetup - Init DB connection pools
 04-24/10:48:08  INFO [main] DefaultServerSetup - Binding JDBC pool "master" to java:comp/env/jdbc/master
 04-24/10:48:08  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.server.util:type=DatabaseConnectionPool,name=master
 04-24/10:48:08  INFO [main] DefaultServerSetup - Init trash pools..
mq 04-24/10:48:08  INFO [EventProcessor-init] EventProcessor - Init EventProcessor MQ connection factory...
mq 04-24/10:48:08 DEBUG [EventProcessor-init] FailoverTransport - Reconnect was triggered but transport is not started yet. Wait for start to connect the transport.
mq 04-24/10:48:08 DEBUG [EventProcessor-init] FailoverTransport - Started.
mq 04-24/10:48:08 DEBUG [EventProcessor-init] FailoverTransport - Waking up reconnect task
mq 04-24/10:48:08 DEBUG [ActiveMQ Task] FailoverTransport - urlList connectionList:[nio://127.0.0.1:61616?socketBufferSize=1000000]
mq 04-24/10:48:08 DEBUG [ActiveMQ Task] FailoverTransport - Attempting connect to: nio://127.0.0.1:61616?socketBufferSize=1000000
mq 04-24/10:48:08 DEBUG [ActiveMQ Task] WireFormatNegotiator - Sending: WireFormatInfo { version=6, properties={CacheSize=1024, CacheEnabled=true, SizePrefixDisabled=false, MaxInactivityDurationInitalDelay=10000, TcpNoDelayEnabled=true, MaxInactivityDuration=30000, TightEncodingEnabled=true, StackTraceEnabled=true}, magic=[A,c,t,i,v,e,M,Q]}
mq 04-24/10:48:08 DEBUG [ActiveMQ NIO Worker] WireFormatNegotiator - Received WireFormat: WireFormatInfo { version=9, properties={CacheSize=1024, MaxFrameSize=9223372036854775807, CacheEnabled=true, SizePrefixDisabled=false, TcpNoDelayEnabled=true, MaxInactivityDurationInitalDelay=10000, MaxInactivityDuration=30000, TightEncodingEnabled=true, StackTraceEnabled=true}, magic=[A,c,t,i,v,e,M,Q]}
mq 04-24/10:48:08 DEBUG [ActiveMQ NIO Worker] WireFormatNegotiator - tcp:///127.0.0.1:61616 before negotiation: OpenWireFormat{version=6, cacheEnabled=false, stackTraceEnabled=false, tightEncodingEnabled=false, sizePrefixDisabled=false}
mq 04-24/10:48:08 DEBUG [ActiveMQ NIO Worker] WireFormatNegotiator - tcp:///127.0.0.1:61616 after negotiation: OpenWireFormat{version=6, cacheEnabled=true, stackTraceEnabled=true, tightEncodingEnabled=true, sizePrefixDisabled=false}
mq 04-24/10:48:08 DEBUG [ActiveMQ Task] FailoverTransport - Connection established
mq 04-24/10:48:08  INFO [ActiveMQ Task] FailoverTransport - Successfully connected to nio://127.0.0.1:61616?socketBufferSize=1000000
 04-24/10:48:08 DEBUG [main] EventProcessor - Add ru.bitel.bgbilling.server.util.Setup$1@1958015a to BG.Event.ru.bitel.bgbilling.kernel.event.events.system.ModuleConfigModifiedEvent
Module: inet already installed. Reinstalling....
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 1
(1050) Table 'inv_device_group_1' already exists
(1050) Table 'inv_device_group_link_1' already exists
(1050) Table 'inv_ip_category_1' already exists
(1050) Table 'inv_ip_resource_1' already exists
(1050) Table 'inv_ip_resource_dyn_reserve_1' already exists
(1050) Table 'inet_device_1' already exists
(1050) Table 'inet_accounting_period_1' already exists
(1050) Table 'inet_device_type_1' already exists
(1050) Table 'inet_interface_1' already exists
(1050) Table 'inet_option_1' already exists
(1050) Table 'inet_serv_1' already exists
(1050) Table 'inet_serv_type_1' already exists
(1050) Table 'inet_serv_type_device_group_link_1' already exists
(1050) Table 'inet_serv_type_device_type_link_1' already exists
(1050) Table 'inet_traffic_type_1' already exists
(1050) Table 'inet_traffic_type_link_1' already exists
(1050) Table 'inet_traffic_type_link_rule_1' already exists
(1050) Table 'inet_zone_1' already exists
(1050) Table 'inv_ip_resource_subscription_1' already exists
(1050) Table 'inet_serv_option_1' already exists
(1050) Table 'inet_task_process_1' already exists
(1060) Duplicate column name 'title'
(1060) Duplicate column name 'source'
(1060) Duplicate column name 'dynamic'
(1060) Duplicate column name 'config'
(1060) Duplicate column name 'title'
(1060) Duplicate column name 'deviceEntitySpecId'
(1060) Duplicate column name 'saHandlerClass'
(1060) Duplicate column name 'protocolHandlerClass'
(1146) Table 'bgbilling.connection_log_entry_1_201105' doesn't exist
(1146) Table 'bgbilling.connection_log_entry_1_201106' doesn't exist
(1050) Table 'inv_vlan_resource_1' already exists
(1050) Table 'inv_vlan_category_1' already exists
(1050) Table 'inv_vlan_resource_subscription_1' already exists
(1054) Unknown column 'subsciberId' in 'inv_ip_resource_subscription_1'
(1050) Table 'inv_device_port_subscription_1' already exists
(1050) Table 'inv_device_port_1' already exists
(1060) Duplicate column name 'config'
(1060) Duplicate column name 'accessCode'
(1050) Table 'inet_connection_1' already exists
(1050) Table 'inet_session_1' already exists
(1050) Table 'inet_session_detail_1' already exists
(1050) Table 'inet_session_account_1' already exists
(1050) Table 'inet_connection_route_1' already exists
(1091) Can't DROP 'zoneId'; check that column/key exists
(1091) Can't DROP 'ipCategoryId'; check that column/key exists
(1060) Duplicate column name 'ipCategoryId'
(1060) Duplicate column name 'subscriberTitle'
(1054) Unknown column 'subcriberId' in 'inv_device_port_subscription_1'
(1054) Unknown column 'subcriberTitle' in 'inv_device_port_subscription_1'
(1060) Duplicate column name 'deviceId'
(1060) Duplicate column name 'parentId'
(1060) Duplicate column name 'groupIntersection'
(1060) Duplicate column name 'uptime'
(1060) Duplicate column name 'sourceId'
(1050) Table 'inet_tariff_traffic_max_1' already exists
(1060) Duplicate column name 'deviceState'
(1060) Duplicate column name 'deviceState'
(1060) Duplicate column name 'parentId'
(1060) Duplicate column name 'parentTypeIds'
(1060) Duplicate column name 'parentId'
(1060) Duplicate column name 'counterService'
(1050) Table 'inet_tariff_traffic_range_1' already exists
(1060) Duplicate column name 'yy'
(1060) Duplicate column name 'personalVlan'
(1060) Duplicate column name 'ipResourceSubscriptionId'
Table 'bgbilling.inv_ip_resource_subscription_dyn_201112' doesn't exist
Table 'bgbilling.inv_ip_resource_subscription_dyn_1_201112' doesn't exist
(1054) Unknown column 'hour' in 'inet_task_process_1'
(1061) Duplicate key name 'sessionId'
(1061) Duplicate key name 'sessionId'
(1061) Duplicate key name 'login'
(1060) Duplicate column name 'userId'
(1060) Duplicate column name 'deviceManagerClass'
(1060) Duplicate column name 'macAddress'
(1060) Duplicate column name 'needMacAddress'
(1060) Duplicate column name 'sessionCountLimitLock'
(1060) Duplicate column name 'comment'
(1060) Duplicate column name 'counterRealm'
(1060) Duplicate column name 'config'
(1060) Duplicate column name 'agentDeviceId'
(1060) Duplicate column name 'splittedId'
(1060) Duplicate column name 'router'
(1060) Duplicate column name 'needIdentifier'
(1060) Duplicate column name 'identifier'
(1050) Table 'inv_ip_resource_subscription_real_1' already exists
(1060) Duplicate column name 'unit'
(1060) Duplicate column name 'addressAllInterface'
(1091) Can't DROP 'id'; check that column/key exists
(1091) Can't DROP 'id'; check that column/key exists
(1060) Duplicate column name 'uniqueInterfaces'
(1050) Table 'inv_device_interface_index_1' already exists
Duplicate column name 'title'
(1060) Duplicate column name 'maxAmount'
(1060) Duplicate column name 'needContractObject'
(1060) Duplicate column name 'contractObjectId'
(1050) Table 'inet_serv_restriction_1' already exists
(1060) Duplicate column name 'needRestriction'
(1061) Duplicate key name 'devicePort'
(1060) Duplicate column name 'circuitId'
(1060) Duplicate column name 'dateFrom'
(1060) Duplicate column name 'orderManagerDisabled'
(1050) Table 'inet_device_group_link_1' already exists
Module Instance init => OK
Executing call AddSchedulerTasks; param: inet.sc
Scheduled class ru.bitel.bgbilling.modules.inet.task.InetServPeriodTask already exists!
Result => true
Executing call PutFile; param: inet.xml:actions
Result => true
Executing call PutFile; param: ru:dyn
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Remove libs => OK
Module inet was successfull installed!
Please, restart BGBilling server.