AQ-RAC: Dequeues Are Not Happening For Ruled Subscribers In RAC For SHARDED QUEUES
(Doc ID 2542594.1)
Last updated on APRIL 09, 2020
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124.0 [Release 12.1 to 18]
Information in this document applies to any platform.
Ruled subscribers in RAC for sharded queues have issues with dequeue. The dequeue affinities of ruled subscribers are not
shifted correctly thereby stopping cross instance dequeues of ruled subscribers in sharded queues.The problem is as follows:
If there are two instances(inst1 and inst2) on RAC.
1) Create two ruled subscribers(sub1, sub2) for a sharded queue.
2) Enqueue 5 messages each on to two subscribers.
1) Dequeue the messages of sub1 and sub2.
In this case mentioned above dequeue is failing hence the test is going to indefinite wait.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document