BiTel

[root@lia log]# cat ./error.log
processor 10-30/01:39:28 ERROR [pool-2-thread-4] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.JDBC4PreparedStatement@2b735f84: SELECT * FROM contract WHERE id=105910
com.mysql.jdbc.JDBC4PreparedStatement@1ff31ad9: SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tariff.tpid=tariff_plan.id WHERE cid=105910 AND ((emid=0 AND eid=0) OR (emid=0 AND eid=0)) AND ( isNull(date2) OR date2='0000-00-00' OR date2>='2012-10-01' ) UNION SELECT tree_id, date1, date2, emid, eid, 0, pos FROM contract_tree_link WHERE cid=105910 AND ((emid=0 AND eid=0) OR (emid=0 AND eid=0)) AND (date2 IS NULL OR date2>='2012-10-01') ORDER BY 4 DESC, 5 DESC, 6 ASC, 7 ASC
com.mysql.jdbc.JDBC4PreparedStatement@40d2f5f1: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=105910 AND status.status IN (2,3,4,5,6,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-10-01') ORDER BY status.date1
com.mysql.jdbc.StatementImpl@3351e824
com.mysql.jdbc.StatementImpl@d16e5d6
com.mysql.jdbc.StatementImpl@10b28f30
com.mysql.jdbc.StatementImpl@77d80e9
com.mysql.jdbc.StatementImpl@382ce255
com.mysql.jdbc.StatementImpl@abf5743
com.mysql.jdbc.StatementImpl@17f9f538
com.mysql.jdbc.StatementImpl@1b523bd4
com.mysql.jdbc.StatementImpl@6c87ac60
com.mysql.jdbc.StatementImpl@3f460a4a
com.mysql.jdbc.StatementImpl@f4da0ba
com.mysql.jdbc.StatementImpl@31731b2f
com.mysql.jdbc.StatementImpl@258d3fca
com.mysql.jdbc.StatementImpl@5c56fa08
com.mysql.jdbc.StatementImpl@52395294
com.mysql.jdbc.StatementImpl@315c9cb8
com.mysql.jdbc.StatementImpl@4421972b
com.mysql.jdbc.StatementImpl@794baafe
com.mysql.jdbc.StatementImpl@56c747e8
com.mysql.jdbc.StatementImpl@3541fcda
com.mysql.jdbc.StatementImpl@2124532
com.mysql.jdbc.StatementImpl@7d7cd6ad
com.mysql.jdbc.StatementImpl@ef23838
com.mysql.jdbc.StatementImpl@4048ec32
com.mysql.jdbc.StatementImpl@738ae796
com.mysql.jdbc.StatementImpl@246a641d
com.mysql.jdbc.StatementImpl@44d2be98
com.mysql.jdbc.StatementImpl@67df1074
com.mysql.jdbc.StatementImpl@47b8f42
com.mysql.jdbc.StatementImpl@4bfa385a
com.mysql.jdbc.StatementImpl@1889c3ae
com.mysql.jdbc.StatementImpl@7c8de117
com.mysql.jdbc.StatementImpl@642bd560
com.mysql.jdbc.StatementImpl@79c5c500
com.mysql.jdbc.StatementImpl@2708c175
com.mysql.jdbc.StatementImpl@2fd4fc58
com.mysql.jdbc.StatementImpl@2dcc9f86
com.mysql.jdbc.StatementImpl@54fd2de7
com.mysql.jdbc.StatementImpl@6ebc8d97
com.mysql.jdbc.StatementImpl@1cf3ed4d
com.mysql.jdbc.StatementImpl@52606914
com.mysql.jdbc.StatementImpl@3792ca4c
com.mysql.jdbc.StatementImpl@2667944c
com.mysql.jdbc.StatementImpl@5a391d46
com.mysql.jdbc.StatementImpl@5bb10cf0
com.mysql.jdbc.StatementImpl@44c88f97
com.mysql.jdbc.StatementImpl@57e4bfbe
com.mysql.jdbc.StatementImpl@6ae88006
com.mysql.jdbc.StatementImpl@462d40bf
com.mysql.jdbc.StatementImpl@44f5df97
com.mysql.jdbc.StatementImpl@5366f936
com.mysql.jdbc.StatementImpl@d737301
com.mysql.jdbc.StatementImpl@16834d8d
com.mysql.jdbc.StatementImpl@6586f87
com.mysql.jdbc.StatementImpl@58363f95
com.mysql.jdbc.StatementImpl@51887c71
com.mysql.jdbc.StatementImpl@57a20888
com.mysql.jdbc.StatementImpl@4ede45aa
com.mysql.jdbc.StatementImpl@357d6c
com.mysql.jdbc.StatementImpl@37bd3d8f
com.mysql.jdbc.StatementImpl@691493df
com.mysql.jdbc.StatementImpl@45f84b5e
com.mysql.jdbc.StatementImpl@a35ef07
com.mysql.jdbc.StatementImpl@5adfb9cd
com.mysql.jdbc.StatementImpl@161f7057
com.mysql.jdbc.StatementImpl@6a086b19
com.mysql.jdbc.StatementImpl@716b8f
com.mysql.jdbc.StatementImpl@164c7983
com.mysql.jdbc.StatementImpl@76bd92e4
com.mysql.jdbc.StatementImpl@17f6f3a3
com.mysql.jdbc.StatementImpl@1b1395dc
com.mysql.jdbc.StatementImpl@22d3ac67
com.mysql.jdbc.StatementImpl@76dbb00d
com.mysql.jdbc.StatementImpl@51036271
com.mysql.jdbc.StatementImpl@1391c7b3
com.mysql.jdbc.StatementImpl@47cdc2ce
com.mysql.jdbc.StatementImpl@15b08736
com.mysql.jdbc.StatementImpl@787cf559
com.mysql.jdbc.StatementImpl@9445fbe
com.mysql.jdbc.StatementImpl@67e9b7b2
com.mysql.jdbc.StatementImpl@211b3c6a
com.mysql.jdbc.StatementImpl@31b6421
com.mysql.jdbc.StatementImpl@a00fa7f
com.mysql.jdbc.StatementImpl@463dacfa
com.mysql.jdbc.StatementImpl@7b27751c
com.mysql.jdbc.StatementImpl@5b79c06e
com.mysql.jdbc.StatementImpl@66eeca3a
com.mysql.jdbc.StatementImpl@471edaa1
com.mysql.jdbc.StatementImpl@3aa3a481
com.mysql.jdbc.StatementImpl@4d852f3a
com.mysql.jdbc.StatementImpl@69b8935b
com.mysql.jdbc.StatementImpl@54d27196
com.mysql.jdbc.StatementImpl@441f5a5b
com.mysql.jdbc.StatementImpl@66652f4d
com.mysql.jdbc.StatementImpl@4ab118d8
com.mysql.jdbc.StatementImpl@30d63337
com.mysql.jdbc.StatementImpl@3ebc78ed

java.lang.RuntimeException
        at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:480)
        at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:47)
        at ru.bitel.bgbilling.server.util.ServerUtils.closeConnection(ServerUtils.java:569)
        at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas.restoreConnectionsImpl(DialUpNas.java:971)
        at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas.access$7(DialUpNas.java:739)
        at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas$2.call(DialUpNas.java:733)
        at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas$2.call(DialUpNas.java:1)
        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:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)
[root@lia log]#