github-starred/pangolin
2
0
Fork 0
mirror of https://github.com/fosrl/pangolin.git synced 2026-05-07 21:30:36 -05:00
Code Issues 564 Packages Projects Releases 72 Wiki Activity

[GH-ISSUE #2929] Upgrade from 1.17.0 to 1.18.0 fails #9035

New Issue
Closed
opened 2026-04-30 05:17:28 -05:00 by GiteaMirror · 4 comments
GiteaMirror commented 2026-04-30 05:17:28 -05:00
Owner
Copy Link

Originally created by @coro1404 on GitHub (Apr 29, 2026).
Original GitHub issue: https://github.com/fosrl/pangolin/issues/2929

Originally assigned to: @oschwartz10612 on GitHub.

Describe the Bug

pangolin |
pangolin | > @fosrl/pangolin@0.0.0 start
pangolin | > ENVIRONMENT=prod node dist/migrations.mjs && ENVIRONMENT=prod NODE_ENV=development node --enable-source-maps dist/server.mjs
pangolin |
pangolin | Starting migrations from version 1.17.0
pangolin | Migrations to run: 1.18.0
pangolin | Running migration 1.18.0
pangolin | Running setup script 1.18.0...
pangolin | Found 5 existing targetHealthCheck row(s) to migrate
pangolin | Found 1 existing siteResource(s) to migrate to networks
pangolin | Failed to migrate db: SqliteError: NOT NULL constraint failed: __new_siteResources.tcpPortRangeString
pangolin | at file:///app/dist/migrations.mjs:5029:9
pangolin | at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24)
pangolin | at Object.migration33 [as run] (file:///app/dist/migrations.mjs:5111:7)
pangolin | at executeScripts (file:///app/dist/migrations.mjs:5378:27)
pangolin | at async runMigrations (file:///app/dist/migrations.mjs:5335:7)
pangolin | at async run (file:///app/dist/migrations.mjs:5308:3)
pangolin | at async file:///app/dist/migrations.mjs:5306:1 {
pangolin | code: 'SQLITE_CONSTRAINT_NOTNULL'
pangolin | }

Environment

  • OS Type & Version: (e.g., Ubuntu 22.04)
  • Pangolin Version:
  • Gerbil Version:
  • Traefik Version:
  • Newt Version:
  • Olm Version: (if applicable)

To Reproduce

Switch to 1.18. in docker compose

Expected Behavior

Upgrade works seamless

Originally created by @coro1404 on GitHub (Apr 29, 2026). Original GitHub issue: https://github.com/fosrl/pangolin/issues/2929 Originally assigned to: @oschwartz10612 on GitHub. ### Describe the Bug pangolin | pangolin | > @fosrl/pangolin@0.0.0 start pangolin | > ENVIRONMENT=prod node dist/migrations.mjs && ENVIRONMENT=prod NODE_ENV=development node --enable-source-maps dist/server.mjs pangolin | pangolin | Starting migrations from version 1.17.0 pangolin | Migrations to run: 1.18.0 pangolin | Running migration 1.18.0 pangolin | Running setup script 1.18.0... pangolin | Found 5 existing targetHealthCheck row(s) to migrate pangolin | Found 1 existing siteResource(s) to migrate to networks pangolin | Failed to migrate db: SqliteError: NOT NULL constraint failed: __new_siteResources.tcpPortRangeString pangolin | at file:///app/dist/migrations.mjs:5029:9 pangolin | at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24) pangolin | at Object.migration33 [as run] (file:///app/dist/migrations.mjs:5111:7) pangolin | at executeScripts (file:///app/dist/migrations.mjs:5378:27) pangolin | at async runMigrations (file:///app/dist/migrations.mjs:5335:7) pangolin | at async run (file:///app/dist/migrations.mjs:5308:3) pangolin | at async file:///app/dist/migrations.mjs:5306:1 { pangolin | code: 'SQLITE_CONSTRAINT_NOTNULL' pangolin | } ### Environment - OS Type & Version: (e.g., Ubuntu 22.04) - Pangolin Version: - Gerbil Version: - Traefik Version: - Newt Version: - Olm Version: (if applicable) ### To Reproduce Switch to 1.18. in docker compose ### Expected Behavior Upgrade works seamless
GiteaMirror added the bug label 2026-04-30 05:17:28 -05:00
GiteaMirror commented 2026-04-30 05:17:30 -05:00
Author
Owner
Copy Link

@maddler commented on GitHub (Apr 29, 2026):

Similar issue here

pangolin  | > @fosrl/pangolin@0.0.0 start
pangolin  | > ENVIRONMENT=prod node dist/migrations.mjs && ENVIRONMENT=prod NODE_ENV=development node --enable-source-maps dist/server.mjs
pangolin  |
pangolin  | Starting migrations from version 1.17.0
pangolin  | Migrations to run: 1.18.0
pangolin  | Running migration 1.18.0
pangolin  | Running setup script 1.18.0...
pangolin  | Found 97 existing targetHealthCheck row(s) to migrate
pangolin  | Found 4 existing siteResource(s) to migrate to networks
pangolin  | Failed to migrate db: SqliteError: NOT NULL constraint failed: __new_siteResources.tcpPortRangeString
pangolin  |     at file:///app/dist/migrations.mjs:5029:9
pangolin  |     at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24)
pangolin  |     at Object.migration33 [as run] (file:///app/dist/migrations.mjs:5111:7)
pangolin  |     at executeScripts (file:///app/dist/migrations.mjs:5378:27)
pangolin  |     at async runMigrations (file:///app/dist/migrations.mjs:5335:7)
pangolin  |     at async run (file:///app/dist/migrations.mjs:5308:3)
pangolin  |     at async file:///app/dist/migrations.mjs:5306:1 {
pangolin  |   code: 'SQLITE_CONSTRAINT_NOTNULL'
pangolin  | }
pangolin  | Failed to run migration 1.18.0: SqliteError: NOT NULL constraint failed: __new_siteResources.tcpPortRangeString
pangolin  |     at file:///app/dist/migrations.mjs:5029:9
pangolin  |     at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24)
pangolin  |     at Object.migration33 [as run] (file:///app/dist/migrations.mjs:5111:7)
pangolin  |     at executeScripts (file:///app/dist/migrations.mjs:5378:27)
pangolin  |     at async runMigrations (file:///app/dist/migrations.mjs:5335:7)
pangolin  |     at async run (file:///app/dist/migrations.mjs:5308:3)
pangolin  |     at async file:///app/dist/migrations.mjs:5306:1 {
pangolin  |   code: 'SQLITE_CONSTRAINT_NOTNULL'
pangolin  | }
pangolin  | Migration process failed: SqliteError: NOT NULL constraint failed: __new_siteResources.tcpPortRangeString
pangolin  |     at file:///app/dist/migrations.mjs:5029:9
pangolin  |     at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24)
pangolin  |     at Object.migration33 [as run] (file:///app/dist/migrations.mjs:5111:7)
pangolin  |     at executeScripts (file:///app/dist/migrations.mjs:5378:27)
pangolin  |     at async runMigrations (file:///app/dist/migrations.mjs:5335:7)
pangolin  |     at async run (file:///app/dist/migrations.mjs:5308:3)
pangolin  |     at async file:///app/dist/migrations.mjs:5306:1 {
pangolin  |   code: 'SQLITE_CONSTRAINT_NOTNULL'
pangolin  | }
pangolin  | Error running migrations: SqliteError: NOT NULL constraint failed: __new_siteResources.tcpPortRangeString
pangolin  |     at file:///app/dist/migrations.mjs:5029:9
pangolin  |     at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24)
pangolin  |     at Object.migration33 [as run] (file:///app/dist/migrations.mjs:5111:7)
pangolin  |     at executeScripts (file:///app/dist/migrations.mjs:5378:27)
pangolin  |     at async runMigrations (file:///app/dist/migrations.mjs:5335:7)
pangolin  |     at async run (file:///app/dist/migrations.mjs:5308:3)
pangolin  |     at async file:///app/dist/migrations.mjs:5306:1 {
pangolin  |   code: 'SQLITE_CONSTRAINT_NOTNULL'
pangolin  | }
<!-- gh-comment-id:4346355003 --> @maddler commented on GitHub (Apr 29, 2026): Similar issue here ``` pangolin | > @fosrl/pangolin@0.0.0 start pangolin | > ENVIRONMENT=prod node dist/migrations.mjs && ENVIRONMENT=prod NODE_ENV=development node --enable-source-maps dist/server.mjs pangolin | pangolin | Starting migrations from version 1.17.0 pangolin | Migrations to run: 1.18.0 pangolin | Running migration 1.18.0 pangolin | Running setup script 1.18.0... pangolin | Found 97 existing targetHealthCheck row(s) to migrate pangolin | Found 4 existing siteResource(s) to migrate to networks pangolin | Failed to migrate db: SqliteError: NOT NULL constraint failed: __new_siteResources.tcpPortRangeString pangolin | at file:///app/dist/migrations.mjs:5029:9 pangolin | at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24) pangolin | at Object.migration33 [as run] (file:///app/dist/migrations.mjs:5111:7) pangolin | at executeScripts (file:///app/dist/migrations.mjs:5378:27) pangolin | at async runMigrations (file:///app/dist/migrations.mjs:5335:7) pangolin | at async run (file:///app/dist/migrations.mjs:5308:3) pangolin | at async file:///app/dist/migrations.mjs:5306:1 { pangolin | code: 'SQLITE_CONSTRAINT_NOTNULL' pangolin | } pangolin | Failed to run migration 1.18.0: SqliteError: NOT NULL constraint failed: __new_siteResources.tcpPortRangeString pangolin | at file:///app/dist/migrations.mjs:5029:9 pangolin | at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24) pangolin | at Object.migration33 [as run] (file:///app/dist/migrations.mjs:5111:7) pangolin | at executeScripts (file:///app/dist/migrations.mjs:5378:27) pangolin | at async runMigrations (file:///app/dist/migrations.mjs:5335:7) pangolin | at async run (file:///app/dist/migrations.mjs:5308:3) pangolin | at async file:///app/dist/migrations.mjs:5306:1 { pangolin | code: 'SQLITE_CONSTRAINT_NOTNULL' pangolin | } pangolin | Migration process failed: SqliteError: NOT NULL constraint failed: __new_siteResources.tcpPortRangeString pangolin | at file:///app/dist/migrations.mjs:5029:9 pangolin | at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24) pangolin | at Object.migration33 [as run] (file:///app/dist/migrations.mjs:5111:7) pangolin | at executeScripts (file:///app/dist/migrations.mjs:5378:27) pangolin | at async runMigrations (file:///app/dist/migrations.mjs:5335:7) pangolin | at async run (file:///app/dist/migrations.mjs:5308:3) pangolin | at async file:///app/dist/migrations.mjs:5306:1 { pangolin | code: 'SQLITE_CONSTRAINT_NOTNULL' pangolin | } pangolin | Error running migrations: SqliteError: NOT NULL constraint failed: __new_siteResources.tcpPortRangeString pangolin | at file:///app/dist/migrations.mjs:5029:9 pangolin | at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24) pangolin | at Object.migration33 [as run] (file:///app/dist/migrations.mjs:5111:7) pangolin | at executeScripts (file:///app/dist/migrations.mjs:5378:27) pangolin | at async runMigrations (file:///app/dist/migrations.mjs:5335:7) pangolin | at async run (file:///app/dist/migrations.mjs:5308:3) pangolin | at async file:///app/dist/migrations.mjs:5306:1 { pangolin | code: 'SQLITE_CONSTRAINT_NOTNULL' pangolin | } ```
GiteaMirror commented 2026-04-30 05:17:31 -05:00
Author
Owner
Copy Link

@oschwartz10612 commented on GitHub (Apr 29, 2026):

This will be fixed in the 1.18.1 release which will happen in an hour or two

<!-- gh-comment-id:4346601221 --> @oschwartz10612 commented on GitHub (Apr 29, 2026): This will be fixed in the 1.18.1 release which will happen in an hour or two
GiteaMirror commented 2026-04-30 05:17:32 -05:00
Author
Owner
Copy Link

@oschwartz10612 commented on GitHub (Apr 29, 2026):

Should be fixed with the 1.18.1 update just released. LMK

<!-- gh-comment-id:4347984640 --> @oschwartz10612 commented on GitHub (Apr 29, 2026): Should be fixed with the 1.18.1 update just released. LMK
GiteaMirror commented 2026-04-30 05:17:32 -05:00
Author
Owner
Copy Link

@maddler commented on GitHub (Apr 29, 2026):

Giving a go now. Installed fine. Checking everything now.

<!-- gh-comment-id:4347989755 --> @maddler commented on GitHub (Apr 29, 2026): Giving a go now. Installed fine. Checking everything now.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
api
authentication
bug
config
dependencies
docker
documentation
enhancement
good first issue
help wanted
Improvement
Look Into
needs investigating
networking
new feature
non-critical bug
potential bug
pull-request
Mirrored from GitHub Pull Request
 question
reverse proxy
Security
stale
ui
wontfix
No Label bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/pangolin#9035
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?