You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@activemq.apache.org by j0llyr0g3r <ti...@wincor-nixdorf.com> on 2007/10/02 21:34:54 UTC
single broker + mysql + Attempting to acquire the exclusive lock to
become the Master broker
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.
Re: single broker + mysql + Attempting to acquire the exclusive lock to become the Master broker
Posted by James Strachan <ja...@gmail.com>.
Hopefully, ActiveMQ 5 will be out really soon! :)
On 04/10/2007, j0llyr0g3r <ti...@wincor-nixdorf.com> wrote:
>
> 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 <ti...@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.
>
>
--
James
-------
http://macstrac.blogspot.com/
Open Source SOA
http://open.iona.com
Re: single broker + mysql + Attempting to acquire the exclusive
lock to become the Master broker
Posted by j0llyr0g3r <ti...@wincor-nixdorf.com>.
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 <ti...@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.
Re: single broker + mysql + Attempting to acquire the exclusive lock to become the Master broker
Posted by James Strachan <ja...@gmail.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 <ti...@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