SQL SERVER 2019 ON CENTOS WITH PACEMAKER ISSUE

Issues related to applications and software problems
Post Reply
cdnbf1
Posts: 2
Joined: 2021/06/22 21:45:00

SQL SERVER 2019 ON CENTOS WITH PACEMAKER ISSUE

Post by cdnbf1 » 2021/06/22 21:54:44

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?

cdnbf1
Posts: 2
Joined: 2021/06/22 21:45:00

Re: SQL SERVER 2019 ON CENTOS WITH PACEMAKER ISSUE

Post by cdnbf1 » 2021/06/23 15:19:14

#4. Has anyone ran SQL Server on RHEL with Pacemaker(PCS) In Production?

Post Reply