Версия 4.6, обновления за 15.06.2009
Последнее время каждое утро зависает scheduler. В планировщике показывает, что висят 3 или 4 тяжелых задачи. Обычно это обнаруживается при запуске в ручную снятие абонплат.
В логе scheduler.error.log:
Код:
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:01 ERROR [pool-2-thread-3] LogCalculator - Tree not found for contract id: 6
scheduler 06-16/09:00:02 ERROR [pool-2-thread-3] LogCalculator - Detected errors => 2402
При остановки scheduler-а, процесс продолжает висеть, приходиться убивать. После перезапуска абонплаты снимаются, но в логах такая картина:
Код:
06-16/09:10:09 INFO [main] DefaultServerSetup - Init DB connection pools
06-16/09:10:10 INFO [main] DefaultServerSetup - Init trash pools..
06-16/09:10:10 INFO [main] DefaultServerSetup - Init trash pool trash_1
06-16/09:10:10 INFO [main] TaskExecuter - Start TaskExecuter
06-16/09:10:10 INFO [Thread-5] TaskExecuter - TaskExecuter => reloadTasks()
06-16/09:10:10 INFO [Thread-10] TaskRunProcessor - Running Task: bitel.billing.server.npay.Recalculator@7114460
06-16/09:10:10 INFO [pool-1-thread-1] Recalculator - PaymentRecalculator time: 01.06.2009 00
06-16/09:10:10 INFO [Thread-10] TaskRunProcessor - Running Task: bitel.billing.server.npay.Recalculator@42ef83d3
06-16/09:10:10 INFO [pool-1-thread-2] Recalculator - PaymentRecalculator time: 01.06.2009 00
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.ipn.IPNTestGates
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.contract.LimitRestorer
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.mail.UserDispatchSender
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.contract.DebtMailSender
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.contract.ContractStatusSetter
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.mail.MailSender
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.ipn.LogCalculator
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.ipn.LogCalculator
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.npay.Calculator
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.script.TimerEventGenerate
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.cerbercrypt.CardContractSetter
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.cerbercrypt.StatusSetter
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.cerbercrypt.Calculator
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.cerbercrypt.Locker
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.cerbercrypt.Synchronizer
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.npay.Calculator
06-16/09:10:10 INFO [Thread-5] TaskExecuter - Task: bitel.billing.server.npay.Calculator
06-16/09:10:10 INFO [pool-1-thread-1] Calculator - Calculate current month
06-16/09:10:10 INFO [pool-1-thread-1] Setup - Load config for mid=11
06-16/09:10:10 INFO [Thread-10] TaskRunProcessor - Running Task: bitel.billing.server.npay.Recalculator@5983e7de
06-16/09:10:10 INFO [pool-1-thread-3] Recalculator - PaymentRecalculator time: 01.06.2009 00
06-16/09:10:10 INFO [pool-1-thread-3] Calculator - Calculate current month
06-16/09:10:10 INFO [pool-1-thread-3] Setup - Load config for mid=11
06-16/09:10:10 INFO [pool-1-thread-2] Calculator - Calculate current month
06-16/09:10:10 INFO [pool-1-thread-2] Setup - Load config for mid=11
06-16/09:10:10 INFO [Thread-10] TaskRunProcessor - Running Task: bitel.billing.server.npay.Recalculator@112c3327
06-16/09:10:10 INFO [pool-1-thread-4] Recalculator - PaymentRecalculator time: 01.06.2009 00
06-16/09:10:10 INFO [Thread-10] TaskRunProcessor - Running Task: bitel.billing.server.npay.Recalculator@1118fa47
06-16/09:10:10 INFO [pool-1-thread-5] Recalculator - PaymentRecalculator time: 01.06.2009 00
06-16/09:10:10 INFO [pool-1-thread-1] Calculator - Memory total: 18 546 688; max: 477 233 152; free: 13 286 328
06-16/09:10:10 INFO [pool-1-thread-3] Calculator - Memory total: 18 546 688; max: 477 233 152; free: 13 286 328
06-16/09:10:10 INFO [pool-1-thread-4] Calculator - Calculate current month
06-16/09:10:10 INFO [pool-1-thread-5] Calculator - Calculate current month
06-16/09:10:10 INFO [pool-1-thread-2] Calculator - Memory total: 18 546 688; max: 477 233 152; free: 11 011 896
06-16/09:10:10 INFO [pool-1-thread-4] Calculator - Memory total: 18 546 688; max: 477 233 152; free: 10 879 608
06-16/09:10:10 INFO [pool-1-thread-5] Calculator - Memory total: 18 546 688; max: 477 233 152; free: 10 089 992
06-16/09:10:10 INFO [pool-1-thread-1] Calculator - Setting balances for independ and subs..
06-16/09:10:10 INFO [pool-1-thread-3] Calculator - Setting balances for independ and subs..
06-16/09:10:10 INFO [pool-1-thread-3] Calculator - Selected.
06-16/09:10:10 INFO [pool-1-thread-1] Calculator - Selected.
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '2009-6-2719-47' for key 'PRIMARY'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
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.executeUpdate(PreparedStatement.java:2046)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233)
at bitel.billing.server.contract.bean.BalanceUtils.setAccount(BalanceUtils.java:933)
at bitel.billing.server.npay.Calculator.executeTask(Calculator.java:462)
at bitel.billing.server.task.TaskBase.run(TaskBase.java:50)
at bitel.billing.server.task.TaskBase.startTask(TaskBase.java:72)
at bitel.billing.server.npay.Recalculator.run(Recalculator.java:45)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
06-16/09:10:10 INFO [pool-1-thread-3] Calculator - Selecting sub account
06-16/09:10:10 INFO [pool-1-thread-1] Calculator - Selecting sub account
06-16/09:10:10 INFO [pool-1-thread-3] Calculator - Selected.
06-16/09:10:10 INFO [pool-1-thread-3] Calculator - Setting balance for super..
06-16/09:10:10 INFO [pool-1-thread-1] Calculator - Selected.
06-16/09:10:10 INFO [pool-1-thread-1] Calculator - Setting balance for super..
06-16/09:10:10 INFO [pool-1-thread-5] Calculator - Task finished time=75 ms.
06-16/09:10:10 INFO [pool-1-thread-1] Calculator - Selected.
06-16/09:10:10 INFO [pool-1-thread-3] Calculator - Selected.
06-16/09:10:10 INFO [pool-1-thread-2] Calculator - Setting balances for independ and subs..
06-16/09:10:10 INFO [pool-1-thread-2] Calculator - Selected.
06-16/09:10:10 INFO [pool-1-thread-1] Calculator - Task finished time=434 ms.
06-16/09:10:10 INFO [pool-1-thread-2] Calculator - Selecting sub account
06-16/09:10:10 INFO [pool-1-thread-4] Calculator - Setting balances for independ and subs..
06-16/09:10:10 INFO [pool-1-thread-3] Calculator - Task finished time=269 ms.
06-16/09:10:10 INFO [pool-1-thread-2] Calculator - Selected.
06-16/09:10:10 INFO [pool-1-thread-4] Calculator - Selected.
06-16/09:10:10 INFO [pool-1-thread-2] Calculator - Setting balance for super..
06-16/09:10:10 INFO [pool-1-thread-2] Calculator - Selected.
06-16/09:10:10 INFO [pool-1-thread-4] Calculator - Selecting sub account
06-16/09:10:10 INFO [pool-1-thread-4] Calculator - Selected.
06-16/09:10:10 INFO [pool-1-thread-4] Calculator - Setting balance for super..
06-16/09:10:10 INFO [pool-1-thread-2] Calculator - Task finished time=347 ms.
06-16/09:10:10 INFO [pool-1-thread-4] Calculator - Selected.
06-16/09:10:10 INFO [pool-1-thread-4] Calculator - Task finished time=188 ms.
Как подличить данную проблему?