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