Powerpipe time filters not working consistently, detections fail with error "PRAGMA journal_mode=WAL": database is locked

[Priyanka-Chatterjee-2000]

Powerpipe branch - ducklake
Tailpipe branch - ducklake
When applying time filters in Powerpipe Detection Dashboard, we hit random failures for different detections with the following error:

Invalid Error: Failed to query the most recent snapshot for DuckLake:
Failed to execute query "PRAGMA journal_mode=WAL": database is locked

Dashboard detection counts are inconsistent:
• 1hr total → 259 → 261 (keeps changing)
• 3hr total → 264
• 6hr total → 262 → 264 (intermittent mismatch)
• 12hr total → 243
• 1d total → 192
• 7d total → 262
• 30d total → 264
They should increase with time, like for example, in
Powerpipe branch - main
Tailpipe branch - main
Dashboard detection counts are:
• 1hr total → 0
• 3hr total → 1
• 6hr total → 1
• 12hr total → 1
• 1d total → 1
• 7d total → 20
• 30d total → 261

[github-actions]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.