о, после сегодняшнего обновления BGRadiusDialup стал выдавать:
Код:
processor 07-11/16:28:40 ERROR [pool-2-thread-4] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.JDBC4PreparedStatement@2bbd9de3: 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=10109 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=10109 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@7c187c8: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=10768 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.PreparedStatement@677210a5: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=8259 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.PreparedStatement@64b2e752: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=8946 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.PreparedStatement@2c006765: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=8582 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.PreparedStatement@69e94001: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=13018 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.PreparedStatement@51f1e39b: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=13584 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
...
skipped
...
com.mysql.jdbc.PreparedStatement@2db1d931: SELECT status.date1, status.date2 FROM contract_status AS status WHERE status.cid=13347 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
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:968)
at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas.access$7(DialUpNas.java:738)
at ru.bitel.bgbilling.modules.dialup.radius.DialUpNas$2.call(DialUpNas.java:732)
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)
Ну и потом, при обновлении клиента, опять
Код:
radius 07-11/16:35:37 ERROR [rdsLstnr-p-9-t-13] DefaultServerSetup - Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2332)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor39.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)
at ru.bitel.bgbilling.server.util.DefaultServerSetup$2.makeObject(DefaultServerSetup.java:439)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188)
at ru.bitel.bgbilling.server.util.DefaultServerSetup$ConnectionPool$1.getConnection(DefaultServerSetup.java:180)
at ru.bitel.bgbilling.server.util.DefaultServerSetup.getDBConnectionFromPool(DefaultServerSetup.java:633)
at ru.bitel.common.sql.SetupConnectionSet.newMasterConnection(SetupConnectionSet.java:39)
at ru.bitel.common.sql.ConnectionSet.getConnection(ConnectionSet.java:81)
at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.preprocessAccountingRequest(RadiusProcessor.java:292)
at ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor.preprocessAccountingRequest(DialUpRadiusProcessor.java:476)
at ru.bitel.bgbilling.modules.dialup.radius.DialUpRadiusProcessor.preprocessAccountingRequest(DialUpRadiusProcessor.java:1)
at ru.bitel.bgbilling.kernel.network.radius.RadiusProcessor.accountingRequest(RadiusProcessor.java:442)
at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.accountingRequest(RadiusListenerWorker.java:383)
at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.processPacket(RadiusListenerWorker.java:251)
at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.runImpl(RadiusListenerWorker.java:135)
at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:86)
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)
Caused by: java.net.SocketTimeoutException: connect timed out
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:529)
at sun.reflect.GeneratedMethodAccessor46.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:330)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
... 32 more