BiTel

Форум BiTel
bgbilling.ru     docs.bitel.ru     wiki.bitel.ru     dbinfo.bitel.ru     bgcrm.ru     billing.bitel.ru     bitel.ru    
Текущее время: 29 мар 2024, 02:57

Часовой пояс: UTC + 5 часов [ Летнее время ]




Начать новую тему Ответить на тему  [ Сообщений: 21 ] 
Автор Сообщение
 Заголовок сообщения: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 30 ноя 2012, 23:39 
Не в сети
Клиент

Зарегистрирован: 25 ноя 2007, 22:48
Сообщения: 472
Карма: 8
При попытке запустить начисление в модуле Dr.Web происходит исключение:

Код:
11-30/21:28:49  INFO [Thread-10] TaskRunProcessor - Running Task: ru.bitel.bgbilling.modules.drweb.server.tasks.Recalculator@a2220f
11-30/21:28:49  INFO [pool-1-thread-1] Recalculator - PaymentRecalculator time: 02.11.2012 00
11-30/21:28:49  INFO [pool-1-thread-1] Setup - Load config for mid=9
11-30/21:28:49 ERROR [pool-1-thread-1] AgentAVDManager -
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'expires' in where clause is ambiguous
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.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.executeQuery(PreparedStatement.java:1912)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
        at ru.bitel.bgbilling.modules.drweb.server.bean.AgentAVDManager.getListWithStatus(AgentAVDManager.java:305)
        at ru.bitel.bgbilling.modules.drweb.server.tasks.Calculator.getAgentList(Calculator.java:162)
        at ru.bitel.bgbilling.modules.drweb.server.tasks.Calculator.executeTask(Calculator.java:64)
        at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:63)
        at ru.bitel.bgbilling.kernel.task.server.TaskBase.startTask(TaskBase.java:99)
        at ru.bitel.bgbilling.modules.drweb.server.tasks.Recalculator.executeTask(Recalculator.java:52)
        at bitel.billing.server.task.bean.RunTask.run(RunTask.java:40)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)


Сервер: вер. 5.1 сборка 836 от 08.11.2012 14:14:54
os: Linux; java: Java HotSpot(TM) Server VM, v.1.6.0_30

drweb вер. 5.1 сборка 76 от 01.11.2012 20:07:39


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 02 дек 2012, 16:08 
Не в сети
Разработчик

Зарегистрирован: 27 мар 2008, 17:10
Сообщения: 301
Карма: 27
выложил обновление


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 12:23 
Не в сети
Клиент

Зарегистрирован: 25 ноя 2007, 22:48
Сообщения: 472
Карма: 8
Не помогло:

Код:
root@bill:/usr/local/BGBillingServer# ./bg_installer.sh update
 12-03/10:18:50  INFO [main] DefaultServerSetup - Binding javax.jms.ConnectionFactory[org.apache.activemq.ActiveMQConnectionFactory@1e87719] to java:comp/env/mq/connectionFactory
 12-03/10:18:50 DEBUG [main] JNDIReferenceFactory - Creating reference: org.apache.activemq.ActiveMQConnectionFactory,org.apache.activemq.ActiveMQConnectionFactory@1e87719
 12-03/10:18:50  INFO [main] DefaultServerSetup - Init DB connection pools
 12-03/10:18:51  INFO [main] DefaultServerSetup - Binding JDBC pool "master" to java:comp/env/jdbc/master
 12-03/10:18:51  INFO [main] DefaultServerSetup - Init trash pools..
Update starting..
Update from ftp://ftp.bgbilling.ru/pub/bgbilling
Server version is 5.1
Set passive mode..
Changing dir to /pub/bgbilling/5.1
Checking updates for dialup..
Checking updates for npay..
Checking updates for ipn..
Checking updates for rscm..
Checking updates for card..
Checking updates for ru.bitel.bgbilling.plugins.crm..
Checking updates for reports..
Checking updates for mps..
Checking updates for ru.bitel.bgbilling.plugins.documents..
Checking updates for voiceip..
Checking updates for ru.bitel.bgbilling.plugins.cashcheck..
Checking updates for phone..
Checking updates for ru.bitel.bgbilling.plugins.organizer..
Checking updates for ru.bitel.bgbilling.plugins.helpdesk..
Checking updates for drweb..
Found update for drweb build 76 packet drweb_5.1_77.zip updating to build 77
Checking updates for server..
Checking updates for client..
Install 1 updates (y/n):
y
Downloading drweb_5.1_77.zip OK!
Start installing..
Module: drweb already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 9
Module Instance init => OK
Executing call AddSchedulerTasks; param: drweb.sc
Scheduled class ru.bitel.bgbilling.modules.drweb.server.tasks.ProlongerAVDAgent already exists!
Scheduled class ru.bitel.bgbilling.modules.drweb.server.tasks.Calculator already exists!
Result => true
Executing call PutFile; param: drweb.xml:actions
Result => true
Executing call PutFile; param: drweb-license.pdf:webroot
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module drweb was successfull installed!
Please, restart BGBilling server.


Код:
12-03/10:21:47 ERROR [pool-1-thread-1] AgentAVDManager -
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'expires' in field list is ambiguous
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.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.executeQuery(PreparedStatement.java:1912)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
        at ru.bitel.bgbilling.modules.drweb.server.bean.AgentAVDManager.getListWithStatus(AgentAVDManager.java:305)
        at ru.bitel.bgbilling.modules.drweb.server.tasks.Calculator.getAgentList(Calculator.java:162)
        at ru.bitel.bgbilling.modules.drweb.server.tasks.Calculator.executeTask(Calculator.java:64)
        at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:63)
        at ru.bitel.bgbilling.kernel.task.server.TaskBase.startTask(TaskBase.java:99)
        at ru.bitel.bgbilling.modules.drweb.server.tasks.Recalculator.executeTask(Recalculator.java:52)
        at bitel.billing.server.task.bean.RunTask.run(RunTask.java:40)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)


Сервер: вер. 5.1 сборка 836 от 08.11.2012 14:14:54
os: Linux; java: Java HotSpot(TM) Server VM, v.1.6.0_30
drweb вер. 5.1 сборка 77 от 02.12.2012 16:00:55


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 12:48 
Не в сети
Разработчик

Зарегистрирован: 27 мар 2008, 17:10
Сообщения: 301
Карма: 27
еще раз. хотя погодите, щас сделаю


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 12:56 
Не в сети
Клиент

Зарегистрирован: 25 ноя 2007, 22:48
Сообщения: 472
Карма: 8
Ситуация не изменилась:

Код:
root@bill:/usr/local/BGBillingServer# /etc/rc.d/rc.bgscheduler stop && /etc/rc.d/rc.bgbilling stop && ./bg_installer.sh update
Sending 'stop' on 127.0.0.1:9066
Result: ok
OK stopping..
 12-03/10:51:17  INFO [main] DefaultServerSetup - Binding javax.jms.ConnectionFactory[org.apache.activemq.ActiveMQConnectionFactory@157c2bd] to java:comp/env/mq/connectionFactory
 12-03/10:51:17 DEBUG [main] JNDIReferenceFactory - Creating reference: org.apache.activemq.ActiveMQConnectionFactory,org.apache.activemq.ActiveMQConnectionFactory@157c2bd
 12-03/10:51:17  INFO [main] DefaultServerSetup - Init DB connection pools
 12-03/10:51:17  INFO [main] DefaultServerSetup - Binding JDBC pool "master" to java:comp/env/jdbc/master
 12-03/10:51:17  INFO [main] DefaultServerSetup - Init trash pools..
Update starting..
Update from ftp://ftp.bgbilling.ru/pub/bgbilling
Server version is 5.1
Set passive mode..
Changing dir to /pub/bgbilling/5.1
Checking updates for dialup..
Checking updates for npay..
Checking updates for ipn..
Checking updates for rscm..
Checking updates for card..
Checking updates for ru.bitel.bgbilling.plugins.crm..
Checking updates for reports..
Checking updates for mps..
Checking updates for ru.bitel.bgbilling.plugins.documents..
Checking updates for voiceip..
Checking updates for ru.bitel.bgbilling.plugins.cashcheck..
Checking updates for phone..
Checking updates for ru.bitel.bgbilling.plugins.organizer..
Checking updates for ru.bitel.bgbilling.plugins.helpdesk..
Checking updates for drweb..
Found update for drweb build 77 packet drweb_5.1_78.zip updating to build 78
Checking updates for server..
Checking updates for client..
Install 1 updates (y/n):
y
Downloading drweb_5.1_78.zip OK!
Start installing..
Module: drweb already installed.
Data extract finished...
Extract data => OK
Database updated...
Install ticket inserted..
Base update => OK
Reinit module instanses
REINIT module => 9
Module Instance init => OK
Executing call AddSchedulerTasks; param: drweb.sc
Scheduled class ru.bitel.bgbilling.modules.drweb.server.tasks.ProlongerAVDAgent already exists!
Scheduled class ru.bitel.bgbilling.modules.drweb.server.tasks.Calculator already exists!
Result => true
Executing call PutFile; param: drweb.xml:actions
Result => true
Executing call PutFile; param: drweb-license.pdf:webroot
Result => true
Execute calls => OK
File's copy finished...
File copy => OK
Module drweb was successfull installed!
Please, restart BGBilling server.


Код:
12-03/10:53:06  INFO [pool-1-thread-1] Recalculator - PaymentRecalculator time: 02.10.2012 00
12-03/10:53:06  INFO [pool-1-thread-1] Setup - Load config for mid=9
12-03/10:53:06 ERROR [pool-1-thread-1] AgentAVDManager -
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'expires' in field list is ambiguous
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.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.executeQuery(PreparedStatement.java:1912)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
        at ru.bitel.bgbilling.modules.drweb.server.bean.AgentAVDManager.getListWithStatus(AgentAVDManager.java:305)
        at ru.bitel.bgbilling.modules.drweb.server.tasks.Calculator.getAgentList(Calculator.java:162)
        at ru.bitel.bgbilling.modules.drweb.server.tasks.Calculator.executeTask(Calculator.java:64)
        at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:63)
        at ru.bitel.bgbilling.kernel.task.server.TaskBase.startTask(TaskBase.java:99)
        at ru.bitel.bgbilling.modules.drweb.server.tasks.Recalculator.executeTask(Recalculator.java:52)
        at bitel.billing.server.task.bean.RunTask.run(RunTask.java:40)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)


Сервер: вер. 5.1 сборка 836 от 08.11.2012 14:14:54
os: Linux; java: Java HotSpot(TM) Server VM, v.1.6.0_30
drweb вер. 5.1 сборка 78 от 03.12.2012 12:47:23


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 13:14 
Не в сети
Разработчик

Зарегистрирован: 27 мар 2008, 17:10
Сообщения: 301
Карма: 27
еще раз


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 13:29 
Не в сети
Клиент

Зарегистрирован: 25 ноя 2007, 22:48
Сообщения: 472
Карма: 8
Октябрь, Ноябрь начисление прошло нормально, а при попытке провести начисление в декабре, процесс шедулера загрузил проц в 100% и подвис:

Код:
root@bill:/usr/local/BGBillingServer# grep pool-1-thread-3 /usr/local/BGBillingServer/log/scheduler.log
12-03/11:20:26  INFO [pool-1-thread-3] Recalculator - PaymentRecalculator time: 02.12.2012 00


Сервер: вер. 5.1 сборка 836 от 08.11.2012 14:14:54
os: Linux; java: Java HotSpot(TM) Server VM, v.1.6.0_30

drweb вер. 5.1 сборка 79 от 03.12.2012 13:09:39


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 13:37 
Не в сети
Разработчик

Зарегистрирован: 27 мар 2008, 17:10
Сообщения: 301
Карма: 27
что выдаст ?
SELECT max(t1.date_log) as dtl, t1.id FROM drweb_contract_agent_log_139 AS t1 INNER JOIN drweb_contract_agent_139 AS t2 ON t1.id=t2.id WHERE t1.status = 1 AND t1.date_log>='2012-11-01 00:00:00' AND t1.date_log<='2013-01-01 00:00:00' AND t1.expires>='2012-12-01 00:00:00' AND t1.expires<='2013-01-01 00:00:00' GROUP BY t1.id


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 13:39 
Не в сети
Клиент

Зарегистрирован: 25 ноя 2007, 22:48
Сообщения: 472
Карма: 8
Код:
mysql> SELECT max(t1.date_log) as dtl, t1.id FROM drweb_contract_agent_log_9 AS t1 INNER JOIN drweb_contract_agent_9 AS t2 ON t1.id=t2.id WHERE t1.status = 1 AND t1.date_log>='2012-11-01 00:00:00' AND t1.date_log<='2013-01-01 00:00:00' AND t1.expires>='2012-12-01 00:00:00' AND t1.expires<='2013-01-01 00:00:00' GROUP BY t1.id;
+---------------------+-----+
| dtl                 | id  |
+---------------------+-----+
| 2012-12-01 01:02:08 |   8 |
| 2012-12-01 01:02:08 |  12 |
| 2012-12-01 01:02:09 |  14 |
| 2012-12-01 01:02:09 |  15 |
| 2012-12-01 01:02:10 |  17 |
| 2012-12-01 01:02:11 |  27 |
| 2012-12-01 01:02:11 |  32 |
| 2012-12-01 01:02:12 |  33 |
| 2012-12-01 01:02:13 |  46 |
| 2012-12-01 01:02:13 |  47 |
| 2012-12-01 01:02:15 |  50 |
| 2012-12-01 01:02:16 |  71 |
| 2012-12-01 01:02:16 |  74 |
| 2012-12-01 01:02:17 |  82 |
| 2012-12-01 01:02:18 |  83 |
| 2012-12-01 01:02:18 |  85 |
| 2012-12-01 01:02:19 |  88 |
| 2012-12-01 01:02:21 |  99 |
| 2012-12-01 01:02:22 | 104 |
| 2012-12-01 01:02:25 | 116 |
| 2012-12-01 01:02:25 | 117 |
| 2012-12-01 01:02:26 | 119 |
| 2012-12-01 01:02:26 | 122 |
| 2012-12-01 01:02:27 | 124 |
| 2012-12-01 01:02:28 | 130 |
| 2012-12-01 01:02:28 | 131 |
| 2012-12-01 01:02:29 | 136 |
| 2012-12-01 01:02:30 | 137 |
| 2012-12-01 01:02:30 | 138 |
| 2012-12-01 01:02:31 | 139 |
| 2012-12-01 01:02:32 | 140 |
| 2012-12-01 01:02:32 | 141 |
| 2012-12-01 01:02:34 | 148 |
| 2012-12-01 01:02:34 | 149 |
| 2012-12-01 01:02:35 | 150 |
| 2012-12-01 01:02:35 | 152 |
| 2012-12-01 01:02:36 | 153 |
| 2012-12-01 01:02:37 | 155 |
| 2012-12-01 01:02:37 | 156 |
| 2012-12-01 01:02:38 | 158 |
| 2012-12-01 01:02:38 | 163 |
| 2012-12-01 01:02:39 | 165 |
| 2012-12-01 01:02:40 | 167 |
| 2012-12-01 01:02:41 | 171 |
| 2012-12-01 01:02:42 | 172 |
| 2012-12-01 01:02:42 | 173 |
| 2012-12-01 01:02:43 | 174 |
| 2012-12-01 01:02:43 | 175 |
| 2012-12-01 01:02:44 | 177 |
| 2012-12-01 01:02:44 | 178 |
| 2012-12-01 01:02:45 | 179 |
| 2012-12-01 01:02:45 | 182 |
| 2012-12-01 01:02:46 | 184 |
| 2012-12-01 01:02:49 | 191 |
| 2012-12-01 01:02:50 | 193 |
| 2012-12-01 01:02:51 | 196 |
| 2012-12-01 01:02:51 | 197 |
| 2012-12-01 01:02:53 | 200 |
| 2012-12-01 01:02:53 | 201 |
| 2012-12-01 01:02:54 | 205 |
| 2012-12-01 01:02:54 | 207 |
| 2012-12-01 01:02:55 | 209 |
| 2012-12-01 01:02:56 | 210 |
| 2012-12-01 01:02:56 | 211 |
| 2012-12-01 01:02:57 | 212 |
| 2012-12-01 01:03:00 | 216 |
| 2012-12-01 01:03:01 | 218 |
| 2012-12-01 01:03:02 | 223 |
| 2012-12-01 01:03:02 | 224 |
| 2012-12-01 01:03:03 | 225 |
| 2012-12-01 01:03:03 | 227 |
| 2012-12-01 01:03:04 | 228 |
| 2012-12-01 01:03:04 | 229 |
| 2012-12-01 01:03:05 | 230 |
| 2012-12-01 01:03:06 | 231 |
| 2012-12-01 01:03:06 | 232 |
| 2012-12-01 01:03:07 | 233 |
| 2012-12-01 01:03:07 | 234 |
| 2012-12-01 01:03:09 | 237 |
| 2012-11-04 00:32:36 | 248 |
| 2012-11-03 20:51:25 | 249 |
| 2012-11-04 00:17:09 | 250 |
| 2012-11-04 00:37:40 | 251 |
| 2012-11-05 00:30:05 | 252 |
| 2012-11-04 23:22:38 | 253 |
| 2012-11-07 10:36:08 | 254 |
| 2012-11-07 13:21:54 | 255 |
| 2012-11-07 14:32:09 | 256 |
| 2012-11-07 14:53:31 | 257 |
| 2012-11-07 14:58:50 | 258 |
| 2012-11-07 15:35:36 | 259 |
| 2012-11-08 01:02:22 | 260 |
| 2012-11-09 15:00:14 | 261 |
| 2012-11-09 15:02:32 | 262 |
| 2012-11-11 10:19:11 | 263 |
| 2012-11-11 19:55:53 | 264 |
| 2012-11-14 23:12:30 | 265 |
| 2012-11-22 12:17:54 | 266 |
| 2012-11-24 16:49:33 | 267 |
| 2012-11-24 17:02:23 | 268 |
| 2012-11-28 12:46:24 | 269 |
| 2012-11-29 17:00:56 | 270 |
| 2012-11-29 17:06:32 | 271 |
| 2012-11-30 13:08:30 | 272 |
| 2012-11-30 15:36:19 | 273 |
+---------------------+-----+
105 rows in set (0.02 sec)


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 14:01 
Не в сети
Разработчик

Зарегистрирован: 27 мар 2008, 17:10
Сообщения: 301
Карма: 27
хм, переведите логив в debug и попробуйте еще раз переначислить


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 14:07 
Не в сети
Клиент

Зарегистрирован: 25 ноя 2007, 22:48
Сообщения: 472
Карма: 8
Уже пробовал, ошибок в логе нет, а процесс подвисает:

Код:
12-03/11:33:44  INFO [Thread-10] TaskRunProcessor - Running Task: ru.bitel.bgbilling.modules.drweb.server.tasks.Recalculator@1d6747b
12-03/11:33:44  INFO [pool-1-thread-1] Recalculator - PaymentRecalculator time: 02.12.2012 00
12-03/11:33:44  INFO [pool-1-thread-1] Setup - Load config for mid=9
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:08 agent id = [agentUUID=3b34acc2-0c11-457c-a5b1-3a4ed7130997, pswd=null, description=11112311_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=3b34acc2-0c11-457c-a5b1-3a4ed7130997, cid=13337, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=5, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:08 agent id = [agentUUID=2d23c017-dd44-47ed-95ef-9bc958b9317d, pswd=null, description=11110564_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=2d23c017-dd44-47ed-95ef-9bc958b9317d, cid=11585, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=5, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:09 agent id = [agentUUID=851f7368-1086-4afb-8e79-0c7fa9c99af4, pswd=null, description=11112779_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=851f7368-1086-4afb-8e79-0c7fa9c99af4, cid=13805, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:09 agent id = [agentUUID=6cdbb61e-e7cb-4eab-988a-ebbea49b162e, pswd=null, description=11092966_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=6cdbb61e-e7cb-4eab-988a-ebbea49b162e, cid=2819, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:10 agent id = [agentUUID=b76938ac-541e-4859-ac37-d6016a49b156, pswd=null, description=13100231_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=b76938ac-541e-4859-ac37-d6016a49b156, cid=9558, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:11 agent id = [agentUUID=b84c7c18-88d2-4db3-b17c-2a490c2f7a89, pswd=null, description=11071306_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=b84c7c18-88d2-4db3-b17c-2a490c2f7a89, cid=552, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:11 agent id = [agentUUID=a2a0799d-8650-458e-8154-a5d27dbf2170, pswd=null, description=11112541_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=a2a0799d-8650-458e-8154-a5d27dbf2170, cid=13567, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:12 agent id = [agentUUID=d698b42b-f562-4732-b2bf-b8044b59be2b, pswd=null, description=11112541_1, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=d698b42b-f562-4732-b2bf-b8044b59be2b, cid=13567, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:13 agent id = [agentUUID=71b41ca4-7c02-42ef-844d-6240da9b23a4, pswd=null, description=11100107_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=71b41ca4-7c02-42ef-844d-6240da9b23a4, cid=5181, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:13 agent id = [agentUUID=0d3241a0-39f7-44d7-88d7-39f56a589dcd, pswd=null, description=11111225_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=0d3241a0-39f7-44d7-88d7-39f56a589dcd, cid=12247, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=5, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:15 agent id = [agentUUID=bb3d8c37-b3d9-4cde-8d89-8748019983e8, pswd=null, description=11100884_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=bb3d8c37-b3d9-4cde-8d89-8748019983e8, cid=5966, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:16 agent id = [agentUUID=243248c4-5bfe-4b12-92c0-489964e2d77f, pswd=null, description=11112944_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=243248c4-5bfe-4b12-92c0-489964e2d77f, cid=13971, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:16 agent id = [agentUUID=97e83330-6747-440b-b2bf-faa08ab3542e, pswd=null, description=11101375_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=97e83330-6747-440b-b2bf-faa08ab3542e, cid=6461, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:17 agent id = [agentUUID=ef829ccf-6f47-4f70-a06e-a80b54943c52, pswd=null, description=11111871_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=ef829ccf-6f47-4f70-a06e-a80b54943c52, cid=12895, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:18 agent id = [agentUUID=ffe307d4-5876-4134-a5ee-7458d5b18a99, pswd=null, description=11111871_1, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=ffe307d4-5876-4134-a5ee-7458d5b18a99, cid=12895, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:18 agent id = [agentUUID=5c8ef1f3-c05b-414a-a6a1-f03919b61af0, pswd=null, description=11120708_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=5c8ef1f3-c05b-414a-a6a1-f03919b61af0, cid=14819, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:19 agent id = [agentUUID=154f3e1f-17cc-45c1-abc5-2dabe2be40b1, pswd=null, description=11100192_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=154f3e1f-17cc-45c1-abc5-2dabe2be40b1, cid=5266, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:21 agent id = [agentUUID=12b93e8c-12b2-4f87-a64d-277e11f5abfe, pswd=null, description=11120938_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=12b93e8c-12b2-4f87-a64d-277e11f5abfe, cid=15049, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:22 agent id = [agentUUID=8b9d87df-05f0-4d42-a78f-578258b7c2f9, pswd=null, description=11121197_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=8b9d87df-05f0-4d42-a78f-578258b7c2f9, cid=15315, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:25 agent id = [agentUUID=ab0b7794-6bd8-4f17-9602-63b16d9f0774, pswd=null, description=11110314_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=ab0b7794-6bd8-4f17-9602-63b16d9f0774, cid=11335, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:25 agent id = [agentUUID=4ff6bbc2-cdfb-4696-96af-cff97b7cd997, pswd=null, description=11094283_2, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=4ff6bbc2-cdfb-4696-96af-cff97b7cd997, cid=4193, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:26 agent id = [agentUUID=0a373929-dd6c-43aa-b0ea-171f43db2447, pswd=null, description=11120716_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=0a373929-dd6c-43aa-b0ea-171f43db2447, cid=14827, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:26 agent id = [agentUUID=2f033830-0c47-488f-bcc8-d5aa90358bff, pswd=null, description=11113072_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=2f033830-0c47-488f-bcc8-d5aa90358bff, cid=14099, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:27 agent id = [agentUUID=21e4f4a9-cafa-48da-b3fd-f98c5f31ca9d, pswd=null, description=11102013_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=21e4f4a9-cafa-48da-b3fd-f98c5f31ca9d, cid=7107, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:28 agent id = [agentUUID=bc75be47-8415-47d0-8c32-224e7c2a4da7, pswd=null, description=13070236_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=bc75be47-8415-47d0-8c32-224e7c2a4da7, cid=8684, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:28 agent id = [agentUUID=74342669-c0ac-4522-92f5-10f40dd94ca8, pswd=null, description=11082572_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=74342669-c0ac-4522-92f5-10f40dd94ca8, cid=2411, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:29 agent id = [agentUUID=0a285a9c-990b-4274-905a-15971efc3b26, pswd=null, description=11121745_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=0a285a9c-990b-4274-905a-15971efc3b26, cid=15884, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=5, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:30 agent id = [agentUUID=e8d61342-7713-47b0-aded-01413a5a0160, pswd=null, description=11121589_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=e8d61342-7713-47b0-aded-01413a5a0160, cid=15723, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:30 agent id = [agentUUID=50d84c29-e7ed-417a-83ba-a9d094c0d259, pswd=null, description=11120693_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=50d84c29-e7ed-417a-83ba-a9d094c0d259, cid=14804, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:31 agent id = [agentUUID=d026be72-c545-43aa-be2c-41f32dfec309, pswd=null, description=11071306_1, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=d026be72-c545-43aa-be2c-41f32dfec309, cid=552, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:32 agent id = [agentUUID=c8aee842-6508-4aeb-ba34-ddf27a681f0d, pswd=null, description=11121837_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=c8aee842-6508-4aeb-ba34-ddf27a681f0d, cid=15986, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:32 agent id = [agentUUID=f46a1512-73d1-4d62-ac83-6b92fbb3a04d, pswd=null, description=11121870_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=f46a1512-73d1-4d62-ac83-6b92fbb3a04d, cid=16021, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:34 agent id = [agentUUID=b3eb7500-2e13-46b2-b83a-b472d6b1ba42, pswd=null, description=11113074_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=b3eb7500-2e13-46b2-b83a-b472d6b1ba42, cid=14101, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:34 agent id = [agentUUID=e039d301-5bfc-484c-868c-a224a7b057c1, pswd=null, description=11113072_1, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=e039d301-5bfc-484c-868c-a224a7b057c1, cid=14099, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:35 agent id = [agentUUID=ffb5a717-c1fe-47d8-a0c0-cd037f17314d, pswd=null, description=11121981_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=ffb5a717-c1fe-47d8-a0c0-cd037f17314d, cid=16141, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:35 agent id = [agentUUID=4d308230-0ec3-4b5d-9b9e-86beaabde62f, pswd=null, description=13093002_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=4d308230-0ec3-4b5d-9b9e-86beaabde62f, cid=9265, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=5, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:36 agent id = [agentUUID=67797750-4bf3-4cd9-955d-4d35269e5be5, pswd=null, description=11120716_1, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=67797750-4bf3-4cd9-955d-4d35269e5be5, cid=14827, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:37 agent id = [agentUUID=1a420b7c-2a97-412c-8e12-8361da5fd299, pswd=null, description=13070236_1, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=1a420b7c-2a97-412c-8e12-8361da5fd299, cid=8684, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:37 agent id = [agentUUID=265f6e3c-ecad-410d-b7fc-d2aa190bd97f, pswd=null, description=11122159_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=265f6e3c-ecad-410d-b7fc-d2aa190bd97f, cid=16344, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:38 agent id = [agentUUID=e6d29649-71bc-4f2c-8d59-0b2755d0a69c, pswd=null, description=11122122_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=e6d29649-71bc-4f2c-8d59-0b2755d0a69c, cid=16300, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:38 agent id = [agentUUID=3241eff1-893c-4897-aa2b-1e4a659aa441, pswd=null, description=11110206_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=3241eff1-893c-4897-aa2b-1e4a659aa441, cid=7383, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:39 agent id = [agentUUID=1a666834-ecdf-44fa-b45a-0d32161aa577, pswd=null, description=11122209_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=1a666834-ecdf-44fa-b45a-0d32161aa577, cid=16396, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:40 agent id = [agentUUID=6b2c0b79-b8a5-4fc5-9c0d-ebca8848aabd, pswd=null, description=11122317_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=6b2c0b79-b8a5-4fc5-9c0d-ebca8848aabd, cid=16517, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:41 agent id = [agentUUID=106e54c4-ba46-4be8-8998-e23a883cf97c, pswd=null, description=11121400_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=106e54c4-ba46-4be8-8998-e23a883cf97c, cid=15529, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:42 agent id = [agentUUID=9efa923b-bc10-4c45-927c-87b2e3780538, pswd=null, description=11122394_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=9efa923b-bc10-4c45-927c-87b2e3780538, cid=16602, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:42 agent id = [agentUUID=9aa27bf7-0c0c-4719-bdcd-6c0ff1cd144b, pswd=null, description=11122394_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=9aa27bf7-0c0c-4719-bdcd-6c0ff1cd144b, cid=16602, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:43 agent id = [agentUUID=ac6648ea-f21e-4c61-ac2d-7bff85e78229, pswd=null, description=11120827_7, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=ac6648ea-f21e-4c61-ac2d-7bff85e78229, cid=14938, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=5, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:43 agent id = [agentUUID=4913eff5-dd89-4153-a4c1-4322d9d7c40e, pswd=null, description=11082672_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=4913eff5-dd89-4153-a4c1-4322d9d7c40e, cid=2518, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:44 agent id = [agentUUID=4d4f3182-fac7-4bfd-b0d3-26869dd674d5, pswd=null, description=11081664_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=4d4f3182-fac7-4bfd-b0d3-26869dd674d5, cid=749, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:44 agent id = [agentUUID=94774532-42a7-43fa-9273-3ec763a645a0, pswd=null, description=11111168_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=94774532-42a7-43fa-9273-3ec763a645a0, cid=12190, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:45 agent id = [agentUUID=b5096287-90aa-4a9e-965f-b4830e4efe76, pswd=null, description=11121045_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=b5096287-90aa-4a9e-965f-b4830e4efe76, cid=15156, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:45 agent id = [agentUUID=160476ec-9b55-489d-b320-01b3478f2429, pswd=null, description=11100057_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=160476ec-9b55-489d-b320-01b3478f2429, cid=5131, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:46 agent id = [agentUUID=56131625-358c-45b7-a85a-22b4e1c225e5, pswd=null, description=11112311_1, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=56131625-358c-45b7-a85a-22b4e1c225e5, cid=13337, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:49 agent id = [agentUUID=83b1b1bb-ecf3-4904-8002-52aa0afb2c06, pswd=null, description=11122412_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=83b1b1bb-ecf3-4904-8002-52aa0afb2c06, cid=16622, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:50 agent id = [agentUUID=1ac993df-5678-49b6-9ca1-7fff825f2993, pswd=null, description=13092206_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=1ac993df-5678-49b6-9ca1-7fff825f2993, cid=8522, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:51 agent id = [agentUUID=21eff87d-72fa-4293-b09c-be8559f74775, pswd=null, description=11121953_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=21eff87d-72fa-4293-b09c-be8559f74775, cid=16108, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:51 agent id = [agentUUID=61708b37-f63f-42a1-b5a0-c244e91dabd0, pswd=null, description=11122742_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=61708b37-f63f-42a1-b5a0-c244e91dabd0, cid=16916, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:53 agent id = [agentUUID=cabd62c0-2f23-4875-a822-0ba859fcc6f8, pswd=null, description=11122776_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=cabd62c0-2f23-4875-a822-0ba859fcc6f8, cid=16955, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:53 agent id = [agentUUID=dcb1efe2-63b9-4691-9841-ba2f41642e28, pswd=null, description=11122785_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=dcb1efe2-63b9-4691-9841-ba2f41642e28, cid=16964, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:54 agent id = [agentUUID=621273f5-d334-4977-99e4-01e81ece0fbe, pswd=null, description=11122839_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=621273f5-d334-4977-99e4-01e81ece0fbe, cid=17023, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:54 agent id = [agentUUID=da0c0df0-b955-4f1e-9fa8-2be39602b264, pswd=null, description=13100134_2, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=da0c0df0-b955-4f1e-9fa8-2be39602b264, cid=9459, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:55 agent id = [agentUUID=a93d1093-251f-4326-879d-90517cd0f143, pswd=null, description=11121604_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=a93d1093-251f-4326-879d-90517cd0f143, cid=15738, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:56 agent id = [agentUUID=b327d33f-26c7-460d-a798-0ffb9cd1a4b9, pswd=null, description=11101683_1, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=b327d33f-26c7-460d-a798-0ffb9cd1a4b9, cid=6773, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:56 agent id = [agentUUID=e79b2724-81ad-4eed-980c-1bdf10332e61, pswd=null, description=11122982_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=e79b2724-81ad-4eed-980c-1bdf10332e61, cid=17182, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:57 agent id = [agentUUID=5c5b2d82-a69f-4ae7-a538-52c7c7e69898, pswd=null, description=11112541_2, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=5c5b2d82-a69f-4ae7-a538-52c7c7e69898, cid=13567, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=5, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:03:00 agent id = [agentUUID=9313f0ce-8ef2-4c38-8ab0-856fabfae7ef, pswd=null, description=11120256_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=9313f0ce-8ef2-4c38-8ab0-856fabfae7ef, cid=14367, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=false]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:03:01 agent id = [agentUUID=99b0a44a-95b5-4223-b7ab-34e0b3c9cdfa, pswd=null, description=13092712_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=99b0a44a-95b5-4223-b7ab-34e0b3c9cdfa, cid=9000, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:03:02 agent id = [agentUUID=b18ce50f-0785-42b6-89ac-8b4533ad7594, pswd=null, description=13100892_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=b18ce50f-0785-42b6-89ac-8b4533ad7594, cid=10243, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:03:02 agent id = [agentUUID=73429ce4-d077-46ed-9bc6-0767bc2e9d68, pswd=null, description=13100892_1, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=73429ce4-d077-46ed-9bc6-0767bc2e9d68, cid=10243, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:03:03 agent id = [agentUUID=1269b22a-e591-4a24-b777-02ca145e4dae, pswd=null, description=13100892_2, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=1269b22a-e591-4a24-b777-02ca145e4dae, cid=10243, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:03:03 agent id = [agentUUID=3a74e64b-fae3-4a51-92a0-40ab383455a2, pswd=null, description=11123427_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=3a74e64b-fae3-4a51-92a0-40ab383455a2, cid=17688, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:03:04 agent id = [agentUUID=75ed255f-f803-48b3-9d10-20726a1a9a56, pswd=null, description=11123445_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=75ed255f-f803-48b3-9d10-20726a1a9a56, cid=17709, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:03:04 agent id = [agentUUID=5295077f-608a-4011-b2f7-d7e4fb039bfa, pswd=null, description=11120668_4, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=5295077f-608a-4011-b2f7-d7e4fb039bfa, cid=14779, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:03:05 agent id = [agentUUID=92194bdd-e40b-4cda-9e61-2a2f04ee369d, pswd=null, description=11120400_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=92194bdd-e40b-4cda-9e61-2a2f04ee369d, cid=14511, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:03:06 agent id = [agentUUID=02c0b2bd-1955-4fb7-ae00-92c78b64592c, pswd=null, description=11123392_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=02c0b2bd-1955-4fb7-ae00-92c78b64592c, cid=17651, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:03:06 agent id = [agentUUID=4988cdbb-6112-4118-ba05-872123d3ba79, pswd=null, description=11113072_2, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=4988cdbb-6112-4118-ba05-872123d3ba79, cid=14099, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:03:07 agent id = [agentUUID=ba61190b-227d-4d25-8e30-a64f0d93b7cc, pswd=null, description=11123465_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=ba61190b-227d-4d25-8e30-a64f0d93b7cc, cid=17730, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=5, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:03:07 agent id = [agentUUID=e2285162-b34c-4973-b36c-f1b7a1c3b6e3, pswd=null, description=11123465_1, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=e2285162-b34c-4973-b36c-f1b7a1c3b6e3, cid=17730, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:03:09 agent id = [agentUUID=12b01e8f-cdc8-4978-9cf0-5c5b28d06263, pswd=null, description=11123572_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=12b01e8f-cdc8-4978-9cf0-5c5b28d06263, cid=17842, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=false, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=00:32:36 agent id = [agentUUID=3667ec03-96d2-4d62-bc5c-7b537849a1e0, pswd=null, description=11122592_2, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=3667ec03-96d2-4d62-bc5c-7b537849a1e0, cid=16752, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=2, lock=false, tariffId=3, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=20:51:25 agent id = [agentUUID=b4472f1e-52e2-4cc8-9b08-662af9fcc279, pswd=null, description=11123677_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=b4472f1e-52e2-4cc8-9b08-662af9fcc279, cid=17964, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=00:17:09 agent id = [agentUUID=b1fe47da-4707-4bf0-bab6-adbf4024f335, pswd=null, description=11122592_3, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=b1fe47da-4707-4bf0-bab6-adbf4024f335, cid=16752, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=00:37:40 agent id = [agentUUID=309477a4-9070-4493-aab9-63f4af62c843, pswd=null, description=11122592_4, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=309477a4-9070-4493-aab9-63f4af62c843, cid=16752, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=2, lock=false, tariffId=6, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=00:30:05 agent id = [agentUUID=0b513161-d679-4f60-a00b-fd1d73ac432e, pswd=null, description=11111785_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=0b513161-d679-4f60-a00b-fd1d73ac432e, cid=12809, expires=2012-12-31, blockBegin=2013-01-01, blockEnd=2013-02-28, status=1, nextStatus=1, lock=false, tariffId=6, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=23:22:38 agent id = [agentUUID=babaf940-5f1a-4cb5-a456-3c64e6abc16e, pswd=null, description=11111785_1, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=babaf940-5f1a-4cb5-a456-3c64e6abc16e, cid=12809, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=10:36:08 agent id = [agentUUID=d44eb65a-195a-476a-b510-92cdebc3343b, pswd=null, description=1500_10, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=d44eb65a-195a-476a-b510-92cdebc3343b, cid=13068, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=13:21:54 agent id = [agentUUID=f22ec2bf-b429-43b1-8e16-2b6527a27be2, pswd=null, description=11123121_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=f22ec2bf-b429-43b1-8e16-2b6527a27be2, cid=17345, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=2, lock=false, tariffId=3, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=14:32:09 agent id = [agentUUID=9551d292-5611-487a-a882-0c20eb8ea6a6, pswd=null, description=11123721_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=9551d292-5611-487a-a882-0c20eb8ea6a6, cid=18013, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=14:53:31 agent id = [agentUUID=bc70df33-18ce-4e0e-ae6a-822fcaf0ccc6, pswd=null, description=11123721_1, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=bc70df33-18ce-4e0e-ae6a-822fcaf0ccc6, cid=18013, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=14:58:50 agent id = [agentUUID=6c7f89a7-3387-4cae-8d34-a04e754f1a85, pswd=null, description=11123721_2, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=6c7f89a7-3387-4cae-8d34-a04e754f1a85, cid=18013, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=15:35:36 agent id = [agentUUID=cd46447a-c006-4d0a-8cd9-fbad58aebfd0, pswd=null, description=11123721_3, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=cd46447a-c006-4d0a-8cd9-fbad58aebfd0, cid=18013, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=01:02:22 agent id = [agentUUID=ff41b3c9-91e3-4ca0-89f5-2904f23a5b9d, pswd=null, description=11123723_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=ff41b3c9-91e3-4ca0-89f5-2904f23a5b9d, cid=18015, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=15:00:14 agent id = [agentUUID=4417a8ae-fa05-4b36-b97a-bbfbf74fa189, pswd=null, description=11123416_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=4417a8ae-fa05-4b36-b97a-bbfbf74fa189, cid=17676, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=15:02:32 agent id = [agentUUID=d202e241-d281-44d1-83c3-7f6847180898, pswd=null, description=11123416_1, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=d202e241-d281-44d1-83c3-7f6847180898, cid=17676, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=10:19:11 agent id = [agentUUID=58a53bc4-3c3a-409d-9d71-f46d144c46c4, pswd=null, description=11070547_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=58a53bc4-3c3a-409d-9d71-f46d144c46c4, cid=1246, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=19:55:53 agent id = [agentUUID=66fe8b1a-1627-47ef-bb0a-0fe7e1d49889, pswd=null, description=11111533_2, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=66fe8b1a-1627-47ef-bb0a-0fe7e1d49889, cid=12555, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=23:12:30 agent id = [agentUUID=2cb94e41-7bd2-4300-9e5c-5e5f834a4177, pswd=null, description=13080850_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=2cb94e41-7bd2-4300-9e5c-5e5f834a4177, cid=11172, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=12:17:54 agent id = [agentUUID=ade13024-5d2f-453d-a6e5-bd0c9f52cfd0, pswd=null, description=11093865_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=ade13024-5d2f-453d-a6e5-bd0c9f52cfd0, cid=3744, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=16:49:33 agent id = [agentUUID=dcffdc9a-1121-4c40-8127-10468041cad9, pswd=null, description=11123786_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=dcffdc9a-1121-4c40-8127-10468041cad9, cid=18083, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=17:02:23 agent id = [agentUUID=6bd21693-9f00-438b-81e7-853efe122eaa, pswd=null, description=11123786_1, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=6bd21693-9f00-438b-81e7-853efe122eaa, cid=18083, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=12:46:24 agent id = [agentUUID=4210c442-f05e-43b6-a199-dca939c3a6cc, pswd=null, description=11123996_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=4210c442-f05e-43b6-a199-dca939c3a6cc, cid=18324, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=17:00:56 agent id = [agentUUID=d1a03bd3-9316-445f-b4da-a6c6fd2554d1, pswd=null, description=11124018_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=d1a03bd3-9316-445f-b4da-a6c6fd2554d1, cid=18354, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=17:06:32 agent id = [agentUUID=140b85ee-4416-4ed1-85b9-7d6e8faa50b9, pswd=null, description=11124018_1, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=140b85ee-4416-4ed1-85b9-7d6e8faa50b9, cid=18354, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=6, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=13:08:30 agent id = [agentUUID=a4e7087b-d4f1-446c-9caa-699df76febf9, pswd=null, description=11123981_0, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=a4e7087b-d4f1-446c-9caa-699df76febf9, cid=18303, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] AgentAVDManager - date_log=15:36:19 agent id = [agentUUID=74c1e722-cb34-4b8f-8a04-7e5da0802d47, pswd=null, description=11123981_1, url=http://drweb.xxxxxx.ru:9080/download/download.ds?id=74c1e722-cb34-4b8f-8a04-7e5da0802d47, cid=18303, expires=2012-12-31, blockBegin=null, blockEnd=null, status=1, nextStatus=0, lock=false, tariffId=3, nextTariffId=-1, graceperiod=true, tariffTitle=null, nextTariffTitle=null, newAgent=true]
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>13337; agentId=>8; cost=79.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>11585; agentId=>12; cost=79.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>13805; agentId=>14; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>2819; agentId=>15; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>9558; agentId=>17; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>552; agentId=>27; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>13567; agentId=>32; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>13567; agentId=>33; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>5181; agentId=>46; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>12247; agentId=>47; cost=79.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>5966; agentId=>50; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>13971; agentId=>71; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>6461; agentId=>74; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>12895; agentId=>82; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>12895; agentId=>83; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>14819; agentId=>85; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>5266; agentId=>88; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>15049; agentId=>99; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>15315; agentId=>104; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>11335; agentId=>116; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>4193; agentId=>117; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>14827; agentId=>119; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>14099; agentId=>122; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>7107; agentId=>124; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>8684; agentId=>130; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>2411; agentId=>131; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>15884; agentId=>136; cost=79.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>15723; agentId=>137; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>14804; agentId=>138; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>552; agentId=>139; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>15986; agentId=>140; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>16021; agentId=>141; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>14101; agentId=>148; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>14099; agentId=>149; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>16141; agentId=>150; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>9265; agentId=>152; cost=79.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>14827; agentId=>153; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>8684; agentId=>155; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>16344; agentId=>156; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>16300; agentId=>158; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>7383; agentId=>163; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>16396; agentId=>165; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>16517; agentId=>167; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>15529; agentId=>171; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>16602; agentId=>172; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>16602; agentId=>173; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>14938; agentId=>174; cost=79.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>2518; agentId=>175; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>749; agentId=>177; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>12190; agentId=>178; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>15156; agentId=>179; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>5131; agentId=>182; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>13337; agentId=>184; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>16622; agentId=>191; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>8522; agentId=>193; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>16108; agentId=>196; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>16916; agentId=>197; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>16955; agentId=>200; cost=69.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>16964; agentId=>201; cost=89.0
12-03/11:33:44 DEBUG [pool-1-thread-1] Calculator - cid=>17023; agentId=>205; cost=69.0
12-03/11:34:04 DEBUG [Thread-6] TaskExecuter - Looking tasks



Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 14:15 
Не в сети
Разработчик

Зарегистрирован: 27 мар 2008, 17:10
Сообщения: 301
Карма: 27
смотрим договор для агента id 207
точнее что там в тарифе у этого договора


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 14:24 
Не в сети
Клиент

Зарегистрирован: 25 ноя 2007, 22:48
Сообщения: 472
Карма: 8
Вложение:
agent_id205.jpg


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 14:26 
Не в сети
Разработчик

Зарегистрирован: 27 мар 2008, 17:10
Сообщения: 301
Карма: 27
Да нет, сам тарифный план.


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 14:42 
Не в сети
Клиент

Зарегистрирован: 25 ноя 2007, 22:48
Сообщения: 472
Карма: 8
Вложение:
tarif.jpg

Вложение:
tarif_dr.web.jpg


Все тарифы Dr.Web являются расширением от базового.


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 15:05 
Не в сети
Разработчик

Зарегистрирован: 27 мар 2008, 17:10
Сообщения: 301
Карма: 27
И в договоре тариф действует весь период?
В этом договоре я так понимаю щас нет наработки за декабрь, а если перезапустить только его перерасчет, появиться или опять повесит процессор?


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 16:05 
Не в сети
Клиент

Зарегистрирован: 25 ноя 2007, 22:48
Сообщения: 472
Карма: 8
При начислении по конкретному договору, вываливается ошибка:

Код:
12-03/14:04:11  INFO [Thread-10] TaskRunProcessor - Running Task: ru.bitel.bgbilling.modules.drweb.server.tasks.Recalculator@ccd
12-03/14:04:11  INFO [pool-1-thread-1] Recalculator - PaymentRecalculator time: 02.12.2012 00
12-03/14:04:11  INFO [pool-1-thread-1] Setup - Load config for mid=9
12-03/14:04:11 ERROR [pool-1-thread-1] AgentAVDManager -
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'expires' in where clause is ambiguous
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.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.executeQuery(PreparedStatement.java:1912)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
        at ru.bitel.bgbilling.modules.drweb.server.bean.AgentAVDManager.getListById(AgentAVDManager.java:362)
        at ru.bitel.bgbilling.modules.drweb.server.tasks.Calculator.getAgentList(Calculator.java:169)
        at ru.bitel.bgbilling.modules.drweb.server.tasks.Calculator.executeTask(Calculator.java:64)
        at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:63)
        at ru.bitel.bgbilling.kernel.task.server.TaskBase.startTask(TaskBase.java:99)
        at ru.bitel.bgbilling.modules.drweb.server.tasks.Recalculator.executeTask(Recalculator.java:52)
        at bitel.billing.server.task.bean.RunTask.run(RunTask.java:40)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)
12-03/14:04:11  INFO [pool-1-thread-1] Calculator - Setting balances for independ and subs..
12-03/14:04:11  INFO [pool-1-thread-1] Calculator - Selected.
12-03/14:04:11  INFO [pool-1-thread-1] Calculator - Selecting sub account
12-03/14:04:11  INFO [pool-1-thread-1] Calculator - Selected.
12-03/14:04:11  INFO [pool-1-thread-1] Calculator - Setting balance for super..
12-03/14:04:11  INFO [pool-1-thread-1] Calculator - Selected.
12-03/14:04:11  INFO [pool-1-thread-1] Calculator - Task finished time=16 ms.


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 17:39 
Не в сети
Разработчик

Зарегистрирован: 27 мар 2008, 17:10
Сообщения: 301
Карма: 27
обновитесаь


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 17:50 
Не в сети
Клиент

Зарегистрирован: 25 ноя 2007, 22:48
Сообщения: 472
Карма: 8
После обновления начисление по одному договору с id агента = 205 прошло успешно.
Для всего списка - зависает.


Последний раз редактировалось iONE 03 дек 2012, 18:01, всего редактировалось 1 раз.

Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 03 дек 2012, 17:56 
Не в сети
Клиент

Зарегистрирован: 25 ноя 2007, 22:48
Сообщения: 472
Карма: 8
На самом деле ранее делал начисление по агенту с id=205,а повисает при попытке сделать начисление для договора с id=9459, id агентов 202,206,207.

Вот контракт с этими агентами:
Вложение:
agent_id207.jpg


Договор был закрыт 30.11.2012 в том числе и тариф.
Активировал тариф на этом контракте, начисление прошло успешно.

Сделайте проверку для такой ситуации.


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: Exception: Column 'expires' in where clause is ambiguous
СообщениеДобавлено: 06 дек 2012, 14:02 
Не в сети
Разработчик

Зарегистрирован: 27 мар 2008, 17:10
Сообщения: 301
Карма: 27
выложил обновление


Вернуться к началу
 Профиль  
 
Показать сообщения за:  Поле сортировки  
Начать новую тему Ответить на тему  [ Сообщений: 21 ] 

Часовой пояс: UTC + 5 часов [ Летнее время ]


Кто сейчас на конференции

Сейчас этот форум просматривают: нет зарегистрированных пользователей и гости: 1


Вы не можете начинать темы
Вы не можете отвечать на сообщения
Вы не можете редактировать свои сообщения
Вы не можете удалять свои сообщения
Вы не можете добавлять вложения

Найти:
Перейти:  
cron
POWERED_BY
Русская поддержка phpBB
[ Time : 0.152s | 60 Queries | GZIP : On ]