Write relationships rpc
# spicedbc
claraisrael
08/30/2023, 12:56 PMHi team, I’m getting this error when hitting the WriteRelationships endpoint in spicedb. I’m unsure about the root cause and haven’t seen any GH issues open about this error. Any help would be greatly appreciated. Thanks so much! (Error below)
Unknown desc = unable to write relationships: ERROR: current transaction is aborted, commands ignored until end of transaction block (SQLSTATE 25P02)
claraisrael
08/30/2023, 1:24 PM@vroldanbet
v
vroldanbet
08/30/2023, 1:53 PMis this self-hosted SpiceDB? if so, which datastore are you using?
c
claraisrael
08/30/2023, 2:58 PMIt is self hosted spicedb and I use Postgres
claraisrael
08/30/2023, 2:59 PMUsing the spicedb go client
j
Joey
08/30/2023, 3:54 PMare you writing the same relationships in the overlapping transactions?
c
claraisrael
08/30/2023, 5:09 PMI’m just writing the relationship once so I think nop
j
Joey
08/30/2023, 5:13 PMso one write call with a single relationship?
Joey
08/30/2023, 5:13 PMor many write calls with different relationshipsa?
c
claraisrael
08/31/2023, 6:47 AMThis one was a one write call with a single relationship
v
vroldanbet
08/31/2023, 8:36 AMis this an actual postgres or a derivative managed service?