Mailing-List: contact users-help@activemq.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@activemq.apache.org
Received-SPF: pass (athena.apache.org: domain of james.strachan@gmail.com
 designates 64.233.162.231 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=eJkH/tGFbgM3kyh+aI/EKvCi95IKJx3PUeS7U1QMLO9ZN7tRDs7QPvC/NfWZzwEenleVKf7evD0HJHetCzPvRDdJSjm7nZa26jkYxxfq/WZTkIgBzz76VO4Zx185RKEYc/QrixLjkYA7yj2RdbfighCvS93rPnC+rFM49TAuW78=
Message-ID: <ec6e67fd0710030839v73ab7181p29c9e1ffb96a8338@mail.gmail.com>
Date: Wed, 3 Oct 2007 16:39:27 +0100
From: "James Strachan" <james.strachan@gmail.com>
To: users@activemq.apache.org
Subject: Re: single broker + mysql + Attempting to acquire the exclusive lock
 to become the Master broker
In-Reply-To: <13006218.post@talk.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <13006218.post@talk.nabble.com>

Try upgrading to a newer version; we've fixed up some of the SQL for
locking the database.

Or if you know you're only gonna run a single broker, you can disable
database locking via...

http://activemq.apache.org/maven/activemq-core/xsddoc/http___activemq.org_config_1.0/element/jdbcPersistenceAdapter.html#attr_useDatabaseLock

<jdbcPersistenceAdapter useDatabaseLock="false">

On 02/10/2007, j0llyr0g3r <timo.roessner@wincor-nixdorf.com> wrote:
>
> Hey folks,
>
> i'm having real trouble here with mysql and activmq:
>
> When i start my (single!) broker i get an endless repitition of:
>
> INFO  DefaultDatabaseLocker          - Attempting to acquire the exclusive
> lock to become the Master broker
> INFO  DefaultDatabaseLocker          - Attempting to acquire the exclusive
> lock to become the Master broker
> INFO  DefaultDatabaseLocker          - Attempting to acquire the exclusive
> lock to become the Master broker
> INFO  DefaultDatabaseLocker          - Attempting to acquire the exclusive
> lock to become the Master broker
> INFO  DefaultDatabaseLocker          - Attempting to acquire the exclusive
> lock to become the Master broker
> INFO  DefaultDatabaseLocker          - Attempting to acquire the exclusive
> lock to become the Master broker
> INFO  DefaultDatabaseLocker          - Attempting to acquire the exclusive
> lock to become the Master broker
> INFO  DefaultDatabaseLocker          - Attempting to acquire the exclusive
> lock to become the Master broker
>
> My configuration:
>
> - activemq 4.1
> - mysql 5.0
> - mysql connector 5.0.7
>
> I am pretty sure that this is some kind of bug, but how do i solve this?
>
> My broker configuration is quite simple:
>
> <beans>
>   <!-- Allows us to use system properties as variables in this configuration
> file -->
>   <bean
> class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"/>
>
>   <broker brokerName="localhost" useJmx="true"
> xmlns="http://activemq.org/config/1.0">
>
>     <memoryManager>
>         <usageManager id="memory-manager" limit="20 MB"/>
>     </memoryManager>
>
>     <managementContext>
>        <managementContext connectorPort="1099"
> jmxDomainName="org.apache.activemq"/>
>     </managementContext>
>
>     <persistenceAdapter>
>       <journaledJDBC journalLogFiles="5" dataDirectory="../data"
> dataSource="#mysql-ds"/>
>     </persistenceAdapter>
>
>     <transportConnectors>
>        <transportConnector name="openwire" uri="tcp://localhost:61616"/>
>        <transportConnector name="local_ssl" uri="ssl://localhost:61617"/>
>     </transportConnectors>
>   </broker>
>
>   <bean id="mysql-ds" class="org.apache.commons.dbcp.BasicDataSource"
> destroy-method="close">
>      <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
>      <property name="url"
> value="jdbc:mysql://localhost/activemq?relaxAutoCommit=true"/>
>      <property name="username" value="wnmf"/>
>      <property name="password" value="wnmf"/>
>      <property name="poolPreparedStatements" value="true"/>
>   </bean>
> </beans>
>
> What can i do?
>
> I googled a lot, but found nothing relevant, the only thing i found was:
>
> SET AUTOCOMMIT = 0;
> LOCK TABLE activemq.ACTIVEMQ_LOCK WRITE;
>
> But this didn't help.
>
> Thanks for every hint!
>
> --
> View this message in context: http://www.nabble.com/single-broker-%2B-mysql-%2B-Attempting-to-acquire-the-exclusive-lock-to-become-the-Master-broker-tf4557484s2354.html#a13006218
> Sent from the ActiveMQ - User mailing list archive at Nabble.com.
>
>


-- 
James
-------
http://macstrac.blogspot.com/

Open Source SOA
http://open.iona.com