My Oracle Support Banner

Resequencer Instances Remain in Running State and Mediator Group in locked state 7 after Server Restart (Doc ID 2278279.1)

Last updated on OCTOBER 27, 2021

Applies to:

Oracle SOA Suite - Version to [Release 12c]
Information in this document applies to any platform.


Instances created by Mediator services (running in a cluster) that use either FIFO or BestEffort resequencing strategy are stuck in running state after restarting servers. MEDIATOR_GROUP_STATUS table shows locked state of 7.

The issue can be reproduced at will with the following steps:
1) Deploy Mediator composites that use FIFO and/or BestEffort sequencing strategy.
2) Generate instances.
3) Stop a server in the cluster mid processing.
4) Run the following database query to monitor the composites' Mediator group status, message status and instance count:

5) Bring up one server.
6) Rerun query.

Query shows the status of resequencers in MEDIATOR_GROUP_STATUS are locked (state 7). Also, the EM Console shows instances for both services are stuck in Running state.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.