[GH-ISSUE #1793] UNIQUE constraint failed: resources.resourceGuid #3948

Closed
opened 2026-04-20 08:16:45 -05:00 by GiteaMirror · 4 comments
Owner

Originally created by @johnsturgeon on GitHub (Nov 2, 2025).
Original GitHub issue: https://github.com/fosrl/pangolin/issues/1793

Describe the Bug

I'm getting the following error trying to add a resource:

2025-11-02T02:21:44.742Z [error]: UNIQUE constraint failed: resources.resourceGuid
Stack: SqliteError: UNIQUE constraint failed: resources.resourceGuid
    at PreparedQuery.values (file:///app/node_modules/drizzle-orm/better-sqlite3/session.js:106:28)
    at PreparedQuery.all (file:///app/node_modules/drizzle-orm/better-sqlite3/session.js:81:23)
    at QueryPromise.all (file:///app/node_modules/drizzle-orm/sqlite-core/query-builders/insert.js:165:28)
    at QueryPromise.execute (file:///app/node_modules/drizzle-orm/sqlite-core/query-builders/insert.js:174:41)
    at QueryPromise.then (file:///app/node_modules/drizzle-orm/query-promise.js:21:17)
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5) {"code":"SQLITE_CONSTRAINT_UNIQUE"}

Environment

  • OS Type & Version: debian 12
  • Pangolin Version: CE 10.2
  • Gerbil Version: latest
  • Traefik Version: v3.5
  • Newt Version: v1.5.2
  • Olm Version: (if applicable)

To Reproduce

Create a new resource through the UI

Expected Behavior

Resource Created

Originally created by @johnsturgeon on GitHub (Nov 2, 2025). Original GitHub issue: https://github.com/fosrl/pangolin/issues/1793 ### Describe the Bug I'm getting the following error trying to add a resource: ``` 2025-11-02T02:21:44.742Z [error]: UNIQUE constraint failed: resources.resourceGuid Stack: SqliteError: UNIQUE constraint failed: resources.resourceGuid at PreparedQuery.values (file:///app/node_modules/drizzle-orm/better-sqlite3/session.js:106:28) at PreparedQuery.all (file:///app/node_modules/drizzle-orm/better-sqlite3/session.js:81:23) at QueryPromise.all (file:///app/node_modules/drizzle-orm/sqlite-core/query-builders/insert.js:165:28) at QueryPromise.execute (file:///app/node_modules/drizzle-orm/sqlite-core/query-builders/insert.js:174:41) at QueryPromise.then (file:///app/node_modules/drizzle-orm/query-promise.js:21:17) at process.processTicksAndRejections (node:internal/process/task_queues:105:5) {"code":"SQLITE_CONSTRAINT_UNIQUE"} ``` ### Environment - OS Type & Version: debian 12 - Pangolin Version: CE 10.2 - Gerbil Version: latest - Traefik Version: v3.5 - Newt Version: v1.5.2 - Olm Version: (if applicable) ### To Reproduce Create a new resource through the UI ### Expected Behavior Resource Created
GiteaMirror added the stale label 2026-04-20 08:16:45 -05:00
Author
Owner

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

Hi @johnsturgeon sorry for this issue!

Could you let me know if this still occurs if you update to 1.12.x? Make sure to backup your config first.

<!-- gh-comment-id:3478399370 --> @oschwartz10612 commented on GitHub (Nov 2, 2025): Hi @johnsturgeon sorry for this issue! Could you let me know if this still occurs if you update to 1.12.x? Make sure to [backup your config first](https://docs.pangolin.net/self-host/how-to-update#before-you-update).
Author
Owner

@github-actions[bot] commented on GitHub (Nov 17, 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:3539532949 --> @github-actions[bot] commented on GitHub (Nov 17, 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.
Author
Owner

@github-actions[bot] commented on GitHub (Dec 1, 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:3594044598 --> @github-actions[bot] commented on GitHub (Dec 1, 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.
Author
Owner

@johnsturgeon commented on GitHub (Dec 1, 2025):

Sorry for getting back to you late, yes, it's resolved!!!

<!-- gh-comment-id:3594490730 --> @johnsturgeon commented on GitHub (Dec 1, 2025): Sorry for getting back to you late, yes, it's resolved!!!
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/pangolin#3948