19419

Product

Name

Event ID

19419

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

HADR_AG_LEASE_EXPIRED_WAITING_FOR_RENEW

Message

Text

Windows Server Failover Cluster did not receive a process event signal from SQL Server

hosting availability group ’%.*ls’ within the lease timeout period.

Error 19419 is raised in the SQL Server error log when the lease worker on the SQL Server side

didn’t get scheduled in time to process event signal from the cluster. Specifically, SQL Server

calls

WaitForMultipleObjects()

waiting for the Lease timeout event to be set in a signaled state.

If the function returns WAIT_OBJECT_0, which indicates success, but by this time the lease has

expired, then error 19419 is raised.

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