[GH-ISSUE #2473] Frequent breaking changes in database build & migration commands cause repeated installer and update failures #27791

New Issue

GiteaMirror · 2026-06-10T23:15:39-05:00

GiteaMirror commented

2026-06-10 23:15:39 -05:00

Originally created by @MickLesk on GitHub (Feb 13, 2026).
Original GitHub issue: https://github.com/fosrl/pangolin/issues/2473

Describe the Bug

Over the last 2–3 weeks, Pangolin has changed its database generation and build workflow multiple times (at least 3–4 times), including renaming, removing, and reintroducing npm scripts such as:

build:sqlite
db:sqlite:generate
db:generate
db:pg:generate

These changes are not backward-compatible, often land without stable coordination, and repeatedly break fresh installs, updates, and automation scripts that rely on a predictable build and migration process.

As a result, downstream installers and update scripts are in a constant state of reactive fixes, even though no functional changes were intended on our side.

This is not an isolated incident — it is a recurring pattern tied directly to upstream changes in Pangolin’s build and database workflow.

Environment

OS Type & Version: Debian 13 (LXC)
Pangolin Version: Affected across multiple versions (1.12.x → 1.15.x)
Gerbil Version: Various
Traefik Version: 3.x
Newt Version: As bundled
Olm Version: As bundled

To Reproduce

To Reproduce

Perform a fresh install or run an update using an installer that worked days earlier.
Pangolin installation or update fails with one of the following patterns:

Missing npm scripts (Missing script: build:sqlite, Missing script: db:sqlite:generate)
Database generation commands renamed or removed
Schema or migration mismatches (SQLite errors, missing tables/columns)
Missing generated files in dist/ (e.g. names.json, ios_models.json)

Check recent Pangolin commits or Dockerfile changes — the build/database method has changed again.

Expected Behavior

Pangolin should provide a stable, documented, and versioned database build & migration interface.

Breaking changes to build or DB generation commands should:
- Be clearly documented
- Be coordinated with a migration path
- Not change multiple times within days
Installers and update scripts should not require emergency fixes every few days just to keep Pangolin operational.
By the way, it was never mentioned in any of the current release notes; there were always only direct commits, which makes it impossible to work with.

Originally created by @MickLesk on GitHub (Feb 13, 2026). Original GitHub issue: https://github.com/fosrl/pangolin/issues/2473 ### Describe the Bug Over the last 2–3 weeks, Pangolin has changed its database generation and build workflow multiple times (at least 3–4 times), including renaming, removing, and reintroducing npm scripts such as: - build:sqlite - db:sqlite:generate - db:generate - db:pg:generate These changes are not backward-compatible, often land without stable coordination, and repeatedly break fresh installs, updates, and automation scripts that rely on a predictable build and migration process. As a result, downstream installers and update scripts are in a constant state of reactive fixes, even though no functional changes were intended on our side. This is not an isolated incident — it is a recurring pattern tied directly to upstream changes in Pangolin’s build and database workflow. ### Environment OS Type & Version: Debian 13 (LXC) Pangolin Version: Affected across multiple versions (1.12.x → 1.15.x) Gerbil Version: Various Traefik Version: 3.x Newt Version: As bundled Olm Version: As bundled ### To Reproduce **To Reproduce** 1. Perform a fresh install or run an update using an installer that worked days earlier. 2. Pangolin installation or update fails with one of the following patterns: - Missing npm scripts (Missing script: build:sqlite, Missing script: db:sqlite:generate) - Database generation commands renamed or removed - Schema or migration mismatches (SQLite errors, missing tables/columns) - Missing generated files in dist/ (e.g. names.json, ios_models.json) 3. Check recent Pangolin commits or Dockerfile changes — the build/database method has changed again. ### Expected Behavior Pangolin should provide a stable, documented, and versioned database build & migration interface. - Breaking changes to build or DB generation commands should: - Be clearly documented - Be coordinated with a migration path - Not change multiple times within days - Installers and update scripts should not require emergency fixes every few days just to keep Pangolin operational. - By the way, it was never mentioned in any of the current release notes; there were always only direct commits, which makes it impossible to work with.

GiteaMirror closed this issue

2026-06-10 23:15:39 -05:00

GiteaMirror commented

2026-06-10 23:15:40 -05:00

@oschwartz10612 commented on GitHub (Feb 14, 2026):

Hey, thanks for bringing this up. It is a valid complaint and we should
do better about being consistent and documenting. Right now we are
mostly officially supporting the docker container so thats why we do not
spend much time supporting native deployments but this could change.

Right now you need to set the type first and it should work like in the
Dockerfile:

 npm run set:$DATABASE && \
 npm run set:$BUILD && \
 npm run db:generate && \
 npm run build && \
 npm run build:cli

LMK if that helps

@oschwartz10612 commented on GitHub (Feb 14, 2026): Hey, thanks for bringing this up. It is a valid complaint and we should do better about being consistent and documenting. Right now we are mostly officially supporting the docker container so thats why we do not spend much time supporting native deployments but this could change. Right now you need to set the type first and it should work like in the Dockerfile: npm run set:$DATABASE && \ npm run set:$BUILD && \ npm run db:generate && \ npm run build && \ npm run build:cli LMK if that helps

Sign in to join this conversation.

Branches Tags

main

dev

dependabot/npm_and_yarn/npm-dependencies-8b2d4a9f3a

local-connection

dependabot/go_modules/install/go-install-dependencies-3804ca7238

dependabot/docker/docker-dependencies-4faa477378

dependabot/github_actions/github-actions-dependencies-6d79802a48

api-improvements

feat/remember-last-idp-on-smart-login-form

refactor/batch-status-requests

dependabot/npm_and_yarn/multi-5f1280885e

fix/non-semver-version-error

private-resource-page

resource-launcher

backhaul

exit-node-reconnect

feat/command-palette

ssh

delete-account

msg-delivery

org-only-idp

cicd

patch

site-targets-auto-login

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/pangolin#27791