From 856527b65e3c4807cf2bfb9d0e495d9712d56a90 Mon Sep 17 00:00:00 2001 From: Dan Goodliffe Date: Mon, 8 Jun 2026 23:36:01 +0100 Subject: Select uninsertable is for update This prevents other instances acting on the same rows in parallel, potentially duplicating the rows and effort. --- src/sql/selectUninsertableLines.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'src/sql/selectUninsertableLines.sql') diff --git a/src/sql/selectUninsertableLines.sql b/src/sql/selectUninsertableLines.sql index 5c07791..894ab67 100644 --- a/src/sql/selectUninsertableLines.sql +++ b/src/sql/selectUninsertableLines.sql @@ -9,3 +9,4 @@ WHERE ORDER BY id LIMIT ? +FOR UPDATE -- cgit v1.3