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 APRIL 17, 2023

Applies to:

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

Symptoms

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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