Hello all quick question: After upgrading to SpiceDB 1.30.0 (from 1.29.5) one of my tests started failing while performing the following operations (running on postgreSQL): 1 - write 100 relationships 2 - check a single permission that requires one of the relationships created earlier 3 - Delete all relationships 4 - recheck the same permissions from 2 5 - redo steps from 1 to 4 The 2nd delete relationships fails because of unique key violation

uq_relation_tuple_living_xid

and error message: could not CREATE relationship ####### , as it already existed. Has someone stumbled upon this? Why is a delete operation creating relationships?

Only change that could impact that code path was https://github.com/authzed/spicedb/pull/1771 Is the failure happening when you are doing a delete? Deletes in Postgres and MySQL, because those implementations do their own MVCC, involve inserting a tuple with the

deleted_xid

colum set to the transaction XID it was deleted at. I don't think that failure is expected? Can you create a repro test? cc @Joey

we highly recommend against deleting all relationships for testing; we recommend using

serve-testing

I'll create an issue explaining the problem but TL DR is has something to do with setting limits and not allowing partial deletions

Thanks a ton Joao!