Caused by: java.lang.Throwable: org.apache.derby.impl.jdbc.EmbedSQLException: A lock could not be obtained within the time requested

[Dhruba Bandopadhyay <bd...@gmail.com>]

Hi,

I'm getting the following exception.

2008-04-10 02:59:23,282  WARN                  org.apache.activemq.ActiveMQCo
ception: A lock could not be obtained within the time requested
java.lang.RuntimeException: java.io.IOException: Failed to broker
message: ID:gboff01-gs-dev-bpro1-47686-1207774918264-0:9:1:1:98922 in
container: SQL Exception: A lock could not be obtained within the time
requested
        at org.apache.activemq.broker.region.IndirectMessageReference.incrementReferenceCount(IndirectMessageReference.java:103)
        at org.apache.activemq.broker.region.QueueSubscription.dispatch(QueueSubscription.java:170)
        at org.apache.activemq.broker.region.PrefetchSubscription.dispatchMatched(PrefetchSubscription.java:369)
        at org.apache.activemq.broker.region.PrefetchSubscription.acknowledge(PrefetchSubscription.java:204)
        at org.apache.activemq.broker.region.AbstractRegion.acknowledge(AbstractRegion.java:299)
        at org.apache.activemq.broker.region.RegionBroker.acknowledge(RegionBroker.java:402)
        at org.apache.activemq.broker.TransactionBroker.acknowledge(TransactionBroker.java:177)
        at org.apache.activemq.broker.BrokerFilter.acknowledge(BrokerFilter.java:74)
        at org.apache.activemq.broker.BrokerFilter.acknowledge(BrokerFilter.java:74)
        at org.apache.activemq.broker.MutableBrokerFilter.acknowledge(MutableBrokerFilter.java:88)
        at org.apache.activemq.broker.TransportConnection.processMessageAck(TransportConnection.java:506)
        at org.apache.activemq.command.MessageAck.visit(MessageAck.java:179)
        at org.apache.activemq.broker.TransportConnection.service(TransportConnection.java:294)
        at org.apache.activemq.broker.TransportConnection$1.onCommand(TransportConnection.java:185)
        at org.apache.activemq.transport.TransportFilter.onCommand(TransportFilter.java:65)
        at org.apache.activemq.transport.WireFormatNegotiator.onCommand(WireFormatNegotiator.java:133)
        at org.apache.activemq.transport.InactivityMonitor.onCommand(InactivityMonitor.java:122)
        at org.apache.activemq.transport.TransportSupport.doConsume(TransportSupport.java:84)
        at org.apache.activemq.transport.tcp.TcpTransport.run(TcpTransport.java:137)
        at java.lang.Thread.run(Thread.java:619)
Caused by: java.io.IOException: Failed to broker message:
ID:gboff01-gs-dev-bpro1-47686-1207774918264-0:9:1:1:98922 in
container: SQL Exception: A lock could not be obtained within the time
requested
        at org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:31)
        at org.apache.activemq.store.jdbc.JDBCMessageStore.getMessage(JDBCMessageStore.java:110)
        at org.apache.activemq.store.journal.JournalMessageStore.getMessage(JournalMessageStore.java:329)
        at org.apache.activemq.broker.region.IndirectMessageReference.incrementReferenceCount(IndirectMessageReference.java:95)
        ... 19 more
Caused by: java.lang.Throwable:
org.apache.derby.impl.jdbc.EmbedSQLException: A lock could not be
obtained within the time requested
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
        at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source)
        at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown
Source)
        at org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doGetMessage(DefaultJDBCAdapter.java:240)
        at org.apache.activemq.store.jdbc.JDBCMessageStore.getMessage(JDBCMessageStore.java:100)
        ... 21 more

This is after sending 1546676 messages from one producer to one broker
with six consumers consuming at the other end.

Any help would be much appreciated in understanding why this is
happening with a stock release and any potential workarounds.

Thanks.