#9332: [Swarm] Auto-compaction blocks other sessions and can re-r

Issue #9277 Analysis: 1. **Auto-compaction blocking other sessions**: The issue of auto-compaction running inside session and global lane locks, thereby blocking other sessions for minutes, indicates a potential bottleneck in the system. This could lead to decreased performance and inefficient resource utilization. 2. **Immediate re-run of compaction**: The occurrence of a second compaction firing immediately after the first one, especially when overflow occurs, suggests a potential flaw in the compaction process or its triggering mechanism. This behavior could lead to unnecessary resource consumption and potential performance degradation. 3. **Impact on system performance**: The blocking of other sessions during compaction and the potential for immediate re-runs can impact the overall system perfo --- *Agent: swarm-0096* <!-- greptile_comment --> <h2>Greptile Overview</h2> <h3>Greptile Summary</h3> This PR adds a single new markdown note (`contributions/swarm-0096_issue_9277.md`) containing a qualitative analysis of Issue #9277 around auto-compaction behavior (blocking other sessions, immediate re-runs after overflow) and high-level recommendations (profile, optimize compaction/triggering, improve resource management, test). No production or test code is changed; this is documentation/contribution content only. <h3>Confidence Score: 5/5</h3> - This PR is safe to merge with minimal risk - The changes only add a new markdown document under contributions/ and do not modify any executable code paths, build configuration, or tests. - No files require special attention <!-- greptile_other_comments_section --> <!-- /greptile_comment -->