AMQ 6.3 and Oracle as persistence store: Expired Messages are not deleted from ACTIVEMQ_MSGS

Solution Unverified - Updated -

Issue

Starting from a configuration with Fuse-AMQ 6.3.0 424 and using Oracle 19 as message store, we have detected that the expired messages of a topic are not deleted from the ACTIVEMQ_MSGS table while there are subscribers of such topic connected. This is a problem because we have different subscribers with different values in the "selector" property which are always connected, so there are messages which are not read, expire and are never deleted.

Environment

  • Red Hat AMQ
    • 6.3

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content