Aug 2021

1 commit
Fix broken snapshot handling in parallel workers.
25 Aug 2021Robert Haasmaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14rc1REL_13_STABLE13.5+3 more
LLM analysis, 100% surelanded as postedfrom patchset #611 of 6 reviewers saw the final version

All four hunks in src/backend/access/transam/parallel.c match #61 exactly after normalizing abbreviated blob hashes, including the isolation-level guards and shared snapshot restoration. The commit credits Greg Nancarrow, and Robert Haas confirms committing it in #62.

  • Zhijie Hou (Fujitsu)saw an earlier versionLLM analysis, 96% sureIn #18, he reproduced the crash and reported two crash-free hours with Greg's inline fix from #14, before the attached versions and subsequent isolation-level changes.
  • Pengchengliusaw an earlier versionLLM analysis, 88% sureIn #20, he reviewed the inline fix from #14, explaining why resetting TransactionXmin should prevent the crash while questioning its effect on other parallel execution scenarios.
  • Pavel Borisovsaw an earlier versionLLM analysis, 99% sureHe tested the original snapshot fix and its reinstatement across isolation levels in #25 and #41, reviewed the alternative approaches in #33 and #37, and supplied a correction to #43 in #44, before the final isolation-level redesign.
  • Maxim Orlovsaw an earlier versionLLM analysis, 86% sureIn #31, he reviewed #22, objected to removing the separate snapshot, and supplied an alternative implementation that was subsequently rejected.
  • Tomas Vondrasaw an earlier versionLLM analysis, 99% sureIn #35, he identified wraparound and visibility problems in #31, questioned higher-isolation-level correctness in #22, and proposed accounting for both snapshots when setting TransactionXmin.
  • Robert Haassaw the final versioncommittercommitted the patch

Credits across 1 commit

Author
Greg NancarrowLLM1
Reviewer
Robert Haascommitter1
Committer
Robert Haas1

N LLM means N of the credits come from LLM analysis, not from commit trailers.