zaratanDotWorld / choreWheel

Computational governance tooling
GNU Affero General Public License v3.0
9 stars 1 forks source link

Investigate missing houseId #174

Open kronosapiens opened 3 months ago

kronosapiens commented 3 months ago

This error has begun appearing in the logs, likely after deploying https://github.com/zaratanDotWorld/choreWheel/commit/bf04fcf47905e42e8d51eba6beb450754912049e

chores user_change 
[ERROR]  bolt-app error: insert into "Resident" ("activeAt", "exemptAt", "houseId", "slackId") values ($1, $2, $3, $4) on conflict ("slackId") do update set "activeAt" = excluded."activeAt", "exemptAt" = excluded."exemptAt", "houseId" = excluded."houseId", "slackId" = excluded."slackId" - insert or update on table "Resident" violates foreign key constraint "resident_houseid_foreign" 
    at Parser.parseErrorMessage (/home/ubuntu/mirror/node_modules/pg-protocol/dist/parser.js:287:98) 
    at Parser.handlePacket (/home/ubuntu/mirror/node_modules/pg-protocol/dist/parser.js:126:29) 
    at Parser.parse (/home/ubuntu/mirror/node_modules/pg-protocol/dist/parser.js:39:38) 
    at Socket.<anonymous> (/home/ubuntu/mirror/node_modules/pg-protocol/dist/index.js:11:42) 
    at Socket.emit (node:events:518:28) 
    at addChunk (node:internal/streams/readable:559:12) 
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3) 
    at Readable.push (node:internal/streams/readable:390:5) 
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23) 
    at TCP.callbackTrampoline (node:internal/async_hooks:130:17) { 
  length: 270, 
  severity: 'ERROR', 
  code: '23503', 
  detail: 'Key (houseId)=(E011XGDUJMC) is not present in table "House".', 
  hint: undefined, 
  position: undefined, 
  internalPosition: undefined,
  ...

Investigate and fix.