{"record":{"id":"981ddda2199c0d0a","repo":"diegosouzapw/OmniRoute","slug":"db-failed-to-create-reason-backup","errorCode":null,"errorMessage":"[DB] Failed to create ${reason} backup:","messagePattern":"\\[DB\\] Failed to create (.+?) backup:","errorType":"console","errorClass":null,"httpStatus":null,"severity":"error","filePath":"src/lib/db/core.ts","lineNumber":875,"sourceCode":"  const isTest = isAutomatedTestProcess();\n  if (isTest) return false;\n\n  try {\n    const backupDir = DB_BACKUPS_DIR || path.join(DATA_DIR, \"db_backups\");\n    if (!fs.existsSync(backupDir)) {\n      fs.mkdirSync(backupDir, { recursive: true });\n    }\n\n    const timestamp = new Date().toISOString().replace(/[:.]/g, \"-\");\n    const backupPath = path.join(backupDir, `db_${timestamp}_${reason}.sqlite`);\n    const escapedBackupPath = backupPath.replace(/'/g, \"''\");\n\n    db.exec(`VACUUM INTO '${escapedBackupPath}'`);\n    console.log(`[DB] Backup created (${reason}): ${backupPath}`);\n    return true;\n  } catch (error: unknown) {\n    const message = error instanceof Error ? error.message : String(error);\n    console.warn(`[DB] Failed to create ${reason} backup:`, message);\n    return false;\n  }\n}\n\nfunction createHealthCheckBackup(db: SqliteDatabase): boolean {\n  return createManagedDbBackup(db, \"health-check-repair\");\n}\n\nfunction autoMigrateLegacyEncryptedConnections(db: SqliteDatabase): number {\n  const rows = db.prepare(\"SELECT * FROM provider_connections\").all() as JsonRecord[];\n  const updateStmt = db.prepare(\n    \"UPDATE provider_connections SET api_key = @apiKey, id_token = @idToken, access_token = @accessToken, refresh_token = @refreshToken, updated_at = @updatedAt WHERE id = @id\"\n  );\n  const encryptedFields = [\"apiKey\", \"idToken\", \"accessToken\", \"refreshToken\"] as const;\n  let migratedCount = 0;\n  let backupCreated = false;\n\n  for (const row of rows) {","sourceCodeStart":857,"sourceCodeEnd":893,"githubUrl":"https://github.com/diegosouzapw/OmniRoute/blob/a179ffed5bb2e0b883b9ae7214ce8717b2a94c4d/src/lib/db/core.ts#L857-L893","documentation":"Error \"[DB] Failed to create ${reason} backup:\" thrown in diegosouzapw/OmniRoute.","triggerScenarios":"Thrown at src/lib/db/core.ts:875 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":[],"exampleFix":null,"handlingStrategy":null,"validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"a179ffed5bb2e0b883b9ae7214ce8717b2a94c4d","analyzedAt":"2026-08-25T18:35:09.898Z","schemaVersion":2},"datasetVersion":"2026-08-25T21:54:21.419Z"}