3

So this is the second time it happens.

Specs: SQL Server 2014 Enterprise Failover Cluster with 2 nodes No Quorum ( I Think )

Event Viwer has some events as follow:

enter image description here

The information one always appears 1 second before the critical error.

Information:

Isatap interface isatap.{2B13Exxx-xxxx-xxxx-868D-xxxx959E5250} is no longer active.

I don't know if it's sensitive data so I repaced some number with Xs.

The critial ones are the famous:

Cluster node 'CLUSTER_NAME_SECONDARY' was removed from the active failover cluster membership. The Cluster service on this node may have stopped. This could also be due to the node having lost communication with other active nodes in the failover cluster. Run the Validate a Configuration wizard to check your network configuration. If the condition persists, check for hardware or software errors related to the network adapters on this node. Also check for failures in any other network components to which the node is connected such as hubs, switches, or bridges.

The Cluster service is shutting down because quorum was lost. This could be due to the loss of network connectivity between some or all nodes in the cluster, or a failover of the witness disk. Run the Validate a Configuration wizard to check your network configuration. If the condition persists, check for hardware or software errors related to the network adapter. Also check for failures in any other network components to which the node is connected such as hubs, switches, or bridges.

On SQL Server errors logs, theres nothing useful, only that the cluster was lost.

What place can I find more information, and the error responsible for the failover?

I think it's something related to this isatap adapter but as I see, it just transform ipv6 to ipv4 , according to the internet.

After this, SQL Server is moved to another node with no problems. then I just return it to the old original node manually with no problems too. I just can't understand what's triggering this failover.


EDIT1:

I found some info Here but I really don't know if this is useful or just a random internet post.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.