forum.bitel.ru http://forum.bitel.ru/ |
|
Закрыть все не закрывшиеся шлюзы http://forum.bitel.ru/viewtopic.php?f=7&t=9795 |
Страница 1 из 1 |
Автор: | mikos [ 03 окт 2014, 19:40 ] |
Заголовок сообщения: | Закрыть все не закрывшиеся шлюзы |
Коллеги, приветствую всех. Обнаружил, что часть шлюзов на железках не закрыто, хотя биллинг говорит закрыто. Если шлюзы передернуть у такого договора (открыть/закрыть) - все нормально закроется. По какой причине накое получилось - не знаю, возможно биллинг глюканул или еще что, сейчас это уже не важно. Вопрос - как теперь привести все шлюзы в соответствии с биллингом? Как закрыть то, что закрыто в биллинге? Задача синхронизации бежит каждый час, но шлюзы эти не закрывает. |
Автор: | skyb [ 07 окт 2014, 00:19 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
нужно как то найти эти договора, дальше можно просто передернуть шлюз или сделать с ним что то Код: int open = 0;
int closed = 1; AddressRangeManager adrRangeMan = new AddressRangeManager( con, IPN_MODULE_ID ); ModuleSetup ipnSetup = new ModuleSetup( con, IPN_MODULE_ID ); IPNContractStatusManager icsm = new IPNContractStatusManager (con, IPN_MODULE_ID, ipnSetup); icsm.changeStatus(cid, closed, 0, true); icsm.changeStatus(cid, open, 0, true); |
Автор: | stark [ 07 окт 2014, 10:59 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
какие шлюзы то? Обычно шлюзы сами должны проверять и если состояние с устройством изменилось, то исправляют. |
Автор: | barguzin2 [ 07 окт 2014, 20:40 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
логи нужно смотреть на предмет наличия ошибок. можно не ждать очередного часа, а просто выбрать из списка снова статус "Закрыт" и посмотреть что происходит как на стороне сервера, так и на стороне шлюза. а там уже делать выводы. может чего вскроется. |
Автор: | mikos [ 13 окт 2014, 21:29 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
barguzin2 писал(а): логи нужно смотреть на предмет наличия ошибок. можно не ждать очередного часа, а просто выбрать из списка снова статус "Закрыт" и посмотреть что происходит как на стороне сервера, так и на стороне шлюза. а там уже делать выводы. может чего вскроется. Так в том то и дело, что при ручном передергивании шлюзов у договора - все работает. |
Автор: | mikos [ 13 окт 2014, 21:34 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
stark писал(а): какие шлюзы то? Обычно шлюзы сами должны проверять и если состояние с устройством изменилось, то исправляют. Шлюзы скриптовые, Микротик по SSH. Еще раз убедился, что биллинг не проверяет состояние - удалил ручками все правила в микротике и биллинг НЕ ЗАЛИЛ их при следующей задаче. Пошел смотреть код шлюза. Он еще и со слейвом. Видать где-то накосячил... |
Автор: | mikos [ 13 окт 2014, 21:44 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
Хм, интересно, чтобы это могло быть? Код: 10-11/01:15:05 ERROR [pool-198-thread-2] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[16] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3646' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3646' com.mysql.jdbc.ServerPreparedStatement[17] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='380' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[18] - SELECT id, type, data FROM mtree_node WHERE parent_node='1240' com.mysql.jdbc.ServerPreparedStatement[19] - SELECT id, type, data FROM mtree_node WHERE parent_node='1243' com.mysql.jdbc.ServerPreparedStatement[20] - SELECT id, type, data FROM mtree_node WHERE parent_node='1244' com.mysql.jdbc.ServerPreparedStatement[22] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3443' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3443' com.mysql.jdbc.ServerPreparedStatement[23] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2074' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[24] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='4955' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='4955' com.mysql.jdbc.ServerPreparedStatement[25] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[26] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3690' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3690' com.mysql.jdbc.ServerPreparedStatement[27] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='380' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[28] - SELECT id, type, data FROM mtree_node WHERE parent_node='1240' com.mysql.jdbc.ServerPreparedStatement[29] - SELECT id, type, data FROM mtree_node WHERE parent_node='1243' com.mysql.jdbc.ServerPreparedStatement[30] - SELECT id, type, data FROM mtree_node WHERE parent_node='1244' com.mysql.jdbc.ServerPreparedStatement[31] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3497' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3497' com.mysql.jdbc.ServerPreparedStatement[32] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='380' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[33] - SELECT id, type, data FROM mtree_node WHERE parent_node='1240' com.mysql.jdbc.ServerPreparedStatement[34] - SELECT id, type, data FROM mtree_node WHERE parent_node='1243' com.mysql.jdbc.ServerPreparedStatement[35] - SELECT id, type, data FROM mtree_node WHERE parent_node='1244' com.mysql.jdbc.ServerPreparedStatement[36] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3527' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3527' com.mysql.jdbc.ServerPreparedStatement[37] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[38] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3539' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3539' com.mysql.jdbc.ServerPreparedStatement[39] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[40] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3693' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3693' com.mysql.jdbc.ServerPreparedStatement[41] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[42] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3475' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3475' com.mysql.jdbc.ServerPreparedStatement[43] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[44] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='4897' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='4897' com.mysql.jdbc.ServerPreparedStatement[45] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[46] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='4815' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='4815' com.mysql.jdbc.ServerPreparedStatement[47] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2102' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[48] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3824' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3824' com.mysql.jdbc.ServerPreparedStatement[49] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[50] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3452' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3452' com.mysql.jdbc.ServerPreparedStatement[51] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[52] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3441' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3441' com.mysql.jdbc.ServerPreparedStatement[53] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[54] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3438' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3438' com.mysql.jdbc.ServerPreparedStatement[55] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2073' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[56] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='4739' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='4739' com.mysql.jdbc.ServerPreparedStatement[57] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[58] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='4844' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='4844' com.mysql.jdbc.ServerPreparedStatement[59] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[60] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3487' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3487' com.mysql.jdbc.ServerPreparedStatement[61] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2074' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[62] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='4196' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='4196' com.mysql.jdbc.ServerPreparedStatement[63] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2102' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[64] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3459' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3459' com.mysql.jdbc.ServerPreparedStatement[65] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2102' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[66] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3583' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3583' com.mysql.jdbc.ServerPreparedStatement[67] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[68] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3989' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3989' com.mysql.jdbc.ServerPreparedStatement[69] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[70] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3608' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3608' com.mysql.jdbc.ServerPreparedStatement[71] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2102' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[72] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='4124' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='4124' com.mysql.jdbc.ServerPreparedStatement[73] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[74] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3454' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3454' com.mysql.jdbc.ServerPreparedStatement[75] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2103' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[76] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3543' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3543' com.mysql.jdbc.ServerPreparedStatement[77] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2102' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[78] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3802' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3802' com.mysql.jdbc.ServerPreparedStatement[79] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[80] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3554' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3554' com.mysql.jdbc.ServerPreparedStatement[81] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[82] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='4761' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='4761' com.mysql.jdbc.ServerPreparedStatement[83] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[84] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3460' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3460' com.mysql.jdbc.ServerPreparedStatement[85] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[86] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='4835' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='4835' com.mysql.jdbc.ServerPreparedStatement[87] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2184' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[88] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='4046' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='4046' com.mysql.jdbc.ServerPreparedStatement[89] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[90] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='4224' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='4224' com.mysql.jdbc.ServerPreparedStatement[91] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[92] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3440' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3440' com.mysql.jdbc.ServerPreparedStatement[93] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[94] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3444' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3444' com.mysql.jdbc.ServerPreparedStatement[95] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[96] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3437' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3437' com.mysql.jdbc.ServerPreparedStatement[97] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[98] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3458' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3458' com.mysql.jdbc.ServerPreparedStatement[99] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2102' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[100] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='4342' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='4342' com.mysql.jdbc.ServerPreparedStatement[101] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[102] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='4395' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='4395' com.mysql.jdbc.ServerPreparedStatement[103] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[104] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='4714' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='4714' com.mysql.jdbc.ServerPreparedStatement[105] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[106] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3439' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3439' com.mysql.jdbc.ServerPreparedStatement[107] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[108] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3860' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3860' com.mysql.jdbc.ServerPreparedStatement[109] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[110] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3937' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3937' com.mysql.jdbc.ServerPreparedStatement[111] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2102' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[112] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='4104' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='4104' com.mysql.jdbc.ServerPreparedStatement[113] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[114] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3846' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3846' com.mysql.jdbc.ServerPreparedStatement[115] - SELECT mtree_node.id FROM module_tariff_tree INNER JOIN mtree_node ON (module_tariff_tree.id=mtree_node.mtree_id) WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='2072' AND module_tariff_tree.mid='1' com.mysql.jdbc.ServerPreparedStatement[116] - SELECT contract_tree_link.tree_id FROM contract_tree_link WHERE (contract_tree_link.date1 is NULL OR contract_tree_link.date1<='2014-10-11') AND (contract_tree_link.date2 is NULL OR contract_tree_link.date2>='2014-10-11') AND contract_tree_link.cid='3436' UNION SELECT tariff_tree_link.tree_id FROM contract_tariff INNER JOIN tariff_tree_link ON (contract_tariff.tpid=tariff_tree_link.tpid) WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='2014-10-11') AND (contract_tariff.date2 is NULL OR contract_tariff.date2>='2014-10-11') AND contract_tariff.cid='3436' java.lang.RuntimeException at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:417) at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:47) at ru.bitel.bgbilling.server.util.ServerUtils.closeConnection(ServerUtils.java:568) at ru.bitel.bgbilling.server.util.ServerUtils.closeConnection(ServerUtils.java:550) at bitel.billing.server.ipn.GateWorker.run(GateWorker.java:129) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) 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) 10-11/01:15:05 INFO [pool-2-thread-9] Calculator - Memory total: 796 655 616; max: 1 908 932 608; free: 557 540 328 Memory pools: Non-heap memory[Code Cache]: max: 50 331 648; used: 13 732 736; peek: 13 814 400 Heap memory[PS Eden Space]: max: 657 588 224; used: 146 124 888; peek: 633 798 656 Heap memory[PS Survivor Space]: max: 4 325 376; used: 4 311 456; peek: 75 497 472 Heap memory[PS Old Gen]: max: 1 431 699 456; used: 88 678 944; peek: 475 762 048 Non-heap memory[PS Perm Gen]: max: 85 983 232; used: 37 865 136; peek: 38 302 272 Thread count: 161 |
Автор: | stark [ 14 окт 2014, 11:36 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
mikos писал(а): Хм, интересно, чтобы это могло быть? [code]10-11/01:15: Об этом лучше напишите в эту тему |
Автор: | stark [ 14 окт 2014, 11:38 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
скорее всего у вас preparedStatemet-ы не закрываются в скриптовом шлюзе. Или там какие-то dao-ки не утилизируются. Покажите ваш скрипт. |
Автор: | mikos [ 14 окт 2014, 16:41 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
Да, похоже на то... Как их правильно закрывать? Код: private ParseTarif(H)
{ H.put("is_found", false); cid = H.get("cid"); if (cid == null) { return; }; time = H.get("time"); if (time == null) { return; }; formatter = new SimpleDateFormat("yyyy-MM-dd"); tarif_date = formatter.format(time.getTime()).toString(); query = "SELECT contract_tree_link.tree_id "+ "FROM contract_tree_link "+ "WHERE "+ "(contract_tree_link.date1 is NULL OR contract_tree_link.date1<='"+tarif_date+"') AND "+ "(contract_tree_link.date2 is NULL OR contract_tree_link.date2>='"+tarif_date+"') AND "+ "contract_tree_link.cid='"+cid+"' "+ "UNION "+ "SELECT tariff_tree_link.tree_id "+ "FROM contract_tariff "+ " INNER JOIN tariff_tree_link "+ " ON (contract_tariff.tpid=tariff_tree_link.tpid) "+ "WHERE (contract_tariff.date1 is NULL OR contract_tariff.date1<='"+tarif_date+"') AND "+ "(contract_tariff.date2 is NULL OR contract_tariff.date2>='"+tarif_date+"') AND "+ "contract_tariff.cid='"+cid+"'"; re = con.prepareStatement(query); rs = re.executeQuery(); while (rs.next()) { tree_id = rs.getString(1); ParseMTree(tree_id,H); }; } private ParseMTree(tree_id,H) { is_found = H.get("is_found"); if (is_found == null) { return; }; if (is_found) { return; }; mid = H.get("mid"); if (mid == null) { return; }; query = "SELECT mtree_node.id "+ "FROM module_tariff_tree "+ " INNER JOIN mtree_node "+ " ON (module_tariff_tree.id=mtree_node.mtree_id) "+ "WHERE mtree_node.type='root' AND module_tariff_tree.tree_id='"+tree_id+"' AND module_tariff_tree.mid='"+mid+"'"; re = con.prepareStatement(query); rs = re.executeQuery(); while (rs.next()) { node_id = rs.getString(1); ParseNode(node_id,H); }; } private ParseNode(node_id,H) { is_found = H.get("is_found"); if (is_found == null) { return; }; if (is_found) { return; }; sid = H.get("sid"); if (sid == null) { return; }; operation = H.get("operation"); if (operation == null) { return; }; time = H.get("time"); if (time == null) { return; }; query = "SELECT id, type, data FROM mtree_node WHERE parent_node='"+node_id+"'"; re = con.prepareStatement(query); rs = re.executeQuery(); while (rs.next()) { id = rs.getString(1); type = rs.getString(2); data = rs.getString(3); if (type.equals("service") && sid != Integer.parseInt(data)) { continue; }; if (type.equals("ipn_rule") && operation.equals("get_ipn_rule_id")) { datas = data.split ("&"); H.put("rule_id",datas[1]); H.put("is_found",true); }; if (type.equals("period")) { datas = data.split ("%"); date1 = null; date2 = null; for (i=0; i<datas.length; i++) { date_arr = datas[i].split("&"); if (date_arr.length != 2) { continue; }; formatter = new SimpleDateFormat("dd.MM.yyyy"); date = formatter.parse(date_arr[1]); if (date_arr[0].equals("date1")) { date1 = date; }; if (date_arr[0].equals("date2")) { date2 = date; }; }; if (date1 != null && date1.compareTo(time.getTime()) != -1){ continue; }; if (date2 != null && date2.compareTo(time.getTime()) != 1){ continue; }; }; ParseNode(id,H); }; }; |
Автор: | barguzin2 [ 14 окт 2014, 18:01 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
После этого и других аналогичных блоков типа Код: re = con.prepareStatement(query); rs = re.executeQuery(); while (rs.next()) { tree_id = rs.getString(1); ParseMTree(tree_id,H); }; нужно дописать Код: re.close();
|
Автор: | mikos [ 14 окт 2014, 18:19 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
Спасибо, исправил - понаблюдаю. |
Автор: | stark [ 14 окт 2014, 19:52 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
mikos писал(а): Спасибо, исправил - понаблюдаю. Там как минимум в 2-х местах закрыть надо. |
Автор: | mikos [ 14 окт 2014, 22:00 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
Ага, пробегусь везде где есть SQL, позакрываю. Продолжаю копать и вот что нашел в Slave скрипте микротик шлюза: Код: 10-11/03:13:07 ERROR [pool-200-thread-18] MikrotikGateWorker - Eval error2: Typed variable declaration : Cannot access field: statusList, on object: Thread[Thread-412896,5,main] Typed variable declaration : Cannot access field: statusList, on object: Thread[Thread-412896,5,main] : at Line: 36 : in file: inline evaluation of: ``import java.util.*; import java.util.regex.*; import java.text.*; import java . . . '' : childWorker .statusList at bsh.UtilEvalError.toEvalError(UtilEvalError.java:85) at bsh.UtilEvalError.toEvalError(UtilEvalError.java:90) at bsh.BSHAmbiguousName.toObject(BSHAmbiguousName.java:64) at bsh.BSHAmbiguousName.toObject(BSHAmbiguousName.java:51) at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:93) at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47) at bsh.BSHVariableDeclarator.eval(BSHVariableDeclarator.java:86) at bsh.BSHTypedVariableDeclaration.eval(BSHTypedVariableDeclaration.java:84) at bsh.BSHBlock.evalBlock(BSHBlock.java:131) at bsh.BSHBlock.eval(BSHBlock.java:81) at bsh.BSHBlock.eval(BSHBlock.java:47) at bsh.BSHTryStatement.eval(BSHTryStatement.java:86) at bsh.BSHBlock.evalBlock(BSHBlock.java:131) at bsh.BSHBlock.eval(BSHBlock.java:81) at bsh.BshMethod.invokeImpl(BshMethod.java:362) at bsh.BshMethod.invoke(BshMethod.java:258) at bsh.BshMethod.invoke(BshMethod.java:161) at bitel.billing.server.ipn.GateWorker$ScripterParent.invokeMethod(GateWorker.java:347) at bitel.billing.server.ipn.GateWorker$Scripter.runScriptSync(GateWorker.java:266) at bitel.billing.server.ipn.GateWorker.doParentSync(GateWorker.java:191) at bitel.billing.server.ipn.GateWorker.run(GateWorker.java:94) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) 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) В этом месте пытаюсь взять статус у childWorker Код: protected void parentSync( Gate child, GateWorker childWorker ) { host = gate.getHost(); port = gate.getPort(); Preferences gateSetup = new Preferences( gate.getConfig(), "\r\n" ); login = gateSetup.get( "login", "root" ); pswd = gate.getKeyword(); int timeout = gateSetup.getInt( "timeout", 10000 ); //if ( log.isDebugEnabled() ) //{ log.info( " gate: " + host + ":" + port + " login: " + login + " pswd: " + pswd ); //} session = null; try { session = new SSHSessionExec( host, port, login, pswd ); session.setTimeout( timeout ); List childStatusList = childWorker.statusList; for ( UserStatus status : childStatusList ) { cid = status.contractId; Можно конечно поставить проверку на наличие childWorker, но он ведь в любом случае должен передаваться? |
Автор: | stark [ 15 окт 2014, 01:28 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
Тут вроде идет попытка обращения к приватному полю. И зачем он вам нужен? Это тот же самый statusList ..Он един на все иерархию шлюзов. |
Автор: | mikos [ 15 окт 2014, 02:18 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
Ок. А как тогда вытащить statusList а parent-шлюзе? |
Автор: | barguzin2 [ 15 окт 2014, 09:05 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
А его и не надо вытаскивать. Можно просто использовать statusList также, как и в doSync Цитата: Также дополнительно может быть определена дополнительная функция синхронизации со шлюзом предком. Она определяется у шлюза предка и вызывается потомком перед вызовом doSync().
protected void parentSync( Gate child, GateWorker childWorker) { } где child - объект типа bitel.billing.server.ipn.bean.Gate, представляющий шлюз, который вызывал этот метод. childWorker - объект типа bitel.billing.server.ipn.GateWorker, представляющий шлюз, который вызывал этот метод. В скрипт передаются такие переменные: con — объект java.sql.Connection для соединения с БД; gate — объект bitel.billing.server.ipn.bean.Gate; ruleTypeMap — объект java.util.Map<Integer, bitel.billing.server.ipn.bean.RuleType>. В нем содержаться все типы правил из БД. Ключ — id правила; gateTypeMap — объект java.util.Map<Integer, bitel.billing.server.ipn.bean.GateType> gateTypeMap. В нем содержаться все типы шлюзов из БД. Ключ — id типа шлюза; Log — объект org.apache.log4j.Logger. Для вывода сообщений, ошибок шлюза; StatusList — объект List<bitel.billing.server.ipn.UserStatus> statusList. В нем содержаться статусы пользователей, которые синхронизируются на данном шлюзе. Ключ — id статуса. ; GateErrors — объект java.lang.StringBuilder, содержащий ошибки выполнения шлюза; mid — int, код модуля; worker - объект типа GateWorker, обработчтик логики работы со шлюзом, который вызвал этот скрипт. |
Автор: | mikos [ 16 окт 2014, 17:49 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
У меня в doSync() как раз обращение к statusList идет и там ошибок нет почему-то. В parentSync() все тоже самое, только childWorker.statusList. Что нужно сделать, не понял |
Автор: | stark [ 17 окт 2014, 14:00 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
mikos писал(а): У меня в doSync() как раз обращение к statusList идет и там ошибок нет почему-то. В parentSync() все тоже самое, только childWorker.statusList. Что нужно сделать, не понял в parentSync() так же доступен "statusList" ..Уберите приставку "childWorker." и все должно заработать. |
Автор: | barguzin2 [ 17 окт 2014, 14:37 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
Вроде же написал, что просто также используйте statusList. Чтобы совсем понятно было: for ( UserStatus status : { cid = status.contractId; |
Автор: | mikos [ 17 окт 2014, 18:55 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
аааа, спасибо |
Автор: | barguzin2 [ 18 окт 2014, 14:20 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
где !? |
Автор: | mikos [ 18 окт 2014, 14:55 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
Два раза подряд не позволяют:( |
Автор: | barguzin2 [ 18 окт 2014, 16:59 ] |
Заголовок сообщения: | Re: Закрыть все не закрывшиеся шлюзы |
а, пардоньте. просмотрел. |
Страница 1 из 1 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |