summaryrefslogtreecommitdiff
path: root/src/sql/selectUninsertableLines.sql
Commit message (Collapse)AuthorAge
* Include extra details when storing unparsable and uninsertable lines.Dan Goodliffe7 days
| | | | | | | | Now includes the hostnameId, timestamp and optionally error message. Updates idx_entities_retryinsert to account for details not being NULL. Also fixes the issue where the entities inserted and rollback would still be recorded in the entity cache if the access log insert failed. This would have lead to PK violations later on.
* Select uninsertable is for updatewebstat-0.6Dan Goodliffe2026-06-08
| | | | | This prevents other instances acting on the same rows in parallel, potentially duplicating the rows and effort.
* Run the retry uninsertable process batchedDan Goodliffe2026-05-19
| | | | | 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 failedDan Goodliffe2026-05-18
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.