Robustness: recover orphaned subscription file locks; single-flight manual venue refresh
This issue addresses two resilience problems in the Mimir project. First, it aims to prevent orphaned subscription file locks by implementing a mechanism to detect and break stale locks, avoiding perpetual timeouts. Second, it proposes adding a single-flight guard to the manual venue refresh process to prevent redundant fetches and writes when triggered concurrently with the scheduled refresh.