Upgrade Issues 1.11.0 Postgres Image #755

New Issue

MrUnknownDE · 2026-04-05T17:39:05+02:00

MrUnknownDE commented

2026-04-05 17:39:05 +02:00

Originally created by @ex-aequo-et-bono on 10/19/2025

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 10/19/2025* ### 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

MrUnknownDE closed this issue

2026-04-05 17:39:05 +02:00

MrUnknownDE added the stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale labels 2026-04-05 17:39:08 +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 stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale stale

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/pangolin#755