forum.bitel.ru http://forum.bitel.ru/ |
|
Неполадки при обновлении http://forum.bitel.ru/viewtopic.php?f=22&t=6918 |
Страница 2 из 2 |
Автор: | stark [ 06 июл 2012, 12:44 ] |
Заголовок сообщения: | Re: Неполадки при обновлении |
SVK писал(а): Не показывает версию и билд (последний update версии 5.2) Код: [root@stat BGIPNNetflowCollector]# ./netflow_status.sh Traffic collector [b]for IPN v build from[/b] Started: 06.07.2012 08:18:40 Uptime: 0 d 00:00:35 Memory total: 94 044 160; max: 1 431 699 456; free: 38 779 432 Memory pools: Non-heap memory[Code Cache]: max: 50 331 648; used: 770 560; peek: 781 312 Heap memory[PS Eden Space]: max: 528 744 448; used: 21 876 424; peek: 24 576 000 Heap memory[PS Survivor Space]: max: 4 063 232; used: 4 027 952; peek: 4 027 952 Heap memory[PS Old Gen]: max: 1 073 741 824; used: 29 360 352; peek: 29 360 352 Non-heap memory[PS Perm Gen]: max: 85 983 232; used: 19 392 232; peek: 19 392 232 Thread count: 32 FlowListener: queue_size: 0; threads_active: 0; largest: 10; core: 10; pool_size: 10; ru.bitel.bgbilling.modules.ipn.collector.IPNFlowListener$3@27e91a4d [recv_socket_buf_size: 131 071; recv_buf_size: 2 097 152]; packets: 859 Flow loader: [files: 1] Hour logs processed: 0 Connections pool to Master status Idle: 1; Active: 1; maxActive: 300; maxIdle: 100 исправили. В следующем обновлении будет . |
Автор: | SVK [ 10 июл 2012, 12:49 ] |
Заголовок сообщения: | Re: Неполадки при обновлении |
SVK писал(а): Цитата: Посмотрите на загрузку mysqld . Включите лог длинных запросов. Загрузка ЦП на сервере SQL не выше 6%, load average = 0,2 - 0,6. лог длинных запросов включу позже. проблематично на ходу все останавливать. Значит так: на mysql включил лог длинных/медленных запросов Код: [mysqld] long_query_time=1 slow_query_log = /var/log/mysql-slow-queries.log ошибка BGRadiusDialup Код: radius 07-10/12:31:42 ERROR [rdsLstnr-p-9-t-17] DefaultServerSetup - Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. 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.SQLError.createCommunicationsException(SQLError.java:1116) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.GeneratedConstructorAccessor33.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.ConnectionImpl.getInstance(ConnectionImpl.java:381) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:538) at ru.bitel.common.sql.SetupConnectionSet.newMasterConnection(SetupConnectionSet.java:39) at ru.bitel.common.sql.ConnectionSet.getConnection(ConnectionSet.java:81) at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.preprocessAccountingRequest(RadiusProcessor.java:292) at ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor.preprocessAccountingRequest(DialUpRadiusProcessor.java:476) at ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor.preprocessAccountingRequest(DialUpRadiusProcessor.java:1) at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.accountingRequest(RadiusProcessor.java:442) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.accountingRequest(RadiusListenerWorker.java:383) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.processPacket(RadiusListenerWorker.java:251) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.runImpl(RadiusListenerWorker.java:135) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) Caused by: java.net.SocketTimeoutException: connect timed out at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:529) at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:330) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294) ... 32 more radius 07-10/12:31:42 ERROR [rdsLstnr-p-9-t-17] RadiusListenerWorker - java.lang.NullPointerException at ru.bitel.common.sql.SetupConnectionSet.newMasterConnection(SetupConnectionSet.java:42) at ru.bitel.common.sql.ConnectionSet.getConnection(ConnectionSet.java:81) at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.preprocessAccountingRequest(RadiusProcessor.java:292) at ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor.preprocessAccountingRequest(DialUpRadiusProcessor.java:476) at ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor.preprocessAccountingRequest(DialUpRadiusProcessor.java:1) at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.accountingRequest(RadiusProcessor.java:442) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.accountingRequest(RadiusListenerWorker.java:383) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.processPacket(RadiusListenerWorker.java:251) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.runImpl(RadiusListenerWorker.java:135) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) radius 07-10/12:31:42 ERROR [rdsLstnr-p-9-t-17] RadiusListenerWorker - java.lang.NullPointerException at ru.bitel.common.sql.SetupConnectionSet.newMasterConnection(SetupConnectionSet.java:42) at ru.bitel.common.sql.ConnectionSet.getConnection(ConnectionSet.java:81) at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.preprocessAccountingRequest(RadiusProcessor.java:292) at ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor.preprocessAccountingRequest(DialUpRadiusProcessor.java:476) at ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor.preprocessAccountingRequest(DialUpRadiusProcessor.java:1) at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.accountingRequest(RadiusProcessor.java:442) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.accountingRequest(RadiusListenerWorker.java:383) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.processPacket(RadiusListenerWorker.java:251) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.runImpl(RadiusListenerWorker.java:135) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) radius 07-10/12:31:42 ERROR [rdsLstnr-p-9-t-17] RadiusListenerWorker - java.lang.NullPointerException at ru.bitel.common.sql.SetupConnectionSet.newMasterConnection(SetupConnectionSet.java:42) at ru.bitel.common.sql.ConnectionSet.getConnection(ConnectionSet.java:81) at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.preprocessAccountingRequest(RadiusProcessor.java:292) at ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor.preprocessAccountingRequest(DialUpRadiusProcessor.java:476) at ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor.preprocessAccountingRequest(DialUpRadiusProcessor.java:1) at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.accountingRequest(RadiusProcessor.java:442) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.accountingRequest(RadiusListenerWorker.java:383) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.processPacket(RadiusListenerWorker.java:251) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.runImpl(RadiusListenerWorker.java:135) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) radius 07-10/12:31:42 ERROR [rdsLstnr-p-9-t-17] RadiusListenerWorker - java.lang.NullPointerException at ru.bitel.common.sql.SetupConnectionSet.newMasterConnection(SetupConnectionSet.java:42) at ru.bitel.common.sql.ConnectionSet.getConnection(ConnectionSet.java:81) at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.preprocessAccountingRequest(RadiusProcessor.java:292) at ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor.preprocessAccountingRequest(DialUpRadiusProcessor.java:476) at ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor.preprocessAccountingRequest(DialUpRadiusProcessor.java:1) at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.accountingRequest(RadiusProcessor.java:442) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.accountingRequest(RadiusListenerWorker.java:383) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.processPacket(RadiusListenerWorker.java:251) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.runImpl(RadiusListenerWorker.java:135) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) radius 07-10/12:31:42 ERROR [rdsLstnr-p-9-t-17] RadiusListenerWorker - java.lang.NullPointerException at ru.bitel.common.sql.SetupConnectionSet.newMasterConnection(SetupConnectionSet.java:42) at ru.bitel.common.sql.ConnectionSet.getConnection(ConnectionSet.java:81) at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.preprocessAccountingRequest(RadiusProcessor.java:292) at ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor.preprocessAccountingRequest(DialUpRadiusProcessor.java:476) at ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor.preprocessAccountingRequest(DialUpRadiusProcessor.java:1) at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.accountingRequest(RadiusProcessor.java:442) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.accountingRequest(RadiusListenerWorker.java:383) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.processPacket(RadiusListenerWorker.java:251) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.runImpl(RadiusListenerWorker.java:135) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) выходит точно при обновлении клиента с сервера, и, возможно, при первом заходе клиента. файл /var/log/mysql-slow-queries.log при этом пустой. Ни BGIPNetflowCollector ни BGBillingServer при этом не ругаются на потерю коннекта с базой. Как и писал до этого, в эти моменты загрузка CPU на mysql 3-4%, load average 0,3 - 0,6, от сервера до mysql трафик около 3-4M/с Какие-нибудь еще советы будут? |
Автор: | SVK [ 11 июл 2012, 16:33 ] |
Заголовок сообщения: | Re: Неполадки при обновлении |
о, после сегодняшнего обновления BGRadiusDialup стал выдавать: Код: processor 07-11/16:28:40 ERROR [pool-2-thread-4] DefaultServerSetup - Many statements was open at connection close: com.mysql.jdbc.JDBC4PreparedStatement@2bbd9de3: SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tariff.tpid=tariff_plan.id WHERE cid=10109 AND ((emid=0 AND eid=0) OR (emid=0 AND eid=0)) AND ( isNull(date2) OR date2='0000-00-00' OR date2>='2012-07-01' ) UNION SELECT tree_id, date1, date2, emid, eid, 0, pos FROM contract_tree_link WHERE cid=10109 AND ((emid=0 AND eid=0) OR (emid=0 AND eid=0)) AND (date2 IS NULL OR date2>='2012-07-01') ORDER BY 4 DESC, 5 DESC, 6 ASC, 7 ASC com.mysql.jdbc.JDBC4PreparedStatement@7c187c8: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=10768 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1 com.mysql.jdbc.PreparedStatement@677210a5: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=8259 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1 com.mysql.jdbc.PreparedStatement@64b2e752: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=8946 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1 com.mysql.jdbc.PreparedStatement@2c006765: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=8582 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1 com.mysql.jdbc.PreparedStatement@69e94001: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=13018 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1 com.mysql.jdbc.PreparedStatement@51f1e39b: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=13584 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1 ... skipped ... com.mysql.jdbc.PreparedStatement@2db1d931: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=13347 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1 java.lang.RuntimeException at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:480) at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:47) at ru.bitel.bgbilling.server.util.ServerUtils.closeConnection(ServerUtils.java:566) at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas.restoreConnectionsImpl(DialUpNas.java:968) at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas.access$7(DialUpNas.java:738) at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas$2.call(DialUpNas.java:732) at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas$2.call(DialUpNas.java:1) 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:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Ну и потом, при обновлении клиента, опять Код: radius 07-11/16:35:37 ERROR [rdsLstnr-p-9-t-13] DefaultServerSetup - Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. 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.SQLError.createCommunicationsException(SQLError.java:1116) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.GeneratedConstructorAccessor39.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.ConnectionImpl.getInstance(ConnectionImpl.java:381) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) at ru.bitel.bgbilling.server.util.DefaultServerSetup$2.makeObject(DefaultServerSetup.java:439) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188) at ru.bitel.bgbilling.server.util.DefaultServerSetup$ConnectionPool$1.getConnection(DefaultServerSetup.java:180) at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:633) at ru.bitel.common.sql.SetupConnectionSet.newMasterConnection(SetupConnectionSet.java:39) at ru.bitel.common.sql.ConnectionSet.getConnection(ConnectionSet.java:81) at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.preprocessAccountingRequest(RadiusProcessor.java:292) at ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor.preprocessAccountingRequest(DialUpRadiusProcessor.java:476) at ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor.preprocessAccountingRequest(DialUpRadiusProcessor.java:1) at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.accountingRequest(RadiusProcessor.java:442) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.accountingRequest(RadiusListenerWorker.java:383) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.processPacket(RadiusListenerWorker.java:251) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.runImpl(RadiusListenerWorker.java:135) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) Caused by: java.net.SocketTimeoutException: connect timed out at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:529) at sun.reflect.GeneratedMethodAccessor46.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:330) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294) ... 32 more |
Автор: | SVK [ 11 июл 2012, 16:51 ] |
Заголовок сообщения: | Re: Неполадки при обновлении |
еще новых ошибок BGRadiusDialUP Код: radius 07-11/16:37:38 ERROR [rdsLstnr-p-9-t-8] RadiusListenerWorker -
java.lang.NullPointerException radius 07-11/16:37:38 ERROR [rdsLstnr-p-8-t-4] ServerUtils - java.lang.NullPointerException at ru.bitel.bgbilling.server.util.ServerUtils.closeConnection(ServerUtils.java:564) at ru.bitel.bgbilling.server.util.ServerUtils.closeConnection(ServerUtils.java:548) at ru.bitel.bgbilling.kernel.network.radius.RadiusUtils.addToLog(RadiusUtils.java:671) at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.addToLog(RadiusProcessor.java:302) at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.accessRequest(RadiusProcessor.java:368) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.accessRequest(RadiusListenerWorker.java:333) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.processPacket(RadiusListenerWorker.java:213) at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.runImpl(RadiusListenerWorker.java:135) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) radius 07-11/16:37:38 ERROR [rdsLstnr-p-9-t-4] RadiusListenerWorker - java.lang.NullPointerException radius 07-11/16:37:38 ERROR [rdsLstnr-p-9-t-12] RadiusListenerWorker - java.lang.NullPointerException radius 07-11/16:37:38 ERROR [rdsLstnr-p-9-t-15] RadiusListenerWorker - java.lang.NullPointerException radius 07-11/16:37:38 ERROR [rdsLstnr-p-9-t-7] RadiusListenerWorker - java.lang.NullPointerException radius 07-11/16:37:38 ERROR [rdsLstnr-p-9-t-6] RadiusListenerWorker - java.lang.NullPointerException radius 07-11/16:37:38 ERROR [rdsLstnr-p-9-t-19] RadiusListenerWorker - java.lang.NullPointerException radius 07-11/16:37:38 ERROR [rdsLstnr-p-9-t-5] RadiusListenerWorker - java.lang.NullPointerException |
Автор: | Amir [ 11 июл 2012, 17:06 ] |
Заголовок сообщения: | Re: Неполадки при обновлении |
Покажите radius.properties (вроде бы еще не показывали?). |
Автор: | SVK [ 11 июл 2012, 17:20 ] |
Заголовок сообщения: | Re: Неполадки при обновлении |
Amir писал(а): Покажите radius.properties (вроде бы еще не показывали?). Код: processor.class=ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor
processor.mid=6 db.driver=com.mysql.jdbc.Driver db.url=jdbc:mysql://***/bgbilling?useUnicode=true&characterEncoding=Cp1251&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&elideSetAutoCommits=true&cachePrepStmts=true&queryTimeoutKillsConnection=true&connectTimeout=1000 db.user=bill db.pswd=bgbilling db.maxIdle=20 db.maxActive=300 db.validationTimeout=60 mq.url=failover:(nio://127.0.0.1:61616?socketBufferSize=1000000) mq.user=bill mq.pswd=bgbilling auth.port=1812 acct.port=1813 admin.port=1955 auth.thread.count=20 auth.thread.queue=50 acct.thread.count=20 acct.thread.queue=50 auth.thread.must.be.free.count=5 acct.thread.must.be.free.count=10 collector.capture.flow.port.1=2001 collector.capture.flow.port.1.type=netflow collector.capture.flow.port.1.thread.count=10 collector.capture.flow.port.2=2002 collector.capture.flow.port.2.type=netflow collector.capture.flow.port.2.thread.count=10 collector.capture.flow.port.3=2000 collector.capture.flow.port.3.type=netflow collector.capture.flow.port.3.thread.count=10 |
Автор: | Amir [ 11 июл 2012, 18:17 ] |
Заголовок сообщения: | Re: Неполадки при обновлении |
Попробуйте изменить connectTimeout=1000 на connectTimeout=10000. |
Автор: | SVK [ 12 июл 2012, 09:52 ] |
Заголовок сообщения: | Re: Неполадки при обновлении |
Amir писал(а): Попробуйте изменить connectTimeout=1000 на connectTimeout=10000. Изменил. При перезапуске также Код: processor 07-12/09:46:17 ERROR [pool-2-thread-4] DefaultServerSetup - Many statements was open at connection close: com.mysql.jdbc.JDBC4PreparedStatement@67a1f370: SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tariff.tpid=tariff_plan.id WHERE cid=13561 AND ((emid=0 AND eid=0) OR (emid=0 AND eid=0)) AND ( isNull(date2) OR date2='0000-00-00' OR date2>='2012-07-01' ) UNION SELECT tree_id, date1, date2, emid, eid, 0, pos FROM contract_tree_link WHERE cid=13561 AND ((emid=0 AND eid=0) OR (emid=0 AND eid=0)) AND (date2 IS NULL OR date2>='2012-07-01') ORDER BY 4 DESC, 5 DESC, 6 ASC, 7 ASC com.mysql.jdbc.JDBC4PreparedStatement@eb3ae5c: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=10768 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1 com.mysql.jdbc.PreparedStatement@1b071c0: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=8259 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1 com.mysql.jdbc.PreparedStatement@521ba1d9: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=8946 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1 com.mysql.jdbc.PreparedStatement@651ee017: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=8582 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1 com.mysql.jdbc.PreparedStatement@7e566633: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=13018 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1 com.mysql.jdbc.PreparedStatement@4cd1ad08: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=13584 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1 com.mysql.jdbc.PreparedStatement@7dbd9d76: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=9493 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1 ... java.lang.RuntimeException at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:480) at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:47) at ru.bitel.bgbilling.server.util.ServerUtils.closeConnection(ServerUtils.java:566) at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas.restoreConnectionsImpl(DialUpNas.java:968) at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas.access$7(DialUpNas.java:738) at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas$2.call(DialUpNas.java:732) at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas$2.call(DialUpNas.java:1) 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:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Слил дефолтный клиент с сайта, обновился с двух мест - ошибок коннекта с базой не было. Уже хорошо. |
Автор: | Amir [ 12 июл 2012, 12:19 ] |
Заголовок сообщения: | Re: Неполадки при обновлении |
Код: ERROR [pool-2-thread-4] DefaultServerSetup - Many statements was open at connection close: Эта ошибка - на самом деле не ошибка, а предупреждение - таким образом ищем места, где ресурсы освобождаются позже, чем стоило бы. Т.е. ничего страшного, но на форум лучше постить, если возникают - будем исправлять, какие-то задачи будут выполняться быстрее. Тип сообщения ERROR сделали пока, чтобы отслеживать проще было.
|
Автор: | SVK [ 13 июл 2012, 09:58 ] |
Заголовок сообщения: | Re: Неполадки при обновлении |
Amir писал(а): Код: ERROR [pool-2-thread-4] DefaultServerSetup - Many statements was open at connection close: Эта ошибка - на самом деле не ошибка, а предупреждение - таким образом ищем места, где ресурсы освобождаются позже, чем стоило бы. Т.е. ничего страшного, но на форум лучше постить, если возникают - будем исправлять, какие-то задачи будут выполняться быстрее. Тип сообщения ERROR сделали пока, чтобы отслеживать проще было.Отлично. После обновлений от 12.07 в BGRadiusDialUP ошибок нет. |
Страница 2 из 2 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |