activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Strachan" <james.strac...@gmail.com>
Subject Re: JDBCPersistenceAdapter Too many connections
Date Mon, 31 Dec 2007 17:34:19 GMT
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 <suwei@sphsearch.sg> 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

Mime
View raw message