From 856527b65e3c4807cf2bfb9d0e495d9712d56a90 Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan@randomdan.homeip.net>
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

