summaryrefslogtreecommitdiff
path: root/src/sql/selectUninsertableLines.sql
Commit message (Collapse)AuthorAge
* Insert uninsirtable lines using the hostnameId recorded in the bad_lines tableDan Goodliffe7 days
| | | | | | | Includes the same fix from the previous commit which stops caching entities until the inserts are complete. Updates storeLogLine to take an insert command with the hostnameId already bound.
* 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.