Hi,
I have a Durable Topic Subscribers using activeMQ5.0.0 with oracle 9i. When
I published over 1000(one time it was 3000) messages, I got an error
"ORA-00020: maximum number of processes (350) exceeded". I didn't get any
problem when publsihing small volumn.
If I user oacle 10g, I got this error "java.sql.SQLException: Io exception:
Got minus one from a read call"
Can anyone tell me what the problem is and solution?
thanks in advance!
****************************************************
INFO log - Started
[EMAIL PROTECTED]:81 61
ERROR TopicStorePrefetch - Failed to fill batch
java.io.IOException: ORA-00020: maximum number of processes (350) exceeded
at
org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport
.java:45)
at
org.apache.activemq.store.jdbc.TransactionContext.getConnection(Trans
actionContext.java:61)
at
org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doGetLastAc
kedDurableSubscriberMessageId(DefaultJDBCAdapter.java:587)
at
org.apache.activemq.store.jdbc.JDBCTopicMessageStore.recoverNextMessa
ges(JDBCTopicMessageStore.java:94)
at
org.apache.activemq.store.ProxyTopicMessageStore.recoverNextMessages(
ProxyTopicMessageStore.java:97)
at
org.apache.activemq.broker.region.cursors.TopicStorePrefetch.fillBatc
h(TopicStorePrefetch.java:215)
at
org.apache.activemq.broker.region.cursors.TopicStorePrefetch.safeFill
Batch(TopicStorePrefetch.java:200)
at
org.apache.activemq.broker.region.cursors.TopicStorePrefetch.isEmpty(
TopicStorePrefetch.java:96)
at
org.apache.activemq.broker.region.cursors.StoreDurableSubscriberCurso
r.isEmpty(StoreDurableSubscriberCursor.java:131)
at
org.apache.activemq.broker.region.PrefetchSubscription.add(PrefetchSu
bscription.java:129)
at
org.apache.activemq.broker.region.DurableTopicSubscription.add(Durabl
eTopicSubscription.java:171)
at
org.apache.activemq.broker.region.policy.SimpleDispatchPolicy.dispatc
h(SimpleDispatchPolicy.java:48)
at org.apache.activemq.broker.region.Topic.dispatch(Topic.java:601)
at
org.apache.activemq.broker.region.Topic.doMessageSend(Topic.java:427)
at org.apache.activemq.broker.region.Topic.send(Topic.java:371)
at
org.apache.activemq.broker.region.AbstractRegion.send(AbstractRegion.
java:328)
at
org.apache.activemq.broker.region.RegionBroker.send(RegionBroker.java
:402)
at
org.apache.activemq.broker.TransactionBroker.send(TransactionBroker.j
ava:224)
at
org.apache.activemq.broker.BrokerFilter.send(BrokerFilter.java:125)
at
org.apache.activemq.broker.CompositeDestinationBroker.send(CompositeD
estinationBroker.java:95)
at
org.apache.activemq.broker.MutableBrokerFilter.send(MutableBrokerFilt
er.java:135)
at
org.apache.activemq.broker.TransportConnection.processMessage(Transpo
rtConnection.java:434)
at
org.apache.activemq.command.ActiveMQMessage.visit(ActiveMQMessage.jav
a:623)
at
org.apache.activemq.broker.TransportConnection.service(TransportConne
ction.java:281)
at
org.apache.activemq.broker.TransportConnection$1.onCommand(TransportC
onnection.java:178)
at
org.apache.activemq.transport.TransportFilter.onCommand(TransportFilt
er.java:67)
at
org.apache.activemq.transport.WireFormatNegotiator.onCommand(WireForm
atNegotiator.java:134)
at
org.apache.activemq.transport.InactivityMonitor.onCommand(InactivityM
onitor.java:138)
at
org.apache.activemq.transport.TransportSupport.doConsume(TransportSup
port.java:83)
at
org.apache.activemq.transport.tcp.TcpTransport.doRun(TcpTransport.jav
a:185)
at
org.apache.activemq.transport.tcp.TcpTransport.run(TcpTransport.java:
172)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: ORA-00020: maximum number of processes
(350) e xceeded
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:429)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:248)
at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:252)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
va:365)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv
erConnectionFactory.java:37)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable
ConnectionFactory.java:290)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericOb
jectPool.java:771)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSo
urce.java:95)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
.java:544)
at
org.apache.activemq.store.jdbc.TransactionContext.getConnection(Trans
actionContext.java:54)
... 30 more
--
View this message in context:
http://www.nabble.com/java.io.IOException%3A-ORA-00020%3A-maximum-number-of-processes-%28350%29-exceeded-tp14701485s2354p14701485.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
