{"record":{"id":"1e20936e35c21db5","repo":"paperclipai/paperclip","slug":"failed-to-restore-basename-opts-backupfile","errorCode":null,"errorMessage":"Failed to restore ${basename(opts.backupFile)}: ${sanitizeRestoreErrorMessage(error)}${statementPreview ? ` [statement: ${statementPreview.slice(0, 120)}]` : \"\"}${psqlMessage}","messagePattern":"Failed to restore (.+?): (.+?)(.+?)\\]` : \"\"\\}(.+?)","errorType":"exception","errorClass":null,"httpStatus":null,"severity":"error","filePath":"packages/db/src/backup-lib.ts","lineNumber":1022,"sourceCode":"    }\n  }\n\n  const sql = postgres(opts.connectionString, { max: 1, connect_timeout: connectTimeout });\n\n  try {\n    await sql`SELECT 1`;\n    for await (const statement of readRestoreStatements(opts.backupFile)) {\n      await sql.unsafe(statement).execute();\n    }\n  } catch (error) {\n    const statementPreview = typeof error === \"object\" && error !== null && typeof (error as Record<string, unknown>).query === \"string\"\n      ? String((error as Record<string, unknown>).query)\n        .split(/\\r?\\n/)\n        .map((line) => line.trim())\n        .find((line) => line.length > 0 && !line.startsWith(\"--\"))\n      : null;\n    const psqlMessage = psqlRestoreError === null ? \"\" : `; psql error: ${sanitizeRestoreErrorMessage(psqlRestoreError)}`;\n    throw new Error(\n      `Failed to restore ${basename(opts.backupFile)}: ${sanitizeRestoreErrorMessage(error)}${statementPreview ? ` [statement: ${statementPreview.slice(0, 120)}]` : \"\"}${psqlMessage}`,\n    );\n  } finally {\n    await sql.end();\n  }\n}\n\nexport function formatDatabaseBackupResult(result: RunDatabaseBackupResult): string {\n  const size = formatBackupSize(result.sizeBytes);\n  const pruned = result.prunedCount > 0 ? `; pruned ${result.prunedCount} old backup(s)` : \"\";\n  return `${result.backupFile} (${size}${pruned})`;\n}\n","sourceCodeStart":1004,"sourceCodeEnd":1035,"githubUrl":"https://github.com/paperclipai/paperclip/blob/120ae5428fa29bee300bcf806491cd4d965fbb7c/packages/db/src/backup-lib.ts#L1004-L1035","documentation":"Error \"Failed to restore ${basename(opts.backupFile)}: ${sanitizeRestoreErrorMessage(error)}${statementPreview ? ` [statement: ${statementPreview.slice(0, 120)}]` : \"\"}${psqlMessage}\" thrown in paperclipai/paperclip.","triggerScenarios":"Thrown at packages/db/src/backup-lib.ts:1022 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":["Inspect the statement preview and psql message, fix the failing statement or schema conflict, and retry.","Restore into an empty database to avoid object conflicts."],"exampleFix":null,"handlingStrategy":null,"validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"120ae5428fa29bee300bcf806491cd4d965fbb7c","analyzedAt":"2026-08-18T22:49:45.177Z","contentChangedAt":"2026-08-18T22:49:45.177Z","schemaVersion":2},"datasetVersion":"2026-09-14T05:17:10.506Z"}