Database Administration (MOSC)

MOSC Banner

Oracle AQ Leave Dead Subscribers in the Queue

in Database Administration (MOSC) 6 commentsAnswered

We are using Oracle AQ(Advanced Queue) in our project. We see messages keep accumulating in our AQ Queue table if subscription is not closed (close method not called) due to developer mistake or due to unexpected shutdown/crash, when un-subscription could not be done.

As a workaround we ran below cleanup script to remove all the subscribers from the JMS broker. We were expecting when we remove active subscription it will throw exception in OnError method of ExceptionListener and we will re-establish the connection here as Our Subscribers are implementing ExceptionListener. But the behaviour we observed is- it does not throw any exception nor it is delivering any new messages. Looks like full subscriber instance is removed along with the Connection object?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center