projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 5b7187c) | patch
LP#1931737: DYM can cause deadlocks w/ parallel ingest user/miker/lp-1931737-dym-deadlock-fix
authorMike Rylander <mrylander@gmail.com>
Fri, 4 Mar 2022 15:38:12 +0000 (10:38 -0500)
committerMike Rylander <mrylander@gmail.com>
Mon, 21 Mar 2022 17:33:58 +0000 (13:33 -0400)
commit06f838fc0c7970b39cedc4cbb5ba5d799085dd92
tree988a5acd50c8acd01f8fddd1ed325965d147cb24tree
parent5b7187ce79dd13cc567d6dee5c46554333b9b5e1commit | 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>
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