projects / evergreen / pines.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: c74d59b) | patch
LP#1931737: DYM can cause deadlocks w/ parallel ingest
authorMike Rylander <mrylander@gmail.com>
Fri, 4 Mar 2022 15:38:12 +0000 (10:38 -0500)
committerMike Rylander <mrylander@gmail.com>
Tue, 25 Oct 2022 15:41:27 +0000 (11:41 -0400)
commit7a27063c8afbdf8ff3becf7a8c1542334e0999ce
tree4499fcbc8c6debd3d9cb9a4b0b9760aa12101351tree
parentc74d59b4699e761ebc914501c60c5fbcad0e2623commit | 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>
Signed-off-by: blake <blake@mobiusconsortium.org>
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 working repo (PINES)