forum.bitel.ru http://forum.bitel.ru/ |
|
[6.0] Exception в bgaccounting (CRM) http://forum.bitel.ru/viewtopic.php?f=44&t=9464 |
Страница 1 из 2 |
Автор: | borisk [ 18 июл 2014, 23:03 ] |
Заголовок сообщения: | [6.0] Exception в bgaccounting |
Добрый день! Чтобы это значило и не мешает ли нормальной работе? Код: accounting 07-18/22:52:20 ERROR [accwrkr-1-p-14-t-1] SessionTarifficationWorker - java.lang.NullPointerException at ru.bitel.bgbilling.modules.inet.accounting.worker.SessionTarifficationWorker.runImpl(SessionTarifficationWorker.java:107) at ru.bitel.bgbilling.modules.inet.accounting.worker.SessionTarifficationWorker.runImpl(SessionTarifficationWorker.java:66) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:165) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:267) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:701) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) Цитата: Информация о версии:
Клиент: вер. 6.0 сборка 1333 от 11.07.2014 17:38:02 os: Windows XP; java: Java HotSpot(TM) Client VM, v.1.7.0_65 ВНИМАНИЕ: Спецификация версии 1.7 не рекомендуется Сервер: вер. 6.0 сборка 1769 от 15.07.2014 17:54:29 os: FreeBSD; java: OpenJDK 64-Bit Server VM, v.1.6.0_32 ВНИМАНИЕ: Виртуальная машина OpenJDK 64-Bit Server VM не рекомендуется bill вер. 6.0 сборка 343 от 12.03.2014 19:11:40 card вер. 6.0 сборка 227 от 06.05.2014 18:58:40 dialup вер. 6.0 сборка 404 от 24.04.2014 19:38:56 email вер. 6.0 сборка 187 от 05.02.2014 15:53:45 inet вер. 6.0 сборка 1411 от 15.07.2014 18:25:17 ipn вер. 6.0 сборка 276 от 10.04.2014 19:28:30 mps вер. 6.0 сборка 216 от 26.05.2014 14:51:29 npay вер. 6.0 сборка 226 от 11.06.2014 17:27:01 phone вер. 6.0 сборка 300 от 07.07.2014 16:18:26 reports вер. 6.0 сборка 216 от 07.07.2014 14:39:22 ru.bitel.bgbilling.plugins.documents вер. 6.0 сборка 199 от 02.04.2014 17:18:42 ru.bitel.bgbilling.plugins.organizer вер. 6.0 сборка 74 от 05.02.2014 15:55:20 voiceip вер. 6.0 сборка 232 от 12.05.2014 16:41:36 wellpay вер. 6.0 сборка 38 от 05.02.2014 15:56:19 Третьи стороны: Fugue Icons. Copyright © 2011 Yusuke Kamiyamane. All rights reserved. http://p.yusukekamiyamane.com/ Silk icon set. Copyright © Mark James. All rights reserved. http://www.famfamfam.com/lab/icons/silk/ |
Автор: | LёLik [ 23 июл 2014, 17:27 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting |
Присоединяюсь к вопросу Код: ==> ./log/error.log <==
accounting 07-23/15:25:33 ERROR [accwrkr-1-p-13-t-1] SessionTarifficationWorker - java.lang.NullPointerException at ru.bitel.bgbilling.modules.inet.accounting.worker.SessionTarifficationWorker.runImpl(SessionTarifficationWorker.java:107) at ru.bitel.bgbilling.modules.inet.accounting.worker.SessionTarifficationWorker.runImpl(SessionTarifficationWorker.java:66) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) |
Автор: | stark [ 23 июл 2014, 17:33 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting |
Это полный stack? |
Автор: | stark [ 23 июл 2014, 17:37 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting |
borisk писал(а): Д inet вер. 6.0 сборка 1411 от 15.07.2014 18:25:17 Версия библиотеки inet на acess/accounting совпадает с этой версией? посмотреть можно внутри jar в файле /bitel/billing/properties/inet.properties |
Автор: | stark [ 23 июл 2014, 17:40 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting |
Тему сразу не заметил. Нужна информация о stack-e. есть подозрение что там есть еще что-то ниже, типа cause by. Точно нет ? |
Автор: | stark [ 23 июл 2014, 17:44 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting |
Кажется нашли в чем дело. Исправляем. |
Автор: | stark [ 23 июл 2014, 18:03 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting |
Исправлено. Обновление выложено |
Автор: | LёLik [ 23 июл 2014, 20:55 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting |
Та ошибка пропала, зато появилась новая Код: ==> ./log/error.log <== collector 07-23/18:55:11 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[51]@1079640815 java.lang.RuntimeException: Lock wait timeout for ContractRuntime[51]@1079640815 at ru.bitel.common.util.CheckReentrantLock.tryLockEx(CheckReentrantLock.java:88) at ru.bitel.bgbilling.kernel.contract.runtime.ContractRuntime.tryLockEx(ContractRuntime.java:173) at ru.bitel.bgbilling.modules.inet.runtime.InetServRuntime.tryLockEx(InetServRuntime.java:572) at ru.bitel.bgbilling.modules.inet.accounting.FlowAgentInterface.getConnection(FlowAgentInterface.java:91) at ru.bitel.bgbilling.modules.inet.accounting.FlowAgentInterface.processFlow(FlowAgentInterface.java:156) at ru.bitel.bgbilling.modules.inet.collector.FlowListenerWorker.processPacketImpl0(FlowListenerWorker.java:284) at ru.bitel.bgbilling.modules.inet.collector.FlowListenerWorker.processPacketImpl(FlowListenerWorker.java:141) at ru.bitel.bgbilling.modules.inet.collector.FlowListenerWorkerNetflow.processPacket(FlowListenerWorkerNetflow.java:29) at ru.bitel.bgbilling.modules.inet.collector.FlowListenerWorker.runImpl(FlowListenerWorker.java:58) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) Caused by: java.lang.RuntimeException: OwnerThread: Thread[accwrkr-3-p-11-t-1,5,main] at sun.misc.Unsafe.park(Native Method) at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:196) at java.util.concurrent.locks.AbstractQueuedSynchronizer.doAcquireNanos(AbstractQueuedSynchronizer.java:905) at java.util.concurrent.locks.AbstractQueuedSynchronizer.tryAcquireNanos(AbstractQueuedSynchronizer.java:1224) at java.util.concurrent.locks.ReentrantLock.tryLock(ReentrantLock.java:416) at ru.bitel.bgbilling.kernel.contract.runtime.ContractRuntime.tryLock(ContractRuntime.java:144) at ru.bitel.bgbilling.kernel.contract.runtime.ContractRuntime.tryLock(ContractRuntime.java:154) at ru.bitel.bgbilling.modules.inet.runtime.InetServRuntime.tryLock(InetServRuntime.java:566) at ru.bitel.bgbilling.modules.inet.accounting.worker.SessionFinishWorker.runImpl(SessionFinishWorker.java:100) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204) ... 4 more Код: Информация о версии:
Клиент: вер. 6.0 сборка 1333 от 11.07.2014 17:38:02 os: Windows XP; java: Java HotSpot(TM) Client VM, v.1.6.0_14 Сервер: вер. 6.0 сборка 1770 от 22.07.2014 18:15:35 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.6.0_45 bill вер. 6.0 сборка 343 от 12.03.2014 19:11:40 card вер. 6.0 сборка 227 от 06.05.2014 18:58:40 inet вер. 6.0 сборка 1413 от 23.07.2014 18:02:48 reports вер. 6.0 сборка 217 от 21.07.2014 15:59:08 |
Автор: | stark [ 24 июл 2014, 14:32 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting |
LёLik писал(а): Та ошибка пропала, зато появилась новая Код: ==> ./log/error.log <== collector 07-23/18:55:11 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[51]@1079640815 java.lang.RuntimeException: Lock wait timeout for ContractRuntime[51]@1079640815 at ru.bitel.common.util.CheckReentrantLock.tryLockEx(CheckReentrantLock.java:88) at ru.bitel.bgbilling.kernel.contract.runtime.ContractRuntime.tryLockEx(ContractRuntime.java:173) at ru.bitel.bgbilling.modules.inet.runtime.InetServRuntime.tryLockEx(InetServRuntime.java:572) at ru.bitel.bgbilling.modules.inet.accounting.FlowAgentInterface.getConnection(FlowAgentInterface.java:91) at ru.bitel.bgbilling.modules.inet.accounting.FlowAgentInterface.processFlow(FlowAgentInterface.java:156) at ru.bitel.bgbilling.modules.inet.collector.FlowListenerWorker.processPacketImpl0(FlowListenerWorker.java:284) at ru.bitel.bgbilling.modules.inet.collector.FlowListenerWorker.processPacketImpl(FlowListenerWorker.java:141) at ru.bitel.bgbilling.modules.inet.collector.FlowListenerWorkerNetflow.processPacket(FlowListenerWorkerNetflow.java:29) at ru.bitel.bgbilling.modules.inet.collector.FlowListenerWorker.runImpl(FlowListenerWorker.java:58) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) Caused by: java.lang.RuntimeException: OwnerThread: Thread[accwrkr-3-p-11-t-1,5,main] at sun.misc.Unsafe.park(Native Method) at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:196) at java.util.concurrent.locks.AbstractQueuedSynchronizer.doAcquireNanos(AbstractQueuedSynchronizer.java:905) at java.util.concurrent.locks.AbstractQueuedSynchronizer.tryAcquireNanos(AbstractQueuedSynchronizer.java:1224) at java.util.concurrent.locks.ReentrantLock.tryLock(ReentrantLock.java:416) at ru.bitel.bgbilling.kernel.contract.runtime.ContractRuntime.tryLock(ContractRuntime.java:144) at ru.bitel.bgbilling.kernel.contract.runtime.ContractRuntime.tryLock(ContractRuntime.java:154) at ru.bitel.bgbilling.modules.inet.runtime.InetServRuntime.tryLock(InetServRuntime.java:566) at ru.bitel.bgbilling.modules.inet.accounting.worker.SessionFinishWorker.runImpl(SessionFinishWorker.java:100) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204) ... 4 more Код: Информация о версии: Клиент: вер. 6.0 сборка 1333 от 11.07.2014 17:38:02 os: Windows XP; java: Java HotSpot(TM) Client VM, v.1.6.0_14 Сервер: вер. 6.0 сборка 1770 от 22.07.2014 18:15:35 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.6.0_45 bill вер. 6.0 сборка 343 от 12.03.2014 19:11:40 card вер. 6.0 сборка 227 от 06.05.2014 18:58:40 inet вер. 6.0 сборка 1413 от 23.07.2014 18:02:48 reports вер. 6.0 сборка 217 от 21.07.2014 15:59:08 Много таких ошибок ? стабильно появляются ? |
Автор: | LёLik [ 24 июл 2014, 15:02 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
Код: tail -f ./log/error.log | grep ERROR
collector 07-24/12:47:16 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:47:18 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[53]@500571876 collector 07-24/12:47:18 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:49:53 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[51]@1079640815 collector 07-24/12:49:53 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:49:53 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:49:53 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:49:53 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:49:53 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:49:53 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:49:53 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:49:54 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:49:55 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:50:33 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:50:35 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:12 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:13 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:15 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:16 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:21 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:22 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:25 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:26 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:51:26 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:26 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:27 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:51:31 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:41 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:41 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:41 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:41 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:41 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:41 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:42 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:51:44 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:45 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:47 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:12 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:12 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:12 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:54:12 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:12 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:12 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:12 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:12 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:13 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:14 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:52 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:54:55 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:55:35 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:55:37 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:55:39 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:55:41 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:55:42 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:55:44 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:55:45 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:55:46 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:55:49 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:55:51 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:56:03 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:56:03 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:56:03 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:56:03 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:56:03 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[51]@1079640815 collector 07-24/12:56:06 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:56:08 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:56:10 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:58:41 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:58:41 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:58:41 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:58:41 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:58:41 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:58:46 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:58:48 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:59:21 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:59:57 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:59:58 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:59:59 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:00 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:02 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:04 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:05 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:07 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:09 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:11 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/13:00:14 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:16 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:27 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:27 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:28 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:29 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:30 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:30 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:31 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/13:00:33 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/13:00:35 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/13:01:08 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/13:01:10 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:01:45 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:01:46 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:01:47 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:01:50 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:01:56 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/13:01:58 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:02:00 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:02:00 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[59]@940667589 collector 07-24/13:02:00 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/13:02:04 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 |
Автор: | stark [ 24 июл 2014, 16:27 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
LёLik писал(а): Код: tail -f ./log/error.log | grep ERROR collector 07-24/12:47:16 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:47:18 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[53]@500571876 collector 07-24/12:47:18 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:49:53 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[51]@1079640815 collector 07-24/12:49:53 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:49:53 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:49:53 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:49:53 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:49:53 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:49:53 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:49:53 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:49:54 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:49:55 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:50:33 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:50:35 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:12 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:13 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:15 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:16 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:21 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:22 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:25 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:26 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:51:26 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:26 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:27 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:51:31 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:41 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:41 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:41 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:41 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:41 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:41 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:42 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:51:44 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:45 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:51:47 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:12 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:12 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:12 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:54:12 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:12 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:12 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:12 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:12 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:13 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:14 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:54:52 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:54:55 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:55:35 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:55:37 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:55:39 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:55:41 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:55:42 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:55:44 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:55:45 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:55:46 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:55:49 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:55:51 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:56:03 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:56:03 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:56:03 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:56:03 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:56:03 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[51]@1079640815 collector 07-24/12:56:06 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:56:08 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:56:10 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:58:41 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:58:41 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:58:41 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:58:41 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:58:41 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:58:46 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:58:48 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:59:21 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:59:57 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:59:58 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:59:59 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:00 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:02 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:04 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:05 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:07 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:09 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:11 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/13:00:14 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:16 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:27 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:27 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:28 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:29 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:30 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:30 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:00:31 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/13:00:33 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/13:00:35 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/13:01:08 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/13:01:10 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:01:45 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:01:46 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:01:47 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:01:50 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:01:56 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/13:01:58 ERROR [flow-p-8-t-6] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:02:00 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/13:02:00 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[59]@940667589 collector 07-24/13:02:00 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/13:02:04 ERROR [flow-p-8-t-8] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 Доступ можете дать ? |
Автор: | stark [ 24 июл 2014, 16:33 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
LёLik писал(а): [code]tail -f ./log/error.log | grep ERROR collector 07-24/12:47:16 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:47:18 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[53]@500571876 collector 07-24/12:47:18 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 На договорах с Id 48, 53, 54 считается все верно ? |
Автор: | LёLik [ 24 июл 2014, 17:25 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
stark писал(а): LёLik писал(а): [code]tail -f ./log/error.log | grep ERROR collector 07-24/12:47:16 ERROR [flow-p-8-t-4] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-9] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-7] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-2] WorkerTask - Lock wait timeout for ContractRuntime[48]@1888547228 collector 07-24/12:47:18 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[53]@500571876 collector 07-24/12:47:18 ERROR [flow-p-8-t-3] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 collector 07-24/12:47:18 ERROR [flow-p-8-t-1] WorkerTask - Lock wait timeout for ContractRuntime[54]@806842425 На договорах с Id 48, 53, 54 считается все верно ? С подсчётом непонятно, началось всё с того, что логи выгруженные из accounting расходились с биллингом. После обновления повалили ошибки, и сравнения я ещё не проводил. Данные для доступа отправил в личку. |
Автор: | Amir [ 29 июл 2014, 16:28 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
Ошибки возникают из-за больших задержек в соединении к БД. Уменьшили в конфигурации период сброса сессий в БД, добавили useCompression=true в URL к БД, сегодня выложим обновление, в котором можно будет указать длительность попытки получить блокировку синхронизации serv.lockTimeout=60. |
Автор: | LёLik [ 30 июл 2014, 17:56 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
Может пригодится кому: 1. Правим конфиг корневого устройства Код: ### # Добавлено serv.lockTimeout=60 ### # Количество потоков на worker accounting.worker.1.thread.count=1 # Тарификатор: # Минимальная сумма трафика, при которой тарифицировать соединение accounting.worker.1.tariffication.1.minDeltaAmount=0 # Пауза между заданиями тарификации accounting.worker.1.tariffication.1.delay=10 # Максимальное количество тарифицируемых соединений за задание accounting.worker.1.tariffication.1.batchSize=300 # Трекер (обработка сессий без наработки): # Пауза между заданиями трекинга accounting.worker.1.tracking.1.delay=20 # Максимальное количество проверенных соединений за задание accounting.worker.1.tracking.1.batchSize=100 # Трекер (обработка сервисов модуля без активных сессий, по умолчанию не требуется): # Пауза между заданиями трекинга accounting.worker.1.serv.tracking.1.delay=20 # Максимальное количество проверенных соединений за задание accounting.worker.1.serv.tracking.1.batchSize=100 # Изменённая секция ########################################################################## # Количество потоков на worker accounting.worker.2.thread.count=2 # Сброс в базу трафиков и наработки: # минимальная наработка, при которой сбрасывать соединение в базу accounting.worker.2.flushing.1.minDeltaAccount=0 # минимальная сумма трафика, при которой сбрасывать соединение в базу accounting.worker.2.flushing.1.minDeltaAmount=0 # пауза между заданиями сброса в базу accounting.worker.2.flushing.1.delay=60 # максимальное количество сброшенных соединений в базу за задание accounting.worker.2.flushing.1.batchSize=1 # минимальная наработка (руб), при которой сбрасывать соединение в базу accounting.worker.2.flushing.2.minDeltaAccount=100 # минимальная сумма трафика, при которой сбрасывать соединение в базу accounting.worker.2.flushing.2.minDeltaAmount=0 # пауза между заданиями сброса в базу accounting.worker.2.flushing.2.delay=20 # максимальное количество сброшенных соединений в базу за задание accounting.worker.2.flushing.2.batchSize=1 ########################################################################### # Количество потоков на worker accounting.worker.3.thread.count=1 # Завершатель соединений: # Пауза между заданиями accounting.worker.3.finishing.1.delay=20 # Максимальное количество сброшенных соединений в базу за задание accounting.worker.3.finishing.1.batchSize=500 2. Правим inet-accounting.xml <param name="db.url" value="jdbc:mysql://Ваш_IP/bgbilling?useUnicode=true&characterEncoding=Cp1251&allowUrlInLocalInfile=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&queryTimeoutKillsConnection=true&connectTimeout=5000&useCompression=true"/> 3. Перезагружаем accounting |
Автор: | Cromeshnic [ 01 авг 2014, 08:40 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
Добавил в 5.2 в BGInetAccounting useCompression=true При старте аккаунтинг падает с ошибкой в accounting.out: Код: The last packet successfully received from the server was 10 milliseconds ago. The last packet sent successfully to the server was 10 milliseconds 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:411) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3537) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:943) at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1441) at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2925) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:477) at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2631) at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1800) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2221) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at ru.bitel.oss.kernel.entity.server.bean.AbstractEntityAttrDao.listImpl(AbstractEntityAttrDao.java:631) ... 16 more Caused by: java.lang.ArrayIndexOutOfBoundsException at com.mysql.jdbc.CompressedInputStream.read(CompressedInputStream.java:280) at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2549) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3058) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2991) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3532) ... 28 more |
Автор: | stark [ 01 авг 2014, 13:30 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
Cromeshnic писал(а): Добавил в 5.2 в BGInetAccounting useCompression=true ] А заче вам это? У LёLik проблема в том, что accounting обращается в mysql через спутник. Вообще пока непонятно будет ли вообще это работать. |
Автор: | Cromeshnic [ 01 авг 2014, 13:46 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
Ну, я думал, это официальная рекомендация: Цитата: добавили useCompression=true в URL к БД, сегодня выложим обновление Потестить, все дела.. Потестил, отписался ![]() |
Автор: | stark [ 01 авг 2014, 13:58 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
Cromeshnic писал(а): Ну, я думал, это официальная рекомендация: Не совсем, это скорее способ решения специфичной проблемы . За тестирование - спасибо, разберемся. |
Автор: | LёLik [ 06 окт 2014, 18:05 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
Добрый день. Может посоветуете, как поступить. По одному из договоров наработка входящего/исходящего трафика 288.613/90.130 Тогда как если просуммировать логи получается 763,93/297,66 В аккаунтинг сыплется ошибка какраз по этому договору: Код: collector 10-06/15:59:57 ERROR [flow-p-8-t-10] WorkerTask - Lock wait timeout for ContractRuntime[67]@1305960912 java.lang.RuntimeException: Lock wait timeout for ContractRuntime[67]@1305960912 at ru.bitel.common.util.CheckReentrantLock.tryLockEx(CheckReentrantLock.java:88) at ru.bitel.bgbilling.kernel.contract.runtime.ContractRuntime.tryLockEx(ContractRuntime.java:173) at ru.bitel.bgbilling.modules.inet.runtime.InetServRuntime.tryLockEx(InetServRuntime.java:572) at ru.bitel.bgbilling.modules.inet.accounting.FlowAgentInterface.getConnection(FlowAgentInterface.java:96) at ru.bitel.bgbilling.modules.inet.accounting.FlowAgentInterface.processFlow(FlowAgentInterface.java:161) at ru.bitel.bgbilling.modules.inet.collector.FlowListenerWorker.processPacketImpl0(FlowListenerWorker.java:248) at ru.bitel.bgbilling.modules.inet.collector.FlowListenerWorker.processPacketImpl(FlowListenerWorker.java:141) at ru.bitel.bgbilling.modules.inet.collector.FlowListenerWorkerNetflow.processPacket(FlowListenerWorkerNetflow.java:29) at ru.bitel.bgbilling.modules.inet.collector.FlowListenerWorker.runImpl(FlowListenerWorker.java:58) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) Caused by: java.lang.RuntimeException: OwnerThread: Thread[flow-p-8-t-6,5,main] at sun.misc.Unsafe.park(Native Method) at java.util.concurrent.locks.LockSupport.park(LockSupport.java:156) at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:1987) at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:399) at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:957) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:917) ... 2 more collector 10-06/16:00:48 ERROR [flow-p-8-t-5] WorkerTask - Lock wait timeout for ContractRuntime[67]@1305960912 java.lang.RuntimeException: Lock wait timeout for ContractRuntime[67]@1305960912 at ru.bitel.common.util.CheckReentrantLock.tryLockEx(CheckReentrantLock.java:88) at ru.bitel.bgbilling.kernel.contract.runtime.ContractRuntime.tryLockEx(ContractRuntime.java:173) at ru.bitel.bgbilling.modules.inet.runtime.InetServRuntime.tryLockEx(InetServRuntime.java:572) at ru.bitel.bgbilling.modules.inet.accounting.FlowAgentInterface.getConnection(FlowAgentInterface.java:96) at ru.bitel.bgbilling.modules.inet.accounting.FlowAgentInterface.processFlow(FlowAgentInterface.java:161) at ru.bitel.bgbilling.modules.inet.collector.FlowListenerWorker.processPacketImpl0(FlowListenerWorker.java:248) at ru.bitel.bgbilling.modules.inet.collector.FlowListenerWorker.processPacketImpl(FlowListenerWorker.java:141) at ru.bitel.bgbilling.modules.inet.collector.FlowListenerWorkerNetflow.processPacket(FlowListenerWorkerNetflow.java:29) at ru.bitel.bgbilling.modules.inet.collector.FlowListenerWorker.runImpl(FlowListenerWorker.java:58) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) Caused by: java.lang.RuntimeException: OwnerThread: Thread[flow-p-8-t-6,5,main] at sun.misc.Unsafe.park(Native Method) at java.util.concurrent.locks.LockSupport.park(LockSupport.java:156) at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:1987) at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:399) at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:957) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:917) ... 2 more Переобсчёт запускать не хотелось бы, так как боюсь, что изменятся значения для других договоров, а счета по ним уже выставлены. |
Автор: | Amir [ 06 окт 2014, 18:11 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
Какой билд? Это супердоговор или субдоговор? Может быть на нем много сервисов или он еще как-то отличается от большинства? |
Автор: | LёLik [ 06 окт 2014, 18:30 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
Обычный договор, без иерархии. Три сервиса, есть и больше на том же коллекторе. Особо ничем не отличается от остальных. Accounting сервер тот же самый, на котором была проблема со спутниковой задержкой. Код: Информация о версии:
Клиент: вер. 6.0 сборка 1333 от 11.07.2014 17:38:02 os: Windows XP; java: Java HotSpot(TM) Client VM, v.1.6.0_14 Сервер: вер. 6.0 сборка 1770 от 22.07.2014 18:15:35 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.6.0_45 bill вер. 6.0 сборка 343 от 12.03.2014 19:11:40 card вер. 6.0 сборка 227 от 06.05.2014 18:58:40 inet вер. 6.0 сборка 1416 от 30.07.2014 15:50:30 reports вер. 6.0 сборка 217 от 21.07.2014 15:59:08 |
Автор: | LёLik [ 07 окт 2014, 22:16 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
А есть какая-нибудь возможность закрыть период и переобработать логи только для одного договора? |
Автор: | stark [ 08 окт 2014, 15:24 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
LёLik писал(а): А есть какая-нибудь возможность закрыть период и переобработать логи только для одного договора? Переобработать логи для одного договора - нет такой возможности . Можно только переобсчитывать сессии для одного договора. |
Автор: | Amir [ 09 окт 2014, 03:50 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
Цитата: В аккаунтинг сыплется ошибка какраз по этому договору: Завтра выложим обновление.
|
Автор: | LёLik [ 10 окт 2014, 14:42 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
Обновился, на договоре ошибка не вылетает. Но при переобсчёте вылезает во такое: Код: accounting 10-10/10:43:55 ERROR [worker-p-14-t-1] InetLogProccessor - EROOR!!!!
com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1064) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2345) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2330) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at ru.bitel.bgbilling.modules.inet.accounting.proccess.InetLogProccessor.saveAmounts(InetLogProccessor.java:523) at ru.bitel.bgbilling.modules.inet.accounting.proccess.InetLogProccessor.process(InetLogProccessor.java:275) at ru.bitel.bgbilling.modules.inet.accounting.proccess.InetLogProccessor.run(InetLogProccessor.java:164) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) accounting 10-10/11:14:41 ERROR [accwrkr-2-p-12-t-1] SessionFlushingWorker - com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction ru.bitel.bgbilling.common.BGException: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction at ru.bitel.bgbilling.modules.inet.accounting.SessionFlushingManager.flush(SessionFlushingManager.java:415) at ru.bitel.bgbilling.modules.inet.accounting.worker.SessionFlushingWorker.runImpl(SessionFlushingWorker.java:160) at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1064) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2345) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2330) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at ru.bitel.bgbilling.modules.inet.accounting.SessionFlushingManager.flushDetailDelta(SessionFlushingManager.java:614) at ru.bitel.bgbilling.modules.inet.accounting.SessionFlushingManager.flushDelta(SessionFlushingManager.java:472) at ru.bitel.bgbilling.modules.inet.accounting.SessionFlushingManager.flush(SessionFlushingManager.java:387) ... 12 more accounting 10-10/11:22:16 ERROR [worker-p-14-t-1] InetLogProccessor - EROOR!!!! com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1064) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del at ru.bitel.bgbilling.modules.inet.accounting.proccess.InetLogProccessor at ru.bitel.bgbilling.modules.inet.accounting.proccess.InetLogProccessor at ru.bitel.bgbilling.modules.inet.accounting.proccess.InetLogProccessor at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:43 at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask. at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor at java.lang.Thread.run(Thread.java:662) at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40) |
Автор: | LёLik [ 10 окт 2014, 18:58 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
И после каждого переобсчёта получаются разные значения! |
Автор: | stark [ 10 окт 2014, 19:20 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
Я не уверен что вообще так получися работать с mysql, когда он за спутником . |
Автор: | stark [ 10 окт 2014, 19:26 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
как вариант можно отключить переобсчет на вашем accounting-е вообще. А поставить отдельный accounting возле базы и на пересчитывать на нем . |
Автор: | stark [ 10 окт 2014, 19:27 ] |
Заголовок сообщения: | Re: [6.0] Exception в bgaccounting (CRM) |
Стопюю Так вы про не про переобсчет, а про переобработку логов говорите. Тогда сложнее |
Страница 1 из 2 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |