BiTel

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);

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

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);
   };
};

re = con.prepareStatement(query);
   rs = re.executeQuery();
   while (rs.next())
   {
      tree_id = rs.getString(1);
      ParseMTree(tree_id,H);
   };

re.close();

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)

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;