Mercurial > hg > orthanc-databases

changeset 706:2bf70b3ef0d5 sql-opti

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
use SKIP LOCKED in UpdateInvlidChildCounts
author Alain Mazy <am@orthanc.team>
date Mon, 30 Jun 2025 09:49:36 +0200
parents 435ad957f829
children 86e27eadc5cc
files PostgreSQL/Plugins/SQL/PrepareIndex.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/PostgreSQL/Plugins/SQL/PrepareIndex.sql	Fri Jun 27 15:29:59 2025 +0200
+++ b/PostgreSQL/Plugins/SQL/PrepareIndex.sql	Mon Jun 30 09:49:36 2025 +0200
@@ -715,7 +715,7 @@
     SELECT ARRAY(SELECT internalId
                  FROM Resources
                  WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts)
-                 FOR UPDATE)
+                 FOR UPDATE SKIP LOCKED)
     INTO locked_resources_ids;
 
     -- New rows can be added in the meantime, they won't be taken into account this time.