A-MQ get hung if there are too many of messages on a queue and JDBC persistance is used
Issue
We are using Mysql as the jdbc persistence of A-MQ, for some reason, there are about 20 million messages (one message is 1k)on the queue, we found the database table are locked and when executing below command, the table is locked for 90 seconds about every 5 mins.
DELETE FROM ACTIVEMQ_MSGS WHERE (PRIORITY=0 AND ID <= (SELECT min(ACTIVEMQ_ACKS.LAST_ACKED_ID) FROM ACTIVEMQ_ACKS WHERE ACTIVEMQ_ACKS.CONTAINER=ACTIVEMQ_MSGS.CONTAINER AND ACTIVEMQ_ACKS.PRIORITY=0));
Environment
- Red Hat JBoss A-MQ 6.X
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
