[
https://issues.apache.org/jira/browse/AMQ-992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12973529#action_12973529
]
Albrecht Militzer commented on AMQ-992:
---------------------------------------
I still seem to run into this problem. I have MySQL 5.1, I have InnoDB-Tables,
but Slaves do not start up. The first process becomes master. The others block
while trying to become master. They never become slaves. They try to execute
SELECT * FROM ACTIVEMQ_LOCK FOR UPDATE.
This waits for the lock to be available and finally ends with a timeout. The
next line in the log is:
Failed to acquire lock. Sleeping for 1000 milli(s) before trying again...
This keeps going forever.
1) If I switch to Derby, the problem goes away.
2) In MySQL, I had some luck with changing the lock statement to
SELECT * FROM ACTIVEMQ_LOCK LOCK IN SHARE MODE
but then Failover does not work. Once I kill the master, no slave becomes
master.
> MySQL doesn't honor lock in JDBC Master Slave configuration?
> ------------------------------------------------------------
>
> Key: AMQ-992
> URL: https://issues.apache.org/jira/browse/AMQ-992
> Project: ActiveMQ
> Issue Type: Bug
> Affects Versions: 4.1.0
> Environment: RHEL 4
> MySQL 4.x, 5.x
> mysql-ab_jdbc_driver
> Reporter: Steven Lotito
> Fix For: 5.3.0
>
> Attachments: mysql_obtain_lock.txt, patch.txt
>
>
> I have been attempting to get the new 4.1 JDBC Master Slave configuration
> working with MySQL.
> The log from the first broker to start up states:
> 2006-10-18 09:35:08,558 [main ] INFO DefaultDatabaseLocker
> - Attempting to acquire the exclusive lock to become the Master broker
> 2006-10-18 09:35:08,559 [main ] INFO DefaultDatabaseLocker
> - Becoming the master on dataSource:
> org.apache.commons.dbcp.basicdatasou...@136d9d8
> The 2nd broker to start up has an identical message and both brokers listen
> for connections.
> The 2nd broker should be waiting for the lock and NOT accepting connections,
> if I understand http://www.activemq.org/site/jdbc-master-slave.html
> correctly...
> Oracle exhibits the expected behavior:
> When running the exact same configuration (except using an Oracle
> datasource), the first broker has the same log message as above, while the
> 2nd broker halts at the "Attempting to acquire the exclusive lock to become
> the Master broker" message until I fail the master. Then it becomes the
> master.
> Is this a known issue? I was able to replicate it using both MySql 4 and 5
> (trying both the MySQL Connector/J 3.1 and MySQL Connector/J 5.0 drivers)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
