Hopefully, ActiveMQ 5 will be out really soon! :) On 04/10/2007, j0llyr0g3r <[EMAIL PROTECTED]> 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 <[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. > >
-- James ------- http://macstrac.blogspot.com/ Open Source SOA http://open.iona.com
