| forum.bitel.ru http://forum.bitel.ru/ |
|
| Ошибки в scheduler.out http://forum.bitel.ru/viewtopic.php?f=22&t=745 |
Страница 1 из 1 |
| Автор: | Gankov [ 11 фев 2008, 14:15 ] |
| Заголовок сообщения: | Ошибки в scheduler.out |
Подскажите пожалуйста что за ошибки у меня постоянно вылезают в scheduler.out. Такое чувство что планировщик при них просто не работает. Версия сервера 4.4 build 75 Код: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: [/code]
** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException: Connection refused STACKTRACE: java.net.SocketException: java.net.ConnectException: Connection refused at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) 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:94) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) at bitel.billing.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:111) at bitel.billing.server.util.SetupData.init(SetupData.java:44) at bitel.billing.server.util.SetupData.<init>(SetupData.java:26) at bitel.billing.server.util.SetupData.<init>(SetupData.java:20) at bitel.billing.server.util.manager.SocketManager.<init>(SocketManager.java:16) at bitel.billing.server.task.TESocketManager.<init>(TESocketManager.java:8) at bitel.billing.server.TaskExecuter.main(TaskExecuter.java:215) ** END NESTED EXCEPTION ** Last packet sent to the server was 80 ms ago. at com.mysql.jdbc.Connection.createNewIO(Connection.java:2707) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) 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:94) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) at bitel.billing.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:111) at bitel.billing.server.util.SetupData.init(SetupData.java:44) at bitel.billing.server.util.SetupData.<init>(SetupData.java:26) at bitel.billing.server.util.SetupData.<init>(SetupData.java:20) at bitel.billing.server.util.manager.SocketManager.<init>(SocketManager.java:16) at bitel.billing.server.task.TESocketManager.<init>(TESocketManager.java:8) at bitel.billing.server.TaskExecuter.main(TaskExecuter.java:215) java.lang.NullPointerException at bitel.billing.server.util.DefaultServerSetup.loadModuleSetup(DefaultServerSetup.java:36) at bitel.billing.server.util.SetupData.init(SetupData.java:45) at bitel.billing.server.util.SetupData.<init>(SetupData.java:26) at bitel.billing.server.util.SetupData.<init>(SetupData.java:20) at bitel.billing.server.util.manager.SocketManager.<init>(SocketManager.java:16) at bitel.billing.server.task.TESocketManager.<init>(TESocketManager.java:8) at bitel.billing.server.TaskExecuter.main(TaskExecuter.java:215) Returning NULL to pool!!! Checking port 9066... Port is free starting the applicalion... com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException: Connection refused STACKTRACE: java.net.SocketException: java.net.ConnectException: Connection refused at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) 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:94) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) at bitel.billing.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:111) at bitel.billing.server.util.SetupData.init(SetupData.java:44) at bitel.billing.server.util.SetupData.<init>(SetupData.java:26) at bitel.billing.server.util.SetupData.<init>(SetupData.java:20) at bitel.billing.server.TaskExecuter.<init>(TaskExecuter.java:31) at bitel.billing.server.task.TESocketManager.startApplication(TESocketManager.java:37) at bitel.billing.server.util.manager.SocketManager.analizeArgs(SocketManager.java:105) at bitel.billing.server.util.manager.SocketManager.executeCommand(SocketManager.java:22) at bitel.billing.server.task.TESocketManager.<init>(TESocketManager.java:11) at bitel.billing.server.TaskExecuter.main(TaskExecuter.java:215) ** END NESTED EXCEPTION ** Last packet sent to the server was 1 ms ago. at com.mysql.jdbc.Connection.createNewIO(Connection.java:2707) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) 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:94) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) at bitel.billing.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:111) at bitel.billing.server.util.SetupData.init(SetupData.java:44) at bitel.billing.server.util.SetupData.<init>(SetupData.java:26) at bitel.billing.server.util.SetupData.<init>(SetupData.java:20) at bitel.billing.server.TaskExecuter.<init>(TaskExecuter.java:31) at bitel.billing.server.task.TESocketManager.startApplication(TESocketManager.java:37) at bitel.billing.server.util.manager.SocketManager.analizeArgs(SocketManager.java:105) at bitel.billing.server.util.manager.SocketManager.executeCommand(SocketManager.java:22) at bitel.billing.server.task.TESocketManager.<init>(TESocketManager.java:11) at bitel.billing.server.TaskExecuter.main(TaskExecuter.java:215) java.lang.NullPointerException at bitel.billing.server.util.DefaultServerSetup.loadModuleSetup(DefaultServerSetup.java:36) at bitel.billing.server.util.SetupData.init(SetupData.java:45) at bitel.billing.server.util.SetupData.<init>(SetupData.java:26) at bitel.billing.server.util.SetupData.<init>(SetupData.java:20) at bitel.billing.server.TaskExecuter.<init>(TaskExecuter.java:31) at bitel.billing.server.task.TESocketManager.startApplication(TESocketManager.java:37) at bitel.billing.server.util.manager.SocketManager.analizeArgs(SocketManager.java:105) at bitel.billing.server.util.manager.SocketManager.executeCommand(SocketManager.java:22) at bitel.billing.server.task.TESocketManager.<init>(TESocketManager.java:11) at bitel.billing.server.TaskExecuter.main(TaskExecuter.java:215) Returning NULL to pool!!! Starting TEProccessManager on 9066 Creating socket on 9066 com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException: Connection refused STACKTRACE: java.net.SocketException: java.net.ConnectException: Connection refused at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) 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:94) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) at bitel.billing.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:111) at bitel.billing.server.task.TaskRunProcessor.run(TaskRunProcessor.java:25) ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago. at com.mysql.jdbc.Connection.createNewIO(Connection.java:2707) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) 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:94) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) at bitel.billing.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:111) at bitel.billing.server.task.TaskRunProcessor.run(TaskRunProcessor.java:25) java.lang.NullPointerException at bitel.billing.server.task.bean.RunTaskDataManager.getNextTask(RunTaskDataManager.java:77) at bitel.billing.server.task.TaskRunProcessor.run(TaskRunProcessor.java:29) com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException: Connection refused STACKTRACE: java.net.SocketException: java.net.ConnectException: Connection refused at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) 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:94) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) at bitel.billing.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:111) at bitel.billing.server.TaskExecuter.reloadTasks(TaskExecuter.java:122) at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:76) ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago. at com.mysql.jdbc.Connection.createNewIO(Connection.java:2707) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) 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:94) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) at bitel.billing.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:111) at bitel.billing.server.TaskExecuter.reloadTasks(TaskExecuter.java:122) at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:76) java.lang.NullPointerException at bitel.billing.server.TaskExecuter.reloadTasks(TaskExecuter.java:135) at bitel.billing.server.TaskExecuter.run(TaskExecuter.java:76) Returning NULL to pool!!! Returning NULL to pool!!! com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException: Connection refused STACKTRACE: java.net.SocketException: java.net.ConnectException: Connection refused at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) 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:94) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) at bitel.billing.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:111) at bitel.billing.server.task.TaskRunProcessor.run(TaskRunProcessor.java:25) ** END NESTED EXCEPTION ** Last packet sent to the server was 1 ms ago. at com.mysql.jdbc.Connection.createNewIO(Connection.java:2707) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) 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:94) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) at bitel.billing.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:111) at bitel.billing.server.task.TaskRunProcessor.run(TaskRunProcessor.java:25) java.lang.NullPointerException at bitel.billing.server.task.bean.RunTaskDataManager.getNextTask(RunTaskDataManager.java:77) at bitel.billing.server.task.TaskRunProcessor.run(TaskRunProcessor.java:29) Returning NULL to pool!!! com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException: Connection refused STACKTRACE: java.net.SocketException: java.net.ConnectException: Connection refused at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) 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:94) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) at bitel.billing.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:111) at bitel.billing.server.task.TaskRunProcessor.run(TaskRunProcessor.java:25) ** END NESTED EXCEPTION ** Last packet sent to the server was 1 ms ago. at com.mysql.jdbc.Connection.createNewIO(Connection.java:2707) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) 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:94) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) at bitel.billing.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:111) at bitel.billing.server.task.TaskRunProcessor.run(TaskRunProcessor.java:25) java.lang.NullPointerException at bitel.billing.server.task.bean.RunTaskDataManager.getNextTask(RunTaskDataManager.java:77) at bitel.billing.server.task.TaskRunProcessor.run(TaskRunProcessor.java:29) Returning NULL to pool!!! Executing stop |
|
| Автор: | Amir [ 11 фев 2008, 15:06 ] |
| Заголовок сообщения: | |
Не может соединится с базой данных. |
|
| Автор: | stark [ 12 фев 2008, 13:11 ] |
| Заголовок сообщения: | |
У вас либо настоийки доступа к бд неправильные либо mysql сервер иногда бывает недоступен (напрмер после перезагрузки машины шедулер поднялся раньше mysqld, если они на одной машине ) |
|
| Автор: | Gankov [ 12 фев 2008, 14:31 ] |
| Заголовок сообщения: | |
Спасибо, уже разобрались. Это после перезагрузки. Кстати, как можно сделать чтобы все службы запускались после перезагрузки сами без проблем. Сейчас они запускаются но похоже после SQL сервера, поэтому при запуске в сервисах билинга постоянно возникают ошибки. Приходится запускать в ручную. |
|
| Автор: | stark [ 12 фев 2008, 15:06 ] |
| Заголовок сообщения: | |
Gankov писал(а): Спасибо, уже разобрались. Это после перезагрузки. Кстати, как можно сделать чтобы все службы запускались после перезагрузки сами без проблем. Сейчас они запускаются но похоже после SQL сервера, поэтому при запуске в сервисах билинга постоянно возникают ошибки. Приходится запускать в ручную.
можно менять порядок запуска/остановки служб ..Если служба конфигурируется с помощью chkconfig, то в скрипте запуска вначале идут 2 цифры . Они обазначают какой по счету стартует служба и какой по счету останавливается(можно посмотреть в bgwifiagent) .. А если без chkconfig, то надо вроде ручками создавать ссылки типа : /etc/rc.d/rc3.d/K02bgwifiagent(в данном случае K - kill, 02 - убивать второй по счету) .. Установка службы без использования chkconfig: http://bgbilling.ru/v4.4/doc/ch01s04.html |
|
| Автор: | Gankov [ 13 фев 2008, 15:29 ] |
| Заголовок сообщения: | |
Так в том то и дело что mySQL сервис у меня стоит как S10mysql. А все службы вилинга стоят как: S15bgbilling S15bgdataloader S15bgradius S15bgscheduler S15bgwifiagent Я так сделал еще в самом начале, но не помогло, все равно при запуске сервисы автоматически не запускаются, приходится запускать в ручную. Вернее запускаются но вылезают ошибки конекта с базой. Может быть службы билинга тоже надо в определенном порядке запускать? Или еще в чем то проблема? Еще что нибудь посмтореть. P.S. Службы билинга у меня прописаны на 2-х уровнях 3 и 5 а mysql по умолчанию прописался на 2, 3, 5 |
|
| Автор: | snark [ 13 фев 2008, 17:54 ] |
| Заголовок сообщения: | |
Gankov писал(а): Сейчас они запускаются но похоже после SQL сервера, поэтому при запуске в сервисах билинга постоянно возникают ошибки. Приходится запускать в ручную.
|
|
| Страница 1 из 1 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|