projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 92b75f9) | 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)
committerJason Stephenson <jason@sigio.com>
Tue, 28 Jun 2022 18:27:40 +0000 (14:27 -0400)
commit206e6e261c877864fb9d689b6223945f445af4f7
tree7ce802d1a6bd3899d17d1e52f6b8ac3d1109fc07tree
parent92b75f94aa82176338084deb200be6fc9cb43820commit | 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