#781 HIGH: HeartbeatService SKIP LOCKED may cause premature task timeout

HeartbeatService uses FOR UPDATE SKIP LOCKED, skipping rows locked by workflow transaction. If workflow holds lock >30s during complex orchestration, heartbeat is skipped and TimeoutService marks task as failed. Location: engine/services/heartbeat_service.py:221-227. Fix: Use advisory locks or increase staleness threshold.