WebStat analyser/src/sql/selectUninsertableLines.sql, branch main WebStat web site access analyser http://git.randomdan.homeip.net/repo/webstat/atom?h=main 2026-06-08T22:36:01Z Select uninsertable is for update 2026-06-08T22:36:01Z Dan Goodliffe dan@randomdan.homeip.net 2026-06-08T22:36:01Z urn:sha1:856527b65e3c4807cf2bfb9d0e495d9712d56a90 This prevents other instances acting on the same rows in parallel, potentially duplicating the rows and effort. Run the retry uninsertable process batched 2026-05-18T23:36:50Z Dan Goodliffe dan@randomdan.homeip.net 2026-05-18T23:36:50Z urn:sha1:b298237a297cb70640c85c016b702a35ecafd9b9 Standard sized batch in a transaction, ordered by entity id. Includes early exit if terminated. Add job to retry insertion of log lines which had previously failed 2026-05-18T19:43:51Z Dan Goodliffe dan@randomdan.homeip.net 2026-05-18T19:43:51Z urn:sha1:e1a6654bd5e284842ffbc3b93bd390f3bad7a187 Entities are reparsed and reinserted, removed on success. Failure to parse updates the entity type to UnparsableLine. Failure to insert again updates the detail with the reason.