model-writtenrun 9090 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Fujii Masao reported that delayed archive recovery used an unowned recoveryWakeupLatch and triggered an assertion failure, proposing to disable recovery_min_apply_delay outside standby mode in #1.
- Michael Paquier reviewed the code and requested safeguards for entering XLOG_FROM_STREAM in #2; Fujii added two standby assertions in #3, which Michael reviewed with an indentation nit in #4.
- Fujii reconsidered the restriction after finding that the documentation promised to honor the delay beyond streaming replication in #5, then posted #6 to acquire the latch during archive recovery while explicitly excluding crash recovery.
- Michael reproduced the failure and reviewed the replacement patch in #7, explaining that ArchiveRecoveryRequested already covers standby mode and requesting simpler conditions plus an archiving test.
- Fujii split #6 into 9b95a36be8, excluding crash recovery and updating documentation, and ec1259e880, fixing archive-recovery latch ownership and adding the assertions; both incorporated Michael’s condition simplifications, but neither added the requested test.
- Michael confirmed the archive-recovery fix had landed in #8; the crash-recovery fix was backpatched to version 12, while the archive-recovery fix was backpatched through version 9.4.
- After landing, Alvaro Herrera asked how the original bug affected builds without assertions in #9; Fujii clarified in #10 that recovery failed with a fatal latch-ownership error and shut down the server, leaving both fixes committed with no further patch pending.