New install producing NOT NULL constraint failure #1544

New Issue

MrUnknownDE · 2026-04-05T19:33:54+02:00

MrUnknownDE commented

2026-04-05 19:33:54 +02:00

Originally created by @AaronFOhl on 5/2/2025

I have done the installer both with and without Gerbil for pangolin versions 1.2.0 and 1.3.0.

This morning when I was running testing, everything was running fine, but as of about 12pm today, I keep getting the following error:

pangolin | 2025-05-02T16:58:54.618Z [error]: NOT NULL constraint failed: user.username pangolin | Stack: SqliteError: NOT NULL constraint failed: user.username pangolin | at PreparedQuery.run (/app/node_modules/src/better-sqlite3/session.ts:113:20) pangolin | at QueryPromise.run (/app/node_modules/src/sqlite-core/query-builders/insert.ts:385:26) pangolin | at QueryPromise.execute (/app/node_modules/src/sqlite-core/query-builders/insert.ts:401:53) pangolin | at QueryPromise.then (/app/node_modules/src/query-promise.ts:31:15) {"code":"SQLITE_CONSTRAINT_NOTNULL"} pangolin | 2025-05-02T16:58:54.619Z [error]: Error running setup functions: Rollback pangolin | Stack: DrizzleError: Rollback pangolin | at BetterSQLiteTransaction.rollback (/app/node_modules/src/sqlite-core/session.ts:229:9) pangolin | at Function.<anonymous> (/app/server/setup/setupServerAdmin.ts:78:17) pangolin | at async setupServerAdmin (/app/server/setup/setupServerAdmin.ts:27:5) pangolin | at async runSetupFunctions (/app/server/setup/index.ts:10:9) pangolin | at async startServers (/app/server/index.ts:8:5) {"name":"DrizzleError"}

*Originally created by @AaronFOhl on 5/2/2025* I have done the installer both with and without Gerbil for pangolin versions 1.2.0 and 1.3.0. This morning when I was running testing, everything was running fine, but as of about 12pm today, I keep getting the following error: `pangolin | 2025-05-02T16:58:54.618Z [error]: NOT NULL constraint failed: user.username pangolin | Stack: SqliteError: NOT NULL constraint failed: user.username pangolin | at PreparedQuery.run (/app/node_modules/src/better-sqlite3/session.ts:113:20) pangolin | at QueryPromise.run (/app/node_modules/src/sqlite-core/query-builders/insert.ts:385:26) pangolin | at QueryPromise.execute (/app/node_modules/src/sqlite-core/query-builders/insert.ts:401:53) pangolin | at QueryPromise.then (/app/node_modules/src/query-promise.ts:31:15) {"code":"SQLITE_CONSTRAINT_NOTNULL"} pangolin | 2025-05-02T16:58:54.619Z [error]: Error running setup functions: Rollback pangolin | Stack: DrizzleError: Rollback pangolin | at BetterSQLiteTransaction.rollback (/app/node_modules/src/sqlite-core/session.ts:229:9) pangolin | at Function.<anonymous> (/app/server/setup/setupServerAdmin.ts:78:17) pangolin | at async setupServerAdmin (/app/server/setup/setupServerAdmin.ts:27:5) pangolin | at async runSetupFunctions (/app/server/setup/index.ts:10:9) pangolin | at async startServers (/app/server/index.ts:8:5) {"name":"DrizzleError"}`

MrUnknownDE closed this issue

2026-04-05 19:33:54 +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

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/pangolin#1544