Пример ошибки из RadiusDialup
Цитата:
processor 07-12/14:39:26 ERROR [pool-2-thread-1] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.JDBC4PreparedStatement@7746df77: SELECT * FROM contract WHERE id=14298
com.mysql.jdbc.JDBC4PreparedStatement@2583d260: 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=14298 AND ((emid=0 AND eid=0) OR (emid=0 AND eid=0)) AND ( isNull(date2) OR date2='0000-00-00' OR date2>='2012-07-01' ) UNION SELECT tree_id, date1, date2, emid, eid, 0, pos FROM contract_tree_link WHERE cid=14298 AND ((emid=0 AND eid=0) OR (emid=0 AND eid=0)) AND (date2 IS NULL OR date2>='2012-07-01') ORDER BY 4 DESC, 5 DESC, 6 ASC, 7 ASC
com.mysql.jdbc.JDBC4PreparedStatement@44091520: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=14298 AND status.status IN (3,4,null,null,null,null) AND (null IS NULL OR status.date1 IS NULL OR status.date1<=null) AND (status.date2 IS NULL OR status.date2>='2012-07-01') ORDER BY status.date1
com.mysql.jdbc.StatementImpl@19fcbac1
com.mysql.jdbc.StatementImpl@6c97f621
com.mysql.jdbc.StatementImpl@60487c5f
com.mysql.jdbc.StatementImpl@4799a84f
com.mysql.jdbc.StatementImpl@57e2793d
com.mysql.jdbc.StatementImpl@1d2b9f14
com.mysql.jdbc.StatementImpl@63220fd1
com.mysql.jdbc.StatementImpl@43422d0b
com.mysql.jdbc.StatementImpl@77b9e7fc
com.mysql.jdbc.StatementImpl@514f2bd7
com.mysql.jdbc.StatementImpl@1be2f6b0
com.mysql.jdbc.StatementImpl@51b1ab1d
com.mysql.jdbc.StatementImpl@17510d96
com.mysql.jdbc.StatementImpl@4a52fecf
com.mysql.jdbc.StatementImpl@ed6ee28
com.mysql.jdbc.StatementImpl@7b8353cf
com.mysql.jdbc.StatementImpl@5a335053
com.mysql.jdbc.StatementImpl@5edea768
com.mysql.jdbc.StatementImpl@3ef3c5c4
com.mysql.jdbc.StatementImpl@763ce725
com.mysql.jdbc.StatementImpl@21913751
com.mysql.jdbc.StatementImpl@9866417
com.mysql.jdbc.StatementImpl@11cdc190
com.mysql.jdbc.StatementImpl@31455cf4
com.mysql.jdbc.StatementImpl@1547a16f
com.mysql.jdbc.StatementImpl@409bad4f
com.mysql.jdbc.StatementImpl@10b173c3
com.mysql.jdbc.StatementImpl@72270fc4
com.mysql.jdbc.StatementImpl@32bed1fd
com.mysql.jdbc.StatementImpl@5b08ea49
com.mysql.jdbc.StatementImpl@46eff545
com.mysql.jdbc.StatementImpl@67a4076
com.mysql.jdbc.StatementImpl@3a4c585f
com.mysql.jdbc.StatementImpl@6a3de2df
com.mysql.jdbc.StatementImpl@11e3c2c6
com.mysql.jdbc.StatementImpl@85e57
com.mysql.jdbc.StatementImpl@61335b86
com.mysql.jdbc.StatementImpl@72bdec44
com.mysql.jdbc.StatementImpl@190a0d51
com.mysql.jdbc.StatementImpl@62f04dae
com.mysql.jdbc.StatementImpl@26a150e
com.mysql.jdbc.StatementImpl@48a84b47
com.mysql.jdbc.StatementImpl@6e659812
com.mysql.jdbc.StatementImpl@4fe2fe5d
com.mysql.jdbc.StatementImpl@32552379
com.mysql.jdbc.StatementImpl@3f8771dc
com.mysql.jdbc.StatementImpl@6e94124f
com.mysql.jdbc.StatementImpl@3b3e3940
com.mysql.jdbc.StatementImpl@67afe460
com.mysql.jdbc.StatementImpl@28fe53cf
com.mysql.jdbc.StatementImpl@3ad8326d
com.mysql.jdbc.StatementImpl@5fcfad77
com.mysql.jdbc.StatementImpl@593f5a2f
com.mysql.jdbc.StatementImpl@12539a92
com.mysql.jdbc.StatementImpl@ef1df6
com.mysql.jdbc.StatementImpl@529801f4
com.mysql.jdbc.StatementImpl@2b1bed2
com.mysql.jdbc.StatementImpl@45d18084
com.mysql.jdbc.StatementImpl@3d4c7deb
com.mysql.jdbc.StatementImpl@2bbef4c6
com.mysql.jdbc.StatementImpl@272b72f4
com.mysql.jdbc.StatementImpl@15880543
com.mysql.jdbc.StatementImpl@16ff6348
com.mysql.jdbc.StatementImpl@4b01ea1e
com.mysql.jdbc.StatementImpl@4ecd200f
com.mysql.jdbc.StatementImpl@7cf3e133
com.mysql.jdbc.StatementImpl@63ae2c6f
com.mysql.jdbc.StatementImpl@6eef9525
com.mysql.jdbc.StatementImpl@4e695527
com.mysql.jdbc.StatementImpl@575e6691
com.mysql.jdbc.StatementImpl@7bcf6f61
com.mysql.jdbc.StatementImpl@6f9988c7
com.mysql.jdbc.StatementImpl@6a301bf5
com.mysql.jdbc.StatementImpl@1a659078
com.mysql.jdbc.StatementImpl@1efc3d2
com.mysql.jdbc.StatementImpl@7862af46
com.mysql.jdbc.StatementImpl@56ab436d
com.mysql.jdbc.StatementImpl@1d05a248
com.mysql.jdbc.StatementImpl@45135cd9
com.mysql.jdbc.StatementImpl@20bf9a12
com.mysql.jdbc.StatementImpl@1f4b52aa
com.mysql.jdbc.StatementImpl@44dd20b6
com.mysql.jdbc.StatementImpl@2ec7ecd5
com.mysql.jdbc.StatementImpl@26137fea
com.mysql.jdbc.StatementImpl@42b7141a
com.mysql.jdbc.StatementImpl@3f6a5bcb
com.mysql.jdbc.StatementImpl@3ff5d699
com.mysql.jdbc.StatementImpl@655d7752
com.mysql.jdbc.StatementImpl@15ec4535
com.mysql.jdbc.StatementImpl@4ab3a5d1
com.mysql.jdbc.StatementImpl@2688e83d
com.mysql.jdbc.StatementImpl@6647108e
com.mysql.jdbc.StatementImpl@132c08c7
com.mysql.jdbc.StatementImpl@4af6ae1c
com.mysql.jdbc.StatementImpl@76bcfa38
com.mysql.jdbc.StatementImpl@70cfaf6e
com.mysql.jdbc.StatementImpl@3f610944
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:566)
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)