Method GetStaleChats

coderd/database/querier.go:665–665

Find chats that appear stuck and need recovery: 1. Running chats whose heartbeat has expired (worker crash). 2. requires_action chats past the timeout threshold (client disappeared). 3. Waiting chats with a non-empty queue and stale updated_at (deferred-promote stranding when the worker dies before

(ctx context.Context, staleThreshold time.Time)

	//      (deferred-promote stranding when the worker dies before its
	//      post-cancel cleanup runs).
	GetStaleChats(ctx context.Context, staleThreshold time.Time) ([]Chat, error)
	GetTailnetPeers(ctx context.Context, id uuid.UUID) ([]TailnetPeer, error)
	GetTailnetTunnelPeerBindingsBatch(ctx context.Context, ids []uuid.UUID) ([]GetTailnetTunnelPeerBindingsBatchRow, error)
	GetTailnetTunnelPeerIDsBatch(ctx context.Context, ids []uuid.UUID) ([]GetTailnetTunnelPeerIDsBatchRow, error)