Description of problem:
In RHEL 8.7, with the use of pacemaker 2.0+ in SQL Server Availability groups,
Automatic failover within the nodes keep happening.

With 3 replicas setup, when SQL is shutdown on primary , failover keeps happening between the replicas.

This is caused/observed by pacemaker breaking change after introducing "on-fail=demote" property.

Version-Release number of selected component (if applicable):

How reproducible:

Steps to Reproduce:
1.Setup sql server 3 node replica in rhel 8.7 with pacemaker 2.0+
2. Stop SQL server in primary
3. Observe that pacemaker failovers HA resource back and forth , attempts to start sql server infinitely.

Actual results:

Expected results:

Additional info: