Oguz Kilcan 3640387a10
fix: batch SQLite cleanup deletes to reduce write lock contention
Break large DELETE operations in audit log and machine log cleanup into batches of 1000 rows. Each statement releases the SQLite write lock on completion, preventing long-held locks from blocking concurrent writers.

- Audit log Remove() now deletes in batched subquery loops
- Machine log DoCleanup() split into cleanupByTime() and cleanupOrphans() phases, each batched independently
- Initial cleanup failure in log manager is now non-fatal (warns and retries on next tick) to avoid blocking startup

Signed-off-by: Oguz Kilcan <oguz.kilcan@siderolabs.com>
(cherry picked from commit 3251d1429e582b8c1bea99dd475296c0ed17abe4)
2026-04-09 12:51:41 +02:00
..
2026-01-21 15:30:49 +01:00
2026-01-21 15:30:49 +01:00
2026-01-21 15:30:49 +01:00
2026-01-21 15:30:49 +01:00
2026-02-12 20:43:45 +01:00
2026-01-21 15:30:49 +01:00
2026-01-21 15:30:49 +01:00
2026-01-21 15:30:49 +01:00
2026-01-21 15:30:49 +01:00
2026-01-21 15:30:49 +01:00