fix: keep SQLite pragma tuning best effort

TheLastCicada · TheLastCicada · commit 54fd3bb85a4d · 2026-05-06T10:39:00.000-07:00
Log transient PRAGMA setup failures instead of blocking SQLite connection
acquisition so performance tuning cannot prevent startup.
diff --git a/src/database/sqlite-pragmas.js b/src/database/sqlite-pragmas.js
@@ -1,3 +1,5 @@
+import { logger } from '../config/logger.js';
+
 const SQLITE_PRAGMAS = [
   'PRAGMA synchronous = NORMAL',
   'PRAGMA cache_size = -65536',
@@ -34,8 +36,13 @@ export const installSqlitePragmas = (sequelize) => {
     const connection = await getConnection(...args);
 
     if (!configuredConnections.has(connection)) {
-      await applySqlitePragmas(connection);
-      configuredConnections.add(connection);
+      try {
+        await applySqlitePragmas(connection);
+        configuredConnections.add(connection);
+      } catch (error) {
+        const message = error instanceof Error ? error.message : String(error);
+        logger.warn(`Could not apply SQLite PRAGMAs: ${message}`);
+      }
     }
 
     return connection;
