BiTel

Форум BiTel
bgbilling.ru     docs.bitel.ru     wiki.bitel.ru     dbinfo.bitel.ru     bgcrm.ru     billing.bitel.ru     bitel.ru    
Текущее время: 20 июн 2025, 17:39

Часовой пояс: UTC + 5 часов [ Летнее время ]




Начать новую тему Ответить на тему  [ Сообщений: 17 ] 
Автор Сообщение
 Заголовок сообщения: Ошибка SQL при запуске переобсчета
СообщениеДобавлено: 01 ноя 2012, 11:08 
Запускаем переобсчет выставляя галочку только день и появляется следующая ошибка
Код:
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)


Вернуться к началу
  
 
СообщениеДобавлено: 01 ноя 2012, 15:33 
Не в сети
Разработчик

Зарегистрирован: 08 ноя 2007, 01:05
Сообщения: 8343
Откуда: Уфа
Карма: 238
Исправлено. В следующем обновлении будет.


Вернуться к началу
 Профиль  
 
СообщениеДобавлено: 01 ноя 2012, 18:37 
Обновились теперь выходит другая ошибка
Код:
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)


Вернуться к началу
  
 
СообщениеДобавлено: 01 ноя 2012, 18:43 
Не в сети
Разработчик

Зарегистрирован: 08 ноя 2007, 01:05
Сообщения: 8343
Откуда: Уфа
Карма: 238
Исправлено. В следующем обновлении будет.


Вернуться к началу
 Профиль  
 
СообщениеДобавлено: 02 ноя 2012, 23:59 
Теперь выходит такая ошибка
Код:
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)


Вернуться к началу
  
 
СообщениеДобавлено: 07 ноя 2012, 16:55 
up


Вернуться к началу
  
 
СообщениеДобавлено: 07 ноя 2012, 17:01 
Не в сети
Разработчик

Зарегистрирован: 08 ноя 2007, 01:05
Сообщения: 8343
Откуда: Уфа
Карма: 238
madmax писал(а):
Теперь выходит такая ошибка
Код:
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)


Это исправили уже в 1005 сборке inet


Вернуться к началу
 Профиль  
 
СообщениеДобавлено: 07 ноя 2012, 17:28 
Не в сети
Разработчик

Зарегистрирован: 08 ноя 2007, 01:05
Сообщения: 8343
Откуда: Уфа
Карма: 238
Обновитесь. Там еще одну ошибку при переобсчете исправили


Вернуться к началу
 Профиль  
 
СообщениеДобавлено: 23 апр 2015, 15:30 
Не в сети

Зарегистрирован: 23 апр 2015, 15:07
Сообщения: 5
Карма: 0
Возникла аналогичная проблема при запуске переобсчета.
Accounting error.log:

Код:
  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


Вернуться к началу
 Профиль  
 
СообщениеДобавлено: 23 апр 2015, 16:28 
Не в сети
Разработчик

Зарегистрирован: 08 ноя 2007, 01:05
Сообщения: 8343
Откуда: Уфа
Карма: 238
.id писал(а):
Возникла аналогичная проблема при запуске переобсчета.
Accounting error.log:

Код:
  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}


где {mid} - заменить на код модуля inet.


Вернуться к началу
 Профиль  
 
СообщениеДобавлено: 23 апр 2015, 16:58 
Не в сети

Зарегистрирован: 23 апр 2015, 15:07
Сообщения: 5
Карма: 0
stark писал(а):
Покажите запрос.
Код:
show create table inet_tariff_traffic_range_{mid}


где {mid} - заменить на код модуля inet.


Код:
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 */


Вернуться к началу
 Профиль  
 
СообщениеДобавлено: 23 апр 2015, 17:37 
Не в сети
Разработчик

Зарегистрирован: 08 ноя 2007, 01:05
Сообщения: 8343
Откуда: Уфа
Карма: 238
.id писал(а):
stark писал(а):
Покажите запрос.
Код:
show create table inet_tariff_traffic_range_{mid}


где {mid} - заменить на код модуля inet.


Код:
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 */



У вас не актуальная структура таблиц . Сделайте так

1. Остановите сервер.
2.
Код:
./bg_installer.sh killhash m1

3.
Код:
./bg_installer.sh update


Это обновит все до последней версии и исправит таблицы. Алтернативным способом если не обновляться, это выкачать вашу версию модуля
Код:
inet вер. 6.0 сборка 1472 от 14.11.2014 18:59:34

и установить ее (так же в 3-ем пункте), но ее на сайте уже нет:
ftp://bgbilling.ru/pub/bgbilling/6.0/data/

там есть только 1473, но не стоит обновлять модуль отдельно от ядра.


Вернуться к началу
 Профиль  
 
СообщениеДобавлено: 24 апр 2015, 11:52 
Не в сети

Зарегистрирован: 23 апр 2015, 15:07
Сообщения: 5
Карма: 0
Обновили сервер, Access и Accounting.

Код:
Сервер: вер. 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



Вернуться к началу
 Профиль  
 
СообщениеДобавлено: 24 апр 2015, 12:52 
Не в сети
Разработчик

Зарегистрирован: 08 ноя 2007, 01:05
Сообщения: 8343
Откуда: Уфа
Карма: 238
.id писал(а):
Обновили сервер, Access и Accounting.

Код:
Сервер: вер. 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



Сразу не заметил.. что-то у вас с базой странное с базой. Столбцы из первой ошибки были доаблены позже и для них есть update, а тут был столбец rangeKey вроде бы с самого начала, а не key - проверил историю.

Исправьте так:
Код:
 ALTER TABLE `inet_tariff_traffic_range_1`
CHANGE COLUMN `key` `rangeKey` BIGINT(20) NOT NULL ;


А вы inet не помните когда внедряли ? с версии 5.2 начинали ? Может нам стоит добавить это в update.


Вернуться к началу
 Профиль  
 
СообщениеДобавлено: 24 апр 2015, 13:18 
Не в сети

Зарегистрирован: 23 апр 2015, 15:07
Сообщения: 5
Карма: 0
stark писал(а):
А вы inet не помните когда внедряли ? с версии 5.2 начинали ? Может нам стоит добавить это в update.

Да, начинали еще с 5.2.

stark писал(а):
Исправьте так:
Код:
 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



Вернуться к началу
 Профиль  
 
СообщениеДобавлено: 24 апр 2015, 13:30 
Не в сети
Разработчик

Зарегистрирован: 08 ноя 2007, 01:05
Сообщения: 8343
Откуда: Уфа
Карма: 238
.id писал(а):
stark писал(а):
А вы inet не помните когда внедряли ? с версии 5.2 начинали ? Может нам стоит добавить это в update.

Да, начинали еще с 5.2.

stark писал(а):
Исправьте так:
Код:
 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
?
я думал у вас эти столбцы уже добавились давно .. Или может быть ошибки какие-то были перед обновлением? сделайте так:

1. Скачайте модуль Inet последний( сейчас он 1498 )
2.
Код:
./bg_installer.sh killhash m1

вывод команды сюда пожалуйста.
3.
Код:
 ./bg_installer.sh inet_6.0_1498.zip

И вывод команды опять сюда. Все проводить на остановленном сервере. Должно исправиться все. Если так не сделать, то еще что-то может вылезти.


Вернуться к началу
 Профиль  
 
СообщениеДобавлено: 24 апр 2015, 14:24 
Не в сети

Зарегистрирован: 23 апр 2015, 15:07
Сообщения: 5
Карма: 0
Заработало! Большое спасибо за помощь!

stark писал(а):
так я не понял, вы кэш чистили перед предыдущим обновлением ? вызывали
Код:
./bg_installer.sh killhash m1


Да. Было сообщение:
Код:
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.


Вернуться к началу
 Профиль  
 
Показать сообщения за:  Поле сортировки  
Начать новую тему Ответить на тему  [ Сообщений: 17 ] 

Часовой пояс: UTC + 5 часов [ Летнее время ]


Кто сейчас на конференции

Сейчас этот форум просматривают: нет зарегистрированных пользователей и гости: 1


Вы не можете начинать темы
Вы не можете отвечать на сообщения
Вы не можете редактировать свои сообщения
Вы не можете удалять свои сообщения
Вы не можете добавлять вложения

Найти:
Перейти:  
POWERED_BY
Русская поддержка phpBB
[ Time : 0.156s | 43 Queries | GZIP : On ]