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 <[EMAIL PROTECTED]> 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: > [EMAIL PROTECTED] > > 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. > >