Игрался с
отчётом по должникам, а потом в логах навалило:
Код:
server 06-02/16:29:44 ERROR [http-bio-127.0.0.1-8080-exec-10] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[1156] - SELECT summa1, summa1 + summa2 - summa3 - summa4 FROM contract_balance WHERE cid=21382 AND yy=2016 AND mm=05
com.mysql.jdbc.ServerPreparedStatement[1157] - SELECT summa1 + summa2 - summa3 - summa4 FROM contract_balance WHERE cid=21382 AND (yy<2016 OR (yy=2016 AND mm<=05)) ORDER BY yy DESC, mm DESC
com.mysql.jdbc.ServerPreparedStatement[1158] - SELECT t1.val as phone, t2.val as fio, t3.address as address FROM contract LEFT JOIN contract_parameter_type_1 as t1 ON contract.id=t1.cid AND t1.pid=1 LEFT JOIN contract_parameter_type_1 as t2 ON contract.id=t2.cid AND t2.pid=2 LEFT JOIN contract_parameter_type_2 as t3 ON contract.id=t3.cid AND t3.pid=3 WHERE contract.id=21382
com.mysql.jdbc.ServerPreparedStatement[1159] - SELECT SUM(summa) FROM contract_payment WHERE cid=null AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<TO_DAYS('2016-05-01')
com.mysql.jdbc.ServerPreparedStatement[1160] - SELECT SUM(summa) FROM contract_payment WHERE cid=21382 AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') AND pt!=0
com.mysql.jdbc.ServerPreparedStatement[1161] - SELECT SUM(summa) FROM contract_payment WHERE cid=21382 AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02') AND pt=0
com.mysql.jdbc.ServerPreparedStatement[1162] - SELECT id, title, comment, scid, sub_list, sub_mode FROM contract WHERE gr&6088299485643521727>0 ORDER BY contract.title
com.mysql.jdbc.ServerPreparedStatement[1163] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17499,17500,17501,17502,26158,26167) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1165] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (5052) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1167] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (39039,39048) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1169] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (38780,38782) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1171] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (39022,39023) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1173] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (6500,28532,29191) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1175] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (38881) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1177] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (3257,3272,3273,5004,8510,16919,17307,21321,21457,22241,23571,24351,24693,25107,25179,26834,26936,27523,27993,28159,28514,28612,28626,30098,30208,30209,30255,30522,31723,32074,32452,32464,32691,33102,34450,34637,35878,36154,36454,37273,37381,37455,38338,38349,38412,38422,38786,38964,39396,39466,43812,43990,44292,44543,44647,44666,44667) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1179] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (589,2131,5676) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1181] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (1559,10915) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1183] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (264,265,266,1031,1043) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1185] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (951,1095,3341,4215,18250,18251,18252,18253,18254,18255,23466) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1187] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4921,6780,13209) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1189] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4452,6573) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1191] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (34714) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1193] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (2210) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1195] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17693) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1197] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (2699) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1199] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (24607,24608) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1201] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (29318) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1203] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (11629) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1205] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (33559) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1207] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (33918) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1209] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (25269) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1211] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (25350) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1213] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (267,268,20172,22771) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1215] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17199,17201,17503,17505,18408,19583,20819,22802,42035) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1217] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (28965) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1219] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (5996) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1221] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (948,950,937) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1223] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (24439,24440,24441,24442,24443) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1225] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (34604) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1227] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30326,30327) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1229] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30663) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1231] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30781,30782) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1233] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30791,30792) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1235] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30834) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1237] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (30873,30874) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1239] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (31192,31193) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1241] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (34006,34972) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1243] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (31696) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1245] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32013,32014) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1247] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32742,32743) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1249] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32808,32809) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1251] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32821,32822) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1253] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32827,32828) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1255] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32857,32858) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1257] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32956,32957) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1259] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (32986,32987) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1261] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (33119,33120) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1263] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17099,17102,29243,29246) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1265] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4001,4152,11093,17103) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1267] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (3390,3817,4057,5138,17850,39683) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1269] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (33741,33742,33743,33744,34277,34610) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1271] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (16277) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1273] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4726,11772,16025,16026) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1275] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (11904) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1277] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (22108) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1279] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (11597) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1281] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (7184,9700) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1283] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4401,4402,4403,4404,4405,4406,4407,4408,4409,4410,4411,4412,4413,4414,4415,4416,4417,4418,17617,33403) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1285] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4980) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1287] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (20346) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1289] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (6250,16824,17107,17108) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1291] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4465,4466,4467,4468) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1293] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (28970,28971,28972,28973,28974,28975) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1295] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (28543) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1297] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4252,4531,4532,23090) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1299] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4905,11624,11625) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1301] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (2543,20246,20248) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1303] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4874,4875,6471,9445,11857) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1305] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (14557) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1307] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (35271) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1309] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (4968) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1311] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (18329,18331,33627,33629) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1313] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (25463) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1315] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (22440) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1317] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (18093) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1319] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (10287,10581,10592,23895) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1321] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (8251,17120) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1323] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17109) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1325] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (6788,6793,6794,6795,6797) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1327] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (15865,15866,16276,41616) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1329] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (34087) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1331] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (8660,8661,8667,11097,17121) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1333] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (11464) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1335] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (11379) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1337] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (7366,7367,11268,12049,12318) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1339] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (17196) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1341] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (33406) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1343] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (36722) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1345] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (8044,41617) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
com.mysql.jdbc.ServerPreparedStatement[1347] - SELECT SUM(summa) FROM contract_payment WHERE cid IN (24600) AND TO_DAYS(dt)>=TO_DAYS('2016-05-01') AND TO_DAYS(dt)<=TO_DAYS('2016-06-02')
java.lang.RuntimeException: http://forum.bitel.ru/viewtopic.php?t=7369
at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:426)
at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48)
at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:272)
at ru.bitel.bgbilling.kernel.base.server.DefaultContext.destroy(DefaultContext.java:37)
at ru.bitel.bgbilling.kernel.container.managed.ServerContext.destroy(ServerContext.java:400)
at bitel.billing.server.ActionBase.freeConnection(ActionBase.java:180)
at bitel.billing.server.Executer.doModule(SourceFile:649)
at bitel.billing.server.Executer$1.run(SourceFile:199)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:422)
at bitel.billing.server.Executer.doPost(SourceFile:193)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at ru.bitel.common.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:54)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)