forum.bitel.ru
http://forum.bitel.ru/

Незакрытые preparedStatement (CRM)
http://forum.bitel.ru/viewtopic.php?f=22&t=7369		 Страница 3 из 12
Автор:  Artur [ 25 фев 2013, 15:30 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
В 5.2 будет исправлено. в следующем релизе этого уже не должно быть, но проверю на всякий случай.
Автор:  Koldun [ 25 фев 2013, 16:31 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
Artur писал(а):
В 5.2 будет исправлено. в следующем релизе этого уже не должно быть, но проверю на всякий случай.


Нам до следующего еще далеко. ) Я имел ввиду в билде каком 5.2?
Автор:  stark [ 25 фев 2013, 21:06 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
Koldun писал(а):
Это тоже сюда, правильно?

Код:
02-25/12:50:57 ERROR [pool-3-thread-58] DefaultServerSetup - Many statements was open at connection close:                                                   
com.mysql.jdbc.StatementImpl@4da0c53e                                                                                                                       
com.mysql.jdbc.ServerPreparedStatement[4] - SELECT * FROM contract WHERE id=110502                                                                           
com.mysql.jdbc.JDBC4PreparedStatement@6266440a: SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tarif
com.mysql.jdbc.PreparedStatement@770ae914: SELECT * FROM service WHERE id=2                                                                                 
com.mysql.jdbc.PreparedStatement@14747fa3: SELECT * FROM service WHERE id=1                                                                                 
com.mysql.jdbc.PreparedStatement@6b94d42: SELECT * FROM service WHERE id=3                                                                                   
com.mysql.jdbc.PreparedStatement@60c53e80: SELECT * FROM service WHERE id=13                                                                                 
com.mysql.jdbc.PreparedStatement@4de59c72: SELECT * FROM service WHERE id=108                                                                               
com.mysql.jdbc.PreparedStatement@1f553bae: SELECT * FROM service WHERE id=7                                                                                 
com.mysql.jdbc.JDBC4PreparedStatement@25c7c7a5: SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tarif
com.mysql.jdbc.PreparedStatement@106c88c8: SELECT * FROM service WHERE id=43                                                                                 
com.mysql.jdbc.PreparedStatement@552839d3: SELECT * FROM service WHERE id=44                                                                                 
com.mysql.jdbc.PreparedStatement@328d0dcb: SELECT * FROM service WHERE id=45                                                                                 
com.mysql.jdbc.PreparedStatement@48580bfb: SELECT * FROM service WHERE id=13                                                                                 
com.mysql.jdbc.PreparedStatement@76a6f3fc: SELECT * FROM service WHERE id=12                                                                                 
com.mysql.jdbc.PreparedStatement@1a6b5142: SELECT * FROM service WHERE id=37                                                                                 
com.mysql.jdbc.PreparedStatement@c7bb7e0: SELECT * FROM service WHERE id=3                                                                                   
com.mysql.jdbc.PreparedStatement@7f053572: SELECT * FROM service WHERE id=2                                                                                 
com.mysql.jdbc.PreparedStatement@6d38225b: SELECT * FROM service WHERE id=1                                                                                 
com.mysql.jdbc.PreparedStatement@2740d241: SELECT * FROM service WHERE id=11                                                                                 
com.mysql.jdbc.PreparedStatement@6fcde4e7: SELECT * FROM service WHERE id=108                                                                               
com.mysql.jdbc.PreparedStatement@67ac914a: SELECT * FROM service WHERE id=7                                                                                 
com.mysql.jdbc.JDBC4PreparedStatement@24bca273: SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tarif
com.mysql.jdbc.PreparedStatement@783ad17a: SELECT * FROM service WHERE id=13                                                                                 
com.mysql.jdbc.PreparedStatement@71decb88: SELECT * FROM service WHERE id=2                                                                                 
com.mysql.jdbc.PreparedStatement@5e2b2b2b: SELECT * FROM service WHERE id=1                                                                                 
com.mysql.jdbc.PreparedStatement@201cd404: SELECT * FROM service WHERE id=3                                                                                 
com.mysql.jdbc.PreparedStatement@756f547f: SELECT * FROM service WHERE id=7                                                                                 
com.mysql.jdbc.ServerPreparedStatement[246] - SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tariff.
com.mysql.jdbc.PreparedStatement@7aa2c898: SELECT * FROM service WHERE id=13                                                                                 
com.mysql.jdbc.PreparedStatement@2a7ca1e3: SELECT * FROM service WHERE id=2                                                                                 
com.mysql.jdbc.PreparedStatement@39c92e64: SELECT * FROM service WHERE id=1                                                                                 
com.mysql.jdbc.PreparedStatement@a1930e6: SELECT * FROM service WHERE id=3                                                                                   
com.mysql.jdbc.PreparedStatement@38405d49: SELECT * FROM service WHERE id=7                                                                                 
com.mysql.jdbc.ServerPreparedStatement[247] - SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tariff.
com.mysql.jdbc.PreparedStatement@61530970: SELECT * FROM service WHERE id=43                                                                                 
com.mysql.jdbc.PreparedStatement@5fbc8742: SELECT * FROM service WHERE id=44                                                                                 
com.mysql.jdbc.PreparedStatement@14e41552: SELECT * FROM service WHERE id=45                                                                                 
com.mysql.jdbc.PreparedStatement@4cd81fce: SELECT * FROM service WHERE id=13                                                                                 
com.mysql.jdbc.PreparedStatement@4efa3d9f: SELECT * FROM service WHERE id=12                                                                                 
com.mysql.jdbc.PreparedStatement@8d77f20: SELECT * FROM service WHERE id=11                                                                                 
com.mysql.jdbc.PreparedStatement@6b95a95e: SELECT * FROM service WHERE id=37                                                                                 
com.mysql.jdbc.PreparedStatement@632458f4: SELECT * FROM service WHERE id=3                                                                                 
com.mysql.jdbc.PreparedStatement@3a617f3e: SELECT * FROM service WHERE id=2                                                                                 
com.mysql.jdbc.PreparedStatement@521ebb28: SELECT * FROM service WHERE id=1                                                                                 
com.mysql.jdbc.PreparedStatement@4392893e: SELECT * FROM service WHERE id=108                                                                               
com.mysql.jdbc.PreparedStatement@49ccdb3c: SELECT * FROM service WHERE id=7                                                                                 
com.mysql.jdbc.ServerPreparedStatement[248] - SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tariff.
com.mysql.jdbc.PreparedStatement@1751e53e: SELECT * FROM service WHERE id=13                                                                                 
com.mysql.jdbc.PreparedStatement@6ee1fae: SELECT * FROM service WHERE id=2                                                                                   
com.mysql.jdbc.PreparedStatement@55b69c11: SELECT * FROM service WHERE id=1                                                                                 
com.mysql.jdbc.PreparedStatement@21c10e48: SELECT * FROM service WHERE id=3                                                                                 
com.mysql.jdbc.PreparedStatement@789b61df: SELECT * FROM service WHERE id=108                                                                               
com.mysql.jdbc.PreparedStatement@ebaf07c: SELECT * FROM service WHERE id=7                                                                                   
com.mysql.jdbc.ServerPreparedStatement[249] - SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tariff.
com.mysql.jdbc.PreparedStatement@5c56ab04: SELECT * FROM service WHERE id=13                                                                                 
com.mysql.jdbc.PreparedStatement@51d3478f: SELECT * FROM service WHERE id=2                                                                                 
com.mysql.jdbc.PreparedStatement@326a1f7a: SELECT * FROM service WHERE id=1                                                                                 
com.mysql.jdbc.PreparedStatement@77a6ea6c: SELECT * FROM service WHERE id=3                                                                                 
com.mysql.jdbc.PreparedStatement@3b444722: SELECT * FROM service WHERE id=108                                                                               
com.mysql.jdbc.PreparedStatement@619c6557: SELECT * FROM service WHERE id=7                                                                                 
com.mysql.jdbc.ServerPreparedStatement[250] - SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tariff.
com.mysql.jdbc.PreparedStatement@281bd4fe: SELECT * FROM service WHERE id=13                                                                                 
com.mysql.jdbc.PreparedStatement@20faabe: SELECT * FROM service WHERE id=2                                                                                   
com.mysql.jdbc.PreparedStatement@1888315a: SELECT * FROM service WHERE id=1                                                                                 
com.mysql.jdbc.PreparedStatement@57daeee3: SELECT * FROM service WHERE id=3                                                                                 
com.mysql.jdbc.PreparedStatement@3c8aba0b: SELECT * FROM service WHERE id=108                                                                               
com.mysql.jdbc.PreparedStatement@29e84d6c: SELECT * FROM service WHERE id=7                                                                                 
com.mysql.jdbc.ServerPreparedStatement[251] - SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tariff.
com.mysql.jdbc.PreparedStatement@3078fe65: SELECT * FROM service WHERE id=13                                                                                 
com.mysql.jdbc.PreparedStatement@a589f7d: SELECT * FROM service WHERE id=2                                                                                   
com.mysql.jdbc.PreparedStatement@756adb8a: SELECT * FROM service WHERE id=1                                                                                 
com.mysql.jdbc.PreparedStatement@7423d113: SELECT * FROM service WHERE id=3                                                                                 
com.mysql.jdbc.PreparedStatement@783efc61: SELECT * FROM service WHERE id=108                                                                               
com.mysql.jdbc.PreparedStatement@1160b18a: SELECT * FROM service WHERE id=7                                                                                 
com.mysql.jdbc.ServerPreparedStatement[252] - SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tariff.
com.mysql.jdbc.PreparedStatement@657629d2: SELECT * FROM service WHERE id=13                                                                                 
com.mysql.jdbc.PreparedStatement@6c9b8832: SELECT * FROM service WHERE id=2                                                                                 
com.mysql.jdbc.PreparedStatement@35bc223: SELECT * FROM service WHERE id=1                                                                                   
com.mysql.jdbc.PreparedStatement@6d10c82b: SELECT * FROM service WHERE id=3                                                                                 
com.mysql.jdbc.PreparedStatement@c70d1c8: SELECT * FROM service WHERE id=108                                                                                 
com.mysql.jdbc.PreparedStatement@248fb9da: SELECT * FROM service WHERE id=7                                                                                 
com.mysql.jdbc.ServerPreparedStatement[253] - SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tariff.
com.mysql.jdbc.PreparedStatement@2912cf26: SELECT * FROM service WHERE id=13                                                                                 
com.mysql.jdbc.PreparedStatement@7cceb706: SELECT * FROM service WHERE id=2                                                                                 
com.mysql.jdbc.PreparedStatement@43806299: SELECT * FROM service WHERE id=1                                                                                 
com.mysql.jdbc.PreparedStatement@26fa8216: SELECT * FROM service WHERE id=3                                                                                 
com.mysql.jdbc.PreparedStatement@16d1ffbd: SELECT * FROM service WHERE id=108                                                                               
com.mysql.jdbc.PreparedStatement@2aa1047e: SELECT * FROM service WHERE id=7                                                                                 
com.mysql.jdbc.StatementImpl@17d3217d                                                                                                                       
com.mysql.jdbc.StatementImpl@1951f997                                                                                                                       
com.mysql.jdbc.ServerPreparedStatement[254] - SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tariff.
com.mysql.jdbc.PreparedStatement@6c5d606: SELECT * FROM service WHERE id=2                                                                                   
com.mysql.jdbc.PreparedStatement@7ca3e846: SELECT * FROM service WHERE id=1                                                                                 
com.mysql.jdbc.PreparedStatement@13d69e5c: SELECT * FROM service WHERE id=3                                                                                 
com.mysql.jdbc.PreparedStatement@706ff45a: SELECT * FROM service WHERE id=13                                                                                 
com.mysql.jdbc.PreparedStatement@28c79a38: SELECT * FROM service WHERE id=108                                                                               
com.mysql.jdbc.PreparedStatement@d06127c: SELECT * FROM service WHERE id=7                                                                                   
com.mysql.jdbc.ServerPreparedStatement[255] - SELECT tree_id, date1, date2, emid, eid, 1, pos FROM contract_tariff INNER JOIN tariff_plan ON contract_tariff.
com.mysql.jdbc.PreparedStatement@42cd9e3f: SELECT * FROM service WHERE id=13                                                                                 
                                                                                                                                                             
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:567)                                                                 
        at ru.bitel.bgbilling.server.util.ServerUtils.closeConnection(ServerUtils.java:549)                                                                 
        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:886)                                                               
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)                                                                   
        at java.lang.Thread.run(Thread.java:662)                                                                                                             

Какой-то скрипт у вас . Вы в другой теме пишите про шлюз dlink, возможно он.
Автор:  Bazhutyan [ 27 фев 2013, 03:48 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
Код:
accounting 02-27/00:00:11 ERROR [accwrkr-1-p-13-t-1] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.JDBC4PreparedStatement@709cbec2: UPDATE contract_account SET summa=summa+0.00887 WHERE cid=9892 AND sid=8 AND yy=2013 AND mm=2
com.mysql.jdbc.JDBC4PreparedStatement@42afec50: SELECT SUM(ROUND(contract_account.summa, 2)) FROM contract LEFT JOIN contract_account ON contract_account.cid=contract.id AND contract_account.yy=2013 AND contract_account.mm=2 WHERE contract.id=9892 OR (contract.scid=9892 AND contract.sub_mode=0)
com.mysql.jdbc.JDBC4PreparedStatement@36cd31ae: UPDATE contract_balance SET summa3=29.93 WHERE yy=2013 AND mm=2 AND cid=9892
com.mysql.jdbc.JDBC4PreparedStatement@5978b29d: SELECT yy, mm, summa1, (summa2 - summa3 - summa4) FROM contract_balance WHERE cid=9892 AND ( (yy=2013 AND mm>=2) OR yy>2013 ) ORDER BY yy, mm
com.mysql.jdbc.JDBC4PreparedStatement@3168f4f: UPDATE contract_balance SET summa1=** NOT SPECIFIED ** WHERE cid=9892 AND yy=** NOT SPECIFIED ** AND mm=** NOT SPECIFIED **

<<cut>>

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.common.sql.ConnectionSet.recycle(ConnectionSet.java:261)
        at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:366)
        at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:103)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
        at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204)
        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)
        at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40)
Автор:  Jimm [ 28 фев 2013, 07:00 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
ActionContractParameters
ActionListDirectory
тут тоже непорядок..
Автор:  KostiK [ 28 фев 2013, 10:24 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
В следующем обновлении будет исправлено! Спасибо за помощь в поисках утечек! :lupa:
Автор:  Jimm [ 28 фев 2013, 12:02 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
u welcome :bow:
Автор:  SVK [ 28 фев 2013, 12:12 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
А хрен вам

Код:
02-28/12:00:02 ERROR [pool-2-thread-1] LoggingPrintStream - java.sql.SQLException: org.apache.commons.dbcp.DelegatingPreparedStatement with address: "com.mysql.jdbc.ServerPreparedStatement[2] - statement has been closed, no further internal information available" is closed.
02-28/12:00:02 ERROR [pool-2-thread-1] LoggingPrintStream -     at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:137)
02-28/12:00:02 ERROR [pool-2-thread-1] LoggingPrintStream -     at org.apache.commons.dbcp.DelegatingPreparedStatement.setInt(DelegatingPreparedStatement.java:120)
02-28/12:00:02 ERROR [pool-2-thread-1] LoggingPrintStream -     at bitel.billing.server.contract.bean.ContractManager.getContractById(ContractManager.java:505)
02-28/12:00:02 ERROR [pool-2-thread-1] LoggingPrintStream -     at bitel.billing.server.ipn.IPNTestGates.executeTask(IPNTestGates.java:114)
02-28/12:00:02 ERROR [pool-2-thread-1] LoggingPrintStream -     at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:74)
02-28/12:00:02 ERROR [pool-2-thread-1] LoggingPrintStream -     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
02-28/12:00:02 ERROR [pool-2-thread-1] LoggingPrintStream -     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
02-28/12:00:02 ERROR [pool-2-thread-1] LoggingPrintStream -     at java.lang.Thread.run(Thread.java:662)


в модуле выделенный канал, во всех коммутаторах положило порты в down. Это пиздец.
Автор:  stark [ 28 фев 2013, 12:40 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
Обновление выложено ..
Автор:  SVK [ 28 фев 2013, 12:44 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
stark писал(а):
Обновление выложено ..


Ви так больше не шутите :)
Автор:  stark [ 28 фев 2013, 12:47 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
SVK писал(а):
stark писал(а):
Обновление выложено ..


Ви так больше не шутите :)


Один рыцарь решил всех сразу спасти, не разобравшись в ситуации(где враги, а где свои) ..Сейчас еще обновление будет , это еще не все ..
Автор:  SVK [ 28 фев 2013, 12:49 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
stark писал(а):
SVK писал(а):
stark писал(а):
Обновление выложено ..


Ви так больше не шутите :)


Один рыцарь решил всех сразу спасти, не разобравшись в ситуации(где враги, а где свои) ..Сейчас еще обновление будет , это еще не все ..


подожду лучше пару часиков.
Автор:  stark [ 28 фев 2013, 12:51 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
SVK писал(а):
stark писал(а):
SVK писал(а):
stark писал(а):
Обновление выложено ..


Ви так больше не шутите :)


Один рыцарь решил всех сразу спасти, не разобравшись в ситуации(где враги, а где свои) ..Сейчас еще обновление будет , это еще не все ..


подожду лучше пару часиков.

Оно исправляет то, что сломали . не все исправили сразу.
Автор:  stark [ 28 фев 2013, 13:27 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
Обновитесь еще раз. Откатили ошибки
Автор:  SVK [ 28 фев 2013, 13:33 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
stark писал(а):
Обновитесь еще раз. Откатили ошибки


Как-то ссыкотно (с) Люлей за предыдущее уже получил. :)
Автор:  SVK [ 28 фев 2013, 15:33 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
stark писал(а):
Обновитесь еще раз. Откатили ошибки


В модуле "Выделенный канал" тоже ошибки откатили?
Автор:  stark [ 28 фев 2013, 16:17 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
SVK писал(а):
stark писал(а):
Обновитесь еще раз. Откатили ошибки


В модуле "Выделенный канал" тоже ошибки откатили?

Там в ядре проблема была. Ее исправили
Автор:  Dog [ 02 апр 2013, 18:51 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
акаунтинг сервер модуля инет на старте:
Код:
accounting 04-02/16:49:37 ERROR [main] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.JDBC4PreparedStatement@6a862a07: SELECT deviceGroupId FROM inv_device_group_link_20 WHERE deviceId=263
com.mysql.jdbc.JDBC4PreparedStatement@4db03533: SELECT * FROM inet_device_type_20 WHERE id=5
com.mysql.jdbc.JDBC4PreparedStatement@4bc2d25e: SELECT * FROM inet_serv_type_20 WHERE sessionInitiationType=1 ORDER BY id
com.mysql.jdbc.JDBC4PreparedStatement@6381402d: SELECT deviceTypeId FROM inet_serv_type_device_type_link_20 WHERE inetServId=8
com.mysql.jdbc.JDBC4PreparedStatement@3a9c7d64: SELECT deviceGroupId FROM inet_serv_type_device_group_link_20 WHERE inetServId=8
com.mysql.jdbc.JDBC4PreparedStatement@e1e1948: SELECT product_period.* FROM inv_product_period AS product_period LEFT JOIN inv_product_spec as spec ON product_period.pr
oductSpecId=spec.id  WHERE product_period.contractId=1475 AND (((1 OR product_period.accountId=0) AND (1 OR spec.moduleId=-1)) OR (1 AND spec.moduleId=0)) AND (1 OR pro
duct_period.timeFrom IS NULL OR product_period.timeFrom<=null) AND (0 OR product_period.timeTo IS NULL OR product_period.timeTo>='2013-04-01 00:00:00')
 ORDER BY product_period.timeFrom
com.mysql.jdbc.JDBC4PreparedStatement@67025bf3: SELECT product_period.* FROM inv_product_period AS product_period LEFT JOIN inv_product_spec as spec ON product_period.p
roductSpecId=spec.id  WHERE product_period.contractId=3402 AND (((1 OR product_period.accountId=0) AND (1 OR spec.moduleId=-1)) OR (1 AND spec.moduleId=0)) AND (1 OR pr
oduct_period.timeFrom IS NULL OR product_period.timeFrom<=null) AND (0 OR product_period.timeTo IS NULL OR product_period.timeTo>='2013-04-01 00:00:00')
 ORDER BY product_period.timeFrom
com.mysql.jdbc.JDBC4PreparedStatement@4e64cc22: SELECT product_period.* FROM inv_product_period AS product_period LEFT JOIN inv_product_spec as spec ON product_period.p
roductSpecId=spec.id  WHERE product_period.contractId=3512 AND (((1 OR product_period.accountId=0) AND (1 OR spec.moduleId=-1)) OR (1 AND spec.moduleId=0)) AND (1 OR pr
oduct_period.timeFrom IS NULL OR product_period.timeFrom<=null) AND (0 OR product_period.timeTo IS NULL OR product_period.timeTo>='2013-04-01 00:00:00')
 ORDER BY product_period.timeFrom
com.mysql.jdbc.JDBC4PreparedStatement@268aadef: SELECT product_period.* FROM inv_product_period AS product_period LEFT JOIN inv_product_spec as spec ON product_period.p
roductSpecId=spec.id  WHERE product_period.contractId=3676 AND (((1 OR product_period.accountId=0) AND (1 OR spec.moduleId=-1)) OR (1 AND spec.moduleId=0)) AND (1 OR pr
oduct_period.timeFrom IS NULL OR product_period.timeFrom<=null) AND (0 OR product_period.timeTo IS NULL OR product_period.timeTo>='2013-04-01 00:00:00')
 ORDER BY product_period.timeFrom
com.mysql.jdbc.JDBC4PreparedStatement@747fcf24: SELECT product_period.* FROM inv_product_period AS product_period LEFT JOIN inv_product_spec as spec ON product_period.p
roductSpecId=spec.id  WHERE product_period.contractId=2475 AND (((1 OR product_period.accountId=0) AND (1 OR spec.moduleId=-1)) OR (1 AND spec.moduleId=0)) AND (1 OR pr
oduct_period.timeFrom IS NULL OR product_period.timeFrom<=null) AND (0 OR product_period.timeTo IS NULL OR product_period.timeTo>='2013-04-01 00:00:00')
 ORDER BY product_period.timeFrom
com.mysql.jdbc.JDBC4PreparedStatement@3e98ae8d: SELECT product_period.* FROM inv_product_period AS product_period LEFT JOIN inv_product_spec as spec ON product_period.p
roductSpecId=spec.id  WHERE product_period.contractId=2245 AND (((1 OR product_period.accountId=0) AND (1 OR spec.moduleId=-1)) OR (1 AND spec.moduleId=0)) AND (1 OR pr
oduct_period.timeFrom IS NULL OR product_period.timeFrom<=null) AND (0 OR product_period.timeTo IS NULL OR product_period.timeTo>='2013-04-01 00:00:00')
 ORDER BY product_period.timeFrom
com.mysql.jdbc.JDBC4PreparedStatement@7cef307c: SELECT product_period.* FROM inv_product_period AS product_period LEFT JOIN inv_product_spec as spec ON product_period.p
roductSpecId=spec.id  WHERE product_period.contractId=2606 AND (((1 OR product_period.accountId=0) AND (1 OR spec.moduleId=-1)) OR (1 AND spec.moduleId=0)) AND (1 OR pr
oduct_period.timeFrom IS NULL OR product_period.timeFrom<=null) AND (0 OR product_period.timeTo IS NULL OR product_period.timeTo>='2013-04-01 00:00:00')
 ORDER BY product_period.timeFrom
com.mysql.jdbc.JDBC4PreparedStatement@186a7c3c: SELECT product_period.* FROM inv_product_period AS product_period LEFT JOIN inv_product_spec as spec ON product_period.p
roductSpecId=spec.id  WHERE product_period.contractId=4122 AND (((1 OR product_period.accountId=0) AND (1 OR spec.moduleId=-1)) OR (1 AND spec.moduleId=0)) AND (1 OR pr
oduct_period.timeFrom IS NULL OR product_period.timeFrom<=null) AND (0 OR product_period.timeTo IS NULL OR product_period.timeTo>='2013-04-01 00:00:00')
 ORDER BY product_period.timeFrom
com.mysql.jdbc.JDBC4PreparedStatement@3fbcc0c6: SELECT product_period.* FROM inv_product_period AS product_period LEFT JOIN inv_product_spec as spec ON product_period.p
roductSpecId=spec.id  WHERE product_period.contractId=2261 AND (((1 OR product_period.accountId=0) AND (1 OR spec.moduleId=-1)) OR (1 AND spec.moduleId=0)) AND (1 OR pr
oduct_period.timeFrom IS NULL OR product_period.timeFrom<=null) AND (0 OR product_period.timeTo IS NULL OR product_period.timeTo>='2013-04-01 00:00:00')
...
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.common.sql.ConnectionSet.recycle(ConnectionSet.java:261)
        at ru.bitel.bgbilling.kernel.base.server.DefaultContext.destroy(DefaultContext.java:37)
        at ru.bitel.bgbilling.kernel.container.managed.ServerContext.destroy(ServerContext.java:406)
        at ru.bitel.bgbilling.modules.inet.accounting.Accounting.startImpl(Accounting.java:423)
        at ru.bitel.bgbilling.modules.inet.accounting.Accounting.start(Accounting.java:262)
        at ru.bitel.bgbilling.kernel.application.server.Application.application(Application.java:239)
        at ru.bitel.bgbilling.kernel.application.server.Application.<init>(Application.java:154)
        at ru.bitel.bgbilling.kernel.application.server.Application.main(Application.java:742)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at ru.bitel.common.bootstrap.Boot.boot(Boot.java:129)
        at ru.bitel.common.bootstrap.Boot.main(Boot.java:178)
Автор:  Dog [ 02 апр 2013, 18:55 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
он же, только на передыдущем билде:

Код:
collector 03-14/00:05:23 ERROR [flow-p-8-t-8] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.JDBC4PreparedStatement@7082e9e5: UPDATE inet_session_20 SET sessionCost=sessionCost+** NOT SPECIFIED **, sessionTime=sessionTime+** NOT SPECIFIED **, las
tActive=** NOT SPECIFIED ** WHERE id=** NOT SPECIFIED ** AND connectionId=** NOT SPECIFIED ** AND sessionStart=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@22c9f318: UPDATE inet_session_20 SET sessionCost=sessionCost+0, sessionTime=sessionTime+0, lastActive='2013-03-14 00:00:01', sessi
onStop='2013-03-14 00:00:01', status=4 WHERE id=2246695 AND connectionId=1989321 AND sessionStart='2013-03-13 16:24:33'
com.mysql.jdbc.JDBC4PreparedStatement@7876be7f: UPDATE inet_session_detail_20 SET amount=amount+** NOT SPECIFIED ** WHERE sessionId=2246695 AND day=** NOT SPECIFIED **
AND hour=** NOT SPECIFIED ** AND trafficTypeId=** NOT SPECIFIED ** AND deviceId=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@3bd4c1a2: INSERT INTO inet_session_detail_20 (sessionId, day, hour, trafficTypeId, deviceId, amount) VALUES (** NOT SPECIFIED **,*
* NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **)
com.mysql.jdbc.JDBC4PreparedStatement@cf4915e: UPDATE inet_session_account_20 SET amount=amount+** NOT SPECIFIED **, account=account+** NOT SPECIFIED ** WHERE contractI
d=3367 AND sessionId=2246695 AND serviceId=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@c73b8f7: INSERT INTO inet_session_account_20 (contractId, sessionId, serviceId, amount, account) VALUES (** NOT SPECIFIED **,** NO
T SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **)
com.mysql.jdbc.JDBC4PreparedStatement@1746684: SELECT @counter, @amount
com.mysql.jdbc.JDBC4PreparedStatement@f664db: UPDATE inet_tariff_traffic_range_20 SET counter=counter+1, amount=amount+** NOT SPECIFIED ** WHERE contractId=** NOT SPECI
FIED ** AND treeNodeId=** NOT SPECIFIED ** AND rangeKey=** NOT SPECIFIED **  AND yy=** NOT SPECIFIED ** AND mm = ** NOT SPECIFIED ** AND (@counter:=counter) IS NOT NULL
 AND (@amount:=amount) IS NOT NULL
com.mysql.jdbc.JDBC4PreparedStatement@3057665b: INSERT INTO inet_tariff_traffic_range_20 (contractId, treeNodeId, rangeKey, counter, amount, yy, mm ) VALUES (** NOT SPE
CIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **)
com.mysql.jdbc.JDBC4PreparedStatement@3a00f928: UPDATE inet_tariff_traffic_range_detail_20_201303 SET amount=amount+** NOT SPECIFIED ** WHERE contractId=** NOT SPECIFIE
D ** AND treeNodeId=** NOT SPECIFIED ** AND rangeKey=** NOT SPECIFIED ** AND day=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@15e5ced8: INSERT INTO inet_tariff_traffic_range_detail_20_201303 (contractId, treeNodeId, rangeKey, day, amount) VALUES (** NOT SP
ECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **)
com.mysql.jdbc.JDBC4PreparedStatement@226ed223: SELECT @counter, @amountMax, @amount1, @amount2
com.mysql.jdbc.JDBC4PreparedStatement@19a6097e: UPDATE inet_tariff_traffic_max_20 SET counter=counter+1, amountMax=amountMax+** NOT SPECIFIED **, amount1=amount1+** NOT
 SPECIFIED **, amount2=amount2+** NOT SPECIFIED ** WHERE contractId=** NOT SPECIFIED ** AND treeNodeId=** NOT SPECIFIED ** AND maxKey=** NOT SPECIFIED ** AND yy=** NOT
SPECIFIED ** AND mm = ** NOT SPECIFIED ** AND (@counter:=counter) IS NOT NULL AND (@amountMax:=amountMax) IS NOT NULL AND (@amount1:=amount1) IS NOT NULL AND (@amount2:
=amount2) IS NOT NULL
com.mysql.jdbc.JDBC4PreparedStatement@63b93c59: INSERT INTO inet_tariff_traffic_max_20 (contractId, treeNodeId, maxKey, counter, amountMax, amount1, amount2, yy, mm ) V
ALUES (** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFI
ED **, ** NOT SPECIFIED ** )
com.mysql.jdbc.JDBC4PreparedStatement@16292a35: UPDATE inet_tariff_traffic_max_detail_20_201303 SET amountMax=amountMax+** NOT SPECIFIED **, amount1=amount1+** NOT SPEC
IFIED **, amount2=amount2+** NOT SPECIFIED ** WHERE contractId=** NOT SPECIFIED ** AND treeNodeId=** NOT SPECIFIED ** AND maxKey=** NOT SPECIFIED ** AND day=** NOT SPEC
IFIED **
com.mysql.jdbc.JDBC4PreparedStatement@689208f0: INSERT INTO inet_tariff_traffic_max_detail_20_201303 (contractId, treeNodeId, maxKey, day, amountMax, amount1, amount2)
VALUES (** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **)
com.mysql.jdbc.JDBC4PreparedStatement@de20f5c: INSERT INTO inet_session_log_20_201303 (id, connectionId, parentConnectionId, parentId, splittedId, deviceId, devicePort,
 agentDeviceId, acctSessionId, username, realm, type, servId, calledStationId, callingStationId, ipResourceId, ipAddress, connectionStart, sessionStart, sessionStop, la
stActive, deviceState, deviceOptions, sessionTime, sessionCost, status) SELECT session.id, connection.id, connection.parentId, session.parentId, session.splittedId, con
nection.deviceId, connection.devicePort, connection.agentDeviceId, connection.acctSessionId, connection.username, null, connection.type, connection.servId, connection.c
alledStationId, connection.callingStationId, connection.ipResourceId, connection.ipAddress, connection.connectionStart, session.sessionStart, session.sessionStop, sessi
on.lastActive, session.deviceState, connection.deviceOptions, session.sessionTime, session.sessionCost, session.status FROM inet_session_20 as session LEFT JOIN inet_co
nnection_20 as connection ON connection.id=session.connectionId AND connection.deviceId=167 WHERE session.id=2246695 AND session.connectionId=1989321
com.mysql.jdbc.JDBC4PreparedStatement@745e6822: DELETE FROM inet_session_20 WHERE id=** NOT SPECIFIED ** AND connectionId=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@6206cbdd: INSERT INTO inet_session_log_detail_20_201303 SELECT * FROM inet_session_detail_20 WHERE sessionId=2246695
com.mysql.jdbc.JDBC4PreparedStatement@2c324c72: DELETE FROM inet_session_detail_20 WHERE sessionId=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@1a38e709: INSERT INTO inet_session_log_account_20_201303 SELECT * FROM inet_session_account_20 WHERE sessionId=** NOT SPECIFIED **
 AND contractId=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@dc80d52: DELETE FROM inet_session_account_20 WHERE sessionId=** NOT SPECIFIED ** AND contractId=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@48e2898f: INSERT INTO inet_session_log_route_20_201303 (sessionId, subnet, mask) SELECT ** NOT SPECIFIED **, subnet, mask FROM ine
t_connection_route_20 WHERE connectionId=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@10b530ab: DELETE FROM inet_connection_20 WHERE id=** NOT SPECIFIED ** AND deviceId=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@476eb301: UPDATE inet_session_20 SET sessionCost=sessionCost+** NOT SPECIFIED **, sessionTime=sessionTime+** NOT SPECIFIED **, las
tActive=** NOT SPECIFIED ** WHERE id=** NOT SPECIFIED ** AND connectionId=** NOT SPECIFIED ** AND sessionStart=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@34aa2b4a: UPDATE inet_session_20 SET sessionCost=sessionCost+0, sessionTime=sessionTime+0, lastActive='2013-03-14 00:00:01', sessi
onStop='2013-03-14 00:00:01', status=4 WHERE id=2246695 AND connectionId=1989321 AND sessionStart='2013-03-13 16:24:33'
com.mysql.jdbc.JDBC4PreparedStatement@10002249: UPDATE inet_session_detail_20 SET amount=amount+** NOT SPECIFIED ** WHERE sessionId=2246695 AND day=** NOT SPECIFIED **
AND hour=** NOT SPECIFIED ** AND trafficTypeId=** NOT SPECIFIED ** AND deviceId=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@78caeed3: INSERT INTO inet_session_detail_20 (sessionId, day, hour, trafficTypeId, deviceId, amount) VALUES (** NOT SPECIFIED **,*
* NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **)
com.mysql.jdbc.JDBC4PreparedStatement@53059c99: UPDATE inet_session_account_20 SET amount=amount+** NOT SPECIFIED **, account=account+** NOT SPECIFIED ** WHERE contract
Id=3367 AND sessionId=2246695 AND serviceId=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@156c2b64: INSERT INTO inet_session_account_20 (contractId, sessionId, serviceId, amount, account) VALUES (** NOT SPECIFIED **,** N
OT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **,** NOT SPECIFIED **)
com.mysql.jdbc.JDBC4PreparedStatement@7094bd38: SELECT @counter, @amount
com.mysql.jdbc.JDBC4PreparedStatement@3512e146: UPDATE inet_tariff_traffic_range_20 SET counter=counter+1, amount=amount+** NOT SPECIFIED ** WHERE contractId=** NOT SPE
CIFIED ** AND treeNodeId=** NOT SPECIFIED ** AND rangeKey=** NOT SPECIFIED **  AND yy=** NOT SPECIFIED ** AND mm = ** NOT SPECIFIED ** AND (@counter:=counter) IS NOT NU
LL AND (@amount:=amount) IS NOT NULL
com.mysql.jdbc.JDBC4PreparedStatement@6a83d5e2: INSERT INTO inet_tariff_traffic_range_20 (contractId, treeNodeId, rangeKey, counter, amount, yy, mm ) VALUES (** NOT SPE
CIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **)
com.mysql.jdbc.JDBC4PreparedStatement@754f1f0f: UPDATE inet_tariff_traffic_range_detail_20_201303 SET amount=amount+** NOT SPECIFIED ** WHERE contractId=** NOT SPECIFIE
D ** AND treeNodeId=** NOT SPECIFIED ** AND rangeKey=** NOT SPECIFIED ** AND day=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@1d804df4: INSERT INTO inet_tariff_traffic_range_detail_20_201303 (contractId, treeNodeId, rangeKey, day, amount) VALUES (** NOT SP
ECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **)
com.mysql.jdbc.JDBC4PreparedStatement@527ddd4d: SELECT @counter, @amountMax, @amount1, @amount2
com.mysql.jdbc.JDBC4PreparedStatement@454c148a: UPDATE inet_tariff_traffic_max_20 SET counter=counter+1, amountMax=amountMax+** NOT SPECIFIED **, amount1=amount1+** NOT
 SPECIFIED **, amount2=amount2+** NOT SPECIFIED ** WHERE contractId=** NOT SPECIFIED ** AND treeNodeId=** NOT SPECIFIED ** AND maxKey=** NOT SPECIFIED ** AND yy=** NOT
SPECIFIED ** AND mm = ** NOT SPECIFIED ** AND (@counter:=counter) IS NOT NULL AND (@amountMax:=amountMax) IS NOT NULL AND (@amount1:=amount1) IS NOT NULL AND (@amount2:
=amount2) IS NOT NULL
com.mysql.jdbc.JDBC4PreparedStatement@5d89391: INSERT INTO inet_tariff_traffic_max_20 (contractId, treeNodeId, maxKey, counter, amountMax, amount1, amount2, yy, mm ) VA
LUES (** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIE
D **, ** NOT SPECIFIED ** )
com.mysql.jdbc.JDBC4PreparedStatement@4dc01796: UPDATE inet_tariff_traffic_max_detail_20_201303 SET amountMax=amountMax+** NOT SPECIFIED **, amount1=amount1+** NOT SPEC
IFIED **, amount2=amount2+** NOT SPECIFIED ** WHERE contractId=** NOT SPECIFIED ** AND treeNodeId=** NOT SPECIFIED ** AND maxKey=** NOT SPECIFIED ** AND day=** NOT SPEC
IFIED **
com.mysql.jdbc.JDBC4PreparedStatement@7e4ca0ba: INSERT INTO inet_tariff_traffic_max_detail_20_201303 (contractId, treeNodeId, maxKey, day, amountMax, amount1, amount2)
VALUES (** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **)
com.mysql.jdbc.JDBC4PreparedStatement@4ea66976: INSERT INTO inet_session_log_20_201303 (id, connectionId, parentConnectionId, parentId, splittedId, deviceId, devicePort
, agentDeviceId, acctSessionId, username, realm, type, servId, calledStationId, callingStationId, ipResourceId, ipAddress, connectionStart, sessionStart, sessionStop, l
astActive, deviceState, deviceOptions, sessionTime, sessionCost, status) SELECT session.id, connection.id, connection.parentId, session.parentId, session.splittedId, co
nnection.deviceId, connection.devicePort, connection.agentDeviceId, connection.acctSessionId, connection.username, null, connection.type, connection.servId, connection.
calledStationId, connection.callingStationId, connection.ipResourceId, connection.ipAddress, connection.connectionStart, session.sessionStart, session.sessionStop, sess
ion.lastActive, session.deviceState, connection.deviceOptions, session.sessionTime, session.sessionCost, session.status FROM inet_session_20 as session LEFT JOIN inet_c
onnection_20 as connection ON connection.id=session.connectionId AND connection.deviceId=167 WHERE session.id=2246695 AND session.connectionId=1989321
com.mysql.jdbc.JDBC4PreparedStatement@f55ea51: DELETE FROM inet_session_20 WHERE id=** NOT SPECIFIED ** AND connectionId=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@518a73b4: INSERT INTO inet_session_log_detail_20_201303 SELECT * FROM inet_session_detail_20 WHERE sessionId=2246695
com.mysql.jdbc.JDBC4PreparedStatement@58b2583e: DELETE FROM inet_session_detail_20 WHERE sessionId=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@24bf7bf0: INSERT INTO inet_session_log_account_20_201303 SELECT * FROM inet_session_account_20 WHERE sessionId=** NOT SPECIFIED **
 AND contractId=** NOT SPECIFIED **
com.mysql.jdbc.JDBC4PreparedStatement@1761dc69: DELETE FROM inet_session_account_20 WHERE sessionId=** NOT SPECIFIED ** AND contractId=** NOT SPECIFIED **

...

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.common.sql.ConnectionSet.recycle(ConnectionSet.java:261)
        at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:366)
        at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:103)
        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)
        at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40)
Автор:  Bazhutyan [ 17 апр 2013, 04:48 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
Каждый раз в 00:00 ошибки Accounting-сервера.

Kernel version 5.2 build 1480 from 15.04.2013 15:53:00
Inet version 5.2 build 1148 from 15.04.2013 15:52:57

Код:
script 04-17/00:00:03 ERROR [dyn-clss-evnt-lstnr-p-5-t-5] Calculator - Tariff error contractId: 8928; serviceId: 1
collector 04-17/00:00:03 ERROR [flow-p-9-t-9] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.JDBC4PreparedStatement@2e08d870: UPDATE contract_account SET summa=summa+0.00402 WHERE cid=9389 AND sid=8 AND yy=2013 AND mm=4
com.mysql.jdbc.JDBC4PreparedStatement@46b9b8ac: SELECT SUM(ROUND(contract_account.summa, 2)) FROM contract LEFT JOIN contract_account ON contract_account.cid=contract.id AND contract_account.yy=2013 AND contract_account.mm=4 WHERE contract.id=9389 OR (contract.scid=9389 AND contract.sub_mode=0)
com.mysql.jdbc.JDBC4PreparedStatement@51c36813: UPDATE contract_balance SET summa3=22137.01 WHERE yy=2013 AND mm=4 AND cid=9389
com.mysql.jdbc.JDBC4PreparedStatement@73e5e154: SELECT yy, mm, summa1, (summa2 - summa3 - summa4) FROM contract_balance WHERE cid=9389 AND ( (yy=2013 AND mm>=4) OR yy>2013 ) ORDER BY yy, mm
com.mysql.jdbc.JDBC4PreparedStatement@792c8d3d: UPDATE contract_balance SET summa1=** NOT SPECIFIED ** WHERE cid=9389 AND yy=** NOT SPECIFIED ** AND mm=** NOT SPECIFIED **
<<cut>>

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.common.sql.ConnectionSet.recycle(ConnectionSet.java:261)
   at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:376)
   at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:103)
   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)
   at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40)
mq 04-17/00:00:16 ERROR [accwrkr-1-p-19-t-4] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.JDBC4PreparedStatement@302bfe83: UPDATE contract_account SET summa=summa+0.00060 WHERE cid=9853 AND sid=8 AND yy=2013 AND mm=4
com.mysql.jdbc.JDBC4PreparedStatement@1852632a: SELECT SUM(ROUND(contract_account.summa, 2)) FROM contract LEFT JOIN contract_account ON contract_account.cid=contract.id AND contract_account.yy=2013 AND contract_account.mm=4 WHERE contract.id=9853 OR (contract.scid=9853 AND contract.sub_mode=0)
com.mysql.jdbc.JDBC4PreparedStatement@1855dfe0: UPDATE contract_balance SET summa3=2.47 WHERE yy=2013 AND mm=4 AND cid=9853
com.mysql.jdbc.JDBC4PreparedStatement@2ddcf79b: SELECT yy, mm, summa1, (summa2 - summa3 - summa4) FROM contract_balance WHERE cid=9853 AND ( (yy=2013 AND mm>=4) OR yy>2013 ) ORDER BY yy, mm
com.mysql.jdbc.JDBC4PreparedStatement@603f8a3: UPDATE contract_balance SET summa1=** NOT SPECIFIED ** WHERE cid=9853 AND yy=** NOT SPECIFIED ** AND mm=** NOT SPECIFIED **
<<cut>>

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.common.sql.ConnectionSet.recycle(ConnectionSet.java:261)
   at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:376)
   at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:103)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
   at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
   at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180)
   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204)
   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)
   at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40)
mq 04-17/00:00:36 ERROR [accwrkr-1-p-19-t-4] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.JDBC4PreparedStatement@2108c41b: UPDATE contract_account SET summa=summa+0.00492 WHERE cid=9059 AND sid=8 AND yy=2013 AND mm=4
com.mysql.jdbc.JDBC4PreparedStatement@4682d98e: SELECT SUM(ROUND(contract_account.summa, 2)) FROM contract LEFT JOIN contract_account ON contract_account.cid=contract.id AND contract_account.yy=2013 AND contract_account.mm=4 WHERE contract.id=9059 OR (contract.scid=9059 AND contract.sub_mode=0)
com.mysql.jdbc.JDBC4PreparedStatement@4c73591b: UPDATE contract_balance SET summa3=273315.72 WHERE yy=2013 AND mm=4 AND cid=9059
com.mysql.jdbc.JDBC4PreparedStatement@28df22d3: SELECT yy, mm, summa1, (summa2 - summa3 - summa4) FROM contract_balance WHERE cid=9059 AND ( (yy=2013 AND mm>=4) OR yy>2013 ) ORDER BY yy, mm
com.mysql.jdbc.JDBC4PreparedStatement@51675f9b: UPDATE contract_balance SET summa1=** NOT SPECIFIED ** WHERE cid=9059 AND yy=** NOT SPECIFIED ** AND mm=** NOT SPECIFIED **
<<cut>>

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.common.sql.ConnectionSet.recycle(ConnectionSet.java:261)
   at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:376)
   at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:103)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
   at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
   at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180)
   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204)
   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)
   at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40)
mq 04-17/00:00:57 ERROR [accwrkr-1-p-19-t-3] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.JDBC4PreparedStatement@5405d0c2: UPDATE contract_account SET summa=summa+0.00333 WHERE cid=8986 AND sid=8 AND yy=2013 AND mm=4
com.mysql.jdbc.JDBC4PreparedStatement@49cc9ba6: SELECT SUM(ROUND(contract_account.summa, 2)) FROM contract LEFT JOIN contract_account ON contract_account.cid=contract.id AND contract_account.yy=2013 AND contract_account.mm=4 WHERE contract.id=8986 OR (contract.scid=8986 AND contract.sub_mode=0)
com.mysql.jdbc.JDBC4PreparedStatement@5b5b3aca: UPDATE contract_balance SET summa3=2282.83 WHERE yy=2013 AND mm=4 AND cid=8986
com.mysql.jdbc.JDBC4PreparedStatement@4270d2a1: SELECT yy, mm, summa1, (summa2 - summa3 - summa4) FROM contract_balance WHERE cid=8986 AND ( (yy=2013 AND mm>=4) OR yy>2013 ) ORDER BY yy, mm
com.mysql.jdbc.JDBC4PreparedStatement@7d146a1a: UPDATE contract_balance SET summa1=** NOT SPECIFIED ** WHERE cid=8986 AND yy=** NOT SPECIFIED ** AND mm=** NOT SPECIFIED **
<<cut>>

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.common.sql.ConnectionSet.recycle(ConnectionSet.java:261)
   at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:376)
   at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:103)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
   at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
   at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180)
   at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204)
   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)
   at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:40)
radius 04-17/00:56:32 ERROR [InetRadiusListener] RadiusListener - RadiusListener accounting queue is full!
Автор:  stark [ 23 апр 2013, 14:27 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
2 Dog , у вас точно accounting - обновленный? Такое ощущение, что эту ошибку уже исправляли . Может быть вы обновили сервер, но забыли accounting-обновить ?
Автор:  Dog [ 23 апр 2013, 22:19 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
вообще должен был, но возможно что то пошло нет так =) в любом случае сейчас на этот счёт чисто.
Автор:  max [ 20 май 2013, 16:26 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
у нас вот такое вылазит:
Код:
05-19/21:35:17 ERROR [bitel.billing.server.load.action.ActionSourceManagerInfo] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[5619] - SELECT  id, session_cost, session_time, ROUND(input_octets/1,0), ROUND(output_octets/1,0) FROM log_session_3_201305 WHERE lid IN (5) AND DAYOFMONTH( session_start )>=1  AND DAYOFMONTH( session_start )<=31
Автор:  stark [ 20 май 2013, 19:21 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
max писал(а):
у нас вот такое вылазит:
Код:
05-19/21:35:17 ERROR [bitel.billing.server.load.action.ActionSourceManagerInfo] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[5619] - SELECT  id, session_cost, session_time, ROUND(input_octets/1,0), ROUND(output_octets/1,0) FROM log_session_3_201305 WHERE lid IN (5) AND DAYOFMONTH( session_start )>=1  AND DAYOFMONTH( session_start )<=31


У вас какая версия сейчас ? Вроде бы исправили в 5.2 еще в январе.
Автор:  max [ 20 май 2013, 23:40 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
5.1
Автор:  stark [ 21 май 2013, 12:15 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
max писал(а):
5.1

На 5.1 не исправляли
Автор:  Phricker [ 17 июн 2013, 17:03 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
Подскажите пожалуйста...
Есть вот такой вот скрипт
Код:
String query = "SELECT DISTINCT(c.id), t.date1 FROM contract_tariff AS t, contract AS c WHERE t.cid = c.id AND t.tpid IN (" + tariffs + ") AND t.date2 IS NULL ORDER BY c.id";
      java.sql.PreparedStatement ps = con.prepareStatement( query );
      ResultSet rs = ps.executeQuery();
      while ( rs.next() )
      {
         cid = rs.getInt( 1 ); //ID договора
         String queryStatus =    " SELECT date1, status FROM contract_status_log " +
                           " WHERE cid = " + cid +
                           " ORDER BY date1 DESC " +
                           " LIMIT 1" ;
         java.sql.PreparedStatement psStatus = con.prepareStatement( queryStatus );
         ResultSet rsStatus = psStatus.executeQuery();
         while ( rsStatus.next() )
         {
            .......
         }

........................................................................
         


В таком случае ругается на Many statements was open at connection close.
Как это сделать по феншую? Вынести объявление psStatus и rsStatus за пределы цикла (туда же где где объявляются rs и ps) и потом просто вызывать
psStatus = con.prepareStatement( queryStatus );
rsStatus = psStatus.executeQuery();

или же закрывать коннект rs.close(); ps.close(); после каждого обращения?
Автор:  Artur [ 17 июн 2013, 17:21 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
Phricker писал(а):
или же закрывать коннект rsStatus.close(); psStatus.close(); после каждого обращения?


Потом также не забудьте сделать rs.close(); ps.close(); в конце. Всегда лучше явно чистить ресурсы.
Автор:  Phricker [ 17 июн 2013, 17:26 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
Спасибо.
Закрытие rs.close(); ps.close(); итак стоит уже :)
Опечатался в rsStatus.close(); и psStatus.close(); :)
Автор:  Cromeshnic [ 23 июл 2013, 07:07 ]
Заголовок сообщения:  Re: Незакрытые preparedStatement
вер. 5.2 сборка 1525 от 22.07.2013 13:22:39
dialup вер. 5.2 сборка 379 от 20.05.2013 20:12:49
inet вер. 5.2 сборка 1211 от 22.07.2013 13:22:38

При переоформлении договора, в конце процесса:

Код:
server 07-23/09:36:28 ERROR ["http-bio-/0.0.0.0-8080"-exec-6] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[37] - SELECT * FROM contract WHERE id=191468
com.mysql.jdbc.ServerPreparedStatement[57] - SELECT * FROM inet_serv_type_25 ORDER BY id
com.mysql.jdbc.ServerPreparedStatement[58] - SELECT deviceTypeId FROM inet_serv_type_device_type_link_25 WHERE inetServId=6
com.mysql.jdbc.ServerPreparedStatement[59] - SELECT deviceGroupId FROM inet_serv_type_device_group_link_25 WHERE inetServId=6
com.mysql.jdbc.ServerPreparedStatement[68] - SELECT * FROM contract WHERE id=191468
com.mysql.jdbc.JDBC4PreparedStatement@f3e7ab: SELECT sid, SUM(summa) FROM session_account_1_201201 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@3af383: SELECT sid, SUM(summa) FROM session_account_1_201201 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@18355aa: SELECT sid, SUM(summa) FROM session_account_1_201203 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1c03044: SELECT sid, SUM(summa) FROM session_account_1_201203 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@19cb1a8: SELECT sid, SUM(summa) FROM session_account_1_201204 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1cb6e54: SELECT sid, SUM(summa) FROM session_account_1_201204 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1ea8d74: SELECT sid, SUM(summa) FROM session_account_1_201205 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@13f9b54: SELECT sid, SUM(summa) FROM session_account_1_201205 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@153df31: SELECT sid, SUM(summa) FROM session_account_1_201206 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@d7a270: SELECT sid, SUM(summa) FROM session_account_1_201206 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@10910a1: SELECT sid, SUM(summa) FROM session_account_1_201207 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@9ff1d3: SELECT sid, SUM(summa) FROM session_account_1_201207 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1266fce: SELECT sid, SUM(summa) FROM session_account_1_201208 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1d34001: SELECT sid, SUM(summa) FROM session_account_1_201208 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1207d43: SELECT sid, SUM(summa) FROM session_account_1_201209 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@82a431: SELECT sid, SUM(summa) FROM session_account_1_201209 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1d55d9: SELECT sid, SUM(summa) FROM session_account_1_201210 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1ac4ca1: SELECT sid, SUM(summa) FROM session_account_1_201210 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1a1c0d1: SELECT sid, SUM(summa) FROM session_account_1_201211 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@148d5b2: SELECT sid, SUM(summa) FROM session_account_1_201211 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@180cea1: SELECT sid, SUM(summa) FROM session_account_1_201212 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@871b47: SELECT sid, SUM(summa) FROM session_account_1_201212 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@a4156c: SELECT sid, SUM(summa) FROM session_account_1_201301 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@fe1e30: SELECT sid, SUM(summa) FROM session_account_1_201301 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1701f63: SELECT sid, SUM(summa) FROM session_account_1_201302 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@dc42ab: SELECT sid, SUM(summa) FROM session_account_1_201302 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.ServerPreparedStatement[157] - SELECT * FROM inet_serv_option_25 WHERE servId=33
com.mysql.jdbc.ServerPreparedStatement[160] - SELECT * FROM inet_serv_type_25 WHERE id=2
com.mysql.jdbc.ServerPreparedStatement[161] - SELECT deviceTypeId FROM inet_serv_type_device_type_link_25 WHERE inetServId=2
com.mysql.jdbc.ServerPreparedStatement[162] - SELECT deviceGroupId FROM inet_serv_type_device_group_link_25 WHERE inetServId=2
com.mysql.jdbc.ServerPreparedStatement[163] - SELECT serv.*, contract.scid, contract.sub_mode FROM inet_serv_25 AS serv LEFT JOIN contract ON serv.contractId=contract.id WHERE serv.id=33
com.mysql.jdbc.ServerPreparedStatement[165] - SELECT inet_device_25.*, entity.entitySpecId, entity.title as entityTitle FROM inet_device_25 LEFT JOIN entity ON entity.id=inet_device_25.entityId WHERE inet_device_25.id=15
com.mysql.jdbc.ServerPreparedStatement[166] - SELECT deviceGroupId FROM inv_device_group_link_25 WHERE deviceId=15
com.mysql.jdbc.ServerPreparedStatement[167] - SELECT * FROM inet_device_type_25 WHERE id=3
com.mysql.jdbc.ServerPreparedStatement[169] - SELECT * FROM entity_spec WHERE id=0
com.mysql.jdbc.ServerPreparedStatement[134] - SELECT * FROM contract WHERE id=192136
com.mysql.jdbc.ServerPreparedStatement[176] - SELECT * FROM inv_device_port_subscription_25 WHERE deviceId=15 AND (2=-1 OR port=2) AND (dateFrom IS NULL OR '2013-07-18' IS NULL OR dateFrom<='2013-07-18') AND (dateTo IS NULL OR '2013-07-18 00:00:00' IS NULL OR dateTo>='2013-07-18 00:00:00') ORDER BY port
com.mysql.jdbc.ServerPreparedStatement[178] - SELECT * FROM inet_serv_25 WHERE parentId=46 ORDER BY id
com.mysql.jdbc.ServerPreparedStatement[184] - SELECT * FROM inet_accounting_period_25 WHERE contractId=191468 ORDER BY dateFrom
com.mysql.jdbc.JDBC4PreparedStatement@5a86e1: SELECT sid, SUM(summa) FROM session_account_23_201205 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1cdf052: SELECT sid, SUM(summa) FROM session_account_23_201205 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@183901c: SELECT sid, SUM(summa) FROM session_account_23_201206 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@bfea42: SELECT sid, SUM(summa) FROM session_account_23_201206 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1db0032: SELECT sid, SUM(summa) FROM session_account_23_201207 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1b343e9: SELECT sid, SUM(summa) FROM session_account_23_201207 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1c90acb: SELECT sid, SUM(summa) FROM session_account_23_201208 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1211f6d: SELECT sid, SUM(summa) FROM session_account_23_201208 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@19a5b0: SELECT sid, SUM(summa) FROM session_account_23_201209 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1051743: SELECT sid, SUM(summa) FROM session_account_23_201209 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@9ad559: SELECT sid, SUM(summa) FROM session_account_23_201210 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@172f7c3: SELECT sid, SUM(summa) FROM session_account_23_201210 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1278640: SELECT sid, SUM(summa) FROM session_account_23_201211 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@10069c3: SELECT sid, SUM(summa) FROM session_account_23_201211 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1702cfb: SELECT sid, SUM(summa) FROM session_account_23_201212 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@8da92: SELECT sid, SUM(summa) FROM session_account_23_201212 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@d6b576: SELECT sid, SUM(summa) FROM session_account_23_201301 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@870fb: SELECT sid, SUM(summa) FROM session_account_23_201301 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@38584c: SELECT sid, SUM(summa) FROM session_account_23_201302 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@269ced: SELECT sid, SUM(summa) FROM session_account_23_201302 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@19ba407: SELECT sid, SUM(summa) FROM session_account_21_201201 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1afcb90: SELECT sid, SUM(summa) FROM session_account_21_201201 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1a77dcf: SELECT sid, SUM(summa) FROM session_account_21_201203 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1e043a8: SELECT sid, SUM(summa) FROM session_account_21_201203 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@28b43: SELECT sid, SUM(summa) FROM session_account_21_201204 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@f6fd93: SELECT sid, SUM(summa) FROM session_account_21_201204 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@749cf8: SELECT sid, SUM(summa) FROM session_account_21_201205 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@139a1e2: SELECT sid, SUM(summa) FROM session_account_21_201205 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@76e596: SELECT sid, SUM(summa) FROM session_account_21_201206 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@15960dd: SELECT sid, SUM(summa) FROM session_account_21_201206 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1c63a8: SELECT sid, SUM(summa) FROM session_account_21_201207 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@4157d2: SELECT sid, SUM(summa) FROM session_account_21_201207 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@62bc77: SELECT sid, SUM(summa) FROM session_account_21_201208 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@88097e: SELECT sid, SUM(summa) FROM session_account_21_201208 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@1bdacbe: SELECT sid, SUM(summa) FROM session_account_21_201209 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@c76ec3: SELECT sid, SUM(summa) FROM session_account_21_201209 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@102ffa: SELECT sid, SUM(summa) FROM session_account_21_201210 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@b7531e: SELECT sid, SUM(summa) FROM session_account_21_201210 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@3157a8: SELECT sid, SUM(summa) FROM session_account_21_201211 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@134139f: SELECT sid, SUM(summa) FROM session_account_21_201211 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@ff51f1: SELECT sid, SUM(summa) FROM session_account_21_201212 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1c137c7: SELECT sid, SUM(summa) FROM session_account_21_201212 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@f8288e: SELECT sid, SUM(summa) FROM session_account_21_201301 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@4b4dd9: SELECT sid, SUM(summa) FROM session_account_21_201301 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.JDBC4PreparedStatement@b421a2: SELECT sid, SUM(summa) FROM session_account_21_201302 WHERE cid=191468 GROUP BY sid
com.mysql.jdbc.PreparedStatement@1019f2a: SELECT sid, SUM(summa) FROM session_account_21_201302 WHERE cid=192136 GROUP BY sid
com.mysql.jdbc.ServerPreparedStatement[188] - SELECT * FROM contract WHERE id=191468
com.mysql.jdbc.ServerPreparedStatement[219] - DELETE FROM contract_account WHERE cid IN (191468, 192136) AND yy=null AND mm=null AND sid IN ( 33,234,236,84,153,72,73,80,292,124,79,76,139,166,138,167,268,269)
com.mysql.jdbc.ServerPreparedStatement[221] - SELECT * FROM inet_serv_option_26 WHERE servId=1
com.mysql.jdbc.ServerPreparedStatement[224] - SELECT * FROM inet_serv_type_26 WHERE id=1
com.mysql.jdbc.ServerPreparedStatement[225] - SELECT deviceTypeId FROM inet_serv_type_device_type_link_26 WHERE inetServId=1
com.mysql.jdbc.ServerPreparedStatement[226] - SELECT deviceGroupId FROM inet_serv_type_device_group_link_26 WHERE inetServId=1
com.mysql.jdbc.ServerPreparedStatement[227] - SELECT serv.*, contract.scid, contract.sub_mode FROM inet_serv_26 AS serv LEFT JOIN contract ON serv.contractId=contract.id WHERE serv.id=1
com.mysql.jdbc.ServerPreparedStatement[228] - SELECT inet_device_26.*, entity.entitySpecId, entity.title as entityTitle FROM inet_device_26 LEFT JOIN entity ON entity.id=inet_device_26.entityId WHERE inet_device_26.id=3
com.mysql.jdbc.ServerPreparedStatement[229] - SELECT deviceGroupId FROM inv_device_group_link_26 WHERE deviceId=3
com.mysql.jdbc.ServerPreparedStatement[230] - SELECT * FROM inet_device_type_26 WHERE id=3

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.common.sql.ConnectionSet.recycle(ConnectionSet.java:261)
        at ru.bitel.bgbilling.kernel.base.server.DefaultContext.destroy(DefaultContext.java:37)
        at ru.bitel.bgbilling.kernel.container.managed.ServerContext.destroy(ServerContext.java:406)
        at bitel.billing.server.ActionBase.freeConnection(ActionBase.java:181)
        at bitel.billing.server.Executer.doModule(Unknown Source)
        at bitel.billing.server.Executer$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:396)
        at bitel.billing.server.Executer.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:140)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
        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)


Модули 1, 21 - Dialup
Модули 25, 26 - Inet
Страница 3 из 12 Часовой пояс: UTC + 5 часов [ Летнее время ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/