3 Replies Latest reply on Jul 14, 2018 12:31 AM by Martien van den Akker

How to delete pending messages from topic?

3609114 Jul 11, 2018 8:32 PM

Why the pending and current messages on given topic not expiring. Please can you help us configure the expiration so the messages on topic expire if not consumed so we have no accumulating messages on our topics. There are no durable subscribers present in the configuration.

what configurations or things we can do to fix this issue going forward? Like setting TTL or Delivery options? Any inputs are highly appreciated.

1. Re: How to delete pending messages from topic?

Martien van den Akker Jul 12, 2018 9:36 AM (in response to 3609114)

Hi,

Messages are pending because a client has gotten them, but not yet acknowledged. I guess it's the client that should be looked into further.
If the client uses a configured connectionfactory (other then the default one), you can set the time-to-live override property on that. It can be set on the queue/topic as well. You could try that.

But, again, it's actually a signal that the consumer is not handling them properly.

Regards,
Martien
Like Show 0 Likes(0)

Actions
2. Re: How to delete pending messages from topic?

3609114 Jul 13, 2018 5:12 PM (in response to 3609114)

Hi Martien,

Thanks for the reply.

Is the solution of setting time-to-live property would act on the messages that are in pending state from long time and how can we delete them ?

Thank you!
Like Show 0 Likes(0)

Actions
3. Re: How to delete pending messages from topic?

Martien van den Akker Jul 14, 2018 12:31 AM (in response to 3609114)

No, I think not. It applies to new messages. Can you stop the consumers?
Then the connections get lost and the messages might get visible again.

Regards,
Martien
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.