projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 2678ee1) | 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>
Fri, 17 Jun 2022 13:19:11 +0000 (09:19 -0400)
commit4dda1db5eb26e9fa652d70d20831c5323132e255
tree6f879bf1923ac523edbebc547b7a89da804480fbtree
parent2678ee1dfcc448968ba8e8ae7fd0da1bc69eeecfcommit | 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