diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2026-05-19 00:36:50 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2026-05-19 00:36:50 +0100 |
| commit | b298237a297cb70640c85c016b702a35ecafd9b9 (patch) | |
| tree | e046995df39879d545be04a113cf344c449565ba /src/sql/selectUninsertableLines.sql | |
| parent | e1a6654bd5e284842ffbc3b93bd390f3bad7a187 (diff) | |
| download | webstat-b298237a297cb70640c85c016b702a35ecafd9b9.tar.bz2 webstat-b298237a297cb70640c85c016b702a35ecafd9b9.tar.xz webstat-b298237a297cb70640c85c016b702a35ecafd9b9.zip | |
Run the retry uninsertable process batched
Standard sized batch in a transaction, ordered by entity id.
Includes early exit if terminated.
Diffstat (limited to 'src/sql/selectUninsertableLines.sql')
| -rw-r--r-- | src/sql/selectUninsertableLines.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/src/sql/selectUninsertableLines.sql b/src/sql/selectUninsertableLines.sql index 048726b..5c07791 100644 --- a/src/sql/selectUninsertableLines.sql +++ b/src/sql/selectUninsertableLines.sql @@ -6,3 +6,6 @@ FROM WHERE type = 'uninsertable_line' AND detail IS NULL +ORDER BY + id +LIMIT ? |