Feb 2020

1 commit
Test additional speculative conflict scenarios.
12 Feb 2020Andres Freundmaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1
LLM analysis, 98% suremodified before commitmoderate changesfrom patchset #271 of 2 reviewers saw the final version

The commit incorporates #24 and its latest fix-up #27, preserving the speculative-wait and TOAST tests credited to Melanie Plageman, Ashwin Agrawal, and Andres Freund. Beyond that combined state, src/test/isolation/specs/insert-conflict-specconflict.spec adds application names, rewrites lock inspection to include transaction locks filtered by database, and checks two additional lock states.

  • Andres Freundsaw the final versiontrailerAndres checked index ordering in #17, identified lock-query problems in #22, supplied the race fix in #27, and committed the final version after approximately 150 local runs reported in #28.
  • Taylor Veselysaw an earlier versiontrailerMelanie documents Taylor's paired review and naming work in #23 and #24, before the transaction-ordering fix in #27 and the expanded lock checks in the commit.

May 2019

1 commit
Add isolation test for INSERT ON CONFLICT speculative insertion failure.
14 May 2019Andres Freundmaster12beta1REL_19_STABLE12beta1REL_18_STABLE12beta1REL_17_STABLE12beta1REL_16_STABLE12beta1REL_15_STABLE12beta1REL_14_STABLE12beta1REL_13_STABLE12beta1+4 more
LLM analysis, 100% suremodified before commitlight changesfrom patchset #9

The commit preserves all three permutations from #9, renames the test to insert-conflict-specconflict, and registers it in src/test/isolation/isolation_schedule. It removes the temporary nodeModifyTable.c WARNING and corresponding expected output, adds explanatory comments, and explicitly sets read-committed isolation for each session.

Credits across 2 commits

Author
Andres Freund2
Ashwin Agrawal1
Melanie Plageman1
Reviewer
Andres Freund1
Taylor Vesely1
Committer
Andres Freund2