You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Fix server freeze under sustained load with dashboard enabled — Knex's default connection pool (min: 2, max: 10) creates multiple better-sqlite3 connections. Under load, concurrent writes from these connections cause SQLITE_BUSY deadlocks that freeze the event loop. Fixed by using a single-connection pool (min: 1, max: 1) which serializes all SQLite access. Also added busy_timeout=5000 as a safety net and moved PRAGMAs to pool.afterCreate so every connection gets them consistently.
