Could not start OpenArchiver - postgres connection fail #272

New Issue

MrUnknownDE · 2026-04-05T16:17:13+02:00

MrUnknownDE commented

2026-04-05 16:17:13 +02:00

Originally created by @ChrisMcZork on 8/23/2025

While starting up, the OpenArchiver container failes with the following messages in the log:

Running migrations...
Migration failed! DrizzleQueryError: Failed query: CREATE SCHEMA IF NOT EXISTS "drizzle"
params:
at PostgresJsPreparedQuery.queryWithCache (/app/node_modules/.pnpm/drizzle-orm@0.44.2_pg@8.16.3_postgres@3.4.7_sqlite3@5.1.7/node_modules/drizzle-orm/pg-core/session.cjs:67:15)
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
at async PgDialect.migrate (/app/node_modules/.pnpm/drizzle-orm@0.44.2_pg@8.16.3_postgres@3.4.7_sqlite3@5.1.7/node_modules/drizzle-orm/pg-core/dialect.cjs:56:5)
at async migrate (/app/node_modules/.pnpm/drizzle-orm@0.44.2_pg@8.16.3_postgres@3.4.7_sqlite3@5.1.7/node_modules/drizzle-orm/postgres-js/migrator.cjs:27:3)
at async runMigrate (/app/packages/backend/dist/database/migrate.js:20:5) {
query: 'CREATE SCHEMA IF NOT EXISTS "drizzle"',
params: [],
cause: PostgresError: password authentication failed for user "admin"
at ErrorResponse (/app/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
at handle (/app/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)
at Socket.data (/app/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
at Socket.emit (node:events:518:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
severity_local: 'FATAL',
severity: 'FATAL',
code: '28P01',
file: 'auth.c',
line: '329',
routine: 'auth_failed'
}
}
/app/packages/backend:
ERR_PNPM_RECURSIVE_RUN_FIRST_FAIL @open-archiver/backend@0.1.0 db:migrate: node dist/database/migrate.js
Exit status 1
ELIFECYCLE Command failed with exit code 1.
Scope: all 4 workspace projects
Lockfile is up to date, resolution step is skipped
Already up to date

devDependencies: skipped

---------------- 8< ----------
PostgreSQL, Meili and Valkey seem to be running OK
I did work through the installation here: https://docs.openarchiver.com/user-guides/installation.html

Please advise

*Originally created by @ChrisMcZork on 8/23/2025* While starting up, the OpenArchiver container failes with the following messages in the log: Running migrations... Migration failed! DrizzleQueryError: Failed query: CREATE SCHEMA IF NOT EXISTS "drizzle" params: at PostgresJsPreparedQuery.queryWithCache (/app/node_modules/.pnpm/drizzle-orm@0.44.2_pg@8.16.3_postgres@3.4.7_sqlite3@5.1.7/node_modules/drizzle-orm/pg-core/session.cjs:67:15) at process.processTicksAndRejections (node:internal/process/task_queues:105:5) at async PgDialect.migrate (/app/node_modules/.pnpm/drizzle-orm@0.44.2_pg@8.16.3_postgres@3.4.7_sqlite3@5.1.7/node_modules/drizzle-orm/pg-core/dialect.cjs:56:5) at async migrate (/app/node_modules/.pnpm/drizzle-orm@0.44.2_pg@8.16.3_postgres@3.4.7_sqlite3@5.1.7/node_modules/drizzle-orm/postgres-js/migrator.cjs:27:3) at async runMigrate (/app/packages/backend/dist/database/migrate.js:20:5) { query: 'CREATE SCHEMA IF NOT EXISTS "drizzle"', params: [], cause: PostgresError: password authentication failed for user "admin" at ErrorResponse (/app/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26) at handle (/app/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6) at Socket.data (/app/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9) at Socket.emit (node:events:518:28) at addChunk (node:internal/streams/readable:561:12) at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) at Readable.push (node:internal/streams/readable:392:5) at TCP.onStreamRead (node:internal/stream_base_commons:189:23) { severity_local: 'FATAL', severity: 'FATAL', code: '28P01', file: 'auth.c', line: '329', routine: 'auth_failed' } } /app/packages/backend: ERR_PNPM_RECURSIVE_RUN_FIRST_FAIL @open-archiver/backend@0.1.0 db:migrate: `node dist/database/migrate.js` Exit status 1 ELIFECYCLE Command failed with exit code 1. Scope: all 4 workspace projects Lockfile is up to date, resolution step is skipped Already up to date devDependencies: skipped ---------------- 8< ---------- PostgreSQL, Meili and Valkey seem to be running OK I did work through the installation here: https://docs.openarchiver.com/user-guides/installation.html Please advise

MrUnknownDE closed this issue

2026-04-05 16:17:13 +02:00

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/OpenArchiver#272