projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: e35d125) | patch
LP#1931737: DYM can cause deadlocks w/ parallel ingest collab/dyrcona/lp1931737-dym-deadlock-fix-signoff
authorMike Rylander <mrylander@gmail.com>
Fri, 4 Mar 2022 15:38:12 +0000 (10:38 -0500)
committerJason Stephenson <jason@sigio.com>
Fri, 8 Apr 2022 14:18:52 +0000 (10:18 -0400)
commita76b67608b9238227a711eabd468c11359cf09ce
tree478c0b17f40574d328625dabf48c29edf36e074btree
parente35d1254e7608f5067fac23da6e62ecf5ef868c8commit | 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>
Signed-off-by: Jason Stephenson <jason@sigio.com>
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