activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mario Siegenthaler" <msiegentha...@inventsoft.ch>
Subject Re: Yes, and it's an urgent problem [was Re: lock on Oracle activemq_lock table]
Date Wed, 10 Oct 2007 17:24:52 GMT
I don't know about how Oracle exactly handles that, but all of the DBs
I've seen so far remove the locks as soon as the connection holding
them is disconnected or closed or the transaction is rollbacked.
Since the 'old' broker isn't running anymore the connection is
disconnected.  And the locker rollbacks and closes the connection on
shutdown although (I did verify that, but only after I've applied
AMQ-1350 [I didn't want to overwrite my workspace I wrote the patch
in]).
So I really don't see why an Oracle database would leave locks behind
for a connection that did a rollback, was closed and is disconnected.

Mario

On 10/10/07, naql <andrew_hart@harcourt.com> wrote:
>
>
> kmoore4now wrote:
> >
> > I'm using the journaled JDBC approach to message persistence, with Oracle.
> > It seems to work well most of the time. However, I'm finding that even
> > after a normal shutdown a lock occasionally appears to be held on the
> > activemq_lock table. This prevents ActiveMQ from starting up again on the
> > next attempt.
> >
> > Has anyone else seen this? Is there a way to avoid it?
> >
>
> Yes.  I'm pretty sure the problem you're describing here is the same one
> that I'm running into.  I previously posted regarding this on Oct 2nd as
> "ActiveMQ installed as NT service takes a long, long time to restart".  I
> thought it might be related to the servicewrapper, but it happens just
> running it from the prompt whenever I use Oracle jdbc persistence.  I see
> these messages in the log:
>
> 2007-10-02 17:44:50,232 [erSimpleAppMain] INFO  DefaultDatabaseLocker
> - Attempting to acquire the exclusive lock to become the Master broker
> 2007-10-02 19:42:06,568 [erSimpleAppMain] INFO  DefaultDatabaseLocker
> - Becoming the master on dataSource:
> org.apache.commons.dbcp.BasicDataSource@1972e
>
> So, as you can see, in this example, it took 2 hours for ActiveMQ to start
> up.  This doesn't happen when I fall back on the default persistence db,
> comment out the Oracle datasource.
>
> This is a big deal to us and, along with the other issue I'm about to post
> about, is a serious showstopper.
>
> --
> View this message in context: http://www.nabble.com/lock-on-Oracle-activemq_lock-table-tf4576911s2354.html#a13138495
> Sent from the ActiveMQ - User mailing list archive at Nabble.com.
>
>

Mime
View raw message