github-starred/pangolin
2
0
Fork 0
mirror of https://github.com/fosrl/pangolin.git synced 2026-05-22 09:32:36 -05:00
Code Issues 959 Packages Projects Releases 74 Wiki Activity

[GH-ISSUE #1701] Upgrade Issues 1.11.0 Postgres Image #1982

New Issue
Closed
opened 2026-04-16 08:53:30 -05:00 by GiteaMirror · 5 comments
GiteaMirror commented 2026-04-16 08:53:30 -05:00
Owner
Copy Link

Originally created by @ex-aequo-et-bono on GitHub (Oct 19, 2025).
Original GitHub issue: https://github.com/fosrl/pangolin/issues/1701

Describe the Bug

Hi all, am having issues with updating the the postgres version of the image to 1.11.0.

Error running migrations: DrizzleQueryError: Failed query: ALTER TABLE "orgs" ADD COLUMN "settings" text; params: at NodePgPreparedQuery.queryWithCache (file:///app/node_modules/drizzle-orm/pg-core/session.js:41:15) at process.processTicksAndRejections (node:internal/process/task_queues:105:5) at async Object.migration7 [as run] (file:///app/dist/migrations.mjs:1664:5) ... 3 lines matching cause stack trace ... at async file:///app/dist/migrations.mjs:1814:1 { query: 'ALTER TABLE "orgs" ADD COLUMN "settings" text;', params: [], cause: error: column "settings" of relation "orgs" already exists at /app/node_modules/pg-pool/index.js:45:11 at process.processTicksAndRejections (node:internal/process/task_queues:105:5) at async file:///app/node_modules/drizzle-orm/node-postgres/session.js:113:20 at async NodePgPreparedQuery.queryWithCache (file:///app/node_modules/drizzle-orm/pg-core/session.js:39:16) at async Object.migration7 [as run] (file:///app/dist/migrations.mjs:1664:5) at async executeScripts (file:///app/dist/migrations.mjs:1869:9) at async runMigrations (file:///app/dist/migrations.mjs:1828:7) at async run (file:///app/dist/migrations.mjs:1816:3) at async file:///app/dist/migrations.mjs:1814:1 { length: 131, severity: 'ERROR', code: '42701', detail: undefined, hint: undefined, position: undefined, internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'tablecmds.c', line: '7478', routine: 'check_for_column_name_collision' }

Environment

  • OS Type & Version: (Ubuntu 22.04)
  • Pangolin Version: 1.10.3
  • Gerbil Version: 1.21.1
  • Traefik Version: 3.5.3
  • Newt Version: 1.5.2
  • Olm Version: (na)

To Reproduce

Attempt upgrade with Postgres Image

Expected Behavior

Clean upgrade

Originally created by @ex-aequo-et-bono on GitHub (Oct 19, 2025). Original GitHub issue: https://github.com/fosrl/pangolin/issues/1701 ### Describe the Bug Hi all, am having issues with updating the the postgres version of the image to 1.11.0. `Error running migrations: DrizzleQueryError: Failed query: ALTER TABLE "orgs" ADD COLUMN "settings" text; params: at NodePgPreparedQuery.queryWithCache (file:///app/node_modules/drizzle-orm/pg-core/session.js:41:15) at process.processTicksAndRejections (node:internal/process/task_queues:105:5) at async Object.migration7 [as run] (file:///app/dist/migrations.mjs:1664:5) ... 3 lines matching cause stack trace ... at async file:///app/dist/migrations.mjs:1814:1 { query: 'ALTER TABLE "orgs" ADD COLUMN "settings" text;', params: [], cause: error: column "settings" of relation "orgs" already exists at /app/node_modules/pg-pool/index.js:45:11 at process.processTicksAndRejections (node:internal/process/task_queues:105:5) at async file:///app/node_modules/drizzle-orm/node-postgres/session.js:113:20 at async NodePgPreparedQuery.queryWithCache (file:///app/node_modules/drizzle-orm/pg-core/session.js:39:16) at async Object.migration7 [as run] (file:///app/dist/migrations.mjs:1664:5) at async executeScripts (file:///app/dist/migrations.mjs:1869:9) at async runMigrations (file:///app/dist/migrations.mjs:1828:7) at async run (file:///app/dist/migrations.mjs:1816:3) at async file:///app/dist/migrations.mjs:1814:1 { length: 131, severity: 'ERROR', code: '42701', detail: undefined, hint: undefined, position: undefined, internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'tablecmds.c', line: '7478', routine: 'check_for_column_name_collision' } ` ### Environment - OS Type & Version: (Ubuntu 22.04) - Pangolin Version: 1.10.3 - Gerbil Version: 1.21.1 - Traefik Version: 3.5.3 - Newt Version: 1.5.2 - Olm Version: (na) ### To Reproduce Attempt upgrade with Postgres Image ### Expected Behavior Clean upgrade
GiteaMirror added the stale label 2026-04-16 08:53:30 -05:00
GiteaMirror commented 2026-04-16 08:53:31 -05:00
Author
Owner
Copy Link

@github-actions[bot] commented on GitHub (Nov 3, 2025):

This issue has been automatically marked as stale due to 14 days of inactivity. It will be closed in 14 days if no further activity occurs.

<!-- gh-comment-id:3478561095 --> @github-actions[bot] commented on GitHub (Nov 3, 2025): This issue has been automatically marked as stale due to 14 days of inactivity. It will be closed in 14 days if no further activity occurs.
GiteaMirror commented 2026-04-16 08:53:31 -05:00
Author
Owner
Copy Link

@ex-aequo-et-bono commented on GitHub (Nov 7, 2025):

Hi, this is still an issue.

<!-- gh-comment-id:3502628637 --> @ex-aequo-et-bono commented on GitHub (Nov 7, 2025): Hi, this is still an issue.
GiteaMirror commented 2026-04-16 08:53:32 -05:00
Author
Owner
Copy Link

@oschwartz10612 commented on GitHub (Nov 8, 2025):

@ex-aequo-et-bono do you have a old backup to fall back to? Its strange it thinks that column already exists. Is it possible you tried to update once but fell back to the old version? That would mean the columns are still there.

If its out of sync with the migrations and you can not fall back to a backup config I am sad to say the best solution may be to reinstall. You could try this but be warned it might not work...

sudo apt install sqlite3

sqlite3 config/db/db.sqlite

> ALTER TABLE "orgs" DROP COLUMN "settings";

You could also try an upgrade to 1.12.x and see if it works?

<!-- gh-comment-id:3507127355 --> @oschwartz10612 commented on GitHub (Nov 8, 2025): @ex-aequo-et-bono do you have a old backup to fall back to? Its strange it thinks that column already exists. Is it possible you tried to update once but fell back to the old version? That would mean the columns are still there. If its out of sync with the migrations and you can not fall back to a backup config I am sad to say the best solution may be to reinstall. You could try this but be warned it might not work... ``` sudo apt install sqlite3 sqlite3 config/db/db.sqlite > ALTER TABLE "orgs" DROP COLUMN "settings"; ``` You could also try an upgrade to 1.12.x and see if it works?
GiteaMirror commented 2026-04-16 08:53:32 -05:00
Author
Owner
Copy Link

@github-actions[bot] commented on GitHub (Nov 23, 2025):

This issue has been automatically marked as stale due to 14 days of inactivity. It will be closed in 14 days if no further activity occurs.

<!-- gh-comment-id:3567210852 --> @github-actions[bot] commented on GitHub (Nov 23, 2025): This issue has been automatically marked as stale due to 14 days of inactivity. It will be closed in 14 days if no further activity occurs.
GiteaMirror commented 2026-04-16 08:53:32 -05:00
Author
Owner
Copy Link

@github-actions[bot] commented on GitHub (Dec 8, 2025):

This issue has been automatically closed due to inactivity. If you believe this is still relevant, please open a new issue with up-to-date information.

<!-- gh-comment-id:3623922200 --> @github-actions[bot] commented on GitHub (Dec 8, 2025): This issue has been automatically closed due to inactivity. If you believe this is still relevant, please open a new issue with up-to-date information.
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 stale
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#1982
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?