merchant

commit d8687409fb60842079eb19fde79a48fb9759f9b1
parent a35e20ca524de7b3c3e8c4a7dfeb851f8a191feb
Author: Christian Grothoff <christian@grothoff.org>
Date:   Wed, 10 Jun 2026 17:02:40 +0200

break up gc into multiple tx

Diffstat:
M
src/backenddb/gc.sql
 | 
3
++-

1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/src/backenddb/gc.sql b/src/backenddb/gc.sql
@@ -28,7 +28,7 @@ BEGIN
   DELETE FROM merchant.merchant_instances
     WHERE validation_needed
       AND validation_expiration < in_now;
-
+  COMMIT;
   -- Per-instance GC: loop over all surviving instances and run the
   -- per-instance GC helpers + targeted DELETEs in each schema.
   FOR rec IN SELECT merchant_serial FROM merchant.merchant_instances
@@ -47,6 +47,7 @@ BEGIN
       WHEN undefined_function THEN
         NULL;
     END;
+    COMMIT;
   END LOOP;
   DELETE FROM merchant.tan_challenges
     WHERE expiration_date < $1;