19407

Product

Name

Event ID

19407

Event

Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

HADR_AG_LEASE_EXPIRED

Message

Text

The lease between availability group ’%.*ls’ and the Windows Server Failover Cluster has

expired. A connectivity issue occurred between the instance of SQL Server and the

Windows Server Failover Cluster. To determine whether the availability group is failing over

correctly, check the corresponding availability group resource in the Windows Server

Failover Cluster.

Error 19407 is raised in the SQL Server error log when the communication between SQL Server

and the Windows Server Failover cluster is lost. Typically a corrective action occurs - a failover

to another Always On node.

A lease is a time-based communication mechanism that takes place between the SQL Server

and the Windows Server Failover Cluster (WSFC) process, specifically the RHS.EXE process. The

two processes communicate with each other periodically to ensure the other process is running

and responding. This communication takes place using Windows

Event objects

and ensures

that a failover of the AG resource doesn’t occur without the knowledge of the WSFC. If one of

the processes doesn’t respond to the lease communication based on a predefined lease

period, a lease timeout occurs. For detailed information, see

Mechanics and guidelines of lease,

cluster, and health check timeouts for Always On availability groups. Also see

How It Works:

Always On Lease Timeout.

ﾉ

Expand table