[GH-ISSUE #3018] 1.18.3 - Appears to cause Sqlite Mirgration Issues #15182

New Issue

Closed

opened 2026-05-16 03:30:30 -05:00 by GiteaMirror · 2 comments

GiteaMirror commented 2026-05-16 03:30:30 -05:00

Owner

Copy Link

Copy Source

Originally created by @JDKB22 on GitHub (May 7, 2026).
Original GitHub issue: https://github.com/fosrl/pangolin/issues/3018

Originally assigned to: @oschwartz10612 on GitHub.

Describe the Bug

After updating to EE-1.18.3 from 1.18.3 it appears this creates an issue for the migration process for an sqlite DB.

2026-05-07T01:07:35.368059728Z Starting migrations from version 1.18.2
2026-05-07T01:07:35.369929162Z Migrations to run: 1.18.3
2026-05-07T01:07:35.370123576Z Running migration 1.18.3
2026-05-07T01:07:35.373945495Z Running setup script 1.18.3...
2026-05-07T01:07:35.377334455Z Failed to migrate db: SqliteError: table 'trialNotifications' already exists
2026-05-07T01:07:35.377356096Z at Database.prepare (/app/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21)
2026-05-07T01:07:35.377359319Z at file:///app/dist/migrations.mjs:5370:11
2026-05-07T01:07:35.377382479Z at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24)
2026-05-07T01:07:35.377385484Z at Object.migration34 [as run] (file:///app/dist/migrations.mjs:5381:7)
2026-05-07T01:07:35.377388041Z at executeScripts (file:///app/dist/migrations.mjs:5594:27)
2026-05-07T01:07:35.377390552Z at async runMigrations (file:///app/dist/migrations.mjs:5551:7)
2026-05-07T01:07:35.377393151Z at async run (file:///app/dist/migrations.mjs:5524:3)
2026-05-07T01:07:35.377395555Z at async file:///app/dist/migrations.mjs:5522:1 {
2026-05-07T01:07:35.377398111Z code: 'SQLITE_ERROR'
2026-05-07T01:07:35.377400496Z }
2026-05-07T01:07:35.377797645Z Failed to run migration 1.18.3: SqliteError: table 'trialNotifications' already exists
2026-05-07T01:07:35.377810977Z at Database.prepare (/app/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21)
2026-05-07T01:07:35.377813777Z at file:///app/dist/migrations.mjs:5370:11
2026-05-07T01:07:35.377817211Z at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24)
2026-05-07T01:07:35.377819824Z at Object.migration34 [as run] (file:///app/dist/migrations.mjs:5381:7)
2026-05-07T01:07:35.377822454Z at executeScripts (file:///app/dist/migrations.mjs:5594:27)
2026-05-07T01:07:35.377825191Z at async runMigrations (file:///app/dist/migrations.mjs:5551:7)
2026-05-07T01:07:35.377827713Z at async run (file:///app/dist/migrations.mjs:5524:3)
2026-05-07T01:07:35.377830308Z at async file:///app/dist/migrations.mjs:5522:1 {
2026-05-07T01:07:35.377832755Z code: 'SQLITE_ERROR'
2026-05-07T01:07:35.377835157Z }
2026-05-07T01:07:35.378005693Z Migration process failed: SqliteError: table 'trialNotifications' already exists
2026-05-07T01:07:35.378012410Z at Database.prepare (/app/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21)
2026-05-07T01:07:35.378015234Z at file:///app/dist/migrations.mjs:5370:11
2026-05-07T01:07:35.378032310Z at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24)
2026-05-07T01:07:35.378035228Z at Object.migration34 [as run] (file:///app/dist/migrations.mjs:5381:7)
2026-05-07T01:07:35.378037737Z at executeScripts (file:///app/dist/migrations.mjs:5594:27)
2026-05-07T01:07:35.378040403Z at async runMigrations (file:///app/dist/migrations.mjs:5551:7)
2026-05-07T01:07:35.378043041Z at async run (file:///app/dist/migrations.mjs:5524:3)
2026-05-07T01:07:35.378045584Z at async file:///app/dist/migrations.mjs:5522:1 {
2026-05-07T01:07:35.378048069Z code: 'SQLITE_ERROR'
2026-05-07T01:07:35.378050690Z }
2026-05-07T01:07:35.378250243Z Error running migrations: SqliteError: table 'trialNotifications' already exists
2026-05-07T01:07:35.378257020Z at Database.prepare (/app/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21)
2026-05-07T01:07:35.378259717Z at file:///app/dist/migrations.mjs:5370:11
2026-05-07T01:07:35.378262162Z at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24)
2026-05-07T01:07:35.378264848Z at Object.migration34 [as run] (file:///app/dist/migrations.mjs:5381:7)
2026-05-07T01:07:35.378267509Z at executeScripts (file:///app/dist/migrations.mjs:5594:27)
2026-05-07T01:07:35.378270014Z at async runMigrations (file:///app/dist/migrations.mjs:5551:7)
2026-05-07T01:07:35.378272608Z at async run (file:///app/dist/migrations.mjs:5524:3)
2026-05-07T01:07:35.378275159Z at async file:///app/dist/migrations.mjs:5522:1 {
2026-05-07T01:07:35.378277628Z code: 'SQLITE_ERROR'
2026-05-07T01:07:35.378280103Z }

Environment

• OS Type & Version: Ubuntu 24.04.4 LTS
• Pangolin Version: pangolin:ee-1.18.3
• Gerbil Version: gerbil:1.3.1
• Traefik Version: V3.6
• Newt Version: 1.12.3
• Olm Version: (if applicable)

To Reproduce

Update from 1.18.2 to 1.18.3

Expected Behavior

This should follow the normal upgrade process and not hang on the Sqlite Migration.

Originally created by @JDKB22 on GitHub (May 7, 2026). Original GitHub issue: https://github.com/fosrl/pangolin/issues/3018 Originally assigned to: @oschwartz10612 on GitHub. ### Describe the Bug After updating to EE-1.18.3 from 1.18.3 it appears this creates an issue for the migration process for an sqlite DB. > 2026-05-07T01:07:35.368059728Z Starting migrations from version 1.18.2 2026-05-07T01:07:35.369929162Z Migrations to run: 1.18.3 2026-05-07T01:07:35.370123576Z Running migration 1.18.3 2026-05-07T01:07:35.373945495Z Running setup script 1.18.3... 2026-05-07T01:07:35.377334455Z Failed to migrate db: SqliteError: table 'trialNotifications' already exists 2026-05-07T01:07:35.377356096Z at Database.prepare (/app/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21) 2026-05-07T01:07:35.377359319Z at file:///app/dist/migrations.mjs:5370:11 2026-05-07T01:07:35.377382479Z at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24) 2026-05-07T01:07:35.377385484Z at Object.migration34 [as run] (file:///app/dist/migrations.mjs:5381:7) 2026-05-07T01:07:35.377388041Z at executeScripts (file:///app/dist/migrations.mjs:5594:27) 2026-05-07T01:07:35.377390552Z at async runMigrations (file:///app/dist/migrations.mjs:5551:7) 2026-05-07T01:07:35.377393151Z at async run (file:///app/dist/migrations.mjs:5524:3) 2026-05-07T01:07:35.377395555Z at async file:///app/dist/migrations.mjs:5522:1 { 2026-05-07T01:07:35.377398111Z code: 'SQLITE_ERROR' 2026-05-07T01:07:35.377400496Z } 2026-05-07T01:07:35.377797645Z Failed to run migration 1.18.3: SqliteError: table 'trialNotifications' already exists 2026-05-07T01:07:35.377810977Z at Database.prepare (/app/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21) 2026-05-07T01:07:35.377813777Z at file:///app/dist/migrations.mjs:5370:11 2026-05-07T01:07:35.377817211Z at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24) 2026-05-07T01:07:35.377819824Z at Object.migration34 [as run] (file:///app/dist/migrations.mjs:5381:7) 2026-05-07T01:07:35.377822454Z at executeScripts (file:///app/dist/migrations.mjs:5594:27) 2026-05-07T01:07:35.377825191Z at async runMigrations (file:///app/dist/migrations.mjs:5551:7) 2026-05-07T01:07:35.377827713Z at async run (file:///app/dist/migrations.mjs:5524:3) 2026-05-07T01:07:35.377830308Z at async file:///app/dist/migrations.mjs:5522:1 { 2026-05-07T01:07:35.377832755Z code: 'SQLITE_ERROR' 2026-05-07T01:07:35.377835157Z } 2026-05-07T01:07:35.378005693Z Migration process failed: SqliteError: table 'trialNotifications' already exists 2026-05-07T01:07:35.378012410Z at Database.prepare (/app/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21) 2026-05-07T01:07:35.378015234Z at file:///app/dist/migrations.mjs:5370:11 2026-05-07T01:07:35.378032310Z at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24) 2026-05-07T01:07:35.378035228Z at Object.migration34 [as run] (file:///app/dist/migrations.mjs:5381:7) 2026-05-07T01:07:35.378037737Z at executeScripts (file:///app/dist/migrations.mjs:5594:27) 2026-05-07T01:07:35.378040403Z at async runMigrations (file:///app/dist/migrations.mjs:5551:7) 2026-05-07T01:07:35.378043041Z at async run (file:///app/dist/migrations.mjs:5524:3) 2026-05-07T01:07:35.378045584Z at async file:///app/dist/migrations.mjs:5522:1 { 2026-05-07T01:07:35.378048069Z code: 'SQLITE_ERROR' 2026-05-07T01:07:35.378050690Z } 2026-05-07T01:07:35.378250243Z Error running migrations: SqliteError: table 'trialNotifications' already exists 2026-05-07T01:07:35.378257020Z at Database.prepare (/app/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21) 2026-05-07T01:07:35.378259717Z at file:///app/dist/migrations.mjs:5370:11 2026-05-07T01:07:35.378262162Z at sqliteTransaction (/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24) 2026-05-07T01:07:35.378264848Z at Object.migration34 [as run] (file:///app/dist/migrations.mjs:5381:7) 2026-05-07T01:07:35.378267509Z at executeScripts (file:///app/dist/migrations.mjs:5594:27) 2026-05-07T01:07:35.378270014Z at async runMigrations (file:///app/dist/migrations.mjs:5551:7) 2026-05-07T01:07:35.378272608Z at async run (file:///app/dist/migrations.mjs:5524:3) 2026-05-07T01:07:35.378275159Z at async file:///app/dist/migrations.mjs:5522:1 { 2026-05-07T01:07:35.378277628Z code: 'SQLITE_ERROR' 2026-05-07T01:07:35.378280103Z } ### Environment - OS Type & Version: Ubuntu 24.04.4 LTS - Pangolin Version: pangolin:ee-1.18.3 - Gerbil Version: gerbil:1.3.1 - Traefik Version: V3.6 - Newt Version: 1.12.3 - Olm Version: (if applicable) ### To Reproduce Update from 1.18.2 to 1.18.3 ### Expected Behavior This should follow the normal upgrade process and not hang on the Sqlite Migration.

GiteaMirror closed this issue 2026-05-16 03:30:31 -05:00

GiteaMirror commented 2026-05-16 03:30:31 -05:00

Author

Owner

Copy Link

Copy Source

@oschwartz10612 commented on GitHub (May 7, 2026):

Looking into it

<!-- gh-comment-id:4393623275 --> @oschwartz10612 commented on GitHub (May 7, 2026): Looking into it

GiteaMirror commented 2026-05-16 03:30:32 -05:00

Author

Owner

Copy Link

Copy Source

@oschwartz10612 commented on GitHub (May 7, 2026):

Fixed by #3021 pushing over the tag now

<!-- gh-comment-id:4393868423 --> @oschwartz10612 commented on GitHub (May 7, 2026): Fixed by #3021 pushing over the tag now

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

main

dependabot/npm_and_yarn/npm-dependencies-adef1355ca

dependabot/go_modules/install/go-install-dependencies-1560069833

1-27

dependabot/npm_and_yarn/node-forge-1.4.3

feat/sync-idp-user-dir

l10n_dev

dev

website-checkout

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

dependabot/npm_and_yarn/node-forge-1.4.2

dependabot/github_actions/github-actions-dependencies-0c219a018e

extern-ws

1.26.0

1.26.0-rc.0

1.25.3

1.25.2

1.25.1

1.25.0

1.25.0-rc.0

1.24.0

1.24.0-rc.0

1.23.0

1.23.0-rc.0

1.22.2

1.22.1

1.22.0

1.22.0-rc.0

1.21.1

1.21.0

1.21.0-rc.0

1.20.0

1.20.0-rc.0

1.19.4

1.19.3

1.19.2

1.19.1

1.19.0

1.19.0-rc.1

1.19.0-rc.0

1.18.4

1.18.3

1.18.2

1.18.1

1.18.0

1.18.0-rc.0

1.17.1

1.17.0

1.17.0-rc.0

1.16.2

1.16.1

1.16.0

1.16.0-rc.0

1.15.4

1.15.3

1.15.2

1.15.1

1.15.0

1.15.0-rc.0

1.14.1

1.14.0

1.14.0-rc.0

1.13.1

1.13.0

1.13.0-rc.0

1.12.3

1.12.2

1.12.1

1.12.0

1.12.0-rc.0

1.11.1

1.11.0

1.10.3

1.10.2

1.10.1

1.10.0

1.9.4

1.9.3

1.9.2

1.9.1

1.9.0

1.8.0

1.7.3

1.7.2

1.7.1

1.7.0

1.6.2

1.6.1

1.6.0

1.5.1

1.5.0

1.4.0

1.3.2

1.3.1

1.3.0

1.2.0

1.1.0

1.0.1

1.0.0

1.0.0-beta.15

1.0.0-beta.14

1.0.0-beta.13

1.0.0-beta.12

1.0.0-beta.11

1.0.0-beta.10

1.0.0-beta.9

1.0.0-beta.8

1.0.0-beta.7

1.0.0-beta.6

1.0.0-beta.5

1.0.0-beta.4

1.0.0-beta.3

1.0.0-beta.2

1.0.0-beta.1

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 labels

Milestone

No items

No Milestone

Projects

Clear projects

No projects

Assignees

Clear assignees

GiteaMirror ninjasurge (Kaehlen Rog)

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/pangolin#15182