{"record":{"id":"457b3c8a66ee15fe","repo":"diegosouzapw/OmniRoute","slug":"db-failed-to-verify-call-logs-schema","errorCode":null,"errorMessage":"[DB] Failed to verify call_logs schema:","messagePattern":"\\[DB\\] Failed to verify call_logs schema:","errorType":"console","errorClass":null,"httpStatus":null,"severity":"error","filePath":"src/lib/db/schemaColumns.ts","lineNumber":265,"sourceCode":"      console.log(\"[DB] Added call_logs.model_pinned column\");\n    }\n    if (!columnNames.has(\"session_tag\")) {\n      db.exec(\"ALTER TABLE call_logs ADD COLUMN session_tag TEXT DEFAULT NULL\");\n      console.log(\"[DB] Added call_logs.session_tag column\");\n    }\n\n    db.exec(\n      \"CREATE INDEX IF NOT EXISTS idx_call_logs_requested_model ON call_logs(requested_model)\"\n    );\n    db.exec(\"CREATE INDEX IF NOT EXISTS idx_call_logs_request_type ON call_logs(request_type)\");\n    db.exec(\n      \"CREATE INDEX IF NOT EXISTS idx_cl_combo_target ON call_logs(combo_name, combo_execution_key, timestamp)\"\n    );\n    db.exec(\"CREATE INDEX IF NOT EXISTS idx_cl_correlation_id ON call_logs(correlation_id)\");\n    db.exec(\"CREATE INDEX IF NOT EXISTS idx_cl_session_tag ON call_logs(session_tag)\");\n  } catch (error: unknown) {\n    const message = error instanceof Error ? error.message : String(error);\n    console.warn(\"[DB] Failed to verify call_logs schema:\", message);\n  }\n}\n\nexport function ensureProxyLogsColumns(db: SqliteDatabase) {\n  try {\n    const columns = db.prepare(\"PRAGMA table_info(proxy_logs)\").all() as Array<{\n      name?: string;\n    }>;\n    const columnNames = new Set(columns.map((column) => String(column.name ?? \"\")));\n    if (!columnNames.has(\"egress_ip\")) {\n      db.exec(\"ALTER TABLE proxy_logs ADD COLUMN egress_ip TEXT\");\n      console.log(\"[DB] Added proxy_logs.egress_ip column\");\n    }\n  } catch (error: unknown) {\n    const message = error instanceof Error ? error.message : String(error);\n    console.warn(\"[DB] Failed to verify proxy_logs schema:\", message);\n  }\n}","sourceCodeStart":247,"sourceCodeEnd":283,"githubUrl":"https://github.com/diegosouzapw/OmniRoute/blob/a179ffed5bb2e0b883b9ae7214ce8717b2a94c4d/src/lib/db/schemaColumns.ts#L247-L283","documentation":"Error \"[DB] Failed to verify call_logs schema:\" thrown in diegosouzapw/OmniRoute.","triggerScenarios":"Thrown at src/lib/db/schemaColumns.ts:265 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"}