Error upgrading to 11 #806

New Issue

MrUnknownDE · 2026-04-05T17:46:53+02:00

MrUnknownDE commented

2026-04-05 17:46:53 +02:00

Originally created by @Marco674 on 10/6/2025

Describe the Bug

Hello,

While upgrading to 1.11 with sqlite trough docker container fails to start

`> @fosrl/pangolin@0.0.0 start

ENVIRONMENT=prod node dist/migrations.mjs && ENVIRONMENT=prod NODE_ENV=development node --enable-source-maps dist/server.mjs

Starting migrations from version 1.10.2
Migrations to run: 1.10.4
Running migration 1.10.4
Running setup script 1.10.4...
Failed to run migration 1.10.4: SqliteError: UNIQUE constraint failed: webauthnCredentials.credentialId
at file:///app/dist/migrations.mjs:2457:9
at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24)
at Object.migration23 [as run] (file:///app/dist/migrations.mjs:2482:5)
at executeScripts (file:///app/dist/migrations.mjs:2581:27)
at async runMigrations (file:///app/dist/migrations.mjs:2538:7)
at async run (file:///app/dist/migrations.mjs:2515:3)
at async file:///app/dist/migrations.mjs:2513:1 {
code: 'SQLITE_CONSTRAINT_PRIMARYKEY'
}
Migration process failed: SqliteError: UNIQUE constraint failed: webauthnCredentials.credentialId
at file:///app/dist/migrations.mjs:2457:9
at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24)
at Object.migration23 [as run] (file:///app/dist/migrations.mjs:2482:5)
at executeScripts (file:///app/dist/migrations.mjs:2581:27)
at async runMigrations (file:///app/dist/migrations.mjs:2538:7)
at async run (file:///app/dist/migrations.mjs:2515:3)
at async file:///app/dist/migrations.mjs:2513:1 {
code: 'SQLITE_CONSTRAINT_PRIMARYKEY'
}
Error running migrations: SqliteError: UNIQUE constraint failed: webauthnCredentials.credentialId
at file:///app/dist/migrations.mjs:2457:9
at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24)
at Object.migration23 [as run] (file:///app/dist/migrations.mjs:2482:5)
at executeScripts (file:///app/dist/migrations.mjs:2581:27)
at async runMigrations (file:///app/dist/migrations.mjs:2538:7)
at async run (file:///app/dist/migrations.mjs:2515:3)
at async file:///app/dist/migrations.mjs:2513:1 {
code: 'SQLITE_CONSTRAINT_PRIMARYKEY'
}`

Environment

OS Type & Version: Ubuntu 24.04.3 LTS - Docker version 28.5.0, build 887030f
Pangolin Version: 1.10.3
Gerbil Version: 1.2.1
Traefik Version: 3.5.3
Newt Version: 1.5.1
Olm Version: (if applicable) N/A

To Reproduce

If i downgrade to 1.10.3 -> No issue
While using latest image -> Try to upgrade to 1.11 and fails

Expected Behavior

Upgrade working and container starting

*Originally created by @Marco674 on 10/6/2025* ### Describe the Bug Hello, While upgrading to 1.11 with sqlite trough docker container fails to start `> @fosrl/pangolin@0.0.0 start > ENVIRONMENT=prod node dist/migrations.mjs && ENVIRONMENT=prod NODE_ENV=development node --enable-source-maps dist/server.mjs Starting migrations from version 1.10.2 Migrations to run: 1.10.4 Running migration 1.10.4 Running setup script 1.10.4... Failed to run migration 1.10.4: SqliteError: UNIQUE constraint failed: webauthnCredentials.credentialId at file:///app/dist/migrations.mjs:2457:9 at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24) at Object.migration23 [as run] (file:///app/dist/migrations.mjs:2482:5) at executeScripts (file:///app/dist/migrations.mjs:2581:27) at async runMigrations (file:///app/dist/migrations.mjs:2538:7) at async run (file:///app/dist/migrations.mjs:2515:3) at async file:///app/dist/migrations.mjs:2513:1 { code: 'SQLITE_CONSTRAINT_PRIMARYKEY' } Migration process failed: SqliteError: UNIQUE constraint failed: webauthnCredentials.credentialId at file:///app/dist/migrations.mjs:2457:9 at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24) at Object.migration23 [as run] (file:///app/dist/migrations.mjs:2482:5) at executeScripts (file:///app/dist/migrations.mjs:2581:27) at async runMigrations (file:///app/dist/migrations.mjs:2538:7) at async run (file:///app/dist/migrations.mjs:2515:3) at async file:///app/dist/migrations.mjs:2513:1 { code: 'SQLITE_CONSTRAINT_PRIMARYKEY' } Error running migrations: SqliteError: UNIQUE constraint failed: webauthnCredentials.credentialId at file:///app/dist/migrations.mjs:2457:9 at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24) at Object.migration23 [as run] (file:///app/dist/migrations.mjs:2482:5) at executeScripts (file:///app/dist/migrations.mjs:2581:27) at async runMigrations (file:///app/dist/migrations.mjs:2538:7) at async run (file:///app/dist/migrations.mjs:2515:3) at async file:///app/dist/migrations.mjs:2513:1 { code: 'SQLITE_CONSTRAINT_PRIMARYKEY' }` ### Environment - OS Type & Version: Ubuntu 24.04.3 LTS - Docker version 28.5.0, build 887030f - Pangolin Version: 1.10.3 - Gerbil Version: 1.2.1 - Traefik Version: 3.5.3 - Newt Version: 1.5.1 - Olm Version: (if applicable) N/A ### To Reproduce If i downgrade to 1.10.3 -> No issue While using latest image -> Try to upgrade to 1.11 and fails ### Expected Behavior Upgrade working and container starting

MrUnknownDE closed this issue

2026-04-05 17:46:53 +02:00

MrUnknownDE added the bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug labels 2026-04-05 17:46:55 +02:00

Sign in to join this conversation.

Branches Tags

main

dev

dependabot/npm_and_yarn/dev-minor-updates-b4e5d6b9c5

revert-2766-feature/systemd-install-instructions

dependabot/npm_and_yarn/prod-patch-updates-05702d39f2

dependabot/npm_and_yarn/next-16.2.1

dependabot/npm_and_yarn/recharts-3.8.1

alerting-rules

private-site-ha

dependabot/docker/docker/library/node-25-slim

ssh

delete-account

msg-delivery

org-only-idp

cicd

patch

site-targets-auto-login

No Label bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/pangolin#806