#492 — [Bug]: Attempted duplicated officer id’s insertion causes error
Repo: Twill-AI/facade State: closed | Status: done Assignee: Unassigned
Created: 2025-08-13 · Updated: 2025-09-15
Description
Steps to reproduce
No known steps to reproduce.
Caused by alert: https://twill-network.slack.com/archives/C07TPN6FCBX/p1755092737285779
8/13/2025, 1:41:01.611 PM ca-staging-twill-facade-eastus ghcr.io/twill-ai/facade:2025-08-13T12-47-36_232a1b0 ca-staging-twill-facade-eastus—0000060 2025-08-13 13:41:01.234|ERROR|master|merchants_helpers:806|Error upserting merchant officers: ON CONFLICT DO UPDATE command cannot affect row a second time
8/13/2025, 1:41:01.611 PM ca-staging-twill-facade-eastus ghcr.io/twill-ai/facade:2025-08-13T12-47-36_232a1b0 ca-staging-twill-facade-eastus—0000060 HINT: Ensure that no rows proposed for insertion within the same command have duplicate constrained values.
The error is caused by a
Notes
Add implementation notes, blockers, and context here
Related
Add wikilinks to related people, meetings, or other tickets