[GH-ISSUE #3174] updateHolePunch error #30165

Open
opened 2026-06-13 10:41:55 -05:00 by GiteaMirror · 1 comment
Owner

Originally created by @shleeable on GitHub (May 28, 2026).
Original GitHub issue: https://github.com/fosrl/pangolin/issues/3174

Describe the Bug

pangolin  | 2026-05-27T06:18:32+00:00 [error]: Failed query: update "sites" set "endpoint" = $1, "lastHolePunch" = $2 where "sites"."siteId" = $3 returning "siteId", "orgId", "niceId", "exitNode", "name", "pubKey", "subnet", "bytesIn", "bytesOut", "lastBandwidthUpdate", "type", "online", "lastPing", "address", "endpoint", "publicKey", "lastHolePunch", "listenPort", "dockerSocketEnabled", "status"
pangolin  | params: 192.168.99.1:60132,1779862682,2
pangolin  | Stack: Error: Failed query: update "sites" set "endpoint" = $1, "lastHolePunch" = $2 where "sites"."siteId" = $3 returning "siteId", "orgId", "niceId", "exitNode", "name", "pubKey", "subnet", "bytesIn", "bytesOut", "lastBandwidthUpdate", "type", "online", "lastPing", "address", "endpoint", "publicKey", "lastHolePunch", "listenPort", "dockerSocketEnabled", "status"
pangolin  | params: 192.168.99.1:60132,1779862682,2
pangolin  |     at NodePgPreparedQuery.queryWithCache (file:///app/node_modules/drizzle-orm/pg-core/session.js:41:15)
pangolin  |     at process.processTicksAndRejections (node:internal/process/task_queues:104:5)
pangolin  |     at async file:///app/node_modules/drizzle-orm/node-postgres/session.js:117:22
pangolin  |     at async updateAndGenerateEndpointDestinations (file:///app/dist/server.mjs:61690:27)
pangolin  |     at async updateHolePunch (file:///app/dist/server.mjs:61560:26) {"query":"update \"sites\" set \"endpoint\" = $1, \"lastHolePunch\" = $2 where \"sites\".\"siteId\" = $3 returning \"siteId\", \"orgId\", \"niceId\", \"exitNode\", \"name\", \"pubKey\", \"subnet\", \"bytesIn\", \"bytesOut\", \"lastBandwidthUpdate\", \"type\", \"online\", \"lastPing\", \"address\", \"endpoint\", \"publicKey\", \"lastHolePunch\", \"listenPort\", \"dockerSocketEnabled\", \"status\"","params":["192.168.99.1:60132",1779862682,2],"cause":{"length":157,"name":"error","severity":"ERROR","code":"57014","where":"while updating tuple (0,8) in relation \"sites\"","file":"postgres.c","line":"3444","routine":"ProcessInterrupts"}}

Environment

  • OS Type & Version: Ubuntu 26.04 with stock docker
  • Pangolin Version: 1.18.4
  • Gerbil Version: 1.4.0
  • Traefik Version: 3.7
  • Newt Version: latest
  • Olm Version: (if applicable)

To Reproduce

Currently trying to reproduce.

Expected Behavior

no error

Originally created by @shleeable on GitHub (May 28, 2026). Original GitHub issue: https://github.com/fosrl/pangolin/issues/3174 ### Describe the Bug ``` pangolin | 2026-05-27T06:18:32+00:00 [error]: Failed query: update "sites" set "endpoint" = $1, "lastHolePunch" = $2 where "sites"."siteId" = $3 returning "siteId", "orgId", "niceId", "exitNode", "name", "pubKey", "subnet", "bytesIn", "bytesOut", "lastBandwidthUpdate", "type", "online", "lastPing", "address", "endpoint", "publicKey", "lastHolePunch", "listenPort", "dockerSocketEnabled", "status" pangolin | params: 192.168.99.1:60132,1779862682,2 pangolin | Stack: Error: Failed query: update "sites" set "endpoint" = $1, "lastHolePunch" = $2 where "sites"."siteId" = $3 returning "siteId", "orgId", "niceId", "exitNode", "name", "pubKey", "subnet", "bytesIn", "bytesOut", "lastBandwidthUpdate", "type", "online", "lastPing", "address", "endpoint", "publicKey", "lastHolePunch", "listenPort", "dockerSocketEnabled", "status" pangolin | params: 192.168.99.1:60132,1779862682,2 pangolin | at NodePgPreparedQuery.queryWithCache (file:///app/node_modules/drizzle-orm/pg-core/session.js:41:15) pangolin | at process.processTicksAndRejections (node:internal/process/task_queues:104:5) pangolin | at async file:///app/node_modules/drizzle-orm/node-postgres/session.js:117:22 pangolin | at async updateAndGenerateEndpointDestinations (file:///app/dist/server.mjs:61690:27) pangolin | at async updateHolePunch (file:///app/dist/server.mjs:61560:26) {"query":"update \"sites\" set \"endpoint\" = $1, \"lastHolePunch\" = $2 where \"sites\".\"siteId\" = $3 returning \"siteId\", \"orgId\", \"niceId\", \"exitNode\", \"name\", \"pubKey\", \"subnet\", \"bytesIn\", \"bytesOut\", \"lastBandwidthUpdate\", \"type\", \"online\", \"lastPing\", \"address\", \"endpoint\", \"publicKey\", \"lastHolePunch\", \"listenPort\", \"dockerSocketEnabled\", \"status\"","params":["192.168.99.1:60132",1779862682,2],"cause":{"length":157,"name":"error","severity":"ERROR","code":"57014","where":"while updating tuple (0,8) in relation \"sites\"","file":"postgres.c","line":"3444","routine":"ProcessInterrupts"}} ``` ### Environment - OS Type & Version: Ubuntu 26.04 with stock docker - Pangolin Version: 1.18.4 - Gerbil Version: 1.4.0 - Traefik Version: 3.7 - Newt Version: latest - Olm Version: (if applicable) ### To Reproduce Currently trying to reproduce. ### Expected Behavior no error
GiteaMirror added the stale label 2026-06-13 10:41:55 -05:00
Author
Owner

@github-actions[bot] commented on GitHub (Jun 12, 2026):

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:4686427448 --> @github-actions[bot] commented on GitHub (Jun 12, 2026): 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.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/pangolin#30165