We have a 3 Node Cluster
All Nodes installed with Centos 7 and SQL Server 2019 Development Edition
SQL Server Always On is configured across all 3 Nodes
Pacemaker (PCS) is the Clustering Software
We are seeing a situation where one of the Nodes in PCS/Cluster is loosing it's Sequence Number.
Message when starting an Availability Groups in debug mode: sudo pcs resource debug-start ag_dev1
"Verifying replica's sequence number vs all sequence numbers..."
"Sequence number line []"
"0 Sequence Numbers were found"
Right now that node is not able to be failed over too.
#1. Has anyone see this issue before?
#2. Any possible resolution steps?
#3. Has anyone ran SQL Server on CENTOS with Pacemaker(PCS)? In Production?
SQL SERVER 2019 ON CENTOS WITH PACEMAKER ISSUE
Re: SQL SERVER 2019 ON CENTOS WITH PACEMAKER ISSUE
#4. Has anyone ran SQL Server on RHEL with Pacemaker(PCS) In Production?