forum.bitel.ru :: Просмотр темы - Снова табличный манад FreeBS с изменениями правил по времени

Предпалогалось что вот в этом

Код:

scheduler 12-30/08:09:24 ERROR [pool-2-thread-5] LogCalculator - Communications link failure

The last packet successfully received from the server was 749 milliseconds ago.  The last packet sent successfully to the server was 94,272 milliseconds ago.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 749 milliseconds ago.  The last packet sent successfully to the server was 94,272 milliseconds ago.
   at sun.reflect.GeneratedConstructorAccessor88.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:407)
   at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
   at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3082)
   at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2968)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3516)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
   at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1429)
   at com.mysql.jdbc.MysqlIO.fetchRowsViaCursor(MysqlIO.java:4642)
   at com.mysql.jdbc.RowDataCursor.fetchMoreRows(RowDataCursor.java:412)
   at com.mysql.jdbc.RowDataCursor.hasNext(RowDataCursor.java:326)
   at com.mysql.jdbc.RowDataCursor.next(RowDataCursor.java:358)
   at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7171)
   at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:169)
   at bitel.billing.server.ipn.LogCalculator.initContractTrees(LogCalculator.java:710)
   at bitel.billing.server.ipn.LogCalculator.executeTask(LogCalculator.java:226)
   at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:63)
   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)
Caused by: java.io.EOFException: Can not read response from server. Expected to read 27 bytes, read 24 bytes before connection was unexpectedly lost.
   at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2529)
   at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3035)
   ... 16 more
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 3,803 milliseconds ago.  The last packet sent successfully to the server was 975 milliseconds ago.
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at sun.reflect.GeneratedConstructorAccessor88.newInstance(Unknown Source)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3348)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1967)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at bitel.billing.server.ipn.LogCalculator.process(LogCalculator.java:283)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at bitel.billing.server.ipn.LogCalculator.executeTask(LogCalculator.java:227)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:63)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at java.lang.Thread.run(Thread.java:662)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - Caused by: java.net.SocketException: Broken pipe
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at java.net.SocketOutputStream.socketWrite0(Native Method)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3329)
scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream -    ... 12 more

Что за ошибки кстати?

Однако с ними тоже работает.
Проблема была в том что при обсчете лого IPN у меня отваливалась служба NetFlow. Приходилось перезапускать вручную. Сейчас изменил время запусков задач, правила отрабатывают.
Однако как всегда есть одно НО - все это работает только на паре компах на тестовом стенде.
Как она поведет себя в реальных условиях неизвестно:(

Автор:	Sputnik [ 27 дек 2011, 09:29 ]
Заголовок сообщения:	Снова табличный манад FreeBS с изменениями правил по времени
Здравствуйте! Помогите разобратся с тарифами со сменой правил по времени. Сделал все по теме FreeBSD Manad, использующий таблицы Выставил тарифы. Проблема в следующем. Когда я запускаю задачи планировщиуа "обсчет логов IPN" и "Проверку шлюзов IPN" вручную, то правило на тарифе меняется. Это отображается в логе Код: 12-27/10:14:14 INFO [pool-156-thread-3] ManadGateWorker - 1 rule changed 12-27/10:14:14 INFO [pool-156-thread-3] ManadGateWorker - 1 add 9298 pipe {P0} config bw 2048000 \|pipe {P1} config bw 2048000\|table 1 delete 192.168.6.14\|table 2 delete 192.168.6.14\|table 1 add 192.168.6.14 {P0}\|table 2 add 192.168.6.14 {P1} // RULE8 однако при автоматическом выполнении задач планировщика этого не происходит. Он просто показывает что скрипт манада отработал и все. В чем может быть проблема? Если нужно выложить доп.инфу то выложу Клиент: вер. 5.1 сборка 619 от 08.12.2011 12:55:32 os: Windows 7; java: Java HotSpot(TM) 64-Bit Server VM, v.1.6.0_25 Сервер: вер. 5.1 сборка 738 от 29.11.2011 18:07:23 os: Linux; java: Java HotSpot(TM) Server VM, v.1.6.0_26

Автор:	Sputnik [ 29 дек 2011, 08:51 ]
Заголовок сообщения:	Re: Снова табличный манад FreeBS с изменениями правил по вре
Проблему решил. Всем спасибо! Кому интересно пишите.

Автор:	stark [ 29 дек 2011, 12:33 ]
Заголовок сообщения:	Re: Снова табличный манад FreeBS с изменениями правил по вре
так в чем проблема то была ?

Автор:	Sputnik [ 30 дек 2011, 09:03 ]
Заголовок сообщения:	Re: Снова табличный манад FreeBS с изменениями правил по вре
Предпалогалось что вот в этом Код: scheduler 12-30/08:09:24 ERROR [pool-2-thread-5] LogCalculator - Communications link failure The last packet successfully received from the server was 749 milliseconds ago. The last packet sent successfully to the server was 94,272 milliseconds ago. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 749 milliseconds ago. The last packet sent successfully to the server was 94,272 milliseconds ago. at sun.reflect.GeneratedConstructorAccessor88.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:407) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3082) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2968) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3516) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931) at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1429) at com.mysql.jdbc.MysqlIO.fetchRowsViaCursor(MysqlIO.java:4642) at com.mysql.jdbc.RowDataCursor.fetchMoreRows(RowDataCursor.java:412) at com.mysql.jdbc.RowDataCursor.hasNext(RowDataCursor.java:326) at com.mysql.jdbc.RowDataCursor.next(RowDataCursor.java:358) at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7171) at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:169) at bitel.billing.server.ipn.LogCalculator.initContractTrees(LogCalculator.java:710) at bitel.billing.server.ipn.LogCalculator.executeTask(LogCalculator.java:226) at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:63) 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) Caused by: java.io.EOFException: Can not read response from server. Expected to read 27 bytes, read 24 bytes before connection was unexpectedly lost. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2529) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3035) ... 16 more scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 3,803 milliseconds ago. The last packet sent successfully to the server was 975 milliseconds ago. scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at sun.reflect.GeneratedConstructorAccessor88.newInstance(Unknown Source) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.lang.reflect.Constructor.newInstance(Constructor.java:513) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3348) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1967) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at bitel.billing.server.ipn.LogCalculator.process(LogCalculator.java:283) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at bitel.billing.server.ipn.LogCalculator.executeTask(LogCalculator.java:227) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:63) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.lang.Thread.run(Thread.java:662) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - Caused by: java.net.SocketException: Broken pipe scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.net.SocketOutputStream.socketWrite0(Native Method) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.net.SocketOutputStream.write(SocketOutputStream.java:136) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3329) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - ... 12 more Что за ошибки кстати? Однако с ними тоже работает. Проблема была в том что при обсчете лого IPN у меня отваливалась служба NetFlow. Приходилось перезапускать вручную. Сейчас изменил время запусков задач, правила отрабатывают. Однако как всегда есть одно НО - все это работает только на паре компах на тестовом стенде. Как она поведет себя в реальных условиях неизвестно:(

Автор:	Sputnik [ 30 дек 2011, 09:44 ]
Заголовок сообщения:	Re: Снова табличный манад FreeBS с изменениями правил по вре
Дополнение. Ошибки из коллектора Код: dataloader 12-30/09:14:20 ERROR [Thread-13] dataloader - com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Last packet sent to the server was 79169 ms ago. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Last packet sent to the server was 79169 ms ago. 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:406) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3009) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2895) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3438) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at bitel.billing.server.netflow.ipn.Processor.run(Processor.java:91) Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2455) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2906) ... 9 more dataloader 12-30/09:14:23 ERROR [Thread-13] DefaultServerSetup - Communications link failure Last packet sent to the server was 0 ms ago. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. 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:406) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2120) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) 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:406) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) 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:65) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974) at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:574) at bitel.billing.server.netflow.ipn.Processor.run(Processor.java:72) Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. 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:406) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:335) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2043) ... 16 more Caused by: java.net.ConnectException: Connection refused 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 java.net.Socket.connect(Socket.java:478) at java.net.Socket.<init>(Socket.java:375) at java.net.Socket.<init>(Socket.java:218) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284) ... 17 more

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

Снова табличный манад FreeBS с изменениями правил по времени http://forum.bitel.ru/viewtopic.php?f=7&t=6260	Страница 1 из 1

Автор:	stark [ 30 дек 2011, 09:53 ]
Заголовок сообщения:	Re: Снова табличный манад FreeBS с изменениями правил по вре
Sputnik писал(а): Предпалогалось что вот в этом Код: scheduler 12-30/08:09:24 ERROR [pool-2-thread-5] LogCalculator - Communications link failure The last packet successfully received from the server was 749 milliseconds ago. The last packet sent successfully to the server was 94,272 milliseconds ago. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 749 milliseconds ago. The last packet sent successfully to the server was 94,272 milliseconds ago. at sun.reflect.GeneratedConstructorAccessor88.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:407) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3082) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2968) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3516) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931) at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1429) at com.mysql.jdbc.MysqlIO.fetchRowsViaCursor(MysqlIO.java:4642) at com.mysql.jdbc.RowDataCursor.fetchMoreRows(RowDataCursor.java:412) at com.mysql.jdbc.RowDataCursor.hasNext(RowDataCursor.java:326) at com.mysql.jdbc.RowDataCursor.next(RowDataCursor.java:358) at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7171) at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:169) at bitel.billing.server.ipn.LogCalculator.initContractTrees(LogCalculator.java:710) at bitel.billing.server.ipn.LogCalculator.executeTask(LogCalculator.java:226) at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:63) 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) Caused by: java.io.EOFException: Can not read response from server. Expected to read 27 bytes, read 24 bytes before connection was unexpectedly lost. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2529) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3035) ... 16 more scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 3,803 milliseconds ago. The last packet sent successfully to the server was 975 milliseconds ago. scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at sun.reflect.GeneratedConstructorAccessor88.newInstance(Unknown Source) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.lang.reflect.Constructor.newInstance(Constructor.java:513) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3348) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1967) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at bitel.billing.server.ipn.LogCalculator.process(LogCalculator.java:283) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at bitel.billing.server.ipn.LogCalculator.executeTask(LogCalculator.java:227) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:63) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.lang.Thread.run(Thread.java:662) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - Caused by: java.net.SocketException: Broken pipe scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.net.SocketOutputStream.socketWrite0(Native Method) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.net.SocketOutputStream.write(SocketOutputStream.java:136) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3329) scheduler 12-30/08:09:27 ERROR [pool-2-thread-5] LoggingPrintStream - ... 12 more Что за ошибки кстати? Однако с ними тоже работает. Проблема была в том что при обсчете лого IPN у меня отваливалась служба NetFlow. Приходилось перезапускать вручную. Сейчас изменил время запусков задач, правила отрабатывают. Однако как всегда есть одно НО - все это работает только на паре компах на тестовом стенде. Как она поведет себя в реальных условиях неизвестно:( mysql не отвечал по каким-то причинам. был недоступен .

Автор:	Sputnik [ 30 дек 2011, 11:27 ]
Заголовок сообщения:	Re: Снова табличный манад FreeBS с изменениями правил по вре
Кстати. По поводу MySQL влогах вот это постоянно выходит. Это от биллинга идет насколько я понимаю? Код: 111230 9:55:12 [Note] Event Scheduler: Purging the queue. 0 events 111230 9:55:14 InnoDB: Starting shutdown... 111230 9:55:17 InnoDB: Shutdown completed; log sequence number 3 2041513004 111230 9:55:17 [Note] /usr/sbin/mysqld: Shutdown complete 111230 09:55:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 111230 09:56:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 111230 9:56:03 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead. 111230 9:56:03 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. 111230 9:56:03 [Warning] '--default-collation' is deprecated and will be removed in a future release. Please use '--collation-server' instead. 111230 9:56:03 [Note] Plugin 'FEDERATED' is disabled. 111230 9:56:05 InnoDB: Started; log sequence number 3 2041513004 /usr/sbin/mysqld: File '/var/log/slowquery.log' not found (Errcode: 13) 111230 9:56:05 [ERROR] Could not use /var/log/slowquery.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it. 111230 9:56:06 [Warning] 'user' entry 'root@billing' ignored in --skip-name-resolve mode. 111230 9:56:07 [Note] Event Scheduler: Loaded 0 events 111230 9:56:07 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.49-3-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian) 111230 9:58:26 [Note] /usr/sbin/mysqld: Normal shutdown 111230 9:58:27 [Note] Event Scheduler: Purging the queue. 0 events 111230 9:58:27 InnoDB: Starting shutdown... 111230 9:58:32 InnoDB: Shutdown completed; log sequence number 3 2041536893 111230 9:58:32 [Note] /usr/sbin/mysqld: Shutdown complete Эти параметры Код: 111230 9:56:03 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead. 111230 9:56:03 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. 111230 9:56:03 [Warning] '--default-collation' is deprecated and will be removed in a future release. Please use '--collation-server' instead. где можно переставить на новые?

Автор:	stark [ 30 дек 2011, 13:45 ]
Заголовок сообщения:	Re: Снова табличный манад FreeBS с изменениями правил по вре
Sputnik писал(а): Код: 111230 9:56:03 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead. 111230 9:56:03 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. 111230 9:56:03 [Warning] '--default-collation' is deprecated and will be removed in a future release. Please use '--collation-server' instead. где можно переставить на новые? /etc/mysql/my.cnf

Автор:	Sputnik [ 30 дек 2011, 14:17 ]
Заголовок сообщения:	Re: Снова табличный манад FreeBS с изменениями правил по вре
Еще вопрос. Зачем привязывать смену правил к задаче "Обсчета логов IPN"? В чем логика работы?

Автор:	stark [ 30 дек 2011, 18:02 ]
Заголовок сообщения:	Re: Снова табличный манад FreeBS с изменениями правил по вре
Sputnik писал(а): Еще вопрос. Зачем привязывать смену правил к задаче "Обсчета логов IPN"? В чем логика работы? Правило же в тарифе проставляется . А задача обсчета логов как раз тариф разбирает чтобы узнать цену , заодно и правило меняет.

Страница 1 из 1	Часовой пояс: UTC + 5 часов [ Летнее время ]
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/