forum.bitel.ru
http://forum.bitel.ru/

Попытался настроить на тестовом инет, падает почемуто
http://forum.bitel.ru/viewtopic.php?f=44&t=8958		 Страница 1 из 1
Автор:  skyb [ 15 фев 2014, 09:03 ]
Заголовок сообщения:  Попытался настроить на тестовом инет, падает почемуто
собственно для тестов хотел поднять заново модуль, настроить заново и тд., установил на биллинг модуль card, обновил биллинг, все приложения, настроил модуль, пытаюсь стартовать, вот что в логах

аксесс

Код:
02-15/07:07:58  INFO [main] DefaultServerSetup - Binding javax.jms.ConnectionFactory[org.apache.activemq.ActiveMQConnectionFactory@1505bd58] to java:comp/env/mq/connectionFactory
 02-15/07:07:59  INFO [main] DefaultServerSetup - Init DB connection pools
 02-15/07:07:59  INFO [main] DefaultServerSetup - Binding JDBC pool "master" to java:comp/env/jdbc/master
 02-15/07:07:59  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.server.util:type=DatabaseConnectionPool,name=master
 02-15/07:08:00  INFO [main] DefaultServerSetup - Init trash pools..
mq 02-15/07:08:00  INFO [EventProcessor-init] EventProcessor - Init EventProcessor MQ connection factory...
access 02-15/07:08:03  INFO [main] InetApplication - rootDeviceId=1
access 02-15/07:08:03  INFO [main] Setup - Load config for mid=6
access 02-15/07:08:03  INFO [main] InetOptionRuntimeMap - Loading inetOptionRuntimeMap for moduleId:6
script 02-15/07:08:04  INFO [main] ScriptEventListener - Starting ScriptEventListener...
script 02-15/07:08:04  INFO [main] ScriptEventListener - Relinking script functions.
script 02-15/07:08:04  INFO [main] ScriptEventListener - Skip event type bitel.billing.server.script.bean.event.ContractWebLoginEvent. Class not found for this application.
script 02-15/07:08:04  INFO [main] ScriptEventListener - Linked Function [id:1; title:Разблокировка по достаточному платежу]
script 02-15/07:08:05  INFO [main] ScriptEventListener - Starting DynamicScriptEventListener...
access 02-15/07:08:06  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.access:type=Access
radius 02-15/07:08:06  INFO [main] radius - Eap not enabled (keystore file not loaded).
radius 02-15/07:08:06  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.radius:type=InetRadiusProcessor
radius 02-15/07:08:06  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.radius:type=InetRadiusListener
dhcp 02-15/07:08:06  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.dhcp:type=InetDhcpProcessor
dhcp 02-15/07:08:07  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.kernel.network.dhcp:type=DhcpListener
access 02-15/07:08:07  INFO [main] Application - Starting ru.bitel.bgbilling.modules.inet.access.Access@15384ed5
access 02-15/07:08:07  INFO [main] InetDeviceRuntimeMap - (Re)loading InetDeviceRuntimeMap
access 02-15/07:08:08  INFO [main] InetDeviceMap - (Re)loading InetDeviceMap
access 02-15/07:08:08  INFO [main] InetDeviceRuntime - Reload protocolHandler class for device: Access+Accounting: ProcessGroup
access 02-15/07:08:08  INFO [main] InetDeviceRuntime - Reload SA classes for device: Access+Accounting: ProcessGroup
access 02-15/07:08:08  INFO [main] InetDeviceRuntime - Reload protocolHandler class for device: Cisco : Board.r1 [10.1.16.1]
access 02-15/07:08:08  INFO [main] InetDeviceRuntime - Reload SA classes for device: Cisco : Board.r1 [10.1.16.1]
access 02-15/07:08:11  INFO [main] Access - childrenDeviceIds=[1, 2]
access 02-15/07:08:11  INFO [main] InetConnectionManager - Loading connections from database.
dhcp 02-15/07:08:11  INFO [Thread-12] Application - Stopping ru.bitel.bgbilling.kernel.network.dhcp.DhcpListener@396ab2e8
dhcp 02-15/07:08:11  INFO [Thread-12] Application - Stopping ru.bitel.bgbilling.modules.inet.dhcp.InetDhcpProcessor@28f549de
radius 02-15/07:08:11  INFO [Thread-12] Application - Stopping ru.bitel.bgbilling.modules.inet.radius.InetRadiusListener@5454570a [queue_size: 0; threads_active: 0; largest: 0; core: 10; pool_size: 0; recv_socket_buf_size: 106 496; recv_buf_size: 524 288]
radius 02-15/07:08:11  INFO [Thread-12] Application - Stopping ru.bitel.bgbilling.modules.inet.radius.InetRadiusProcessor@7c82a13a
access 02-15/07:08:11  INFO [Thread-12] Application - Stopping ru.bitel.bgbilling.modules.inet.access.Access@15384ed5
 02-15/07:08:11  INFO [Thread-12] EventProcessor - Shutdown EventProcessor...


аккаунтинг

Код:
 02-15/07:10:00  INFO [main] DefaultServerSetup - Binding javax.jms.ConnectionFactory[org.apache.activemq.ActiveMQConnectionFactory@671381e7] to java:comp/env/mq/connectionFactory
 02-15/07:10:00  INFO [main] DefaultServerSetup - Init DB connection pools
 02-15/07:10:01  INFO [main] DefaultServerSetup - Binding JDBC pool "master" to java:comp/env/jdbc/master
 02-15/07:10:01  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.server.util:type=DatabaseConnectionPool,name=master
 02-15/07:10:02  INFO [main] DefaultServerSetup - Init trash pools..
mq 02-15/07:10:02  INFO [EventProcessor-init] EventProcessor - Init EventProcessor MQ connection factory...
accounting 02-15/07:10:05  INFO [main] InetApplication - rootDeviceId=1
accounting 02-15/07:10:05  INFO [main] Setup - Load config for mid=6
accounting 02-15/07:10:05  INFO [main] InetOptionRuntimeMap - Loading inetOptionRuntimeMap for moduleId:6
script 02-15/07:10:05  INFO [main] ScriptEventListener - Starting ScriptEventListener...
script 02-15/07:10:05  INFO [main] ScriptEventListener - Relinking script functions.
script 02-15/07:10:05  INFO [main] ScriptEventListener - Skip event type bitel.billing.server.script.bean.event.ContractWebLoginEvent. Class not found for this application.
script 02-15/07:10:06  INFO [main] ScriptEventListener - Linked Function [id:1; title:Разблокировка по достаточному платежу]
script 02-15/07:10:06  INFO [main] ScriptEventListener - Starting DynamicScriptEventListener...
accounting 02-15/07:10:07  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting:type=Accounting
radius 02-15/07:10:07  INFO [main] radius - Eap not enabled (keystore file not loaded).
radius 02-15/07:10:07  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.radius:type=InetRadiusProcessor
radius 02-15/07:10:07  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.radius:type=InetRadiusListener
collector 02-15/07:10:07  INFO [main] InetFlowListener - Create new FlowListener netflow on port 2001 [recv_buf_size=4194304]
collector 02-15/07:10:07  INFO [main] FlowAgentInterfaceSelector - Loaded sources: []
collector 02-15/07:10:07  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.collector:type=InetNetflowListener
detail 02-15/07:10:07  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.detail:type=InetDetailWorker
accounting 02-15/07:10:07  INFO [main] Application - Starting Accounting@1958151752
accounting 02-15/07:10:07 ERROR [main] Accounting - Table 'bgbilling.inet_connection_6' doesn't exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bgbilling.inet_connection_6' doesn't exist
        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:2618)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
        at ru.bitel.bgbilling.modules.inet.accounting.Accounting.fixSequence(Accounting.java:317)
        at ru.bitel.bgbilling.modules.inet.accounting.Accounting.start(Accounting.java:275)
        at ru.bitel.bgbilling.kernel.application.server.Application.application(Application.java:246)
        at ru.bitel.bgbilling.kernel.application.server.Application.<init>(Application.java:161)
        at ru.bitel.bgbilling.kernel.application.server.Application.main(Application.java:803)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at ru.bitel.common.bootstrap.Boot.boot(Boot.java:129)
        at ru.bitel.common.bootstrap.Boot.main(Boot.java:178)
accounting 02-15/07:10:07  INFO [main] InetDeviceRuntimeMap - (Re)loading InetDeviceRuntimeMap
accounting 02-15/07:10:08  INFO [main] InetDeviceMap - (Re)loading InetDeviceMap
accounting 02-15/07:10:08  INFO [main] InetDeviceRuntime - Reload protocolHandler class for device: Access+Accounting: ProcessGroup
accounting 02-15/07:10:08  INFO [main] InetDeviceRuntime - Reload protocolHandler class for device: Cisco : Board.r1 [10.1.16.1]
accounting 02-15/07:10:08  INFO [main] InetServRuntimeMap - Loading inetServs from database.
accounting 02-15/07:10:09  INFO [inetServ-load-p-12-t-1] InetServRuntimeMap - Loaded 0 inetServs.
accounting 02-15/07:10:09 ERROR [inetServ-load-p-12-t-2] InetServRuntimeMap - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bgbilling.inv_product_period' doesn't exist
ru.bitel.bgbilling.common.BGException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bgbilling.inv_product_period' doesn't exist
        at ru.bitel.oss.systems.inventory.product.server.bean.ProductPeriodDao.list(ProductPeriodDao.java:228)
        at ru.bitel.bgbilling.kernel.contract.runtime.ContractRuntime.load(ContractRuntime.java:471)
        at ru.bitel.bgbilling.kernel.contract.runtime.ContractRuntimeMap.newRuntime(ContractRuntimeMap.java:237)
        at ru.bitel.bgbilling.kernel.contract.runtime.ContractRuntimeMap.getContractRuntime(ContractRuntimeMap.java:175)
        at ru.bitel.bgbilling.modules.inet.runtime.InetServRuntimeMap.newRuntime(InetServRuntimeMap.java:395)
        at ru.bitel.bgbilling.modules.inet.runtime.InetServRuntimeMap.load(InetServRuntimeMap.java:345)
        at ru.bitel.bgbilling.modules.inet.runtime.InetServRuntimeMap.access$0(InetServRuntimeMap.java:321)
        at ru.bitel.bgbilling.modules.inet.runtime.InetServRuntimeMap$2.runImpl(InetServRuntimeMap.java:290)
        at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86)
        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)
        at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'bgbilling.inv_product_period' doesn't exist
        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.executeQuery(PreparedStatement.java:2293)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at ru.bitel.oss.systems.inventory.product.server.bean.ProductPeriodDao.list(ProductPeriodDao.java:217)
        ... 12 more
accounting 02-15/07:10:09  INFO [inetServ-load-p-12-t-2] InetServRuntimeMap - Loaded 0 inetServs.
accounting 02-15/07:10:09  INFO [main] InetServRuntimeMap - Load inetServs from database complete. Loaded 0 inetServs.
accounting 02-15/07:10:09  INFO [main] FlowAgentInterfaceMap - Reload FlowAgentInterfaceMap
accounting 02-15/07:10:09  INFO [main] FlowAgentInterfaceSelector - Loaded sources: [/10.1.16.1]
accounting 02-15/07:10:09  INFO [main] AccountingWorkerSet - Create worker 3
accounting 02-15/07:10:09  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=AccountingWorker,name=3
accounting 02-15/07:10:09  INFO [main] SessionFinishWorker - Add finishing worker: delay=10000, batchSize=1000
accounting 02-15/07:10:09  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=SessionFinishWorker,worker=3,workerTask=1,name=call
accounting 02-15/07:10:09  INFO [main] SessionFinishWorker - Add finishing worker: delay=10000, batchSize=1000
accounting 02-15/07:10:09  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=SessionFinishWorker,worker=3,workerTask=1,name=auto
accounting 02-15/07:10:09  INFO [main] AccountingWorkerSet - Create worker 2
accounting 02-15/07:10:09  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=AccountingWorker,name=2
accounting 02-15/07:10:09  INFO [main] SessionFlushingWorker - Add flushing worker: minDeltaAmount=-9223372036854775808, minDeltaAccount=-9223372036854775808, delay=20000, batchSize=500
accounting 02-15/07:10:09  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=SessionFlushingWorker,worker=2,workerTask=1,name=call
accounting 02-15/07:10:09  INFO [main] SessionFlushingWorker - Add flushing worker: minDeltaAmount=-9223372036854775808, minDeltaAccount=-9223372036854775808, delay=20000, batchSize=500
accounting 02-15/07:10:09  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=SessionFlushingWorker,worker=2,workerTask=1,name=auto
accounting 02-15/07:10:09  INFO [main] AccountingWorkerSet - Create worker 1
accounting 02-15/07:10:09  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=AccountingWorker,name=1
accounting 02-15/07:10:09  INFO [main] SessionTarifficationWorker - Add tariffication worker: minDeltaAmount=0, delay=10000, batchSize=500
accounting 02-15/07:10:09  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=SessionTarifficationWorker,worker=1,workerTask=1,name=call
accounting 02-15/07:10:09  INFO [main] SessionTarifficationWorker - Add tariffication worker: minDeltaAmount=0, delay=10000, batchSize=500
accounting 02-15/07:10:09  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=SessionTarifficationWorker,worker=1,workerTask=1,name=auto
accounting 02-15/07:10:09  INFO [main] SessionTrackingWorker - Add tracking worker: delay=10000, batchSize=500
accounting 02-15/07:10:09  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=SessionTrackingWorker,worker=1,workerTask=1,name=call
accounting 02-15/07:10:09  INFO [main] SessionTrackingWorker - Add tracking worker: delay=10000, batchSize=500
accounting 02-15/07:10:09  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=SessionTrackingWorker,worker=1,workerTask=1,name=auto
detail 02-15/07:10:09  INFO [Thread-12] Application - Stopping ru.bitel.bgbilling.modules.inet.accounting.detail.InetDetailWorker@1441c977
 02-15/07:10:09 ERROR [Thread-12] Application -
java.lang.NullPointerException
        at ru.bitel.bgbilling.kernel.event.EventWorker.shutdown(EventWorker.java:274)
        at ru.bitel.bgbilling.modules.inet.accounting.detail.InetDetailWorker.stop(InetDetailWorker.java:111)
        at ru.bitel.bgbilling.kernel.application.server.Application$3.run(Application.java:194)
        at ru.bitel.common.bootstrap.Shutdown$2.run(Shutdown.java:25)
 02-15/07:10:09  INFO [Thread-12] EventProcessor - Shutdown EventProcessor...

классы все перекомпилял, что не доделал?
Автор:  skyb [ 15 фев 2014, 10:45 ]
Заголовок сообщения:  Re: Попытался настроить на тестовом инет, падает почемуто
аксесс запустил, а вот аккаунтинг

Код:
detail 02-15/09:00:45  INFO [Thread-12] Application - Stopping ru.bitel.bgbilling.modules.inet.accounting.detail.InetDetailWorker@2f984f7d
 02-15/09:00:45 ERROR [Thread-12] Application -
java.lang.NullPointerException
        at ru.bitel.bgbilling.kernel.event.EventWorker.shutdown(EventWorker.java:274)
        at ru.bitel.bgbilling.modules.inet.accounting.detail.InetDetailWorker.stop(InetDetailWorker.java:111)
        at ru.bitel.bgbilling.kernel.application.server.Application$3.run(Application.java:194)
        at ru.bitel.common.bootstrap.Shutdown$2.run(Shutdown.java:25)
radius 02-15/09:00:45 DEBUG [Thread-13] HourlyDataLogger - Flush data...
collector 02-15/09:00:45 DEBUG [Thread-14] HourlyDataLogger - Flush data...
collector 02-15/09:00:45  INFO [Thread-14] EventProcessor - Shutdown EventProcessor...
Автор:  skyb [ 15 фев 2014, 10:59 ]
Заголовок сообщения:  Re: Попытался настроить на тестовом инет, падает почемуто
Вырубил слушатель флоу, всеравно не запускается, вот чего пишет

Код:
accounting 02-15/09:09:04  INFO [inetServ-load-p-10-t-2] InetServRuntimeMap - Loaded 95 inetServs.
accounting 02-15/09:09:04  INFO [main] InetServRuntimeMap - Load inetServs from database complete. Loaded 95 inetServs.
accounting 02-15/09:09:04  INFO [main] FlowAgentInterfaceMap - Reload FlowAgentInterfaceMap
accounting 02-15/09:09:04 DEBUG [main] FlowAgentInterfaceMap - FlowAgent id=1, Access+Accounting: ProcessGroup, ifaces=[-1]
accounting 02-15/09:09:04 DEBUG [main] FlowAgentInterfaceMap - FlowAgent id=2, Cisco : Board [10.1.16.1], ifaces=[-1]
accounting 02-15/09:09:05 DEBUG [main] EventProcessor - Add Accounting@1319007734 to BG.Event.ru.bitel.bgbilling.modules.inet.accounting.event.InetAccountingManageEvent WHERE moduleId=6 AND (accountingRootDeviceId=1)
accounting 02-15/09:09:05 DEBUG [main] EventProcessor - Add Accounting@1319007734 to BG.Event.ru.bitel.bgbilling.modules.inet.accounting.event.InetConnectionCommandEvent WHERE moduleId=6 AND ((deviceId=1 OR deviceId=2))
accounting 02-15/09:09:05  INFO [main] AccountingWorkerSet - Create worker 3
accounting 02-15/09:09:05  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=AccountingWorker,name=3
accounting 02-15/09:09:05  INFO [main] SessionFinishWorker - Add finishing worker: delay=10000, batchSize=1000
accounting 02-15/09:09:05  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=SessionFinishWorker,worker=3,workerTask=1,name=call
accounting 02-15/09:09:05  INFO [main] SessionFinishWorker - Add finishing worker: delay=10000, batchSize=1000
accounting 02-15/09:09:05  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=SessionFinishWorker,worker=3,workerTask=1,name=auto
accounting 02-15/09:09:05  INFO [main] AccountingWorkerSet - Create worker 2
accounting 02-15/09:09:05  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=AccountingWorker,name=2
accounting 02-15/09:09:05  INFO [main] SessionFlushingWorker - Add flushing worker: minDeltaAmount=-9223372036854775808, minDeltaAccount=-9223372036854775808, delay=20000, batchSize=500
accounting 02-15/09:09:05  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=SessionFlushingWorker,worker=2,workerTask=1,name=call
accounting 02-15/09:09:05  INFO [main] SessionFlushingWorker - Add flushing worker: minDeltaAmount=-9223372036854775808, minDeltaAccount=-9223372036854775808, delay=20000, batchSize=500
accounting 02-15/09:09:05  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=SessionFlushingWorker,worker=2,workerTask=1,name=auto
accounting 02-15/09:09:05  INFO [main] AccountingWorkerSet - Create worker 1
accounting 02-15/09:09:05  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=AccountingWorker,name=1
accounting 02-15/09:09:05  INFO [main] SessionTarifficationWorker - Add tariffication worker: minDeltaAmount=0, delay=10000, batchSize=500
accounting 02-15/09:09:05  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=SessionTarifficationWorker,worker=1,workerTask=1,name=call
accounting 02-15/09:09:05  INFO [main] SessionTarifficationWorker - Add tariffication worker: minDeltaAmount=0, delay=10000, batchSize=500
accounting 02-15/09:09:05  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=SessionTarifficationWorker,worker=1,workerTask=1,name=auto
accounting 02-15/09:09:05  INFO [main] SessionTrackingWorker - Add tracking worker: delay=10000, batchSize=500
accounting 02-15/09:09:05  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=SessionTrackingWorker,worker=1,workerTask=1,name=call
accounting 02-15/09:09:05  INFO [main] SessionTrackingWorker - Add tracking worker: delay=10000, batchSize=500
accounting 02-15/09:09:05  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.modules.inet.accounting.worker:type=SessionTrackingWorker,worker=1,workerTask=1,name=auto
accounting 02-15/09:09:05 DEBUG [main] AbstractEventWorker - Linking...
accounting 02-15/09:09:05 DEBUG [main] EventProcessor - Add InetDeviceStateAndOptionsDatabaseWorker@687736006 to BG.Event.ru.bitel.bgbilling.modules.inet.access.event.InetServDeviceStateAndOptionsModifyEvent WHERE moduleId=6
accounting 02-15/09:09:05 DEBUG [main] EventProcessor - Add InetDeviceStateAndOptionsDatabaseWorker@687736006 to BG.Event.ru.bitel.bgbilling.modules.inet.access.event.InetConnectionDeviceStateAndOptionsModifyEvent WHERE moduleId=6
accounting 02-15/09:09:05 DEBUG [main] AbstractEventWorker - Linked
accounting 02-15/09:09:05 DEBUG [main] EventProcessor - Add ru.bitel.bgbilling.modules.inet.accounting.proccess.RequestLogInfoEventProcessor@513b8f62 to BG.Event.ru.bitel.bgbilling.modules.inet.api.server.event.RequestLogInfoEvent WHERE moduleId=6 AND ((deviceId=1 OR deviceId=2))
accounting 02-15/09:09:05 DEBUG [main] EventProcessor - Add ru.bitel.bgbilling.modules.inet.accounting.recalculate.InetRecalculateEventProcessor@447cc9c9 to BG.Event.ru.bitel.bgbilling.modules.inet.accounting.recalculate.event.InetRecalculateBaseEvent WHERE moduleId=6 AND (applicationId=2)
accounting 02-15/09:09:05 DEBUG [main] EventProcessor - Add ru.bitel.bgbilling.modules.inet.accounting.recalculate.InetRecalculateEventProcessor@447cc9c9 to BG.Event.ru.bitel.bgbilling.modules.inet.accounting.recalculate.event.FindFirstAccountingEvent WHERE moduleId=6
accounting 02-15/09:09:05 DEBUG [main] EventProcessor - Add ru.bitel.bgbilling.modules.inet.accounting.recalculate.InetRecalculateEventProcessor@447cc9c9 to BG.Event.ru.bitel.bgbilling.modules.inet.accounting.recalculate.event.InetCanCalculateEvent WHERE moduleId=6 AND (applicationId=2)
accounting 02-15/09:09:05 DEBUG [main] EventProcessor - Add ru.bitel.bgbilling.modules.inet.accounting.recalculate.InetRecalculateEventProcessor@447cc9c9 to BG.Event.ru.bitel.bgbilling.modules.inet.accounting.recalculate.event.InetRecalculateCurrentDayEvent WHERE moduleId=6 AND (applicationId=2)
accounting 02-15/09:09:05 DEBUG [main] EventProcessor - Add ru.bitel.bgbilling.modules.inet.accounting.recalculate.InetRecalculateEventProcessor@447cc9c9 to BG.Event.ru.bitel.bgbilling.modules.inet.accounting.recalculate.event.TarrificationContinueEvent WHERE moduleId=6
accounting 02-15/09:09:05 DEBUG [main] EventProcessor - Add ru.bitel.bgbilling.modules.inet.accounting.recalculate.InetRecalculateEventProcessor@447cc9c9 to BG.Event.ru.bitel.bgbilling.modules.inet.accounting.recalculate.event.TarrificationSuspendEvent WHERE moduleId=6 AND (applicationId=2)
accounting 02-15/09:09:05 DEBUG [main] EventProcessor - Add ru.bitel.bgbilling.modules.inet.accounting.recalculate.InetRecalculateEventProcessor@447cc9c9 to BG.Event.ru.bitel.bgbilling.modules.inet.accounting.recalculate.event.InetRecalculateCurrentMonthBeforeDayEvent WHERE moduleId=6 AND (applicationId=2)
accounting 02-15/09:09:05 DEBUG [main] EventProcessor - Add ru.bitel.bgbilling.modules.inet.accounting.recalculate.InetRecalculateEventProcessor@447cc9c9 to BG.Event.ru.bitel.bgbilling.modules.inet.accounting.recalculate.event.InetRecalculateDayInCurrentMonthEvent WHERE moduleId=6 AND (applicationId=2)
accounting 02-15/09:09:05 DEBUG [main] EventProcessor - Add ru.bitel.bgbilling.modules.inet.accounting.proccess.InetProcessingProcessor@5b8b0b4a to BG.Event.ru.bitel.bgbilling.modules.inet.accounting.proccess.event.ProcessingSuspendEvent WHERE moduleId=6
accounting 02-15/09:09:05 DEBUG [main] EventProcessor - Add ru.bitel.bgbilling.modules.inet.accounting.proccess.InetProcessingProcessor@5b8b0b4a to BG.Event.ru.bitel.bgbilling.modules.inet.accounting.proccess.event.ProcessingContinueEvent WHERE moduleId=6
radius 02-15/09:09:05 DEBUG [Thread-13] HourlyDataLogger - Flush data...
radius 02-15/09:09:05  INFO [Thread-12] Application - Stopping ru.bitel.bgbilling.modules.inet.radius.InetRadiusListener@40d1e07c [queue_size: 0; threads_active: 0; largest: 0; core: 10; pool_size: 0; recv_socket_buf_size: 106 496; recv_buf_size: 1 048 576]
radius 02-15/09:09:05  INFO [Thread-12] Application - Stopping ru.bitel.bgbilling.modules.inet.radius.InetRadiusProcessor@6701fa9e
accounting 02-15/09:09:05  INFO [Thread-12] Application - Stopping Accounting@1319007734
accounting 02-15/09:09:05 DEBUG [Thread-12] Accounting - Saving state...
 02-15/09:09:05  INFO [Thread-12] EventProcessor - Shutdown EventProcessor...
Автор:  skyb [ 15 фев 2014, 11:32 ]
Заголовок сообщения:  Re: Попытался настроить на тестовом инет, падает почемуто
изза памяти же возможно? там всего 2 гига оперы
Автор:  Amir [ 15 фев 2014, 18:22 ]
Заголовок сообщения:  Re: Попытался настроить на тестовом инет, падает почемуто
А таблицы inv_product_period так и нет в БД?
Может в .out файлах что есть?
Автор:  skyb [ 16 фев 2014, 08:47 ]
Заголовок сообщения:  Re: Попытался настроить на тестовом инет, падает почемуто
Код:
java.sql.SQLException: The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        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:2618)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1749)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1666)
        at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
        at ru.bitel.bgbilling.modules.inet.api.server.bean.InetSessionLogDao.createTables(InetSessionLogDao.java:288)
        at ru.bitel.bgbilling.modules.inet.api.server.bean.InetSessionLogDao.checkTables(InetSessionLogDao.java:235)
        at ru.bitel.bgbilling.modules.inet.accounting.Accounting.startImpl(Accounting.java:420)
        at ru.bitel.bgbilling.modules.inet.accounting.Accounting.start(Accounting.java:282)
        at ru.bitel.bgbilling.kernel.application.server.Application.application(Application.java:246)
        at ru.bitel.bgbilling.kernel.application.server.Application.<init>(Application.java:161)
        at ru.bitel.bgbilling.kernel.application.server.Application.main(Application.java:803)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)                                                                                                                                                                                 
        at ru.bitel.common.bootstrap.Boot.boot(Boot.java:129)                                                                                                                                                                               
        at ru.bitel.common.bootstrap.Boot.main(Boot.java:178)

Я так понял нада мускул другой?
Автор:  barguzin2 [ 16 фев 2014, 10:20 ]
Заголовок сообщения:  Re: Попытался настроить на тестовом инет, падает почемуто
Похоже на то, ругается что партиции не поддерживаются. Попробуй создать файл inv_product_period.sql со следующим содержимым
Код:
CREATE TABLE `inv_product_period` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `contractId` int(11) NOT NULL,
  `accountId` int(11) NOT NULL,
  `productSpecId` int(11) NOT NULL,
  `productId` int(11) NOT NULL,
  `timeFrom` datetime NOT NULL,
  `timeTo` datetime DEFAULT NULL,
  KEY `id` (`id`),
  KEY `contract` (`contractId`),
  KEY `account` (`accountId`),
  KEY `product` (`productId`),
  KEY `period` (`timeFrom`,`timeTo`)
)
/*!50100 PARTITION BY HASH (contractId)
PARTITIONS 8 */;


применить напрямую: mysql -ubill -p bgbilling < inv_product_period.sql
Скорее всего получишь ту же ошибку. А мускул сам собирал или из коробки ? Какая версия ?
Автор:  skyb [ 16 фев 2014, 13:00 ]
Заголовок сообщения:  Re: Попытался настроить на тестовом инет, падает почемуто
barguzin2 писал(а):
Похоже на то, ругается что партиции не поддерживаются. Попробуй создать файл inv_product_period.sql со следующим содержимым
Код:
CREATE TABLE `inv_product_period` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `contractId` int(11) NOT NULL,
  `accountId` int(11) NOT NULL,
  `productSpecId` int(11) NOT NULL,
  `productId` int(11) NOT NULL,
  `timeFrom` datetime NOT NULL,
  `timeTo` datetime DEFAULT NULL,
  KEY `id` (`id`),
  KEY `contract` (`contractId`),
  KEY `account` (`accountId`),
  KEY `product` (`productId`),
  KEY `period` (`timeFrom`,`timeTo`)
)
/*!50100 PARTITION BY HASH (contractId)
PARTITIONS 8 */;


применить напрямую: mysql -ubill -p bgbilling < inv_product_period.sql
Скорее всего получишь ту же ошибку. А мускул сам собирал или из коробки ? Какая версия ?

Код:
ERROR 1289 (HY000) at line 1: The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working

железка досталась мне и там гента, да паходу проще другой мускуль поставить, чем с этим разбираться
Страница 1 из 1 Часовой пояс: UTC + 5 часов [ Летнее время ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/