Retry insight persistence with exponential backoff to avoid SQLite lock contention #108

2026-08-07T16:19:36Z

cameron commented

2026-08-07 16:19:36 +00:00

Add retry_with_backoff utility (100ms base, ±25% jitter, 3 attempts)
and replace all 11 direct DAO calls in insight_chat.rs and
insight_generator.rs. The Mutex guard drops between retries so the
maintenance connection can release its SQLite write lock.

Add retry_with_backoff utility (100ms base, ±25% jitter, 3 attempts) and replace all 11 direct DAO calls in insight_chat.rs and insight_generator.rs. The Mutex guard drops between retries so the maintenance connection can release its SQLite write lock.

cameron added 1 commit 2026-08-07 16:19:37 +00:00

Retry insight persistence with exponential backoff to avoid SQLite lock contention 38aaddfd2a

Add retry_with_backoff utility (100ms base, ±25% jitter, 3 attempts)
and replace all 11 direct DAO calls in insight_chat.rs and
insight_generator.rs. The Mutex guard drops between retries so the
maintenance connection can release its SQLite write lock.

cameron merged commit 3732faef71 into master

2026-08-07 16:19:42 +00:00

cameron deleted branch feature/db-locked-fix

2026-08-07 16:19:42 +00:00

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: Apps/ImageApi#108