Your database is refusing new connections. Either increase the number of available connections on your database, or specify a limit in the DBCP configuration in activemq.xml
On 27/12/2007, MQ Newbie <[EMAIL PROTECTED]> wrote: > > I encountered the following error after submitting about 6-8 jms message > consecutively on Master/Slave architecture. Please advise. Thank you. > > WARN JDBCPersistenceAdapter - Old message cleanup failed due to: > java.io.IOException: Too many connections > java.io.IOException: Too many connections > at > org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:45) > at > org.apache.activemq.store.jdbc.TransactionContext.getConnection(TransactionContext.java:61) > at > org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doDeleteOldMessages(DefaultJDBCAdapter.java:570) > at > org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.cleanup(JDBCPersistenceAdapter.java:213) > at > org.apache.activemq.store.jdbc.JDBCPersistenceAdapter$1.run(JDBCPersistenceAdapter.java:187) > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) > 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:181) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) > at java.lang.Thread.run(Thread.java:619) > Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Too > many connections > 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:406) > at com.mysql.jdbc.Util.getInstance(Util.java:381) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:894) > at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3808) > at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1256) > at > com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2032) > at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729) > at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) > at sun.reflect.GeneratedConstructorAccessor10.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:406) > at > com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302) > at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283) > at > org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) > at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) > at > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771) > at > org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:544) > at > org.apache.activemq.store.jdbc.TransactionContext.getConnection(TransactionContext.java:54) > ... 12 more > > -- > View this message in context: > http://www.nabble.com/JDBCPersistenceAdapter-Too-many-connections-tp14511365s2354p14511365.html > Sent from the ActiveMQ - User mailing list archive at Nabble.com. > > -- James ------- http://macstrac.blogspot.com/ Open Source Integration http://open.iona.com
