activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MQ Newbie <su...@sphsearch.sg>
Subject Re: JDBCPersistenceAdapter Too many connections
Date Wed, 02 Jan 2008 01:03:21 GMT

Can you please provide me an example configuration for this?


James.Strachan wrote:
> 
> 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
> 
> 

-- 
View this message in context: http://www.nabble.com/JDBCPersistenceAdapter-Too-many-connections-tp14511365s2354p14572207.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.


Mime
View raw message