activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From j0llyr0g3r <timo.roess...@wincor-nixdorf.com>
Subject Re: single broker + mysql + Attempting to acquire the exclusive lock to become the Master broker
Date Thu, 04 Oct 2007 11:59:18 GMT

Thx James,

i upgraded to the latest snapshot and it works now.

P.S.:

Maybe there should a comment on the download page, that people who want to
use AMQ + mysql should __not__ take the stable release but the
snapshot.....:-)

Or am i the only having this problem? I only tested it with mysql 5, maybe
it worked with mysql 4...


James.Strachan wrote:
> 
> 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
> 
> 

-- 
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#a13038372
Sent from the ActiveMQ - User mailing list archive at Nabble.com.


Mime
View raw message