projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 1623d14) | patch
LP#1931737: DYM can cause deadlocks w/ parallel ingest user/sandbergja/lp-1931737-dym-deadlock-fix-signoff
authorMike Rylander <mrylander@gmail.com>
Fri, 4 Mar 2022 15:38:12 +0000 (10:38 -0500)
committerJane Sandberg <js7389@princeton.edu>
Thu, 7 Apr 2022 16:28:33 +0000 (09:28 -0700)
commit3c9e98dc2225cee5e219e7df0dbe55ca6efa38e9
treec0d9bf4f14bf223db9e149aab24ada484293eaectree
parent1623d146d03c136b27bc2e2511105241a58db654commit | diff
LP#1931737: DYM can cause deadlocks w/ parallel ingest

This patch causes all symspell dictionary updates to occur at then end
of metabib search field updates in one go, which allows Postgres' INSERT
... ON CONFLICT mechanism to properly lock and serialize changes when
necessary.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Jane Sandberg <js7389@princeton.edu>
Open-ILS/src/sql/Pg/030.schema.metabib.sql diff | blob | history
Open-ILS/src/sql/Pg/300.schema.staged_search.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/WWWW.schema.dym_update_and_reify.sql [new file with mode: 0644] blob
Evergreen ILS