он же, только на передыдущем билде:
Код:
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)