Та же проблема появляется в разных местах.
Сервер: вер. 5.2 сборка 1056 от 14.02.2012 13:33:36
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.6.0_22
Кусок data.properties:
Код:
db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://127.0.0.1/bgbilling?useUnicode=true&characterEncoding=Cp1251&allowUrlInLocalInfile=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&elideSetAutoCommits=true&cachePrepStmts=true&useCursorFetch=true&queryTimeoutKillsConnection=true&connectTimeout=1000
db.user=bill
db.pswd=bgbilling
db.maxIdle=20
db.maxActive=300
db.validationTimeout=1
В 5.1 было:
Код:
db.url=jdbc:mysql://127.0.0.1/bgbilling?useUnicode=true&characterEncoding=Cp1251&allowUrlInLocalInfile=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&allowUrlInLocalInfile=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&elideSetAutoCommits=true&cachePrepStmts=true&useCursorFetch=true&queryTimeoutKillsConnection=true
/usr/local/BGBillingServer/lib/ext/mysql.jar/META-INF/MANIFEST.MF:
Код:
Manifest-Version: 1.0
Ant-Version: Apache Ant 1.6.5
Created-By: 1.4.2-b28 (Sun Microsystems Inc.)
Built-By: mysqldev
Name: common
Specification-Title: JDBC
Specification-Version: 3.0
Specification-Vendor: Sun Microsystems Inc.
Implementation-Title: MySQL Connector/J
Implementation-Version: 5.0.8
Implementation-Vendor-Id: com.mysql
Implementation-Vendor: MySQL AB
Размер mysql.jar = 540852 байт
Ошибки:
Закрываем договор статусом, закрываются модули со шлюзами: ipn, email, phone (server.error.log):
Код:
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - java.sql.SQLException: org.apache.commons.dbcp.DelegatingPreparedStatement with address: "com.mysql.jdbc.PreparedStatement@705c6b57: statement has been closed, no further internal information available" is closed.
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:137)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at bitel.billing.server.ipn.bean.IPNContractStatusManager.changeStatus(IPNContractStatusManager.java:206)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at bitel.billing.server.ipn.Module.lockService(Module.java:470)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at bitel.billing.server.ServerEventProcessor.notify(ServerEventProcessor.java:182)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at ru.bitel.bgbilling.kernel.event.AbstractConsumer.notify(AbstractConsumer.java:275)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at ru.bitel.bgbilling.kernel.event.Consumer.notify(Consumer.java:1)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at ru.bitel.bgbilling.kernel.event.Consumer.onMessage0(Consumer.java:112)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at ru.bitel.bgbilling.kernel.event.Consumer$EventListenerRunnable.runImpl(Consumer.java:51)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:54)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at ru.bitel.bgbilling.kernel.event.EventListenerThreadContext$2.rejectedExecution(EventListenerThreadContext.java:88)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:767)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:658)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at ru.bitel.bgbilling.kernel.event.Consumer.onMessage(Consumer.java:159)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at org.apache.activemq.ActiveMQMessageConsumer.dispatch(ActiveMQMessageConsumer.java:1229)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at org.apache.activemq.ActiveMQSessionExecutor.dispatch(ActiveMQSessionExecutor.java:134)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at org.apache.activemq.ActiveMQSessionExecutor.iterate(ActiveMQSessionExecutor.java:205)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at org.apache.activemq.thread.PooledTaskRunner.runTask(PooledTaskRunner.java:122)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at org.apache.activemq.thread.PooledTaskRunner$1.run(PooledTaskRunner.java:43)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] LoggingPrintStream - at java.lang.Thread.run(Thread.java:662)
mq 02-28/14:37:53 ERROR [ActiveMQ Session Task] Preferences - Connection com.mysql.jdbc.Connection@457909f3 is closed.
java.sql.SQLException: Connection com.mysql.jdbc.Connection@457909f3 is closed.
at org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:398)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:279)
at ru.bitel.common.Preferences.loadModuleSetup(Preferences.java:454)
at ru.bitel.bgbilling.server.util.ModuleSetup.<init>(ModuleSetup.java:31)
at bitel.billing.server.email.Module.changeStatus(Module.java:175)
at bitel.billing.server.email.Module.lockService(Module.java:164)
at bitel.billing.server.ServerEventProcessor.notify(ServerEventProcessor.java:182)
at ru.bitel.bgbilling.kernel.event.AbstractConsumer.notify(AbstractConsumer.java:275)
at ru.bitel.bgbilling.kernel.event.Consumer.notify(Consumer.java:1)
at ru.bitel.bgbilling.kernel.event.Consumer.onMessage0(Consumer.java:112)
at ru.bitel.bgbilling.kernel.event.Consumer$EventListenerRunnable.runImpl(Consumer.java:51)
at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:54)
at ru.bitel.bgbilling.kernel.event.EventListenerThreadContext$2.rejectedExecution(EventListenerThreadContext.java:88)
at java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:767)
at java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:658)
at ru.bitel.bgbilling.kernel.event.Consumer.onMessage(Consumer.java:159)
at org.apache.activemq.ActiveMQMessageConsumer.dispatch(ActiveMQMessageConsumer.java:1229)
at org.apache.activemq.ActiveMQSessionExecutor.dispatch(ActiveMQSessionExecutor.java:134)
at org.apache.activemq.ActiveMQSessionExecutor.iterate(ActiveMQSessionExecutor.java:205)
at org.apache.activemq.thread.PooledTaskRunner.runTask(PooledTaskRunner.java:122)
at org.apache.activemq.thread.PooledTaskRunner$1.run(PooledTaskRunner.java:43)
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)
mq 02-28/14:38:03 ERROR [ActiveMQ Session Task] script - Connection com.mysql.jdbc.Connection@457909f3 is closed.
ru.bitel.bgbilling.common.BGException: Connection com.mysql.jdbc.Connection@457909f3 is closed.
at ru.bitel.bgbilling.modules.phone.server.bean.PhoneContractStatusManager.changeContractStatus(PhoneContractStatusManager.java:85)
at bitel.billing.server.phone.Module.lockService(Module.java:476)
at bitel.billing.server.ServerEventProcessor.notify(ServerEventProcessor.java:182)
at ru.bitel.bgbilling.kernel.event.AbstractConsumer.notify(AbstractConsumer.java:275)
at ru.bitel.bgbilling.kernel.event.Consumer.notify(Consumer.java:1)
at ru.bitel.bgbilling.kernel.event.Consumer.onMessage0(Consumer.java:112)
at ru.bitel.bgbilling.kernel.event.Consumer$EventListenerRunnable.runImpl(Consumer.java:51)
at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:54)
at ru.bitel.bgbilling.kernel.event.EventListenerThreadContext$2.rejectedExecution(EventListenerThreadContext.java:88)
at java.util.concurrent.ThreadPoolExecutor.reject(ThreadPoolExecutor.java:767)
at java.util.concurrent.ThreadPoolExecutor.execute(ThreadPoolExecutor.java:658)
at ru.bitel.bgbilling.kernel.event.Consumer.onMessage(Consumer.java:159)
at org.apache.activemq.ActiveMQMessageConsumer.dispatch(ActiveMQMessageConsumer.java:1229)
at org.apache.activemq.ActiveMQSessionExecutor.dispatch(ActiveMQSessionExecutor.java:134)
at org.apache.activemq.ActiveMQSessionExecutor.iterate(ActiveMQSessionExecutor.java:205)
at org.apache.activemq.thread.PooledTaskRunner.runTask(PooledTaskRunner.java:122)
at org.apache.activemq.thread.PooledTaskRunner$1.run(PooledTaskRunner.java:43)
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)
Caused by: ru.bitel.bgbilling.common.BGException: Connection com.mysql.jdbc.Connection@457909f3 is closed.
at ru.bitel.bgbilling.modules.phone.server.bean.PhoneContractStatusManager.adjustGates(PhoneContractStatusManager.java:142)
at ru.bitel.bgbilling.modules.phone.server.bean.PhoneContractStatusManager.changeContractStatus(PhoneContractStatusManager.java:78)
... 19 more
Caused by: java.sql.SQLException: Connection com.mysql.jdbc.Connection@457909f3 is closed.
at org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:398)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:279)
at ru.bitel.bgbilling.modules.phone.server.bean.PhoneContractStatusManager.adjustGates(PhoneContractStatusManager.java:126)
... 20 more
В моих классах такое тоже возникает:
Код:
script 02-29/10:15:30 ERROR [pool-1-thread-159] LoggingPrintStream - java.sql.SQLException: Connection com.mysql.jdbc.Connection@50866ce2 is closed.
script 02-29/10:15:30 ERROR [pool-1-thread-159] LoggingPrintStream - at org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:398)
script 02-29/10:15:30 ERROR [pool-1-thread-159] LoggingPrintStream - at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:279)
script 02-29/10:15:30 ERROR [pool-1-thread-159] LoggingPrintStream - at ru.dsi.bgbilling.sce.extractors.IPNSubscriberExtractor.getSubscribers(IPNSubscriberExtractor.java:81)
...
HTTP-запрос из клиента:
Код:
server 02-28/17:26:10 ERROR ["http-bio-/0.0.0.0-8080"-exec-9] CommonExecuter - Connection com.mysql.jdbc.Connection@697dc141 is closed.
java.sql.SQLException: Connection com.mysql.jdbc.Connection@697dc141 is closed.
at org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:398)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:279)
at bitel.billing.server.contract.bean.CommentPatternManager.updateContractComment(CommentPatternManager.java:57)
at bitel.billing.server.contract.action.ActionUpdateParameterType1.doAction(ActionUpdateParameterType1.java:60)
...
В scheduler.log такое встречается реже:
Код:
scheduler 02-24/10:37:03 ERROR [pool-3-thread-5] LoggingPrintStream - java.sql.SQLException: Connection com.mysql.jdbc.Connection@5992f16f is closed.
scheduler 02-24/10:37:03 ERROR [pool-3-thread-5] LoggingPrintStream - at org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:398)
scheduler 02-24/10:37:03 ERROR [pool-3-thread-5] LoggingPrintStream - at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:279)
scheduler 02-24/10:37:03 ERROR [pool-3-thread-5] LoggingPrintStream - at ru.bitel.bgbilling.kernel.task.server.TaskBase.removeMyselfFromTable(TaskBase.java:140)
scheduler 02-24/10:37:03 ERROR [pool-3-thread-5] LoggingPrintStream - at ru.bitel.bgbilling.kernel.task.server.TaskBase.run(TaskBase.java:66)
scheduler 02-24/10:37:03 ERROR [pool-3-thread-5] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
scheduler 02-24/10:37:03 ERROR [pool-3-thread-5] LoggingPrintStream - at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
scheduler 02-24/10:37:03 ERROR [pool-3-thread-5] LoggingPrintStream - at java.lang.Thread.run(Thread.java:662)
BGRaduisDialup/log/error.log:
Код:
radius 02-28/11:36:33 ERROR [rdsLstnr-p-5-t-9] RadiusListenerWorker - java.sql.SQLException: Connection com.mysql.jdbc.Connection@6edf4bd1 is closed.
ru.bitel.bgbilling.common.BGException: java.sql.SQLException: Connection com.mysql.jdbc.Connection@6edf4bd1 is closed.
at ru.bitel.common.sql.ConnectionSet.commit(ConnectionSet.java:163)
at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.processPacket(RadiusListenerWorker.java:165)
at ru.bitel.bgbilling.kernel.network.radius.RadiusListenerWorker.runImpl(RadiusListenerWorker.java:88)
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.sql.SQLException: Connection com.mysql.jdbc.Connection@6edf4bd1 is closed.
at org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:398)
at org.apache.commons.dbcp.DelegatingConnection.getAutoCommit(DelegatingConnection.java:337)
at ru.bitel.common.sql.ConnectionSet.commit(ConnectionSet.java:138)
... 7 more
radius.properties :
Код:
db.url=jdbc:mysql://127.0.0.1/bgbilling?useUnicode=true&characterEncoding=Cp1251&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&elideSetAutoCommits=true&cachePrepStmts=true&queryTimeoutKillsConnection=true